Help

A lot of scripts ans example to extract information from Control-M tools.
Post Reply
Nancy

Help

Post by Nancy » 30 Nov 2009 7:18

Hi,
I want to pull a report on a monthly basis. I used to run this report manually by giving the start day and end date of the month thru reporting facility. Now I want to run this template thru a batch job. How can I pass the start date and end date to the batch job?

Any reponse would be highly appreciated.

Nancy

User avatar
rahulsehgal
Nouveau
Nouveau
Posts: 148
Joined: 19 Mar 2009 12:00
Location: Delhi
Contact:

Post by rahulsehgal » 30 Nov 2009 11:25

Hi Nancy,

In what format you want to give start date and End Date.

You can use Auto-Edit Variable to provide Start Date and End Date for a Month if your format is in YYYYMMDD or MMDDYYYY etc.

Like use %%DATE for YYMMDD format and then you can use %%CALCDATE Variable to delete number of days from current date for the starting date of Report.

For more information Please check.
Job Parameter and Reference Variable Guide


Regards,
Rahul Sehgal

User avatar
sjjoseph
Nouveau
Nouveau
Posts: 3
Joined: 12 Jan 2010 12:00

Post by sjjoseph » 13 Jan 2010 8:57

Hi all,
I am working on crystal report.
When i am trying to make connection between database and report I am getting error that "SQL Exception" ;
I am Using windows authentication. Does it has anything to do with this error?

Post Reply