Thank you both for your time to answer my post. Really appreciate it.

Thanks much to all of you for your help and comments.

The error can be related with lot of reasons. Would you mind posting the error that you are getting??..... or even an screenshot would probably help us understand more. ...

Thank you v much for helping me out 🙂

Looks like this is working so far :-). Thanks Magoo and thank you all for spending your valuable time in helping me to figure this out. You guys...

Hi J,

Thanks for posting this. It seems to be working only for certain recent dates. For instance, If I choose the @ReportDate = '2013-04-08 00:00:00.000' , it returns...

I believe this query gives me the count of ACTIVE customers for each CATEGORY.

SELECT Category as ConsumerCategory, COUNT(DISTINCT ConsumerID)as TotalConsumerCount

FROM (

SELECT *, ROW_NUMBER() OVER (PARTITION BY ConsumerID ORDER BY ActivityDate...

Everything that I understood in last two days, I tried to put it in these scenarios. So yes I believe these scenarios covered everything so far.

[/quote]

This is a nightmare with the way your data is. When an account is deactivated you should have some adjusting entries to zero out the balance. For account 102 the...

Sorry for the mistake. It should be Total points = (PointsEarned+PointsUsed)

Positive values in the PointsUsed indicates the bonus points. It's weired but that's how the data is right...

Hi Sean,

Thanks for the response

Here are some business rules for the desired output,

•The significance of @Reportdate parameter something that I want to use it in the report as a report...

Try to do this in your underlying query and see if works there.

Your post is not clear in terms of the column names and what exactly are you looking at. Do you need a parameter in this report?

You should just be able...

Never mind. I just had to add "<=" sign. 🙂 Thanks again 🙂

Hi Sean,

There seems to be a small problem I guess. The query seems to work for a April 04,2012. However, if I pick any ActivityDate as @SearchDate then it...