NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: LSlowick on October 30, 2014, 05:37:25 AM

Title: Print button and running reports
Post by: LSlowick on October 30, 2014, 05:37:25 AM

My report is working via button on the form. I am setting a session variable 'orderno' in the forms 'preUpdate' embed that I am getting in the report procedure. This is working.

The report procedure can accept two values ... "orderno' and optionally 'phaseno'. If phaseno is zero it prints all phases.

I want to have two buttons on this form/tab

1) I added button to the BrowsePhase (on each row). When the user presses that button what embed or how do I  set the two sessionvalues for passing to the report procedure. I want to ssv('orderno',oeo2:orderno) and ssv('phaseno','oeo2:phase)?

2) On the form I have just the plain 'print' button to call the same report but I only want to pass the 'orderno'. I'm guessing I would have to clear the value in the 'phaseno' sessionvalue. What embed would be used for a button on the form to set these? This would replace the code I used in the preupdate embed.

Thanks
Lee

Title: Re: Print button and running reports
Post by: Bruce on November 03, 2014, 11:09:30 PM

Hi Lee,

I think the latest webinar may help a bit with answering this question;
http://www.capesoft.com/accessories/NetTalkUserGroup.htm
Webinar #41, Rays question around the 57 minute mark.

the short answer is that parameters for a report are passed as parameters, and not as Session Values.

cheers
Bruce

Title: Re: Print button and running reports
Post by: LSlowick on November 04, 2014, 06:25:04 AM

Bruce

I wish I had that webinar about a week or so earlier... great information. After quite a bit of digging on my own I basically came to the same conclusion and used the parameters field on the button as you showed in the webinar. Works perfect for both my situations.

Thanks
Lee