COGNOiSe.com - The IBM Cognos Community

Suppose I create a report and schedule it to run with some prompt values (how I am gonna schedule it is not clear till now...may with view or with trigger.bat). Even after scheduling it can I run the report on adhoc basis by give some value to its prompts?

Example
I create a report (XYZ) with a prompt say Country(type dropdown), this prompt has all countries in it. Now I have scheduled XYZ report on monthly basis for county='USA' and country='Canada'.
Suppose I need to see XYZ report for India then in this case, run XYZ report by selecting prompt country='India' and click on run in cognos connection i.e without scheduling it

Now Questions are
1.Can I run XYZ report for prompt = 'India' on adhoc basis?
2.Will it affect the already scheduled report(with country='USA' and country='Canada') if I run it on adhoc basis(for Country='India').

Thanks,
Sunita Dudi

You can run the report at any time on an ad-hoc basis without affecting or disrupting the schedule.  When the report runs interactively in your browser, you will simply need to select your country (India for example) when the prompt is rendered.

Regards,

MF.

Thank You MFGF....
Could you please suggest me some gud way to schedule this report i don't want to go with creating views and then scheduling it...becoz in future if i change some thing on a report i need to update all views manually.
Is ther any way to avoid updation manually

Thanks
Sunita 

if I am not wrong, you don't have to update the report views manually. Unless you are talking about report view links getting broken because the report was overwritten with a new CAMID etc.,

Thanks for the reply Tupac_rd
i am not sure about report scheduling as this is the first time i am doing it.
So if i schedule a report view and then i modify something in report, will it refelected automatically in report view or do i need to update view manually.
If i have to do it manually it will be very difficult as i have to schedule my report for around 50 countries.
Also i am not sure if i can create these many views for one report.
Please let me know if there is any other gud way to schedule such reports

Thanks,
Sunita

Hi Sunita,

1) If u want to schedule all countries at a time it is possible to create one report view then schedule it.
2) But if u want to schedule for each country then u need to create that many report views.
3) But no one will go this many schedules go for one time scheduling like create a filter instead of original filter {case when ?country?='All' then (country data item) else ?country? end } and add a static choices 'All' in the value prompt.
4) Then schedule the report based on 'All' item then u will get countries data.
5) If ur requirement is like Scheduling each country then u have to do each country one time scheduling.

Regards,
mvjcognos@gmail.com

Quote from: Sunita on 06 Jul 2010 12:29:44 PM
if i schedule a report view and then i modify something in report, will it refelected automatically in report view or do i need to update view manually.

The whole idea of a report view is to allow you to maintain a single version of a report, but define different schedules/properties/saved outputs.  So if you have a report with three views and you modify the report in Report Studio, all the views reflect the change automatically.

Hope that helps,

MF.

Thanks MF and MVJCognos for response.

Any thoughts on scheduling reports with trigger.bat file.
Which one is better - to schedule views or use trigger.bat.

Thanks,
Sunita

Dear Sunita,

both are same as trigger will fire the report same parametrs what u have given and scheduling report will do the same thing.

While scheduling the report u will be having a option of by trigger select and mention the trigger name and select the necessary prompts and schedule......

Thanks Ascot   :)