Help With Report Footer

[antsox]

Hi,

I have a report footer that I've created and it has several table cells within it. These table cells are labeled and are have colored table cells next to the labels. Basically, I have one footer but that one footer can have 3 possible looks, depending on what year and grade is selected, I have attached the code. When the footer choice was only 2, it was easy because I just used a Boolean variable. Now that I have 3 possible looks to the footer, I can't use a Boolean variable, I need to use a string variable.

I think I need to create 3 different footers, place them in the report and name them (I don't know how to do this) so I can use an If statement to call them???

Or, can I do like the Boolean variable and hide certain table cells depending on the year and grade???

Please inform me if I have not explained myself or what I am trying to do thouroughly enough.

Thank you!

[JGirl]

Hi,

Create a new string variable (eg NewCondVar) and in there, include a case statement to generate your three different outcomes.

Then in your footer, create a conditional block, set the 'block variable' to NewCondVar, change the 'current block' property to get into the edit mode for each of the 3 conditional outcomes, and include in that block the elements required to for the footer for that condition.

I took the report you posted, edited it, added the new variable (obviously youll need to put the correct logic into the variable definition), and added a conditional block into the footer linked to that variable & conditions so its ready to finish (I hope you've got 8.3 or higher!) *attached*

Hope this helps,
J

PS.   For the other conditional variable, you could also use a CASE/WHEN/THEN statement instead of the nested if then else (if then else (if then else)) etc  ;D

[sdee_sekaran]

Are you sure. Boolean/String variables will work at footer of a page?

Dhana.

[antsox]

Dhana,

Yes, Boolean/String variables do work on footers, just so you know.

JGirl,

Thank you for you response, I will try your suggestions and let you know the outcome.

Thanks again!

[antsox]

JGirl,

Thank you, it works perfectly now!!

[JGirl]

Glad to help & thanks for letting me know it was useful  ;D

J