Hi Steve,

That's nice that you have found the solution already. Unfortunately variables cannot be passed in the manner you have been trying earlier. This is the easiest way, there is...

Hi Steve,

You can use it like this,

Function AlternateColor(Byval rowNumber as integer,EvenColor as string,OddColor as string) As String

If rowNumber mod 2 = 0 then

...

You can use this instead

Format(Fields!TRANS_DATE.Value, "MM/dd/yyyy")

Please check the data type of the fields on which "=" operator is used. Both fields must have the same datatype.

I guess your question is simply to fetch the result of a query in the report based on some set of input parameters.

I that case, first define two parameters for...

Thanks Thom ! I was following the same approach. I got the issue for the username since it has a alpha numeric character and number I was using the lower...

Thanks for your comments but unfortunately coloring the borders was not an option, as this idea was already rejected since it was having visual problem for the end-users.

How ever since...

Hi Koen,

Thanks for you suggestions, well my approach was different but i could deduce from your suggestion.

What I did is made a union of the two tables the 1st table...

Build In variables like Page Number and Total Pages does not work in Report Body, as they are property of Page Footer and Header.

One more reason because the body of...

You need to go for a custom code that sets a flag and value in a variables, and set the value based on the condition(flag value) in the page footer.

Have you tried this?

If you are using a table to display the field values then give it a try,

In the row visibility add this code : =iif(IsNothing(Fields!DataSetColumnName.Value),true,false)

Or in case your problem has not got resolved yet, here is another option that you can try...

=Format(Now(),"MM/dd/yyyy")

The Datasource name in the Report Server does not accept space while calling the datasource.

Suggestion is to give a name of the datasource as eg: "ds_datasourcename" insted of "ds datasourcename"

It...

In the text builder itself write the sp name only without using exec statement and put question mark "?" for the parameters.

stored procedure ?,?,?,?... (no of parameters = no of...

Either use the shared datasource of the parent report in the child or use an embedded datasource with saved credentials...