Skip to main content
J
jlig
Inspiring
August 1, 2007
Question

Referencing a "checked record" from my Nextensio Dynamic List

  • August 1, 2007
  • 2 replies
  • 342 views
I have an Orders management system that includes a Spry Menu bar on top and an ADDT Dynamic List below.

From my Spry Menu item, How do I "reference" the "checked" record in the List and grab the "recordID" so I can pass it to my PDF report?

On my Report Link I have:
1) Added the Spry menu item, then for "Link" I let DW build: reports/T1_Service_Agreement.cfm?T1CustID=<cfoutput>#rsT1COEm.T1CustID#</cfoutput>

The Report opens, but errors out because no "parameter" was passed? (My report works fine by itself, so I know that the issue is only related to incorrectly pulling the "parameters" from the Nextensio Dynamic List page and it's checked item.

This same issue comes up when I want to "jump" to a specific "Update" page from the main List? I add the Menu items to my Spry Menu, but do not know how to "grab" the "recordID" of the checked item in the List and pass it's "parameter" to that particular page?

Here is an image of my Main page: http://cerberus.clearwave.com/jerry/Order_Management_Main_Page.jpg
I need to be able to "check" one of the Orders in the List, then have my Spry menu open a page based on the CustID field.

Any ideas much appreciated!
Thanks,
jlig
This topic has been closed for replies.

2 replies

J
jligAuthor
Inspiring
August 13, 2007
I have just posted a Beta of my site to: http://www.clearwave.biz/Beta/T1COElogin.cfm

- Username is: Beta
- Password is: 123

- Once you are logged in you should see the Nextensio list w/one order listed.
- Click on the Printer icon & the Order Agreement will open in PDF.
- Click on the InfoSheet link & the Report will open in PDF as well.
- Everything works fine if you use the links on the same line as the record.

- But if you check the CheckBox on the left, then choose the Spry Menu above, Reports/T1 Agreement the report will not work?

Question: What should the Link be to reference the checked item below, pass the CustID value to the report & print the PDF?

(Note: the CF report has the following line in the SQL: (tblT1OrderProcessing2.T1CustID = #param.T1CustID#) and the report prints fine in Report Builder if I pass it the T1CustID)

Thanks again,
jlig
J
jligAuthor
Inspiring
August 5, 2007
I pasted a piece of the code section where the Edit & Delete buttons are.
- Since these two buttons are already on the same line as the checked record, they correctly Edit/Delete the record (see image link I posted earlier)
- Also, when one of these buttons are clicked on, the Checkbox goes to Checked.
- I also placed my own buttons at the end on the record line, & my CF reports print correctly by getting passed the T1CustID?

What is the secret to linking the Spry Menu bar Links to my Reports via the passed parameter?

Thanks,
jlig
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices