Tag: Cognos Report Studio

To pass a prompt value say – “p_reportdate” to sql query then syntax is as below
select * from table1 where table1.date =  #prompt(‘p_reportdate’)#

if the prompt- “p_name” is multi select then
select * from table2 where table2.name in (#promptmany(‘p_name’)# )
 

few other related articles
http://www-01.ibm.com/support/docview.wss?uid=swg21341148

In report studio go to: File > Report Properties > Page break by data container for interactive HTML : Yes

This option would make the html output in one page with out “page down”.

If this doesn’t work make sure you put the Lists/Crosstabs in table cells inside Block.

to change values of default date prompt dates

below excel sheet gives you the java script for below scenarios

1. Last month Start date
2. Last month End date.

date prompt codes

1. Create page1
2. In page1 create a list report say list1 and query1
3. Now go to page explorer, create a “page Set”
4. Drag page1 to detail pages
5. select “page set”. change query to query1.
   At “grouping & sorting” drag required column you would like to group data on.
6. Run the report. Pages should be separated based on group by element.

Youtube video –

Sometimes you may need to pass the current date time value to the report.

This can be achieved by using following option

select “Date & Time Prompt” –> General –> Clock Mode – default value is “Static”, change this value to “Live”.

Now when you run the prompt page you will see current date time.

Had a situation where I need to develop a detail report for a dashboard based on the prompts selected in that dashboard.
Dashboard had multiple summary lists/crosstabs/charts
below are high level steps.

Solution:
1. develop a detail list report based on the same prompts.
2. At master report

1. create a singleton (on the dashboard where you want to see the url)and say you assigned it to query – q_detail.
2. Create a data item say “Detail data” and with value “click for detail data”
3. now add this data item to the singleton you created.
4. select the data item in the singletom and select drill-Through definitions.
5. select required report and other options. At parameters click on edit sign and use
6. “Pass parameter value” and select associated prompt name.
7. click ok.

now when you run the summary report you should see a link “click for detail data”

Below link gives all possibilities with respect to color codes.

https://www.computerhope.com/htmcolor.htm