Luke thanks for all the tips. The support do their best but they are not in the business of re-writing the code, even if they were they would still use...

Hi Luke

Long story short, why use a cursor? How about posting the query that makes up dataset requirements and perhaps we can suggest a way to do it without using...

I have reviewed the report server log file. I note the following error:

ReportingServicesService!processing!4!6/8/2010-04:04:26:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'Requirements'., ;

Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed...

Thanks guys, much appreciated. I am not using for any comparison, I am only interested in the key portion of the string.

Many Thanks,

Phil.

PS: Is it an easy mod to remove...

I implemented the last post and it is just what I was looking for.

Great work guys.

Many Thanks,

Phil.

That did the trick.

Thanks,

Phil.

I will take a look this evening and post back.

Thanks,

Phil.

Update:

Found this link in another post:

http://www.exactsoftware.com/Docs/DocView.aspx?DocumentID={2b24915c-66b5-4cec-a70b-e3cb414b8821}

Unclear why the initial size would reset to 100MB from 3GB however?

I will double check a job has not been scheduled to shrink.

Regards,

Phil.

On 'Properties' 'General Settings' ensure you have not got option 'Hide in list view' selected.

Regards,

Phil.

Setup a active directory security group. Add you project team members to this group. Add the security group as a SQL Login. Map users to the database you wish them...

Many thanks for your response.

Kind Regards,

Phil.

The structures table has a Product and Component. The component itself is a product and may also contain other products.

So.

Product A has components B,C,D,E,F

B

.....D

.....E

C

D

.....F

E

F

B also contains D & E

D also...

Hi. Thanks for your efforts however the output is not as expected. The query returned 2304 rows for a single parent product and took 1 minute 46 seconds to execute.

Regards,

Phil.

Update:...

Thanks guys, really appreciate your input.

Regards,

Phil.

The updated query returns:

Regards,

Phil.