Thank you !!!!!!!!!!!!!!!

Thank you for your help.

Hi,

When I run the reports from my local machine they work fine.

Why I need a server to host them...

Thank you

anthony.green (6/25/2012)

---

You need to have the reporting services service running on...

Sorry..I have updated the code..But still the same error message..

Msg 137, Level 15, State 1, Line 1

Must declare the scalar variable "@MyCount".

I want to save a table from a sql server on my local pc..

hello,

The procedure that reads the data from the text file creates a unique table name by attaching the username to the table name. This makes the table unique. The data...

That will only list the valuse in the column vertically??6

SQLKnowItAll (5/22/2012)

---

You would take the column name that you want (Code) and drag it into the Column...

I'm sorry for the confusion Paul...Next time will do.

Hello Paul,

Is it possible to make this dynamic, because I do not know how many different codes I have ?

Thank you

Hello,

I'm using SSRS..Any clue how to perform such transpose in SSRS ?

Thank you

i want to do a sum on the derived column...any ideas ?

What I need is very simple :

My dataset contains two column and ID column and a NumberOfCases columns.

I'm calculating the percentage of each ID in the table by dividing each...

Thank you. But this will not work for me.

I will explain more, I need a way to force SSRS to display a specific value from the dataset at a...