Post reply

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

  • 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

  • November 20, 2008 at 12:52 pm

    #901251

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

    Carlton..

  • 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?

  • 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

  • July 14, 2009 at 3:48 pm

    #1024748

    What was your solution to rendering the formula?

    Thanks in advance.

  • 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

  • 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/[/url].

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

  • 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

  • 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 😀

  • 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.

  • 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.

  • 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 =(

Viewing 12 posts - 16 through 26 (of 26 total)

You must be logged in to reply to this topic. Login to reply