sql server 2008 - How to specify a SQL table type input parameter in Crystal Reports? -


I need to give a list of important values ​​for the stored procedure in SQL Server, and it returns the stored procedure. Value required for crystal report

Rather than sending a separate comma separated list and then parsing it, it was suggested that I use a table type. Therefore, I have defined that table types only make an integer: 

  type create [dbo]. [Site identifier] AS table ([cytide] BigTyte, primary ([site ID])

However, now to take me as an input parameter to modify my crystal report the wanted. (The stored procedure starts ... 

  making process [dbo]. [Sp_SiteReport] @SiteIds [dbo]. [SiteIdentifiers] ReadOnly AS
< P> The report will be called mostly with ColdFusion or C # net, so I do not think there will be a problem adding the ID to the table type. But I do not know how to define that parameter in the crystal. The raffle is small.

I do not think you're using the parameter correctly in the crystal concept. To my knowledge, it is best used to enter data manually (and you can use multidimensional array , It is not the best use of it). I recommend:

  1. Your first idea of ​​eating food in the form of a comma-delimited string.
    OR < / Li>
  2. SQL-SER Save the output of the process in a temporary table and and import.

Comments

Post a Comment