Out of object memory in straight table

[jagannalla]

Hi,

I had a straight table with large number of fields. Actually, i had taken tablebox to display all fields but tablebox not able to hold large number of fields when i tried with tablebox it shows X symbol. To overcome this i had taken straight table with all fields in dimension and expression as count(1) and i'm hidding this expression. But even though i'm getting out of object memory.

- I had searched for the reson why i'm getting this problem. At last i found that we need to use proper expression in charts. Can anyone help me whether i'm using proper expression in straight table or not.

- I want to see all fields data in straight table.

[johnw]

Remove the expression and instead uncheck "suppress zero values" on the presentation tab.  That might help, but it may not fix it.  Ultimately, if you have a very large number of rows x a very large number of columns, it simply can't render the chart.  But then, I'm not sure what user can actually look at, say, a million rows of 100 columns each.

[jagannalla]

Sorry john to late response...You said that you are not sure what user can actually look at, say, a million rows of 100 columns each.

- For this i had taken tablebox for testing, first i had taken Primarykey in tablebox and caption as count(Primarykey). i.e the value is 5000.

- Caption for striaght table as above caption we taken for tablebox. In both cases the value is the same.

Thanks a lot john..