I think I may have to go down that route after the problems I have had today. I was creating a top level report to navigate down to each sub...

Thanks for that but thats way beyond my capabilities at the moment. :blush:

Im working in 5.1.2600 Service pack 2 so it should be OK.

OK I copied the rdl as a backup copy.

I tested it again and it works fine when I go...

I starteed looking at pivots for something else a while ago but i got a little lost. I will certianly have another go now Im abit more familiar with SQL...

I spoke too soon. Its now only displaying the first 'Title' when you go into the lower level report instead of giving you the drop down box to select the...

Sorted. I thought it was because the underlying report with the parameter was using a different dataset. The main report at the top is just a report with text boxes...

BTW in the top report via properties to the text box I have also added the title parameter in navigation =Count(Fields!Title.Value, "DATA_QUALITY_OVERVIEW_TOTALS_AND_PERCENTAGES")

This also works in Visual studio so again I...

Ive sorted it. Ive unioned all the SQL together and added an extra column which shows the service the row belongs too.

Debbie

Ahhhh, I had a feeling this was going to be the case.

Im going to get round it now by havng a main report which contains links to the other reports...

Interesting,

Thanks for that. I will definitely try that out. using string parameters seems to go fine. Its just the date time thing that is causing me issues.

Debbie

Whoops sent before I finished. Sorry about that.....

When I go and preview the report you get the drop down list with all the distinct quality dates in it. But when...

Worked a treat,

I executed from the top as

Exec usp_SessAtt_Run_SessionalAttendance_SPs

@AttendDate ='2007-09-03 00:00:00.000',

@WK_COMM = '2007-09-03 00:00:00.000'

(Bearing in mind this is the proper code rather than the examples I put in...

Ah,

Thats brilliant, Thanks for that.

(I only just got started with SP's a short while ago so Im only a beginner with it. That makes sense though Ill get it set...

Sorry Im afraid you have lost me now....

Ive tried to think it through but i dont know how else to explain it than what Ive already written.

Im trying to create a top sp that executes 4 SP's...