• Replies 2 replies
  • Subscribers 337 subscribers
  • Views 27 views
  • Users 0 members are here
Related

Creating SSRS utility with review parameter

Steve Lang
$organization

I'm attempting to create a utility that will enable the Box Office to unlock seats and want them to be able to preview the results before actually pulling the trigger.  My question - Does anyone have any experience in creating a utility via SSRS that includes a review only/update parameter, and how would I include that in the script?

 

Thanks,

Steve

Parents
  • Former Member
    Former Member $organization

    Hi Steve,

    Usually when I am writing something that I want to incorporate a "review" option, I initially write it as though it were going to be just a report (and not a utility).  In your SQL, do all the selection logic to identify the locked seats and load them into a temporary table.  Then select the rows from the temp table followed by a check of your review parameter to see if you should actually do the unlocking.

    In very (very!) rough pseudo code it would look like this:

     

    declare #results table

insert into #results
select {locked seat data}
where {locked seat logic}
 
select * from #results

if @review = 'N'
Begin
{unlock seats}
End
Reply
  • Former Member
    Former Member $organization

    Hi Steve,

    Usually when I am writing something that I want to incorporate a "review" option, I initially write it as though it were going to be just a report (and not a utility).  In your SQL, do all the selection logic to identify the locked seats and load them into a temporary table.  Then select the rows from the temp table followed by a check of your review parameter to see if you should actually do the unlocking.

    In very (very!) rough pseudo code it would look like this:

     

    declare #results table

insert into #results
select {locked seat data}
where {locked seat logic}
 
select * from #results

if @review = 'N'
Begin
{unlock seats}
End
Children