display sub form when there is no data (1 Viewer)

kobiashi

Registered User.
Local time
Today, 07:07
Joined
May 11, 2018
Messages
258
hi

so i had an issue today, that had me stumped, and it was when i was emailing a report in pdf format, there was no data being displayed on the report, it turned out that when the sub form on a report hs no data, it wont display, not even the header.

so my question is, how do i force a sub form to display on a report even when there is no data in there, i want to be able to display the headers of the sub forms, no the problem i have in this scenario is, the report is not bound to any query or table, there is about 7 subforms, all linked to individual queries, the report is like a snap shot of the day, i have read you can force the sub form to display but this requires the report to be bound to a query or table.
 

kobiashi

Registered User.
Local time
Today, 07:07
Joined
May 11, 2018
Messages
258
Did you mean subreport?

You need a dummy record.
I'm using sub forms in my report, as I require a continuous form.

How would I add a dummy record?

Sent from my ONEPLUS A6003 using Tapatalk
 

June7

AWF VIP
Local time
Yesterday, 23:07
Joined
Mar 9, 2014
Messages
5,424
Why would you need form for continuous records? Reports are continuous.

The issue will be same for subreports with no data.

Either create record in tables or use a UNION query as RecordSource.

SELECT ID, field1, field2, field3 FROM table
UNION SELECT 0, Null, Null, Null FROM table;
 

kobiashi

Registered User.
Local time
Today, 07:07
Joined
May 11, 2018
Messages
258
It's the way the report is layed out, it pulls data from various places and displays that data, in a datasheet format, for each subform

Sent from my ONEPLUS A6003 using Tapatalk
 

June7

AWF VIP
Local time
Yesterday, 23:07
Joined
Mar 9, 2014
Messages
5,424
Still don't see reason for subform instead of subreport. Controls can be arranged to look like datasheet, same as a form in Continuous View.
 

kobiashi

Registered User.
Local time
Today, 07:07
Joined
May 11, 2018
Messages
258
Ok, so if I upload some.sample.data with my report, could you tell me whether it could be replicated with sub reports please?

Sent from my ONEPLUS A6003 using Tapatalk
 

Users who are viewing this thread

Top Bottom