September 14, 2017 at 3:38 pm
In a ssrs 2008 report, the users have been exported the report in a PDF format. Now the users want to export the report to an excel file that has the extension of .xls. The want to do that since they want to be able to filter columns using excel. The problem is some of the report columns show up in 2 or 3 columns in excel.
To solve this problem, I have removed the following items from the report header:
1. Report name and
2. report runtime, and
3. report page numbers.
I have placed the items that were in the report header into the report footer. These items appear on the report when the report is executed but do not appear on in excel from the export.
I am asking about keeping the items in the report header since my company has a standard to include these in the header.
Thus can you tell me the following:
1. What else I can do to solve my problem and/or
2. Is there a way for the export to excel to work and still keep the report name, run time, and/or page numbers in the report header?
I would appreciate it if you would tell me how to accomplish my goal and/or let me know if what I am requesting is not possible.
September 14, 2017 at 3:44 pm
You need to ensure all the objects on your report line up. If you have multiple tablixs, they need to all have columns of the same width. If you have text boxes elsewhere in the document they must and a width and left position that coinsides with the columns in your tablixs(es). The text, if you wish, can be wider than any of the columns but then the right MUST be at the same position of a column still. That will cause the report the render in a friendly format.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 15, 2017 at 8:49 am
I have a tablix at the bottom of the report that contains only two columns that displays the report parameters and this works. Thus are you saying that if I make the report header to have the number of boxes that is in the main tablix, everything would line up?
September 15, 2017 at 1:07 pm
I don't think the header needs to have the same number of boxes as the tablix. It's just that the ends of the header box should line up with columns in your tablix (or make the header the same width as the tablix)..
September 18, 2017 at 1:50 am
wendy elizabeth - Friday, September 15, 2017 8:49 AMI have a tablix at the bottom of the report that contains only two columns that displays the report parameters and this works. Thus are you saying that if I make the report header to have the number of boxes that is in the main tablix, everything would line up?
No, you don't need to have the same, just that they line up. This is a little hard to represent in text but, imagine the first box is the header, and the second is the header of your Tablix. This example is good (all lines up):
___________
|___________|
__________ ___________ ___________
|__________|___________|___________|
This example is bad (doesn't line up), and so will create merged cells:
_______________
|_______________|
__________ ___________ ___________
|__________|___________|___________|
This will mean you can't put a filter on your Header Columns, as (most likely) the first column will be a merged cell for Columns A & B, The next will be C, and the last D & E. Your header cell, would also be a merged cell for columns B, C, and D.
Fun times! 😉
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply