Hello,
Trying to create my first report using MS SQL Reporting Services in place of Infomaker.
My data source is a stored procedure with 1 of the parameters being membership level. The parameter is a multiple value string. My stored proc has the following line to deal with it:
create table #tlevels(memb_level char(3) null) Insert into #tlevels Select memb_level From t_memb_level WHERE charindex(',' + memb_level + ',' , ',' + @level_str + ',') > 0
I need help because for some unknown reason, SSRS is not liking the way that Tessitura is sending the string value of the member levels.
For example, from the report parameter selection, the following is output: "VIP","IVI","BA+","CB+"
If I change the parameter values manually to:
VIP,IVI,BA+,CB+
then the SSRS report works.
Any ideas on what I need to do to get it to work?
Christian @ The Tech Museum in San Jose CA
hope this is the right way of 'joining' the SSRS HELP area .....
My first venture with SSRS - needed to modify SP TP_ORDER_ACK ot retrieve row and seat number info.
After learning that I couldn't change the data-source for the acknowledgment in InfoMaker - I went to SSRS
created a modified SP ( TP_ORDER_ACK_MOT - which returns row and seat ..) and tried it as a source in SSRS.
If I run the script below in SSMS it work fine:
execute dbo.TP_ORDER_ACK_MOT @order_start_dt ={ts '1900-01-01 00:00:00.000'} , @order_end_dt ={ts '1900-01-01 00:00:00.000'} , @season_str ='' , @perf_start_dt ={ts '1900-01-01 00:00:00.000'} , @perf_end_dt ={ts '1900-01-01 00:00:00.000'} , @mos_str ='' , @reprint_ind ='' , @habo_flag =0 , @exception_flag =0 , @list_no =0 , @mailing_dt ={ts '1900-01-01 00:00:00.000'} , @mailing_type ='' , @signer =0 , @label_ind ='' , @include_general_public ='' , @eaddress_type =0 , @eaddress_purpose ='' , @eaddress_market_ind_no ='' , @report_type ='O' , @p_order_no =725813 , @ob_no =0 , @balance_type =4
If I run it in SSRS Query builder it also run fine - after telling me the " EXECUTE is not supported ..... "
but if I try to execute it as a stored procedure ( SSRS ) it hangs on the date parameters ...
@order_start_dt ={ts '1900-01-01 00:00:00.000'}
I'm thinking it may run ok if I can just get past the syntax ......