How to set width and hight in cells of a query with the Query Designer 7.x

[Former Member]

Hi,

is possible to set width and hight in cells of a query with the Query Designer 7.x?

The layout of a query takes the dimension of the largest contents of a cell.

Is possible to fix it in a different dimension (i.e. smoller or higher than the contents of a cell)?

I have two query with the same number of columns and rows but in execution they take different value in the same key figure ... if I insert they in the same page in order to show the query results together..they have different dimension..

Example : query 1 takes index value 0,00. Query 2 takes index value more than 10,00.

0,00 is shorter then 10,00, so the dimension of query 1 will be smaller than the dimension of query 2.

I would like to setting the same dimension for the two query.

Is it possible?

Thank's,

Valentina.

[Former Member · Accepted solution]

Hi,

It is not possible in the query designer, but you can do in the analyzer and save as a workbook. You can modify like in excel and save.

I hope it helps.

[Former Member · Accepted solution]

Hi Alec!

...What a pity!

Thank you very much.. but the analyzer can't solve my problem becouse I have to use the query in a template with a web application desiger...

I have a question also on the Repor Designer... I open a new post...

Thanks again,

Valentina

[Former Member]

You can do this with a later SP for BI 7.0. This will be available within SPS 14 for pilot customers only.

Thanks.

[Former Member]

Hi Deepu,

I wait the SPS 14... Thank you very much!

Regards,

Valentina.