Reporting Assistant to Excel

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
gateleys
Premium Member
Premium Member
Posts: 992
Joined: Mon Aug 08, 2005 5:08 pm
Location: USA

Reporting Assistant to Excel

Post by gateleys »

Hi,
I have used Reporting Assistant to get job reports into the supplied Access Database. However, when I choose to get the reports into excel, I cannot get them to export. Has anyone used Reporting Assistant to push job report into an Excel file?

gateleys
diamondabhi
Premium Member
Premium Member
Posts: 108
Joined: Sat Feb 05, 2005 6:52 pm
Location: US

Post by diamondabhi »

Dont know about reporting assistant. I used generate report icon on the designer to get the job report into excel files, it worked fine except it cant get the job design intio the excel doc, may be u can fix it.
Every great mistake has a halfway moment, a split second when it can be recalled and perhaps remedied.
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

You can use Kduke shareware jobs on his website and then update the routines that he is using to develop and html. You can may be add to save it as an excel.
Else you have to build your own routines for that functionality.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Post Reply