Place in each line of a variable in SSRS report, possible?
Hi, So, I'm generating a report in SSRS and found a question (or challenge). I generated a table with the following columns: Customer,% contribution, usage time and total. As far as customer usage time I get in my database ... That is, a basic form of my report will come out + / - like this: Customer | % Contribution | Usage Time | Total Client1 | 0 | 123 | 0 Client2 | 0 | 4567 | 0 Client3 | 0 | 890 | 0 Ok! The Problem is in column” % Contribution”, and “Total”, as each line CONTRIBUTION User must notify and Total will be the multiplication of the contribution to the time of use. Got it? That is, the User will inform my three values in column "% Contribution" and automatically SSRS will have to generate a report like this: Eg: INPUT by User: 20,30,50 Output do SSRS Customer | % Contribution | Usage Time | Total Client1 | 20 | 123 | 24,6 Client2 | 30 | 4567 | 1370,1 Client3 | 50 | 890 | 445 Is to make this dynamic in SSRS? OBS.: I am using SSRS 2005 and SQL2005 version
November 24th, 2010 12:05pm

Hi Bocao_Locao, To your statement "INPUT by User:20,30,50" where do you want to the user type in? we cannot input the value in the textbox on the report directly, but we could type the value in the parameter textbox, then calculate UsageTime * Parameter value on the total column. If you have any question, please feel free to ask. Thanks, Challen Fu
Free Windows Admin Tool Kit Click here and download it now
November 29th, 2010 1:40am

Hi Bocao_Locao, To your statement "INPUT by User:20,30,50" where do you want to the user type in? we cannot input the value in the textbox on the report directly, but we could type the value in the parameter textbox, then calculate UsageTime * Parameter value on the total column. If you have any question, please feel free to ask. Thanks, Challen Fu Thanks.
November 29th, 2010 6:55am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics