I am not very clear about your need. Could you elaborate and give us more details. If possible, you may create a sample test template file (with data entry and markered sheets) and post it here to demonstrate for your requirement, We will check it if we can fullfill your need.
Here is a sample of what I am trying to do. The green field on the DataEntry sheet is initially populated with a dataset field. After the spreadsheet is generated the user can update this number and it should be updated in the red cells in the "report" worksheet that are red
I have put in comments in the these cells to try to clarify the explanation.
Thanks. What I am seeing is that the value from the dataset is being put in the "data entry field" as expected but the field that has the Excel formula also get that value and the formula (ex: =C6) is replaced with the static value from the dataset.
Hi Zosonc, Please try the fix. There is a limit on using excel formula in excel template file,the position of Cells refered by formula can not be changed in the process of rendering template file,otherwise it may result in wrong calculations.
Usage of excel formulas: Directly edit formulas as you do it in normal excel file and do not add “&=” or “&=&=” as the prefix of formulas, for example, in your excel template file,you can input “=DataEntry!$C$6” as the formula of the cell[D18] in the sheet of “Report”.
If the problem persists, please post your rdl file and resultant report excel file.
I actually just figured out a workaround for the problem I was having. What I did was put in an Excel Sum formula to the one cell I wanted to to copy over. It then updates the field in the report output when I update the field on the data entry tab