March 7, 2018 at 9:55 am
Hi I have a report that calls a sub report multiple times - All works fine until I export to Excel and then I have two datasets that when included will add a blank line to the excel (but fine on screen) - There are multiple datasets that cause no issue. The datasets are very simple just a date and a float value.
So the main report is just a table that contains a subreport inside one of the cells and is then repeated for each value in the parameter. The sub-report is another table that displays the data series date and value pairs - V simple 🙁
Any ideas please this is driving me mad 🙁
Cheers
Andy
March 8, 2018 at 7:59 am
Andy Reilly - Wednesday, March 7, 2018 9:55 AMHi I have a report that calls a sub report multiple times - All works fine until I export to Excel and then I have two datasets that when included will add a blank line to the excel (but fine on screen) - There are multiple datasets that cause no issue. The datasets are very simple just a date and a float value.So the main report is just a table that contains a subreport inside one of the cells and is then repeated for each value in the parameter. The sub-report is another table that displays the data series date and value pairs - V simple 🙁
Any ideas please this is driving me mad 🙁
Cheers
Andy
I'm not sure I can visualize what you're saying. If you can provide an image that would perhaps make this a lot clearer. However, that said, we'd probably also need an image of the design view on the report as well. Either way, we need a lot more detail.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
March 8, 2018 at 8:57 am
I've just figured the problem out - if I include blank cells in my table in the main report
------------------------------------------------
| | SUB - REPORT | |
------------------------------------------------
I get blank rows - If I take out the blank cells So the table only has one cell and put the blank cells in the sub-report - Happy days - Still no idea why, but it's fixed
Cheers
Andy
March 8, 2018 at 9:00 am
Andy Reilly - Thursday, March 8, 2018 8:57 AMI've just figured the problem out - if I include blank cells in my table in the main report------------------------------------------------
| | SUB - REPORT | |
------------------------------------------------
I get blank rows - If I take out the blank cells So the table only has one cell and put the blank cells in the sub-report - Happy days - Still no idea why, but it's fixedCheers
Andy
WYSIWYG. What you see is what you get. SSRS has been doing that for a rather long time. If you include a blank cell and don't suppress blank rows, that's what you'll get. Look into suppressing blank cells or rows.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
March 8, 2018 at 9:02 am
I'm getting blank rows not blank columns
March 8, 2018 at 9:12 am
Andy Reilly - Thursday, March 8, 2018 9:02 AMI'm getting blank rows not blank columns
Then suppress blank rows..
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
March 8, 2018 at 9:48 am
There are no blanks rows on the report - They only appear when I export to excel 🙂
March 8, 2018 at 10:05 am
Andy Reilly - Thursday, March 8, 2018 9:48 AMThere are no blanks rows on the report - They only appear when I export to excel 🙂
Then be sure you have no NULL records in your source data, but beyond that, also be sure that you suppress a blank sub-report. and blank rows within said sub-report.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
March 8, 2018 at 10:06 am
And that the size of your rows in the sub-report matches the size of rows in the main report.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
March 8, 2018 at 10:14 am
Hi Steve,
Why would that make a difference only when exporting to excel ?
March 8, 2018 at 10:31 am
Andy Reilly - Thursday, March 8, 2018 10:14 AMHi Steve,Why would that make a difference only when exporting to excel ?
SSRS is notorious for making what I'll call "utterly unnecessary choices" when it comes to exporting to Excel, unless you darn near go entirely out of your way to simplify your report down to totally common row height, totally common header height, and a single report width, and ensure that either no NULL rows make it to the output, or use the suppress blank rows feature. The WYSIWYG design forces that crap to occur, whether we want it or not, even to Excel exports. It's been a major pain in people's butts for years. Heck, even a blank footer that hasn't been suppressed could give you a blank row, as could a blank header similarly not suppressed. That's why I'm so "nit-picking" about this stuff. It's become habitual.... of necessity...
And I thought SS I S was a picky SOB...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
March 9, 2018 at 8:23 am
There are so many quirks in SSRS that we just have to find out and then find a work around - Don't get me started on justified text 🙁
March 9, 2018 at 12:19 pm
Andy Reilly - Friday, March 9, 2018 8:23 AMThere are so many quirks in SSRS that we just have to find out and then find a work around - Don't get me started on justified text 🙁
Yep... don't get me started either.. we'd be here for years commiserating...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply