If anyone has any thoughts love to hear them.Įdit - Actually the above is not the case. It looks as though it goes through all the tables in the Crystal Report and applies the log in information however I don't see any options to make it do the same with stored procedures. I've not figured out the stored procedure bit yet but I'm still working on it. This works great for Crystal Reports that query data directly from tables however not Crystal Reports that get data from stored procedures. Regular parameters don't have that symbol.Ģ. My parameters were created as a result of stored procedure parameters, they are always prefixed with an symbol. Might be something to do with versioning, who knows. where as the following line would Dts.Variables("User::DHB").Value) For example for a Crystal Report with a parameter name of "DHB" the following line would not work:Ĭr.SetParameterValue("DHB", Dts.Variables("User::DHB").Value) In the example given the parameter names were not prefixed with the symbol. Just a few points to note that tripped me up along the way.ġ. Nice article, it got me most of the way to running a Crystal Report with parameters from SSIS.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |