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.

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...

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...

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...

I would want to use it for the Total Revenues, Total Expenses, etc. See the example above: It would be the yellow highlighted cells.

In these files, the totals are already there, as calculated in Stimulsoft. We would want to replace these with formulas in Excel.

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).

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.)

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...

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.