SSRS textbox column - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

Reporting Services Development

SSRS textbox column

Author

Topic

Villanuev
Constraint Violating Yak Guru

478 Posts

Posted - 2011-12-16 : 01:33:22

Guys,

I have 10 textbox column in my SSRS report.
I want my report when exported to excel it should be also
10 columns. how can i do this format?
because there are some fields that occupy 2 or 3 columns
when exporting into excel file. meaning 1 fields in my SSRS form
but when exporting to excel it merge 2 to 3 columns.

Regards,

JOV

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-16 : 01:55:58

are they inside some group in ssrs report?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Villanuev
Constraint Violating Yak Guru

478 Posts

Posted - 2011-12-16 : 02:31:13

I did not use gruping. but i notice that there are some columns that still intact into on column. but the others fields merge into 2 or 3 columns when export to excel. Also when i open the Exported excel file the merge and center and wrap text is acrivated.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-16 : 03:17:28

have you explicitly merge multiple columns inside ssrs report to create the columns?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Villanuev
Constraint Violating Yak Guru

478 Posts

Posted - 2011-12-16 : 04:24:43

I have table to create columns, then place the fields to table. this is what you mean visakh?
some coulns are fine but like the first field when i export to excel it merge from column A&B.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-16 : 06:39:36

ok...my question whether you had explicitly merged columns inside table container

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Villanuev
Constraint Violating Yak Guru

478 Posts

Posted - 2011-12-18 : 20:16:46

Hi Visakh,

I notice why i have a merge columns when exported to excel because of the page header and
sub-report that i have added. I already fixed the page header but my concern is my sub-report that it cause merge column when exported to excel. Thanks.

Villanuev
Constraint Violating Yak Guru

478 Posts

Posted - 2011-12-18 : 21:57:33

Done. I have to aligh page header.
Also, align the width for Sub report records.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-18 : 23:46:53

hmm...ok..that makes sense

anyways glad that you sorted it out and shared the details as a learning point for others

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources