Challenge: No details returning no Group Header info 2

[lordb]

New to CR (patience please),
Vitals: CR 8.5, accessing a FoxPro Data Base via ODBC. Report uses Multiple Parameters (Order No.’s) that uses an Ido formula (Thanks Ido) that returns the data grouped on the Order No.’s in the “order entered” as Load 1, Load 2, Load 3 etc. for a particular truck. The data in the details section includes the item description, number shipped and an item type identifier. Using Record Selection, I use the item type (Record select “in between” to limit listing only specific items under the Load No/ Order No Group. Report looks as follows:

(Group ) Load 1 Order No. Customer Name

(Detail) Qty Shipped Item Description Item type

Group Footer) Total Qty Shipped
-----------------------------------------------------------------------------
(Group ) Load 2 Order No. Customer Name

(Detail) Qty Shipped Item Description Item type

Group Footer) Total Qty Shipped


etc for as many order parameters entered.

The Challenge: the detail data selection process occasionally results in no records for the details and that results in no Group Load etc information being printed: e.g.; only a Load 3 showing up on the report. This confuses the loading crew that is responsible for the specific items listed on the report (and, to answer the obvious question: it confuses them even more to have all the items on an order / series of orders). For info: the item type identifier is ten different numbers.

How do I get the Group header information to print with no details returned by the record selection process? Is there a way to get some “detail”...maybe a sum of all items shipped to generated Group header info? Tried null if statements, etc. Probably doing them wrong. All ideas, comments appreciated. Thanks Byron

 

[midearth]

I've done a workaround like this before by inserting a text box in the details section stating "No records for this order"; then conditionally suppressing the text box using:

not(IsNull({QTY.SHIPPED}))

You might try that for starters.

 

[Madawc]

I'm not clear what you're after. If you want to show all loads, then use loads as your 'details' and drop the other stuff down as a subreport, showing the extra data when it's there. This will be slow and inefficient, but will get you the output you want. And you can use midearth's suggestion to identify those cases with no details.

Madawc Williams
East Anglia, Great Britain