Hi Kevin,

Do you have a defined relationship (dimension usage in BIDS) between Customer and Time? If so what is it?

In my experience - the datetime format type is slow and...

peseta30 (5/8/2012)

---

Ok I already tried the ETL and it doesn't work and the main reason is that all 12 datasets have its own datasource and the datasource changes depending on...

I have also seen this behaviour in BIDS (2008 R2) - I use BIDS helper[/url] from codeplex to delete the cached datasets to ensure im getting...

My apologies - here is a solution you could try: http://msdn.microsoft.com/en-us/library/ms153563.aspx

AFAIK you need to have the full path to parts, so in your example you would need to include the report server URL

For the Report URL I am using: http://server.ca/Reports_2008/

For...

turner.kraig (5/4/2012)

---

Is there any workaround or hack to get around this limitation?

Maybe there's another way I can accomplish the same thing. On a report we have a ton of parameters....

This link [/url]may help with your requirements.

Although the post is quite old (5 years) the solution works when changing the references to 2008, and in particular some of the comments/replies...

This is a very open ended question and if you have the right tools available, maintenance and scalability can be overcome.

I have tried this tool : RSScripter by Jasper Smith...

If the columns are all the same this sounds like an "ETL" process in the making.

Use SSIS to combine the data from the results into a "Staging table" which could...

Have you registered your assembly to the GAC (Global Assembly Cache)

http://msdn.microsoft.com/en-us/library/ex0ss12c(v=vs.80).aspx

The dispute amount (or the join to it) makes the row unique, I suspect that is...

I don't think there are duplicates based on the rows in the picture included.

This may be of assistance...

http://social.technet.microsoft.com/Forums/en-US/winservergen/thread/056c1a3f-7eeb-4d88-995b-8cbba93057d0/

SaintGr8 (9/22/2011)

---

Thanks for the insight you have given. I ran the s.procedure on Person.Person against Adventureworks2008 database. My query was like this:

CREATE PROCEDURE dbo.sp_select

@Person NVARCHAR(200)

AS

DECLARE @cmd NVARCHAR (255)

SET...

Reporting Services

http://www.microsoft.com/sqlserver/en/us/solutions-technologies/business-intelligence/reporting-services.aspx

Business Objects

http://www.sap.com/solutions/sapbusinessobjects/index.epx