View Full Version : Strange issue with reports


Crowbar
05-08-2008, 07:48 AM
I am scratching my head hard over this one....

I have inventory DB for 2 companies under 1 roof.

What I did was get the DB working for main company, make a copy, change some text on reports and forms from company A to company B.

now I am adding some new reports to both DBs - using a parameter query.
you know, the standard: Between [enter starting date] and [enter ending date]
this query works fine in both DBs

Now I use this query to make a report, and pass the parameters into the report by using the [enter starting date] as the control source in a text box.
This works fine for company A but I can't get it to work for company B.

I am sure the text matches exactly between the query and report, in fact I even tried copying the text and pasting it into the control source box.

I have tried copying the entire query and report from A to B, and tried writing everything from scratch, but the dates just won't show up. (comes up blank)

I am totally stumped, anyone ever have an issue like this?
I am sure its something dumb, but I just can't find it!!

Crowbar
05-08-2008, 09:59 AM
Wow, I solved my own issue!!!

Deleted both the the offending query and report, compacted and repaired, and then re-created both query and report. It was a bit of a PITA but it worked.

Strange issue.....

Crowbar
05-08-2008, 10:36 AM
Yikes, it worked in one of my test copies, but not in the real version.
I am back to stumped once again. Deleted all and compacted several times, but still not showing up.
Now I am extra stumped!!

Crowbar
05-09-2008, 05:41 AM
UPDATE:
error is in 2 different databases -
reports to display parameters that worked yesterday do not work today. created new test report using technique from here - http://support.microsoft.com/kb/208630
dont work in the 2 databases, but work fine in others.
Could this be some kind of damage to the database?

Crowbar
06-06-2008, 07:52 AM
**UPDATE**
If anyone really cares -
I *think* I found the issue here

If the report has no data, then it does not print the parameters.

Since I was just testing out a new DB, my data changed often, sometimes I deleted it totally. Now that this is in production, no more missing parameters.

No Data=No Parameters printed.....

boblarson
06-06-2008, 07:56 AM
Glad you got it sorted and thank you very much for posting back with the answer. Perhaps this can help someone else in the future.
http://downloads.btabdevelopment.com/2-Thumbs_up.png