Dialog different from table

[easternfish]

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!

[krishnacbe]

Share the image or application to check the issue

[easternfish]

[krishnacbe]

It is showing the Distinct values.

what I the expression you have used in the chart?

[easternfish]

no expression. even if i create a table box or a list box it only shows 3 records instead of the 6.

[krishnacbe]

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.

[easternfish]

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).

[krishnacbe]

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.

[easternfish]

here's what the report displays. I need the chart to look like the original.

thanks for your help so far!!!

[krishnacbe · Accepted solution]

Hope the Attached file will solve your issue. I have added RowNo to the records and hided the column