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

subreport values blank , need values still report vlaues

Status
Not open for further replies.

DaveCrate

Technical User
Jan 12, 2004
41
US
New User (pup). I have searched for a way to insert text either where it should have been generated in a subreport or at the end of multiple page report. I was thinking of insering another detail section, typing in the information needed and then try to find a way to get it to show only once at the end of report.

Crystal 9.0 database link to Access and multiple ODBC library tables

product # descript- (subreport-specifics about package
package ion column 3-5)

(pghead)col1 col2 col3 col4 col5
(detail)12345 soda A contents test weight
45667 soda B contents test wieght
89987 soda C contents test wieght
65432 soda D (blank )
11234 soda E contents test wieght
(rptfoot)suppressed
(pgfoot)

subreport link to main report is by col3 "contents".
col4 consists of tests that are unique to all except a few cases and are blank.

either way I do not want a blank section under detail main report or subreport.


"Kudos" to all who have educated everyone else like my self in all of the forums.

I hope I have included enough info.
Thanks in advance.
 
Not sure I've grasped the full impact of your problem here, but is it not possible for you to create an additional report footer in the subreport, conditionally suppressed on col3, 4, and 5 being either IsNull or "", with your freehand text inserted in this section?

Thus resulting in:
Code:
        89987    soda C    contents   test    weight
        65432    soda D    *** freehand blurb ***
Naith
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top