Hi... 🙂

We may use a list control and place our report data region on that and group that list control with the first field of that report region.

Please try once...

Hi, 🙂

I guess, this can be acheived by using either nested IIf statements or SWITCH statement as

=Switch(Fields!Value1.Value, "Case1", Fields!Value2.Value, "Case2")

Please try...this should help... 🙂

Cheers,

Niraj Joshi

Hi.. 🙂

Many regards.

You can try storing your report folder information in a hidden text box and refer this text box using ReportItems.

Please try this once.

Try using textbox1.Value = Globals!ReportFolder..with hidden...

Hi...Abj 🙂

Regards,

You can create a parameter such as SelectTopRecs with the data type as Integer. Then you can create a group based on the field you wish to calculate top...

Hi.. 🙂

Regards,

You may try refreshing report datasets once.

Thanks,

Niraj

Hi.. 🙂

Regards,

As you have mentioned..you are able to get 'All' option in your Parameter dropdown.

Please let me knw, did you bind that 'All' to main query as;

Example:

Select * From...

Hi.. 🙂

Regards,

Please go to visibility property of the textbox where you are trying to calculate the sum.

Example:

Textbox name where you are calculating the sum is : SumTextBox

Textbox name which...

Hi.. 🙂

I guess..you can check the check box for "Allow Null" option in SSRS Report Parameters Properties.

Try this. This should resolve this issue.

Thanks alot,

Niraj

Hi 🙂

Please try using the property "RepeatOnNewPage" and keeping the same as "True".

Thanks alot,

Niraj

Hi... 🙂

May b, instead of top, you can try once keeping border only at bottom.

🙂

Thanks alot,

Niraj

Hi Raghu,

Many regards.

Hey, did you try using Round function?

Try once,

=Round(Fields!Valuetoberounded.value)

This should help. 🙂

Thanks alot,

Niraj

Hi.. 🙂

Regards.

Please try setting Format property (given just below the Point Lable property)...as 0.

I think, this should work.

Thanks alot,

Niraj

Hi..:)

Regards frend!!

Did u try using Matrix Reports for the same issue?

If not..yet...please try it once...I guess..it can b acheived in Matrix Reports Layout...

Thanks,

Niraj

Hi..:)

Regards frend!!

Well, did u try storing Credentials to access the concerned data source Cube where it is (On the system)....??

Please try giving valid credentials user name / password and do...

Hi..:)

Regards frend!!

Well, it seems to be a permission issue to me.

Did u try checking and assigning permissions to Everyone on Reporting Services Server?? Please check it once.

Thanks,

Niraj