Search found 14 matches
- Mon Mar 11, 2024 9:01 pm
- Forum: Stimulsoft Reports.NET
- Topic: Hiding columns in Excel output
- Replies: 1
- Views: 713
Hiding columns in Excel output
Is there a way for columns in an Excel output to be hidden? Client wants to be able to access them, but not see them on initial viewing.
- Mon Oct 23, 2023 1:23 pm
- Forum: Stimulsoft Reports.NET
- Topic: Collate dynamically
- Replies: 3
- Views: 6736
Re: Collate dynamically
Let me explain it another way: Project 100 has a summary page (layout 1) and a detail page (layout 2). Project 101 has a summary page (layout 1) and 2 pages of the detail page (layout 2). If I set the collate to 2, then the 2nd page of details for Project 101 gets cut off. Is there a way to make sur...
- Fri Oct 20, 2023 6:04 pm
- Forum: Stimulsoft Reports.NET
- Topic: Collate dynamically
- Replies: 3
- Views: 6736
Collate dynamically
I know this is not necessarily new, but I'm struggling to find the answer. Is this possible: I have a report with two layouts. The first is almost always 1 page. The second layout could be multiple pages. The first and second layout are related, so they need to stay together. I want it so that if pa...
- Fri Sep 29, 2023 2:42 pm
- Forum: Stimulsoft Reports.NET
- Topic: Excel Value Sum of Column
- Replies: 8
- Views: 6690
Re: Excel Value Sum of Column
We found a solution: We added in an index column (=0) and section counts. From there we are able to calculate the row numbers of the different sections since the report starts on the same row every time. This works when we only have one project. We are still thinking through how to do this for a mul...
- Wed Sep 27, 2023 12:58 pm
- Forum: Stimulsoft Reports.NET
- Topic: Excel Value Sum of Column
- Replies: 8
- Views: 6690
Re: Excel Value Sum of Column
I would want to use it for the Total Revenues, Total Expenses, etc. See the example above: It would be the yellow highlighted cells.
- Mon Sep 25, 2023 1:08 pm
- Forum: Stimulsoft Reports.NET
- Topic: Excel Value Sum of Column
- Replies: 8
- Views: 6690
Re: Excel Value Sum of Column
In these files, the totals are already there, as calculated in Stimulsoft. We would want to replace these with formulas in Excel.
- Thu Sep 21, 2023 1:45 pm
- Forum: Stimulsoft Reports.NET
- Topic: Excel Value Sum of Column
- Replies: 8
- Views: 6690
Re: Excel Value Sum of Column
Right, that works for the rows, but I'm looking to do the column. When I put in Sum(C{Line}) I get the value of a random cell (granted, it's in the same column, but I need the sum of the range).
- Wed Sep 20, 2023 3:42 pm
- Forum: Stimulsoft Reports.NET
- Topic: Excel Value Sum of Column
- Replies: 8
- Views: 6690
Excel Value Sum of Column
Is there a way to sum the value of a column so that the exported Excel file shows the formula (Excel Value) of a column that is not static? (I want the part in yellow to calculate using Excel formulas, but the part in blue may increase or decrease in rows.)
- Wed Dec 07, 2022 10:30 pm
- Forum: Stimulsoft Reports.NET
- Topic: Banded Rows across page breaks
- Replies: 1
- Views: 309
Banded Rows across page breaks
Banded rows are restarting as if there is a page break and a header (see rows 50-51). I'm setting the EvenStyle, but I have also tried to use conditional formatting to get the banded rows. This is exported to Excel. BandedRows.PNG Second image is the report design. I have tried removing the header a...
- Fri Aug 26, 2022 6:07 pm
- Forum: Stimulsoft Reports.NET
- Topic: Removing Hyperlinks from PDF Output
- Replies: 2
- Views: 422
Removing Hyperlinks from PDF Output
Is there a way to remove the hyperlinks that are automatically created (for example, when the content is a website or email address) when exporting to a pdf? I tried the Export as Image property but that made it unreadable.