So my rule of SSRS, after migrating if something doesn't work, Check the XML code or Delete and re-create again.

Post a screen shot of what you are trying to do. From what I understand, you have put parameters in your report body itself. I usually put the...

I was looking at this thread, and then I figured out stuff myself. Here it is for SSRS expressions:

First day of last month: =DateAdd("m", -1, DateSerial(Year(Now()), Month(Now()), 1))

Last day...

In the Design mode, right click the cell and go to "Text Box Properties.."

Go to Action tab. There is a option there "Go to URL". I have never...

Anthony,

Did you get a chance to get the eBook yet?

Thanks. eBook will be great. i'll wait for it.

So, basically develop all the KPIs in one report and call that report a dashboard?

What if users want to see detail rows for the KPI. for example,...

Thanks for the input guys. I didn't think about running my SSRS on my personal machine. I'll try to set it up today.

Ravi.

I can't do All = Null because that's not true.

In all, I only need to filter on values 1,2,5. In DB, values 0 - 6 exist.

I also tried going...

Please see attached file. I have included code to create the table and insert the sample data as asked.

What I am looking for:

Select * from dbo.invoice_items

where AR_CATEGORY = 'TUIT'...

Lynn,

Thanks. It worked. Here was the solution.

SELECT left (column_name, len(column_name) -3) FROM Table_Name

I thought about using DSV to filter it out, but I can't use DSV because these rows need to be counted in totals. I really need to filter them...

Thanks a lot guys. It worked.

What DB engine are you using to connect to SQL 2000??

Excel usually formats all the leading zeros by default. You can't format cells using SSIS.

As mentioned earlier, I think it will be better to use flat files if you...