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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Details section supression/Passing parameters from subreport

Status
Not open for further replies.

Futang44

Instructor
Dec 8, 2008
5
US
I have searched through the forums for help and I have come very close.
per lbass's Instruction, I have made the following renditions to the report in hopes it would work.


//{@reset} for the subreport report header:
whileprintingrecords;
shared stringvar x := "";

//{@accum} for the detail section:
whileprintingrecords;
shared stringvar x;

if isnull({table.linkfield}) then //Use the field that you are using to
//link to the main report
x := x + "" else
x := x + "Not Null";

//{@display} for the subreport report footer:
whileprintingrecords;
shared stringvar x;

Suppress these formulas if you wish.

Then in the main report go to the section expert->detail_c->suppress->x+2 and enter:
whileprintingrecords;
shared stringvar x;
x = ""; //note no colon

The only problem is there are multiple subreport records under each entry so it only suppresses the section if there is no record period. I need a way to suppress all but applicable records based on a two and four digit number field. I am fairly new to CR so if the verbiage is off or more specifics are needed I will be happy to comply. Someone Please Help!!!!
Thanks,
Russell
 
This is unclear. What is the group structure of the main report, and in what section is the subreport located? Under what conditions (what values from the sub) do you want to suppress the main report section and which section is it? On what field(s) is the sub linked to the main report?

-LB
 
I have two groups, with a subreport in the details section, The formulas are placed the same way described above, and I am hoping to suppress the entire section for null values. I am sure the report and the sub are linked correctly. 'Suppress blank Section' has no effect.
 
Your response is not detailed enough and does not explain what you meant earlier by:

I need a way to suppress all but applicable records based on a two and four digit number field.

Note that if your sub is in the detail section, you cannot suppress anything in the same section. You would only be able to suppress something in a later section, e.g., detail_b.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top