When a user launches our solution, and creates a new invoice, our solution will prompt the user with a form to verify their till. The the till has till_lines and this table has a relationship to the trans_lines.
For whatever reason, IF a new till is set up, I cannot run a report based on the trans_lines table. I step through the report. It finds the records in the trans_lines table, but when I enter Print Preview, it’s blank.
I get no errors. Not in developer, not in server_log, not in anything.
If I quit my solution and go in again AND NOT start a till, I can then go and run a report based on the trans_lines table and the data comes up.
Any idea what is causing this? I suspect there’s an issue between the relation between the two tables … but without an error, I’m confused.
When print preview is run it actually refetches the data from the database according to the last (internally generated or not) query.
I believe when you create a new record and want to print that you should re-query that record before you do a print (preview).
Thanks for the replies. The reports work fine IF I’m not pulling up what we call a Till.
We are loading the records into the report form and when running the report, we are querying past transactions that may have occurred on any date.
The till_lines to trans_lines relation is new and this issue seemed to appear after we added it. So I suspect we have the cause, but I’m not sure why it’s a cause.