Hello,
I'm encountering a page rendering issue that I was hoping to receive a bit of insight on. I've been perusing through the site on my own for a few days now, and while very valuable, haven't been able to use the available information for my particular issue. I'm attempting to dynamically render three different pages in my report based on a data item value that changes per data record. A specific page will render based on the value. So:
Record ProjectRelationshipType Page
1 Parent ParentPage
2 Child ChildPage
3 Standalone StandalonePage
4 Child ChildPage
And so forth. I have a string variable containing a case statement indicating when each page should render, something to the tune of:
CASE WHEN [Main Report Query].[ProjectRelationshipType] contains 'Parent' THEN 'ParentPage'
WHEN [Main Report Query].[ProjectRelationshipType] contains 'child' THEN 'ChildPage'
WHEN [Main Report Query].[ProjectRelationshipType] contains 'Standalone' THEN 'StandalonePage'
END
Then set the variable as the render variable to each page, with 'render for' selected for the value for which the page should render. The data item ProjectRelationshipType is added to the Properties of the pages as it's not actually used in the pages itself. I then run the report, select my prompt values and fire away. The issue I'm seeing is that the report only renders the page based off the value from the first record in the data set. It does not change the page based on the values of the data item as expected. So, if the first record has ProjectRelationshipType set to 'Parent', ALL records use the 'ParentPage'.
I've tried IF statements, multiple booleans, different data items, but no such luck. I'm imagining I'm missing something minor, but cannot put my finger on it. I'm relatively sure using the Render Variable method is the best way to go about this, but if there is another way, I'm all ears! Any help would be greatly appreciated.
Thanks!
Jaysen647