When the back button is clicked in returns to the main report but in it's original state. All the paramaters are reset to the default and you have to...

That's what I was thinking also. I'll let the cleint decide. Maybe I can add a field to the table and update it manually, then make the field...

Thanks for the help!!! I appreciate it!!

I figured it out. The resaon I wasn't getting the @year-1 logic to work was because the where clause state that NTPDate is = @year. So it...

Hello Doug,

I am using your seggested query logic for prior year comparison. However, it appears that the @Year -1 is not working.

DECLARE @Month int

DECLARE @Year int

SET @Month = 1

SET...

Thanks, For your response. What does the ":with cte AS" statement do?

Thanks I'll give this a try

Thanks for your reply..SSAS does recognize that it's an integer. Its when I try to sort on dimension attribute in SSRS that it's looks at the data as a...

I didn't think so... I have spent a couple of hours per day trying to figure out how to do that. Thanks for you input

I need the subreport to toggle when the main report value is clicked. Everything needs to be on the same report.

Thanks

I have been sucessful with what you are suggesting. What I need the report to do is load, then a user clicks a specific field in the main report...

It will be on a subreport already shown

Thanks for all the input. The issue was that I created a stored procedure that was calling data from a view. I was told that it would eventually...

The data type for the txn_date data type in the table is smalldate.

I am not sure what you mean regarding the first argument

The sp works from SQL and it also works from the report data tab in visual studio.

Steven

Here's the stored procedure that I have in the SQL database. I am calling this procedure with SSRS.

USE [Clearview]

GO

/****** Object: StoredProcedure [dbo].[sp_rpt_Travel_Zone_by_customer] Script Date: 07/22/2010...