Dynamic Parameter

[lgmin]

I have a dynamic parameter that is also cascading. One of the parameters is a date, and data is added daily to the database. When the parameter pulls up, the new dates appear when new data is added, however, the report comes out blank. The report works fine for all the previous dates, just not the new dates. I went into the underlying database and all the data for the new dates is there. Any suggestions on getting my report to come up for the new dates?

Thanks.

lgmin

 

[synapsevampire]

Check what the database is passing to the database, sounds like the SQL is incorrect.

If in doubt, post it here.

-k

 

[lgmin]

After much analysis and review of numerous fields and queries, I discovered that the user importing the data into the database removed a leading zero in one of the fields from his text file, so there were no hits.

Thanks much.