Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to change footer dynamically depends of page context?

Status
Not open for further replies.

alexbelovtt

Programmer
Nov 15, 2005
51
US
I use Crystal XI and Visual basic

I have report with 12 subreports.
Footer of main report has three fields that must be change depends of context of page.
For example page displays part of subreport 1
and subreport 2.
Subreport 1 has data required to display message 1 and 2
and subreport 2 has data to display message 2.
Another example - subreport 1 has question marked as required *, then footer must display “Question marked with * is required”
and subreprt 2 has specific value, that requires message on footer as “Easer field1 or field 2 must be filled…”
In simple words – how do I know what subreports are displaying on to the page?
What technique is better to control footer context?
Thank you
Alex
 
Can't you just conditionally supress the fields?

from the field's properties, choose suppress (click the formula icon)

tablename.fieldname="value"

this will SUPRESS the field when the condition is met.

-- Jason
"It's Just Ones and Zeros
 
Jason,
Problem is not suppressed or shows, but know what is displaying on current page.
Page footer of main report displays on each page. Page may have or may have not for example required fields.
May question is how can I know that current page has part or whole subreport 1 or 2, etc.
In my understanding I must use some global variable changed by subreports and then somehow check that variable for each page.
I just do not know how set those variables and check for each page their values.
Could I use tablename.fieldname?
But how do that for certain page?
Thank you.
Alex
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top