Solved Report not displaying all values in source query (1 Viewer)

Kayleigh

Member
Local time
Today, 21:51
Joined
Sep 24, 2020
Messages
706
I am having trouble with a report based on a query. It is not showing all values.
There are no events in open/current/load of report to filter or change the data.
What is going wrong here?
 

Attachments

  • query source.png
    query source.png
    20.5 KB · Views: 265
  • report.png
    report.png
    18.3 KB · Views: 271

CJ_London

Super Moderator
Staff member
Local time
Today, 21:51
Joined
Feb 19, 2013
Messages
16,553
sure you have the right heading for each column?

values in your report 'converted values' column are in the query cfsumsold column
 

Kayleigh

Member
Local time
Today, 21:51
Joined
Sep 24, 2020
Messages
706
Design view here - just renamed columns for easier user comprehension.
 

Attachments

  • Screenshot 2022-01-12 194828.png
    Screenshot 2022-01-12 194828.png
    24 KB · Views: 176

CJ_London

Super Moderator
Staff member
Local time
Today, 21:51
Joined
Feb 19, 2013
Messages
16,553
OK - sure you are using the same query -qty sold quantity is different for existing customer 2 v 3. Conversion rate/percentage appears to be different for community 67% c 33% unless you have something else going on in the report? Just checking the obvious things first
 

Users who are viewing this thread

Top Bottom