#Error in Reports

[abackdahl]

Hi there,

I get this error when there is no data to display in two different
areas:

1) Where the sum and grand totals would be

2)The report requires the user to enter begin and end date... The
"#Error" shows up where the date range would normally show up if there
was data to display.


I would like the users to be able to see the date range they entered
so that they would not think they entered the wrong date and I would
like the #Error to be replaced with zero where the totals are.

Thanks!

Toni Backdahl

 

[KARL DEWEY]

Copy your date criteria and paste in a calculated fields like this ---
Start_date: [Enter start date]
End_date: [Enter end date]
Then the data is available for use in the report.

NOTE - Always copy and paste so it will be exactly the same else
it will prompt twice givin a chance for error on your part.