Data table spreading out of the sheet design area

[uttamdwibedy]

Dear all,

Hope all are working great there.....!!!

I am developing a Qv model. here I am keeping a straight chart table to view the total data base.

But if I am adding more fields in to the table it expanding horizontally, and spreading out from my sheet design area.

Hence it doesnot look nice .

So Would anybody suggest me is there any option so that I can keep the table within the sheet area.

...Uttam

[m_woolf]

If you add the fields as expressions, the chart can be less wide and a horizontal scroll bar will allow the user to see the columns to the right.

[uttamdwibedy]

Hi Dear,

Ok, so you are saying that the fields that I was added in dimention field that all to add in the expression field , is it ?

And If I will do so will the data in the table affect, would I get the exact data ?

...Uttam

[amars]

Hi Uttam,

What mwoolf suggest is that instead of taking a Table , you can take a Straight Table Chart/ a Pivot (With Always Fully Expanded property set) and then only you can limit the size of the Chart. If it is just a table then you can not control the width of the chart and it will keep on growing as more fields are added (As Table does not allows to have a scrollbar inside the table , but if the table grows rather the Tab will have a scrollbar below). Having a Straight Table/Pivot will add a scrollbar inside the Chart to control the width of the Chart.

To have the same no of rows you can write such a expresion, so that the no of rows will remain the same. (like count of the primary key etc.) After adding the exp in Straight Table you can hide that column as well.

Thanks

Amar.

[uttamdwibedy]

Hello Amar,

Ok, that means I have to write the expressions for all the field that I want to add into the table .

But here I didn't get your point said as" Straight Table Chart/ a Pivot (With Always Fully Expanded property set) " , is it a property of a straight table ?

[amars]

Sorry Uttam,

You can add all the required fields as dimension and only one expression which will allow all the records to be shown. Like Count of the Primary Key etc. You can later hide this column.

Similar to a Straight Table chart you can have a Pivot with the Propert set as Always Fully Expanded true. So it looks like a Straight Table (with some variation only).

Thanks

Amar

[uttamdwibedy]

Amar,

I think you are not getting my problem exactly. I am asking you that , if I am using a straight table and I donot want to hide the fields .

But the straight table is expanding horizontaly and going out of my sheet design area, which i donot like at all. for ex. below attached is the sample qvw. .

check that how to resrict the width of the table within the right hand side boarder.

[uttamdwibedy]

Hello .

would any one not want to help me?

[m_woolf]

Have you tried what I previously suggested?

[amars]

Hi Uttam,

Please find the attached file

Thanks

Amar