homebrew01,

I did the same steps yesterday where i have connected my local SQL2012 SSRS configuration manager with SQL2005 "ReportServer" database and today i have noticed the same error.

Due to this...

Good thinking and simple explanation.

Thanks for sharing your experience.

Nice and simple. Thanks.

Usually beginners comes on forum to find solution from experts and sometimes things are not meant for experts as such. However experts correction and appreciation makes them...

Oh NO. Please don't tell me you are shocked. 😀

@adrian.facio

The problem is that for employee 4 keeps the original status "Widowed" and not the last status "Single" as your example suggest. How is that you know that...

Yes @Lynn Pettis,

That is the point that latest record of employee#4 is not correct. so delete that invalid data.

Error : However you have also deleted one record of...

Hi Lynn Pettis,

Here is the problem with this, we've been there before. We have all posted answers to an OPs dataset and rules only to have the OP come...

Ohhhhh I had no intention to offend anyone but i just went with the flow. sorry!

this has also happened because i could not memorises everyone names and switching back and...

Hi,

"Editing as requested by senior member for better clarity."

"@Kingston Dhasian": There were 7 rows initially and after deletion there are 6 rows. So i can't understand your question.

"@drew.allen": Please note...

Ha Ha Ha ......

Points only to "Practical Joke" is not justified.

Lost 7 points anyway.

OK. However, i am really not dealing with a display issue.

In my actual complex calculation, i want to add col1+col2 but problem in doing this is then i need...

I am trying to make SSRS report based on SSAS cube.

Questions are:

I want to Avoid IsNothing() because in my actual report then i need to use that too much?

How to...

Thanks Mark,

yes, as i said view or drived tabled are the options for that.

The thing which i have just noticed was if there is only one date in a...

Great!

For output 1, i still need a drived table OR in-line view to apply where on dense_rank?

As you know, Dense_rank cannot be use in the same where clause.

in my scenario,...