danawexler (6/10/2013)

---

I'm trying to write an expression in SSRS to allow for different fields to display based on the result set. This example is for the Title line, and...

Krishna1 (6/25/2013)

---

Dear All

I have folloing query

select sum(yy) sumyy, 'summary line' xx

from tablea

where somedate_column < @startdate_parameter

union

select yy, xx

from tablea

where somedate_column between @startdate_parameter and @enddate_parameter

Is there a better way to achive this...

It depends on a few factors. The biggest factor would be salary. Most likely if you make the switch to BI you would be coming in entry level even though...