NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: terryd on December 07, 2008, 04:07:29 AM

Title: Limiting a PDF report print to one parent record
Post by: terryd on December 07, 2008, 04:07:29 AM

I am trying to range (or filter) limit a report which is called by a button press on a browse row.
If I leave off all range and filter limiting the report prints all the records no problem.

To limit the printed report to one primary record I have placed this code in the:
 User pressed button server side code Quote(my Button's equate name) embed
   p_web.SetSessionValue('QuoteID',QHEAD:QuoteID)
Where the QHEAD:QuoteID is the unique identifier for the highlighted row.

In the reports' embed
Prime Reports Option when run in web mode I have this code
  QuoteID=p_web.GetSessionValue('QuoteID')
QuoteID is a local variable I have created in the Report

In the report procedure filter I have this line
QHEAD:QuoteID =  QuoteID

If I then run this I get my DisplayNoRecordsMessage ('Bummer no records!')

I also noted in the Browse that this code is generated
SetSelection  Routine
  loc:selectionexists = loc:rowCount
  do PushDefaultSelection
  p_web.SetSessionValue('QHEAD:QuoteID',QHEAD:QuoteID)

So in the Prime Reports Option when run in web mode I tried this code
QuoteID=p_web.GetSessionValue('QHEAD:QuoteID')

Still the same result.
Any suggestions?

Title: Re: Limiting a PDF report print to one parent record
Post by: Bruce on December 07, 2008, 08:06:09 PM

Hi Terry,

To use a local variable in a Clarion report filter, you need to BIND it.
But usually the result of not binding it is that you get ALL the records, not just none of them. Still, it's the first thing I'd look at.

Second thing to look at, is what value (specifically) is in QuoteID in the report.  Your whole layout looks right, but perhaps it's not setting the Session Value of QuoteID right?

How do you trigger your report? I presume it's _not_ the same button as is setting the QuoteID session value?

cheers
Bruce