Hi David, that's perfect, applied this logic to other reports also and fine !!. I see now the logic of percentages across the diferent levels of rows and columns,...

Sum(Fields!qty.Value) / Sum(Fields!qty.Value,"Product") should give you percentage of product qty

Sum(Fields!qty.Value) / Sum(Fields!qty.Value,"DataSet1") should give you percentage of total qty

Are Product and storage groups, is qty a sum of qty?

Hi David,

I as well can execute it. For example , I have such value: round(0.57,0). When the number less 1 it doesn't work.

As well I receive in this case...

Look at the ROUND function

I know it doesn't contribute to the conversation at hand but it's just fascinating to me that this type of thing is still an issue since the release in...

You're welcome and thanks for the feedback.

You could use powershell to do it. If you google 'powershell extract rdl' you will get a few options, ie

https://sqlbelle.wordpress.com/2011/03/28/how-to-download-all-your-ssrs-report-definitions-rdl-files-using-powershell

It is a bit old but it works fine for SQL...

Brian is correct the only way to find out what to replace is to convert it to hex (VARBINARY).

You cannot use the characters that you see in SSMS, notepad or...

I normally don't do self-advertisement but I'm giving a presentation tonight at 6PM EDST online on an interesting subject.  Here's the link to the Meetup and the abstract...

... and I absolutely do not want someone doing maintenance to change ISNULL to COALESCE to add a third parameter and then get an insidious bug because Params 1...

Not necessarily. Use two selects in the query,...

The New England...

Maybe you should change your handle to SQL God cos you...

Allowing failure: Steve and others use children learning as an analogy for this. That works very well because this is childish. When I am a member of your...

Personally I would concatenate the varchar columns into a single column and depending on how volatile the data is, either a computed column or a separate table and full text...