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

Subreport supression

Status
Not open for further replies.

hassellhorse

Technical User
Aug 16, 2006
11
US
I have a subreport in my report footer that should be surpressed based on certain detail criteria. I have the criteria in the formatting of the reporting. No matter what I try; changing subreport links, etc. The subreport is printing for almost every detail item. Does anyone have any ideas?
 
If your subreport is in the report footer and it is linked on database fields, it will only pick up on the value in the last record of the detail section. Generally, a subreport in the report footer would be linked based on parameter fields from the main report (not database fields) or would be unlinked.

It might help to explain what the subreport is supposed to show in relation to the main report, and to identify how you have it currently linked.

-LB
 
Using CR XI attached to MS SQL Svr and this is the first time I'm trying to incorporate a subreport.

Report LOS1abc.rpt Includes the following sections:
RH, PH, GH1, GH2, D, GF2, GF1, RFa, RFb, RFc, RFd, PF

RFb and c contain cross tabs

I created a separate report called LOS1abcd.rpt and inserted this report into LOS1abc.rpt in the RFd section by clicking on insert of the tool bar, choosing the existing report (LOS1abcd.rpt), didn't set a link so I think it grabbed the first command field.

It is set to grow, keep object together, close border on pagebreak.

I Formatted subreport under Border to have a white border (I want invisible), Background is Blue and background box is unchecked and entered formula beside it, NoColor following Ken Hammady's recommendation of viewing subreports in design mode to be a different color than the rest of the report to easily identify subreports while not displaying this color in the preview mode. However, my background is white no matter which view I'm using. Why?

The subreport is formatted to re-import when opening.

Aside from the background issue, my problem is that the subreport doesn't display details. It shows the header and footer.

After poking around a bit on subreports I thought perhaps there is an issue with the link. I don't exactly understand how the links work. The main report uses a parameter and just so happens to be the same used in the subreport. I changed the link from clientid to
?1_Startdate and ?2_Enddate, but the result is the same, no details.

Both queries of the reports are similar but displaying different views. The main report shows admission info while the subreport shows units authorized and used for those admissions of clients with the same parameter.

Can someone please take the time give me a quick education on how this works?

If and when I'm able to view the subreport in it's entirety, I may want to suppress the details and just show the RH, RFa which includes some summaries, RFb which includes a cross tab and the RFc. Is this possible???

Your feedback is greatly appreciated. Thank you.
 
Check your other post.

If you link by start and end date, the link will be = in each case, which explains why it's blank.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top