Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
0

Referencing a "checked record" from my Nextensio Dynamic List

Contributor ,
Aug 01, 2007 Aug 01, 2007

Copy link to clipboard

Copied

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
TOPICS
Server side applications

Views

312
Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Contributor ,
Aug 04, 2007 Aug 04, 2007

Copy link to clipboard

Copied

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

Votes

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Contributor ,
Aug 13, 2007 Aug 13, 2007

Copy link to clipboard

Copied

LATEST
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

Votes

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines