No Records 2

[jrperry]

Unsure if this is easy or not.

I know I can supress printing if their are no records, but can I add something that will either:

1. Say something on the report "No records for this period"

2. Set an event in Seagate Info only if no records were found so I can use this event to kick off another scheduled program.

cheers

 

[Naith]

In your details or first group header section, you can insert a section below, and add a text field into it saying "No Records Found."

Conditionally suppress the section to only appear if no data exists in the preceding section. You can use a anything like a counter formula or recordnumber to deduce this.

Naith

 

[rhinok]

I have a 'No Records Returned' message in almost all of my reports.[ol][li]Uncheck the 'Suppress Printing If No Records' checkbox in either Options or Report Options[/li][li]As Naith suggests, create a text box with the appropriate message. Personally, I like to include my parameters as part of the message--"No Records Exist for part number '12345'"--so that the user can see if they entered the parameter incorrectly[/li][li]Conditionally suppress either the section or just the text box, depending on your report layout. I generally pick a key field (for example, Part Number) and suppress the message where 'Count({table.part_number}) = 0'[/li][/ol]Hope this helps!

 

[jrperry]

The solutions provided worked, thanks for your assistance.