export report to excel and excel should create formula fields for the sum fields of the report

• thaiafic

  Valued Member

  Points: 51

  More actions

  November 20, 2008 at 7:03 am

  #901022

  hi ,

  I would be really intersted too by this feature as I have to export formula in excel.

  thanks in advance

  chris

• Carlton Leach

  SSCarpal Tunnel

  Points: 4202

  More actions

  November 20, 2008 at 12:52 pm

  #901251

  read the start of this discussion, its explained in one of the first posts.

  Carlton..

• vincenzaccio

  Newbie

  Points: 7

  More actions

  April 6, 2009 at 3:35 am

  #972376

  I have two named text boxes within a matrix. I have another text box in the matrix which contains :

  =ReportItems!Name1.Value-ReportItems!Name2.Value

  However, when I export to Excel, the value of the subtraction is put in the Excel spreadsheet, not the Excel equivalent formula.

  Is there a special incantation, apart from using ReportItems, to cause formulae to migrate from Reporting Services to Excel?

• Gosta Munktell

  SSCertifiable

  Points: 6004

  More actions

  April 7, 2009 at 7:15 am

  #973319

  "When I export a report to excel and my report has sum fields, I would like excel to create the fields into formula fields that I could manipulate the data in excel and the values will ripple thru to the sum fields. "

  Yes this is possible. Your end result will be an Excelreport correct?

  If so you can create the report using VBA code in Excel (remote OLEDB , ADO, SQL to fetch

  the data) You can with VBA dynamically mix data with formulas (sum, filtering).

  You can make the report as a template including VBA code and the user can open the template

  and from a drop down list choose something like a cutomer and then fetch data.

  If you like I can of line provide you with an example.

  /Gosta

• Allen Wong-272664

  Newbie

  Points: 3

  More actions

  July 14, 2009 at 3:48 pm

  #1024748

  What was your solution to rendering the formula?

  Thanks in advance.

• Gosta Munktell

  SSCertifiable

  Points: 6004

  More actions

  July 15, 2009 at 5:56 am

  #1024935

  "What was your solution to rendering the formula?"

  In my case all formulas are parts of the Excel design

  //Gosta

• becklery

  Hall of Fame

  Points: 3315

  More actions

  July 15, 2009 at 11:14 am

  #1025241

  Hi, Rivkah Pil.

  Maybe you can have a try of RAQ Report. I believe you can solve your problem with it easily.

  It is a free reporting tool, and you can get it at http://www.raqsoft.com/%5B/url%5D.

  RAQ Report: Web-based Excel-like Java reporting tool[/url]

• msstarky

  Grasshopper

  Points: 17

  More actions

  May 13, 2011 at 11:11 am

  #1324477

  I have also considered creating a custom extension for exporting, would you be willing to share your code on this?

  Thanks

• Lumbago

  Grasshopper

  Points: 19

  More actions

  May 23, 2011 at 7:25 am

  #1328446

  I just learned a nice little trick while investigating exactly this issue:

  In your SSRS-table add an expression with the formula of your choice like this (char 61 is the equal-sign) ->

  =Chr(61) + "SUM(A2:A5)"

  Then when you export the file to excel, the formula will be rendered as text. To make it in to a formula again just do a "Ctrl+H" (replace), put an = sign in both the search and the replace box, and the click Replace All". And Voila!! All formulas are rendered properly

• ammuprasath

  Grasshopper

  Points: 13

  More actions

  July 14, 2011 at 12:28 am

  #1352584

  hi,

  I want to use a custom excel template to export my SSR 2008 report in SharePoint.Could you please help me out in this like how i can achive and if possible send me the code.

• Carlton Leach

  SSCarpal Tunnel

  Points: 4202

  More actions

  July 14, 2011 at 3:08 am

  #1352644

  ammuprasath (7/14/2011)

  ---

  hi,

  I want to use a custom excel template to export my SSR 2008 report in SharePoint.Could you please help me out in this like how i can achive and if possible send me the code.

  Start a new thread, your question is outside of this thread.

  Carlton.

• Nigativ_kiev

  Grasshopper

  Points: 15

  More actions

  September 11, 2012 at 5:25 am

  #1536166

  I need you help!!!

  When I export report to excel, the hypertext write just like text, for example "=HYPERLINK(http://maps.google.com.ua/maps?ix=acb&q=50.1878 27.0465;50.1878 27.0465)", but I need hypertext =(