Hi Sandra...:)

Best Regards frend !!

I think...you have choosen the correct option to convert an XML file into a PDF format file..

Well, I came across such situation once and I also...

Hi...:)

Regards frend..

Please check once, that the ReportViewer Property :: ShowParameterPrompt must be set to True.

Thanks,

Niraj

Hi...frend..:)

I hope..this may help u...

Suppose u have fields...such as Electric Usage, Gas Usage, and Unit Price..Now..u want to calculate the sum.

So...you may try this infront on Total Field;

=Sum(Fields!ElectricUsage.Value)

=Sum(Fields!GasUsage.Value)

=Sum(Fields!UnitPrice.Value)

Thanks alot,

Niraj

Hello again....:)

Yes...its absolutely correct...

When ever you will click on Dept Name, then that particular name will be passed as a parameter to Sub report and that respective sub report will...

Hi..

Regards to you...:)

As you said..we can use sub report to acheive this task.

We need to create a sub report which excepts Department name as a parameter and then using...

Hi Tima,

Regards to you...:)

You are absolutely correct saying..that the functions "MyFunction" (Custom function)....is never shown as Code.MyFunction...in Expression window...

Well...I would like to say that even though it is invisible..means..not shown...

Hi Vijay...

Regards to you...:)

Well, I tried to change backgound color and deployed the same on the Report server...Bt here on my end, its working fine!!

Please let me knw..in detail regd...

Hi...

Regards to you.. 🙂

I guess, you wish to fill your parameters drop down list with the concerned values.

If its correct, then you may try creating seperate DataSets for different parameters...

Hi Philip,

Regards to you. 🙂

You may try this Switch statement as below;

=Switch(Left(ReportItems!RefText5.Value,3)="PUR","PURCHASE",

Left(ReportItems!RefText5.Value,3)="REP","Repair",

Left(ReportItems!RefText5.Value,3)="SUB","Sub Contract")

Thanks alot,

Niraj

Hi Bhushan...

I'll explain u a scenerio for using a List Cntrl..

See...suppose...I have a report with a Parameter such as Item Name...Now..I may select only a single or multiple item names...

Hi Liz...:)

Umm...I guess...u may use a List Control and may keep the respective tables with in....after this use a rectangle and set a after page break property for the respective...

Hi...

As I have replied earlier..u may use Reporting Services Web Service and using an object for the same..you can convert an RDL file to a simple tabular format or in...

Hi...:)

I think...you can retreive information frm an RDL file using Reporting Service Web Service and concerned methods....

Please try creating an object for the same and access the desired information...u need...

Thanks,...

Hi..:)

I guess, you can try this...

=IIf(Fields!F1.Value = previous(Fields!F1.Value),"Yellow","Gainsboro")

in one column and different field name with same condition in different column...this is so..b'coz its your requirement that only 2 columns...

Hi...

If you are using SSRS 2005, then it is not possible to use Fields Values in Header / Footer(being a limitation in SSRS 2005)......So...to make it work..you can do 1...