User-1210839387 posted
using report builder 2.0
Is there a way just using report builder to have users enter data into a file and have the report read the input from a file.
Example:
UserInput into file: 1, 2, 3
read "1,2,3" and then feed that as param value to the report that could do something like
<ReportSQL>
SELECT * FROM someTable WHERE MyPrimarkKeyID IN (@InputVarFromFile)
--Which would be
SELECT * FROM someTable WHERE MyPrimaryKeyID IN (1,2,3)
</ReportSQL>
If yes, how do you do this? what would the syntax be in the report to read from the file?
I realize another way would be create an assembly and have the assembly read from the report and then pass the values from the assembly to the report.
thanks
MC