The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

How to do colum wise layout in Report in PPM 7.1 and put color in cells

SOLVED
Go to solution
Highlighted
Phanishwar
Collector

How to do colum wise layout in Report in PPM 7.1 and put color in cells

Hi All,

We have a business requirement such that they want a report which should fetch color data(?) and in certain layout.

is it possible to have color cells in ppm report output excel?

Please see the attached xls for layout we want in ppm .We have headers row wise that is possible . However we have header column wise also like BC, CC, ExC, CC, OP....

it is combination of row and column wise header and their respective values. the header(request type field) are BLACK BOLD in sheet.is it possible to that. Can we have done using knta_reports?
11 REPLIES
Om Prakash Acha
Super Collector

Re: How to do colum wise layout in Report in PPM 7.1 and put color in cells

Its possible to add colors to the output excel.
Please find the attached sample code.
Phanishwar
Collector

Re: How to do colum wise layout in Report in PPM 7.1 and put color in cells

thanks omprakash!.is it possible to place values in vertical fashion(BC, CC, EC..etc and half row wise..do you have any sample code for that or any kintana API...

i have developed reports having row wise header and placing values using kintana_reqport.put_line()..simple one..
James++
Regular Collector

Re: How to do colum wise layout in Report in PPM 7.1 and put color in cells

Hi All,

Can you please let me know how you have exported the report in Excel.

Actually we also have a requirment to export the report in Excel. I had tried all the alternative to export the report in excel, but till now no sucess.

I will be great if you can help me in this regard.

Thanks,
James.
Prabha N
Super Collector

Re: How to do colum wise layout in Report in PPM 7.1 and put color in cells

Hi,

Find the attached code for "Export to Excel" in SQL report.
Exporting code will be different for JSP reports.

Thanks,
Prabha
Prabha N
Super Collector

Re: How to do colum wise layout in Report in PPM 7.1 and put color in cells

Oops!! Missed the attachment... Here it is...
Phanishwar
Collector

Re: How to do colum wise layout in Report in PPM 7.1 and put color in cells

Hi Prabha,

I am not able to open the attachment. Pls send it in doc format.

Do you have code to display color in the excel output for value like green , red....


Thanks,
Phani
Prabha N
Super Collector
Solution

Re: How to do colum wise layout in Report in PPM 7.1 and put color in cells

Hi,

Please find the attachment for Export to excel and displaying the color for the row.
Hope this would help you. Let me know.

Thanks,
Prabha
Phanishwar
Collector

Re: How to do colum wise layout in Report in PPM 7.1 and put color in cells

Hi Prabha,

I am getting error whne I try to open the attachment. pls see the screenshot for the same. let me knw if i mt system doesn't support it.

thanks!!
Prabha N
Super Collector

Re: How to do colum wise layout in Report in PPM 7.1 and put color in cells

Here the contents in the attachment..

EXPORT TO EXCEL
---------------

KNTA_REPORT.ADD_TEXT(X_REPORT_ID,
X_LINE_NUM,
'Y',
'
Export To Excel');

For displaying color:
----------------------

KNTA_REPORT.ADD_TEXT(X_REPORT_ID,
X_LINE_NUM,
'Y',
'

Field Name
');

These are for SQL reports only. If you look for JSP report, the coding will be different.
James++
Regular Collector

Re: How to do colum wise layout in Report in PPM 7.1 and put color in cells

Thanks a lot for your help.....
Raka_1
Collector

Re: How to do colum wise layout in Report in PPM 7.1 and put color in cells

Hi Phanishwar

Can you send me the report that you customized actually we have same type of requirement and I was thinking that I can use that as a refernce
//Add this to "OnDomLoad" event