I cannot figure out which table to get information for the next scheduled Job.

Would it be dbo.sysschedules -active_start_date,active_start_time

OR

dbo.sysjobschedules- next_run_date,next_run_time?

Is there a way to figure out which tables are affected by which jobs?

That sounds great! Could you please post it?

Thanks

Ahmed,

I am not a DBA and haven't actually used any of those tools. But I came across some great queries which will provide SQL Agent Jobs and schedules related information.

Cool trick!

It worked!

Thanks

Yes, I have 2 sub-reports. One take two parameters, one from the resultset of main report and the other is one of the main report parameter. This subreport is now...

Actually, on subreport works fine now, but not the second one.

When I try to execute the second one,

[rsErrorExecutingSubreport] An error occurred while executing the subreport ‘srCalcTotals’(THIS IS ACTUALLY THE FIRST...

My report has a set of parameters which execute a stored proc.

When I designed the subreport, I pass it a parameter to test.

When I run the main report, the resultset...

Ok, if I'm understanding you correctly. I right click and go to subreport properties, 'visibility' tab, select option 'Expression'

and put the expression-

=IIf(Parameters!SortSeq.Value = 1, False,True)

This worked, but displayed just first...

I have put the two subreports srCalcProg1Totals,srCalcProg2Totals in the group footers.

Now where do I say which subreport to execute/show and how?

For example. (I know this syntax is not right)

=Switch(Parameters!SortSeq.Value=1,srCalcProg1Totals,

Parameters!SortSeq.Value=2,srCalcProg2Totals)

Thank you very much!

I'm sorry I meant to delete those before posting.

So here it is-

CREATE table From_Upd(

Col_01 Char(1) Not Null,

Col_02 Varchar(20) null )

INSERT INTO From_Upd (Col_01,Col_02) Values ('1','''01'',''02'',''03'',''04''')

INSERT INTO From_Upd (Col_01,Col_02) Values...

It did take double qoutes:

=JOIN(Parameters!ParameterName.Value,";")

Thanks for all your help!

The error I get by doing so is-

The value expression for the textbox 'textbox#' contains an error: [BC30201] Expression expected.

It did work without delimiter though-

=JOIN(Parameters!ParameterName.Value)

Have you have defined ';' somewhere?

thanks