pdf not presenting option for parameters...

Applications Report PDF
#1

Hey folks

Have a pdf file which am trying to link to a form via a button, when creating the link between the two the form is not presenting any option for parameter selection.

here is my pdf sql created with the sql builder:
SELECT
club.clubLogo,
club.clubName,
club.clubTell,
club.clubMobile,
club.clubEmail,
mbr.mbrFname,
mbr.mbrLname,
mbr.mbrPhoto,
mbr.mbrDateValid
FROM
club,
mbr
WHERE
(mbr.mbrID = ‘{mbrID}’) AND
(club.clubID = ‘1’)

any help would be aprechiated… thx in advance

#2

any comments on this or do I need to open a ticket?

Should be something simple I would imagine, just everything I have tried so far is not presenting me any options for parameters so sending a user from a form to the pdf is turning up empty… HELP! :slight_smile:

#3

just to note… have opened a ticket the other day for this as I still am unable to retrieve any data…
Hoping to have a reply some time soon, been 2 days already since ticket was opened…

#4

thought I would add the result to this one, so eventually got a reply from support to my urgent ticket after a few days… :slight_smile:

solution is that local variables do not work, they have to be global variables.

create a variable name, in my case was simple:

Scriptinit -
sc_reset_global ([mbrID]);

Then set the global variable following the kill above

$my_var = {mbrID};
sc_set_global($my_var);

{mbrID} = the form field which is what I wanted to capture providing me with the member ID

then with the button link to the PDF which I already had created.
Within the SQL statement add a WHERE clause, note local {} variabled so not pass to other forms unless master detail!

so SQL:
WHERE
mbrID = ‘[mbrID]’

and thats it all working :slight_smile:

#5

grrr had this working for a moment now the global variable isnt sticking…

any ideas?