Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
When I go to "Table Viewer" right click to preview the "Dialog" it shows my information but when I create a new "Chart" or "Table box" it shows me less information. the "Dialog" previewer shows me 4 records but the "Chart" or "Table box" shows only 2 records.
What would cause the Dialog box be different from a table or chart?
thank you in advance!
Hope the Attached file will solve your issue. I have added RowNo to the records and hided the column
Share the image or application to check the issue
It is showing the Distinct values.
what I the expression you have used in the chart?
no expression. even if i create a table box or a list box it only shows 3 records instead of the 6.
In List box or Table box, by default it will show only distinct Values. You should add the other columns which has values that are not distinct.
that's correct I was just trying to give you more samples on were the records are not displaying properly. it seems to only work when I create a basic Chart using SUM(Quantity) and not just Quantity. I shouldn't have to do this it should just display the same as the Database (Dialog box).
So the Column which has unique values are Quantity.
If you add Quantity as your Dimension the issue will be solved I Hope. for expression just add 1 and hide that column in Presentation tab.
here's what the report displays. I need the chart to look like the original.
thanks for your help so far!!!
Hope the Attached file will solve your issue. I have added RowNo to the records and hided the column