Thanks for the quick response! Worked perfectly... Thank you very much!

I started using SSRS with text datasets.... The reports were great, spent ages on them... Unfortunately our database had a major breach with loss of some important data. After checking...

Just a few questions in order to help...

Are you using data driven subs? Im assuming that the subscription was set up on your account using your user name right? If...

Just to check, if I have mis-understood let me know but your report does work as intended and the sub-totals and totals are correct even when exported into excel. However...

Hi, to answer your questions;

1. You can use multiple datasets in reporting services to call 1 stored procedure only. So 1 dataset is 1 stored procedure. You can however have...

Good article, I too had to do something similar but the approach I took was to apply the SSRS security and also create a report that queried the security setup...

Just a guess but the error you get when selecting the "Select All" option which as far as I know has no bugs around the "Select All" is that maybe...

You would need to create a new report which would be used when you click on the section of the pie chart. Then use the jump to to direct the...

Just a couple of questions really, and a suggestion...

Does the HR system pull the information in automatically directly from the report or does it pull it in from an outputted...

No problem, glad I could help... Glad I could return the help that many, many user's on this forum have given me!:-D

nice one, really simple solution, thanks for the update of the example!!

I suspect this is an issue with your page size settings and the size of your objects more than anything to do with whitepace. You can check to see if...

I would like to see your full existing query however based on what you have posted;

Select SalesS.Id, SalesS.Value, ROW_NUMBER() Over (ORDER BY [SalesS.Id] ASC) AS RowID

FROM

SalesS

NP glad you got it sorted.

have you set the text box property CanGrow to true? Screenshot attached...