Adjusting reportwidth dynamically.. please help me

hi,

I am new to reporting services.I am using sqlserver Reporting services to generate Report.I have designed a static RDL file based on a view which contains 40 columns..i included all the 40 column in rdl file..i have used hidden field expressions for hiding columns..Now at run time if i select three columns for generating report, The remaining hidden column spaces are still there in the report ... The report width is not adjusting to the selected column width... how to eliminate the hidden column spaces in the report.Please help me..it is really urgent for me..

Thanks in advance...

You can change the width of the ReportViewer in the Load() event like so...

ReportViewer1.Width=500

I think if you try to do it in another event it has no effect becasue the size has already been rendered.

Good luck.

|||

try to set the width = "auto"

adding image dynamically to crystal report

hello
please could anyone help me to insert an image into crystal report if I saved the link in the database . I tried to change the type to "ole object" it works, but i don't have to change the type in my project.If you are using SQL Server then search for TextCopy.exe, you will get lot of related code.|||it is very easy in the Crystal 11.5 and later.

Place the OLE object -> Bitmap Image on the report. Right click the OLE Object -> Format Graphics -> Picture (tab) -> Graphic Location.

And enter the URL where the image file is placed.
Now the crystal Report will show the image on runtime by picking from the location mentioned.|||i'm using v8.0 , i'll download the XI version and I'll try

Adding Database Fields Dynamically To the Crystal Reports

I have a problem Where in i need to show 24 sizes in one session so i have sliced it to 3 rows 8 columns each , it is not necessary that all the 24 fields should contain data so if there are only 8 sizes i have to show 8 sizes and i have to reduce the size of the section to one row . I am able to suppress the fields in the section but iam unable to reduce the size of the section to one row . so i want to add the fields dynamically to the session instead of drag and drop using ASP.NET(VB) .
Please can any one help me .
Its very very urgent.Could you be using a crosstab? Placing rows and columns i seperate table columns and then printing them in a crosstab.

- Jukka

Adding Columns Dynamically

Dear All,

I have a requirement, in which i have to add columns dynamically depending the records of a master table in sql server 2000.

Pl, do help me

If you mean a query, than there is no way to do that beside dynamic SQL. if you want to use dynamic SQL, make sure you first read the article of Erland to fully understand what you are doing:

http://www.sommarskog.se/dynamic_sql.html

HTH, Jens SUessmeyer.

http://www.sqlserver2005.de
|||

A.K.A Cross Tab query

Research SELECT CASE WHEN THEN END AS []

Adamus