13 responses

30 07 2014

I retyped the entire code and now I get this message
There is an error on line 8 of custom code: [BC30205] End of statement expected.

29 07 2014

this is what I have

Private LowVal As Decimal, HighVal As Decimal
Function SetHeatMapRange(LowValue As Decimal, HighValue As Decimal) As Object
LowVal = LowValue
HighVal = HighValue
End Function
Function HeatMapColor(ThisValue As Decimal) As String
Dim OutR As Byte, OutG As Byte, OutB As Byte
OutB = 0
OutR = 255 – (((ThisValue – LowVal) – (HighVal – LowVal))* 255)))OutG = 255 *(((ThisValue – LowVal) / (HighVal – LowVal)))
Return “#” & Right(“0″ & Hex(OutR), 2) & Right(“0″ & Hex(OutG), 2) & Right(“0″ & Hex(OutB), 2)
End Function

29 07 2014
Paul Turley

It looks like the problem might be with the double quote characters. Text editors and word processors often replace quote characters with “smart quotes”. Try taking this into NotePad and retyping the quotes and then copy the code back into the SSRS code editor.

29 07 2014

I get The is an error on line 8 of custom code: [BC30037] Character is not value

2 04 2014
Dunc Smith

When implementing this I get error:
BC30289 Statement cannot appear within a method body. End of method assumed.

3 09 2013

I have an report that extends your Heat map sample a little. Say for example you have a grouiping above region, say Country. Now within the Region you want all four cells with the same background/fill of the smallest number. Is there a way to do that?

30 08 2013

How to block right click on SSRS Report by using javascript?

2 09 2013
Paul Turley

This isn’t something that Reporting Services was designed to support. Perhaps if you could explain what you are trying to accomplish, in greater detail, I can offer some suggestions.

20 02 2013

I found this Article very useful. I have similar to this scenario problem that i’m facing. I have an assignment in the report that i have to bring data from 2 different datasets and each dataset from different database to display in the same data regions. here is example of my query

Dataset UnitProd: Select ID, Description, permitTypeID, OverallQouta from Units where permitTypeID = @PermitTypeID // This from Prod database

Dataset UnitTest: Select ID, Description, permitTypeID, OverallQouta from Units where permitTypeID = @PermitTypeID // This from Test Database

Here is my report will look like

ID | Description | OverallQouta | | ID | Description | OverallQouta |
54| AA Unit | 10 | | 54 | AA Unit | 15

the requirement to compare between 2 database for OverallQouta if overallQouta is not the same will highlight that row.

for now i use Lookup to bind dataset to display data in the report but when i compare i use expression something like

=IIF(First(Fields!OverallQouta.Value, “UnitProd”) First(Fields!OverallQouta.Value, “UnitTest”),”Yellow”,”Transparent”)
but when it compare and check that overallqouta is not the same it will highlight very row , what i want i just want to highlight only row that different.

Do you have an advise for me to accomplish this requirement?

Thank you.

21 11 2012

Can custom code be used in the navigation property of an report element?? If so how?

11 12 2012
Paul Turley

Sure. Use an expression to build the target path for a URL action. Expressions can call into an embedded VB function in the report or a custom assembly.

9 08 2012
Liangying Wei

Very useful to me. Thanks a lot!

4 07 2012

Nice Article. Many Thanks.

For those who are novice to SSRS, make PersSal as Public Shared instead of just Public

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


Get every new post delivered to your Inbox.

Join 244 other followers

%d bloggers like this: