May 21, 2014 at 12:24 am
Hi Team,
I have a request to develop a report / template. In which I have some columns where user have to populate them after gettting the report in Excel format.
Eg
Manager - Populted from DB column
Sname - POpulated from DB Column
TT(Mins) - Populated by the user after receiving ther report in excel format.
TransportTime - TT/60 ( formulae to be inserted as expression in SSRS )
My aim is to ensure when the user gets the report the "TransportTime" cell formulae needs to be carried as well. So, that when ever user start populating the TT(MINS) column in excel, the transporttime will get auto populated based on the formuale.
In SSRS fro TransportTime I have used the expression as " Fields!TT(Mins).Value/60
Yet the formulae is not transferring across to excel.
Any advise is highly appreciated.
Thanks.
May 21, 2014 at 12:25 am
I don't think this is possible with SSRS.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 22, 2014 at 10:28 am
Nope, I don't think you can do anything like this in SSRS (of course I am only using 2005 version). A report is just that a report, you will have to export to Excel or something and then you can copy info into another sheet or something and then create macros or whatever to get what you need. Not sure if an SSIS package would be used to do something like this. But you are using SSRS not SSIS.
May 22, 2014 at 10:38 am
I did a test and it wasn't easy. I created a new column and added an expression - "=Q2/60"
You need to have quotes or Reporting Services tries to do the calculation. It does not understand Q2.
When it exported to Excel, it still had the quotes. I did a find and replace to remove the quotes. Then I used the Fill Handle to copy the expression and it updated all the formulas.
Also, when it rendered, there were multiple hidden columns, so I had to adjust the letter in the expression.
It would be easier to do the calculation in an SSRS expression or create the column after exporting.
May 22, 2014 at 10:42 am
Hmm, that is interesting.... I will have to play with this myself..
July 15, 2014 at 8:32 pm
I am curious what happens to the report once the user enters the information and the calculated column renders? Does this just come back into your database system somehow? It sounds like there is room here to re design and improve this process.
----------------------------------------------------
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply