Solved Report/Query won't print my results

asteropi

Member
Local time
Today, 19:12
Joined
Jun 2, 2024
Messages
144
Hey guys, I need some serious help fast.

So I have a system for an online shop.
I have a form for the Orders which prints 3 reports.
If the customer is wholesale but not paid yet, it prints a quotation
If the customer is wholesalebut paid, it prints an invoice
If the customer is retail, it prints a receipt.

It used to work fine, but now it won't show the products or the customer info. It seems it's not pulling the info from the order form.
It only shows up correcly for the first order I have, but everything else comes out blank.

I have a customer waiting for a quotation so I need to solve this one fast. Please help.
 
is the report based on query and the query is getting the filter from the form?
it's hard to guess, without seeing what is going on on your form/report.
 
is the report based on query and the query is getting the filter from the form?
it's hard to guess, without seeing what is going on on your form/report.
yes you are correct
 
So what do you see in the query?
An issue like this will normally be down to data
 
1760090079801.png
 
remove the filter from the query, do you see any data?
 
I meant the data view, not the structure.
Take a copy and remove one object at a time and see what is revealed?

I do not see any criteria in that query?
 
I meant the data view, not the structure.
Take a copy and remove one object at a time and see what is revealed?

I do not see any criteria in that query?
1760090366231.png


just a blank query. it doesn't pull any data
this is the only criteria i put

1760090433412.png
 
you should change all Joining lines.
right-click on each relation line and choose: Join Properties
and from there choose:

"select all records from OrdersT..."

do this to all your relation lines.
you should have this:
1760090079801.png
 
I did. Thank you so much.
This forum is amazing when it come sto helping out beginners like me :D
 

Users who are viewing this thread

Back
Top Bottom