Ashfaque
Search Beautiful Girls from your town for night
- Local time
- Today, 23:05
- Joined
- Sep 6, 2004
- Messages
- 897
Hi,
I placed 2 reports in a main report and generating data. All of them are based on simple queries with date criteria. It works fine.
Example: Let us assume the main reports sum is US$ 149.42. !st sub report's sum is US$ 29.12 and 2nd sub report's sum is US$ 3.12.
At the main report's report footer (in a text box) appears 181.66
The only problem I am facing is when I need to display NZ sum of 1st sub report on Main report as well as the second sub report's sum when there is NO DATA.
I tried using nz function but it always produces 'Error'. If works well when all the 3 sub total text box contains data. But produces Error when there is no data. I need it to produce 0 upon no data.
Any idea?
With kind regards,
Ashfaque
I placed 2 reports in a main report and generating data. All of them are based on simple queries with date criteria. It works fine.
Example: Let us assume the main reports sum is US$ 149.42. !st sub report's sum is US$ 29.12 and 2nd sub report's sum is US$ 3.12.
At the main report's report footer (in a text box) appears 181.66
The only problem I am facing is when I need to display NZ sum of 1st sub report on Main report as well as the second sub report's sum when there is NO DATA.
I tried using nz function but it always produces 'Error'. If works well when all the 3 sub total text box contains data. But produces Error when there is no data. I need it to produce 0 upon no data.
Any idea?
With kind regards,
Ashfaque
