Hi,
I now have a report with "no prompts". I also removed the Prompt for Value
- Welcome Page
- Action Menu
- Properties
- Report
- Prompt for Values > Unchecked
After I did this, I got a message "Report has no Prompts".
When I tested to pass the link opening with a WO Number, I now am getting this error?
"Data source adapter error: java.sql.SQLException: ORA-01489: result of string concatenation is too long".
Suggestions?
Same link as I sent before, and we were getting the Prompt Page?
Thanks.
------------------------------
Maryann Wood
Chelan PUD
------------------------------
Original Message:
Sent: 04-13-2022 11:12
From: vineet joshi
Subject: Cognos Report - Direct Print Report in WO Tracking - Report runs with Open WO
Based on what I understood from your pervious comment, clicking on direct is not actually sending the report to printer it is opening up the report in cognos. This is more like a hyperlink from Maximo but not direct print
For cognos prompt ,make it a not required field and it should not populate when you follow the process in the PDF I sent earlier.
So if Maximo is passing the value in the where clause, cognos parameter should not show up . I have built several reports in the past where running the report from Maximo show the cognos report output directly rather than arriving on cognos parameter page
Thanks
Vineet Joshi
------------------------------
vineet joshi
Asset Analytix
Original Message:
Sent: 04-13-2022 09:44
From: Maryann Wood
Subject: Cognos Report - Direct Print Report in WO Tracking - Report runs with Open WO
Actually it does work!
Yes, the Direct Print is an Icon in Maximo WO Tracking, we connect a link to the Cognos Report (in Cognos), to the Direct Print Report in Maximo.
Then the user –
- Opens Maximo WO Tracking
- Clicks the Report Icon
- And Opens the Cognos Report – in Cognos
We are getting the link to work, Opens the Report, and the correct WO #, however, the first report we had a prompt page with a "Finish" button.
- Report Opens for correct WO
- But users must click "finish"
I tried taking the prompt out, but I'm not having any success.
Any assistance is appreciated. Thank you.
Original Message:
Sent: 4/13/2022 9:34:00 AM
From: vineet joshi
Subject: RE: Cognos Report - Direct Print Report in WO Tracking - Report runs with Open WO
Hello Maryann
You cannot do Direct print from Cognos. Direct print is an icon in Maximo which prints the report(physically on paper) with/ out attachment. This functionality is limited to BIRT only.
For your other question of passing the Maximo where clause, here is the link . Page # 50 and forward.
https://www.ibm.com/support/pages/system/files/support/swg/tivtech.nsf/0/4c7448a75905562585257dee0055e6fd/$FILE/Maximo76CognosFeatureGuide_rev4.pdf
Thanks
Vineet
------------------------------
vineet joshi
Asset Analytix
Original Message:
Sent: 04-12-2022 13:23
From: Maryann Wood
Subject: Cognos Report - Direct Print Report in WO Tracking - Report runs with Open WO
I found the answer to this question - at the end - ParWoNum=:wonum
Part II - This report has a Prompt Page, link is opening the Prompt Page - then user has to insert the WO #.
How do I we send the Active WO # opened in WO Tracking to the Report - so the report opens with that WONUM?
Do I delete the Prompt Page?
Thank you.
------------------------------
Maryann Wood
Chelan PUD
Original Message:
Sent: 04-08-2022 13:36
From: Maryann Wood
Subject: Cognos Report - Direct Print Report in WO Tracking - Report runs with Open WO
This is my link to Cognos WO Report.
http://cognosca.domain1.chelan/ibmcognos/bi/?pathRef=.public_folders%2FAll%2BReports%2BFolder%2FMaximo%2BReports%2FWO%2BCover%2BSheet%2FWork%2BOrder%2BPacket%2BCover%2BSheet%2Bv5
This will be a Direct Print Report from the WO Tracking Application.
What code do I need to add at the end of the link so the current WONUM will pass to the report?
Something like %wonum=:wonum
Thanks All!
#Reporting
------------------------------
Maryann Wood
Chelan PUD
------------------------------