Cognos Script for Impromptu reports

[Abhi2379]

Hi

Is it possible to write a cognos script to generate a report and applying tempalte based on the user login.
any pointers, docs, information on this will be really helpful.

Thanks
~jit

 

[DrSimon]

What do you mean by a template? If it's waht I think you mean, a simple way round this would be to have various versions of the same report and then open them according to the user logon.
Simon Rouse

 

[Abhi2379]

I am sorry I was not that clear.

My requirements are

1) creating diff. templates(format/layouts) and storing them in Database.

2) I need to generate Invoice report, the fields will be remain same for all users only template/layout will be different.

3) I will choose the template depending on the users login and generate the report and publish in PDF format.

4) I need to automate this process.

So is it possible in Impromptu?? I guess yes. plz advice.
is it possible in reportnet?? inputs required.

Thanks in advance
Jit

 

[DrSimon]

How much experience do you have with Impromptu? Because you're asking for a lot as a beginner.
1. The reason I ask is that Impromptu does not have interactive templates in the way you seem to be asking about, certainly not that can be stored in a database. You can choose different displays by clever use of subreports but that's rather advanced and generally a report is static. Having said that, if you mean different addresses or headings (like a Word mail merge), that is not a problem.
2. See answer above
3. You can write a macro to open different reports according to the user login and publish in PDF format.
4. Reports and macros can be automated using the Cognos Scheduler but that could not take the userid into account. You can also use the Windows scheduler.

I know nothing about Reportnet

Simon Rouse

 

[Exie]

Just a quick wild thuoght....

If you created a report, layed it out, inserts a company logo from C:\logo.jpg .... couldnt your macro change the graphic, then run the report for a bactch of invoices, then change the logo again and re-run the report for the next bacth.

You could pass a company or batch number in via a prompt and filter the report based on the prompt.

Just make sure you didnt tick the "Make copy of image in the report" ...

P.S. I know nothing about report net either ....

 

[drlex]

And if wild thoughts are in order, your report formatting could also be set as conditional on a prompt value (although previous threads have discussed the difficulty of entirely removing columns).

(and that makes three of us who know nothing about RN!)

soi la, soi carré