My report has two groups and I print the details on Group Footer two. I cant seem to suppress the report header when there is no records printed.
The data comes from 3 tables (Vehicles, Servicing & ServiceType). With the following layouts:
Vehicles:
VehicleID
Description
Servicing:
ServiceType
ServiceDate
VehicleID
ServiceType:
ServiceType
Duration (How often the servicing is to be done)
The report is to show what Servicing is coming due based on how often the servicetype is performed. The report is grouped by vehicle and service type with the records printed on the Service Type (Group 2) footer. There is a running total field (MaxDate) that is used to determine when the particular service type is due next for the given vehicle since the same service type can be performed multiple times on the same vehicle.
The question is how do I suppress the header when no records are printed?
I have tried doing a Suppress formula checking for IsNull or Count>0 for ServiceType but the count is always greater than the number of fields that are actually printed.
Thanks for any help you can provide.I rarely use the report header section, unless I want to print the report to confirm it has null data (ie print an empty report as a way of confirming something has no data).
I generally use the Page Header to contain logos, titles etc to print at top of each page.
If there's no data, the page header etc won't print....
Dave|||Thanks for the response but I wouldnt want the header to appear at the top of every page. Is there a way to have it only print once?
The report would look something like:
SERVICING
Service Type Due Date
Brake Adjustment Aug 7 2004
Inspection Aug 9 2004
The Servicing title and the column headers are the items I currently have in the Report header.|||Put fields in the report header which u want to print only once. And put those fields in the page header which u want to print on the top of every page.
And to suppress in case of no record, u can put a formula in the format section of the report like
Suppress IF {...}|||I have tried putting a suppress formula in the Report Header of IsNull(ServiceType.Description) or Count(ServiceType.Description) = 0 but it didnt work. The problem was the Count was greater than 0 but they are all being suppressed by the formula in the Group 2 Footer.
Is there a way to calculate the number actually being displayed? Also, when does Crystal compute whether the Report Header should display? Does it do this before or after the details are printed?|||if you want to suppress on the basis of count then u can put formula on any of your record coming from DB, checking for 0.
I dont know this ServiceType.Description as i worked in CR-7 n didnt see this thing there.
Also while open the formatting Tab of format header dection and there you can find to put formula on suppressing the section.|||That is exactly what I did. The problem seems to be that the count is always zero in the Report Header section. If I display the count as it prints the records and in the Report Footer it shows the accurate count.
The question is how do I base the suppression on the number of records displayed?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment