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

Kayleigh

Member
Local time
Today, 17:04
Joined
Sep 24, 2020
Messages
616
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: 232
  • report.png
    report.png
    18.3 KB · Views: 236

CJ_London

Super Moderator
Staff member
Local time
Today, 17:04
Joined
Feb 19, 2013
Messages
14,694
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, 17:04
Joined
Sep 24, 2020
Messages
616
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: 128

CJ_London

Super Moderator
Staff member
Local time
Today, 17:04
Joined
Feb 19, 2013
Messages
14,694
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