Thank you for this Kirill. I'll have a look at the report and will let you know if I can get it to work.

Hello, I have a report where I'd like to set the condition of a text control based on the results of a calculation in the groupfooterband just below the text control. The text control outlined in red should have its text color changed to red if its value is greater than the value of the text box out...

OK - Thank you Lech.

Hello, I've started working with a a very basic stored procedure in MSSQL and have a couple of questions. I have a stored procedure that has 1 input parameter (a DepartmentID ) and the stored procedure returns all rows from a table for that given department ID. I can get columns and data returned fr...

Ok - Thank you Lech. Your sub-report suggestion will work just fine.

Carl

Hello,

Do you have any additional thoughts on changing the page that appears in a sub-report control?

Thank you,
Carl

Thank you for the suggestion Lech. I will actually have about 20 pages in the report which would mean adding 20 sub-reports. I'd like to avoid that if I can - hence my desire to add one sub-report and then change the page that appear in the sub-report. Is this possible with some modifications to the...

Hello, I am wondering if there is a way to change the page that appears in a sub-report component. I have a sample report attached that has 3 pages: - a main page with a sub-report component - page subReport_1 for the sub-report contents - page subReport_2 for alternate sub-report components The rep...

Great Max - Thanks for forwarding the link!

Excellent Lech - Thank you!

As for the Transformations - are they generally only used for Dashboards or can they be used in a report as well?

Carl