Lynn Pettis (7/31/2014)

---

Lynn Pettis (7/31/2014)

---

SQLRNNR (7/30/2014)

---

It could work - depending on what the data is in that...

I'd rather use a clustered columnstore index.

Did you read the blog post I linked to?

Of course, there are also some differences...

Why is it such a drama if the report reloads?

Here's one blog post:

http://rpbouman.blogspot.be/2005/12/reporting-for-masses-eclipsebirt.html

The more I read about BIRT, the more...

Contact a sales rep from BIRT (if they even have one)...

prashant_kr (7/31/2014)

---

This is came from top management to do the feasibility, whether we can migrate all the dashboard to BIRT or not and also which tool is better and in...

Then why take on a new product with its own toolset and learning curve?

Unless you have some exotic requirements for your...

The easiest option would just to do a drill through to the same report and passing the parameters along.

Any workaround would be considerably more complex.

Hard to say without knowing the requirements.

Do you already have SQL Server at your company?

Eirikur Eiriksson (7/31/2014)

---

Do you mean something like this?

😎

select * from (

select

[MediaName]

,[Spend]

,[ClientName]

,[BookingYear]

, ROW_NUMBER() OVER(ORDER BY [Spend] DESC) As Row

from(

select

lhe.LHECRELongDesc as [MediaName]

,cast(sum(spo.SPODiscountedCost) as money) as...

sunil.mvs (7/31/2014)

---

Actually , I simplified problem .. coming to real scenario ...

Task A getting hanged ( Could not able to sort ...

Or if you are from Europe you can check out SQLPassion[/url].

Your expected results have more than 15 rows. How come?

Just one more thought: if task B takes less than 3 seconds, what's the point of having them run in parallel?

Just run task B before task A with a precedence...