I have 2 pages. I want to have the same table on each page, but on the second page, I want to divide by a certain value. I've tried setting a variable via the PageName function, but I have no idea how to use the variable in the expression so I can: [Column] / ?Variable?
Report is due tomorrow god/forum please help me!
Hi,
Couldn't you just go to Page Explorer and add a second report page in there? Once you have your second page, you can put whatever you like onto it, with it's own specific logic.
Cheers!
MF.
I think you are confusing layout and query operations. You can't use variables or layout functions in query expressions.
You will two separate containers each referencing the appropriate query containing the desired logic. They could use the same query if the query has both calculations such as one query item withe the expression [Column] / [Page 1 Divisor] and then another query time with the expression [Column] / [Page 2 Divisor].
Then use the first query item on the layout container in page 1 and the other on page 2.