Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic SYNERGY (steve huntington)
Decrease font size
Increase font size
Topic Title: Exporting Report Results to an Excel
Topic Summary:
Created On: 2-Nov-2006 21:28
Status: Read Only
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
Subscribe to this topic Subscribe to this topic
E-mail this topic to someone. E-mail this topic
Bookmark this topic Bookmark this topic
View similar topics View similar topics
View topic in raw text format. Print this topic.
 2-Nov-2006 21:28
User is offline View Users Profile Print this message


Emily Carlson

Posts: 2
Joined: 2-Nov-2006

I was wondering if anyone has had any success in exporting Report Results to an Excel Spreadsheet?

Thank you.

Report this to a Moderator Report this to a Moderator
 3-Nov-2006 16:09
User is offline View Users Profile Print this message


Manuel Fernando Rivera

Posts: 16
Joined: 26-May-2004

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.
Report this to a Moderator Report this to a Moderator
 3-Nov-2006 20:43
User is offline View Users Profile Print this message


Emily Carlson

Posts: 2
Joined: 2-Nov-2006

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
Report this to a Moderator Report this to a Moderator
 7-Nov-2006 19:01
User is offline View Users Profile Print this message


michael Barnes

Posts: 85
Joined: 12-Nov-2003

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.)
Report this to a Moderator Report this to a Moderator
 15-Nov-2006 22:17
User is offline View Users Profile Print this message


Todd Alden

Posts: 71
Joined: 4-Oct-2002

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.
Report this to a Moderator Report this to a Moderator
 28-Nov-2006 12:10
User is offline View Users Profile Print this message


andreas neufeld

Posts: 3
Joined: 5-Feb-2004

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
Report this to a Moderator Report this to a Moderator
 29-Nov-2006 17:49
User is offline View Users Profile Print this message


michael Barnes

Posts: 85
Joined: 12-Nov-2003

Andreas,

Thanks for that suggestion to avoid multiple Excel rows per CR; it works wonderfully.
Report this to a Moderator Report this to a Moderator
 5-Sep-2007 19:33
User is offline View Users Profile Print this message


Joseph Luk

Posts: 1
Joined: 5-Sep-2007

Andreas and Michael, Would you mind posting an example here? Thanks.
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic SYNERGY forum.
There are currently 1 users logged in.
The most users ever online was 15 on 15-Jan-2009 at 15:34.
There are currently 0 guests browsing this forum, which makes a total of 1 users using this forum.
You have posted 0 messages to this forum. 0 overall.

FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.