AmitVernekar85
asked on
SSRS Report Help - Excel format
I created a report (please see attached) and exported to excel. The problem is Excel puts it into weird format. There are blanks in between the random records. Its hard to sort. When I click on header it selected everything. Also for the last three columns the Excel is merging the rows and also is not aligned correctly.
Report.xlsx
Report.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Then it looks like you need to educate your client on what is possible and what is not. A successful tactic I've used in the past is 'I can do it this way super cheap, or I can do it that way really frEEaking expensive', and let them make their own decisions.
Also if you read the article and follow along that would be reasonably close to 'super cheap'.
ASKER
I was able to figure it out. I just modified the store proc to include unique counts and removed the extra tablix.
ASKER