if you haven't already, you need to add your Windows login as a SQL user to Adventure Works and give that login at least data reader permission.

I have seen it...

hmmm you've got a bit of a problem there... the best way to ensure that a column will always exist even if there's no data is to greate a group...

Here's a link to the download center for MSRS 2000, has an eval edition of MSRS 2000, but i'm sure if you are licensed for SS 2000 then you'll be...

The scheduled report should create a sql agent job on the server which you can see from enterprise manager. you could check and see if the sql agent job has...

Sounds to me like one of your params is trying to pass in a NULL value which is being bounced by the report... try allowing NULL values on your report...

Maybe you could try using the List Object... this is designed for layout requirements that don't fit a table, like you need text in certain places or irregular layout... not...

Sounds like you want to add a drill through linked report. I've never done this but here is some subject areas to search for in VS 2003 Help.

Adding a Drillthrough...

A report can only have one default value per parameter, so if you up load the report you'll over ride the other defaults set up. which maybe OK depends...

However you...

I'm assuming that when a user enters a date range like 03/10/2005 - 03/10/2005 (dd/mm/yyyy) then they just want everything for that day regardless of time...

So I'd give them two...

Change your ORDER BY from

ORDER BY RTRIM(CAST(DATEPART(Year, TimeLineDate) AS char(4)) + '/' + CAST(DATEPART(Month, TimeLineDate) AS char)) DESC

to ...

ORDER BY DATEPART(Year, TimeLineDate) ASC, DATEPART(Month, TimeLineDate) ASC

You may also have to process the cube and dimensions before you can view it.

just a thought but have you checked that the shared data source for the parameter dataset has also been deployed to your live server?

i was thinking that your code was being used to select records into your report ie in the data pane, if so then you can use SQL or a stored...

Couldn't you just do this in the SQL? e.g.

SELECT * FROM mytable

WHERE (@Location = Location)

  AND (

               (@Date = Date)

          OR (@DateRange >= DATEDIFF(dd, Date, GETDATE()))

        )

Or am i missing...