Hi zoom19,

I don't think there's an actual need to create custom code. I put the same logic into my reports using the following textbox expression:

= "Facility: "

+ iif(Parameters!facilityGroup.Count =...

Hi Aaron,

I'm afraid I'm out ot ideas. To be honest I'm not exporting to word all that often, but if the body of your report is exactly the same size...

Hi Aaron,

Looking at the measurements it seems you have some white space at the bottom of your body/layout. It's better to never leave white space at the bottom or right...

Hi Brett,

As attachment you find the proposed solution based on your code and rdl.

Hope this helps.

Kind regards,

Linda

Hi Ninja,

No, I haven't put effort yet in creating such a tool. I'm still running this rss script from the command prompt so in case you find/create a tool to...

Hi Ninja,

Unfortunately using my script will not help you a lot as it contains some company specific code. Maybe you have a better start with the following article: http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/86883afe-b214-445e-9c8c-100a40324646

Kind regards,

Linda

Hi Ninja,

I indeed saw this behaviour before. Especially changing the obligatory parameters is causing me headaches. For that reason we have a custom reporting services script (.rss file) that will...

Welcome

You're welcome.

It's always the little things that you search for the longest.

You're welcome.

Happy to see that you found the solution.

Hi JV,

As attachment you find a sample rdl report for RunningValue. I guess this is self-explanatory but in case you have questions please get don't hesitate to ask.

Kind regards,

Linda

Hi Journeyman,

I don't see anything wrong with your code. Just copied it into a new report and it works like a charm. I'll try to attach my test rdl file.

Kind...

Hi bcronce,

Please try to following statement = CountDistinct(iif(Fields!bAtAbove.Value = 1, Fields!iuserid.Value, nothing), "group_name")

Hope this helps.

Kind regards,

Linda

JV,

You have to be carefull as doing so you will not end up with the exact last day of each month. See following code sample:

DECLARE @date datetime

SELECT @date = '2010-02-28'

SELECT...

Hi JV,

It is unclear to me where you do the sum, but does the solution not lie in: GROUP BY year(DCLE.[Posting Date]) as Jaar, month(DCLE.[Posting Date]) as Maand ?

Kind regards,

Linda