Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JStandard
Starting Member
3 Posts |
 Posted - 2006-03-28 : 19:12:20
|
| Greetings,The Problem:I have a text file I need to read into a string that compiles and comma-delimts each line in the text file. I then take this string and use it in a stored procedure, which spits back a list of values and keys I want to populate a Report Parameter with.My Attempted Solution:To solve this, since it has to do some IOStream activity, I created a custom assembly that reads in the file, calls the stored procedure and returns a DataSet ala C#. I know my Assembly works because I first tested it with returning a string value into a textbox on my reporting services report, and then used it as an expression to return a string to a Report Parameter.I then changed my Assembly to run a stored procedure and return the results as a dataset, and this is where I encounter the problem, when I do this and run the Assembly as an expression for a Report Parameter I receive the following error:"The label expression for the report parameter ‘Report_Parameter_0’ contains an error: [BC30469] Reference to a non-shared member requires an object reference."Which, as I've researched, means in programming terms that I need to set this return equal to an instance variable, but I have no idea how to do this in Reporting Services.At this point I'm a bit stumped, I'm not certain exactly what to do. I know I could accomplish this by moving into a purely C#/ASP.Net Web app, but I would much rather leverage all of the prebuilt functionality of Reporting Services, which will cut down greatly on development time, maintainability, etc.Any help is much appreciated.- Jeff |
|
|
|
|
|
|
|
DataSet returned by a Custom Assembly for Params