no it didnt, we changed fields in the warehouse and were wondering what the impact will be on our cube and reports.

Thanks guys, solved the same issue for me.

also used the query in the report initially, till I worked on a team that used SPs, much easier.

HI Andy, its pulling from a stored proc, the Order by is in the sp.

Not sure if this will work or if its even viable.

Add a variable object. Populate it with a distinct on your 'body' field. Use a loop through to create...

What about using presidence constraints?

chris corbin (5/30/2007)

Create a Data Flow Task (DFT)at the Control Flow Level of your package. Next, add a Flat File Connection Manager to your package by Right-Clicking in the Connection...

thanks Paul. did something similar, but you solution is alot more elagent

CASE WHEN fpsm.InformationDateID = @CurrentMonthEndID

THEN sum(fpsm.NoOfUnits)

ELSE 0

END NoofUnits,

CASE WHEN fpsm.InformationDateID = @PreviousMonthEndID

THEN sum(fpsm.NoOfUnits)

ELSE 0 ...

If you going to use the set-up alot, make a template. saving the rdl file in %Program Files%Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject\

Thanks Daniel, in the end I added a row_number column to the sql and used the filter property of the graph to show 10 columns at a time.

Also had to...

Thanks guys. I tend towards using SSIS rather for those very resasons. Just thought there might be beter reasons to do it all in an SP

haha, yes, would be nice

thanks Dave

Thanks. did some more searching. It looks like if you can suppress this by MANUALLY ADDING in the source code: <rd:SuppressAutoUpdate>true</rd:SuppressAutoUpdate>

seems to be working properly now.

HI Dave, hope you still around.

what do you mean

'I standandize my parameter queries and rename them from the RS generated values (i.e. I prefix the datasets with "parm")....

Mods, please delete this post, i have moved it.

ta