Report based on form has 2 rows, 1 for each record with same date

yessir

Saved By Grace
Local time
Today, 03:13
Joined
May 29, 2003
Messages
349
oh, finally I am close to what i need

I have the report in the included db. there are 2 problems though.

1
the subreport DOES sum the total for each outlet if there is one, BUT it includes a row for each outlet, therefore repeating up to 3 times.

ex:
if EN-02 and EN-05 have values 1 and 3 recorded on the same date then the report has the rows:

March 8, 2004 1 0 3
March 8, 2004 1 0 3

when it should only show 1 of the rows

and if there is a value from another date it includes it in this as well.

so how can i have this limited to the sum where the dates are the same.

2
how can I have it display "No flow" if there are no values instead of '0'

thanks for all your help in advance

~ :confused:
 

Attachments

I was able to get the report to summ properly,

But I am still unable to get it to display "No flow" if the value is null, since 0 is a valid entry.

~ :confused:
 
I assume you grouped the subreport by Date and put the summaries in either the header or the footer to get it to sum property. As far as the “No Flow” text, there may be a better way, but the below should work.

Create a new Unbound text box for each column (I am going to use EN-04 as an example). I named the new box EN-04a. Make the original EN_04 Invisible. Then put an If statement in the On Format event of the data Header or Footer. The If Statement is below.

If (Me.EN_04 = 0) Then
Me.EN_04a = "No Flow"
Else
Me.EN_04a = Me.EN_04

End If

Then just repeat for the other two columns. This is not the most elegant solution, but it worked when I tested it.
 
again though,

the problem is in setting the data to 0 if null since 0 is a valid response.

thus 0 quantity is a good thing and if there was no quantity (ie no flow) that is not the same as 0

thus basing the visibility on 0 destroys valid inforamtion

thanks again though
 
ok, so here is another problem...

if the value entered is 0 it percieves it as null

I am scraping the No flow thing and just displaying a blank.

but now valid 0 entries are also blank.
 
got it,

thanks to everyone who helped and for all your patience.

~ :D
 

Users who are viewing this thread

Back
Top Bottom