![]() |
Telelogic SYNERGY (steve huntington) | ![]() |
Topic Title: Exporting Report Results to an Excel Topic Summary: Created On: 2-Nov-2006 21:28 Status: Read Only |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() |
|
I was wondering if anyone has had any success in exporting Report Results to an Excel Spreadsheet? |
|
![]() |
|
![]() |
|
Hi Emily,
Actually I have a report for Excel. I created it with the Report Builder role and the selected format is CSV, not Excel. This report is installed and users runs it from the query tab, they select a query and the format is in the system folder. I hope this help you. If you need more information I can send you the report. Best Regards. |
|
![]() |
|
![]() |
|
If you could send me the report I would love it. My email address is emily@mindex.com
As only a three day old user of Synergy, I appreciate your help... Thank you, -Emily |
|
![]() |
|
![]() |
|
There is an excel format option in report builder that opens Excel when it runs.
This seems to work well, except for multi-line attributes (such as description and log which occupy multiple Excel rows.) |
|
![]() |
|
![]() |
|
A quick and dirty way to do this is just create a column based report, then copy and paste the results from the generated report page into Excel. I've had good results doing this with IE and newer versions of Office. This give good results. It is only a probem if the number of CRs in the report is long because Excel tries to resolve all of the CR links embedded in the data.
FYI, there is a good chance we'll see native support for outputing to Excel format in the next version (v4.6). This was mentioned at the UGC in October. v4.6 was said to be scheduled for Q4 2006. |
|
![]() |
|
![]() |
|
to prohibit the new line in excel you can add the following: br {mso-data-placement:same-cell;} at the end of file ..\cs43\cs_app\webapps\synergy\WEB-INF\wsconfig\templates\pt\include\styles\report.css
|
|
![]() |
|
![]() |
|
Andreas,
Thanks for that suggestion to avoid multiple Excel rows per CR; it works wonderfully. |
|
![]() |
|
![]() |
|
Andreas and Michael,
Would you mind posting an example here?
Thanks.
|
|
![]() |
Telelogic SYNERGY
» SYNERGY/Change
»
Exporting Report Results to an Excel
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.