Repeat Group header and header doesnt work when exported to excel in SSRS 2008


hi.

i have set table header , group header repeat on new page.. when run report works fine on report manager... when export excel 2003 , hit print preview headers dont repeat on second , other pages.. how should fix this?

and noticed strange fine when exported excel. , in ssrs 2005. first column in table had set false when ran report on report manager columns had been shifted left when exported excel worked fine.

any appreciated.

thanks

karen

 

 

 

 

 

hi karen, 

first question: need repeat group header , table header when export report excel, please refer steps achieve this:
1. open excel file, click “file” menu , select “page setup”.
2. in “page setup” dialog, click “sheet” tab.
3. in “rows repeat @ top” section, type in : $1:$1
(note: “$1:$1” means repeat row 1.)

after that, header displayed on first page , repeat headers on subsequent pages. more information, please refer article below:
http://gaetc-ejournal.org/tutorials/excel/teachexcel/columnheadings/columnhead.htm

second question: please post me property of first column have set “false”? if possible, please post details steps design report. try reproduce issue on local machine , assist resolve it.

if have questions, please feel free ask.

thanks,
bin long


SQL Server  >  SQL Server Reporting Services, Power View



Comments

Post a Comment

Popular posts from this blog

Reindexing

hi     using sql server 2005 ee sp4. our database size 150 gb. weekly once schedule reindex job. ran 4 5 hours maximum. but recent days getting more 13 hours. the possibilities there? ragu thangavel how perform reindex? maint plan? or check fragmentation first , reorganize fragmented? if later, quite more data nowadays fragmented before. if not, consider doing "smart" defrag (ola.hallengren.com). tibor karaszi, sql server mvp | web | blog SQL Server  >  SQL Server Database Engine
Read more

Users List

hello everyone, i"m builing tool tfs , want user list form tfs "assigned to" field. if 1 can post code review i"ll gled.   thanks hello, to imports users tfs, can try this: using microsoft.teamfoundation.server; using microsoft.teamfoundation.client; using microsoft.teamfoundation.workitemtracking.client; icredentialsprovider provider = new uicredentialsprovider (); teamfoundationserver tfs = teamfoundationserverfactory .getserver(“your_server_name”, provider); tfs.authenticate(); igroupsecurityservice gss = ( igroupsecurityservice )tfs.getservice( typeof ( igroupsecurityservice )); identity idsid = gss.readidentity( searchfactor .accountname, "team foundation valid users" , querymembership .expanded); identity [] idusername = gss.readidentities( searchfactor .sid, idsid.members, querymembership .none); foreach ( identity id in idusername) {       if (id != null && id.type == identitytype .windowsuser) ...
Read more

List of charts

Image
i'm trying build report show activity for reservations placed and satisfied month branch. the report has parameter the item category and dataset has fields month category branch reservations placed reservations satisfied on front sheet i've created system wide figures 2 columns per month and a matrix broken down category (e.g. child fiction, child non fiction, adult fiction, adult non fiction) has row , column totals. i want have page each branch in system. what's best way of approaching this?  add parent group based on branch field in row groups  and add page breaks repeat matrix report every branch. please mark answer if post solved problem. milan das SQL Server  >  SQL Server Reporting Services, Power View ...
Read more