I am trying to build a report having multiple queries (total 6) and need help on the following things
1) some of my queries are crosstabs so no of columns vary for these queries, so I not able to see the complete table in the output. Please advice a fix so that I should always see all the columns in the defined space. The text sixe can grow or shrink based on allocated space
2) Print report output in excel - I want output in excel so that user can play with the data if they want
3) Print report in 1 page - currently my report is getting print in 2 or more pages. How can I just limit it to fit 1 page? Please advice.
Thanks
SKV
1) some of my queries are crosstabs so no of columns vary for these queries, so I not able to see the complete table in the output. Please advice a fix so that I should always see all the columns in the defined space. The text sixe can grow or shrink based on allocated space
2) Print report output in excel - I want output in excel so that user can play with the data if they want
3) Print report in 1 page - currently my report is getting print in 2 or more pages. How can I just limit it to fit 1 page? Please advice.
Thanks
SKV
