Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Paramater to have a Dynamic lookup on table
- Thread starter amurgett
- Start date
Sure, this is possible.
You can create a pick list for the parameter to reference at runtime.
You can create your pick list by essentially making a report with the field that the parameter focuses on in the details section.
Export the data of this report to a .txt file.
When you go to edit your parameter, in the add defaults options window, import your pick list.
If your pick list needs to be dynamic, you'll have to schedule the pick list report to run to a .txt format as often as necessary.
Naith
You can create a pick list for the parameter to reference at runtime.
You can create your pick list by essentially making a report with the field that the parameter focuses on in the details section.
Export the data of this report to a .txt file.
When you go to edit your parameter, in the add defaults options window, import your pick list.
If your pick list needs to be dynamic, you'll have to schedule the pick list report to run to a .txt format as often as necessary.
Naith
synapsevampire
Programmer
Naith: How do you do this?
The import of a text file is done once only I think, not dynamically, so you'd have to open it manually and re-import each time you run the parm list to a text file (which could probably more easily be done by just importing directly from the table, rather than exporting to a text file and then re-importing).
amurgett: My understanding is that dynamic pick lists require external processes, neither CR nor CE ePortfolio does it as a setting.
Though CE offers ways to automatically use a text file as the parameter list (I've forgotten the call to make, someone else here probably knows it by heart), as far as I know, this requires a call to the API to set the file for the list, it's not something pre-canned in CE through ePortfolio or within CR by which you might set the report once and it'll dynamically update.
I believe you can also use a CSP page to update these automatically W/O using a text file, there's a thread on TEK-Tips where someone references it.
-k kai@informeddatadecisions.com
The import of a text file is done once only I think, not dynamically, so you'd have to open it manually and re-import each time you run the parm list to a text file (which could probably more easily be done by just importing directly from the table, rather than exporting to a text file and then re-importing).
amurgett: My understanding is that dynamic pick lists require external processes, neither CR nor CE ePortfolio does it as a setting.
Though CE offers ways to automatically use a text file as the parameter list (I've forgotten the call to make, someone else here probably knows it by heart), as far as I know, this requires a call to the API to set the file for the list, it's not something pre-canned in CE through ePortfolio or within CR by which you might set the report once and it'll dynamically update.
I believe you can also use a CSP page to update these automatically W/O using a text file, there's a thread on TEK-Tips where someone references it.
-k kai@informeddatadecisions.com
Isn't the SDK only compatible with Seagate Info? I think it is - so the explanation I gave is for achieving this with SI. - Except I missed out the valuable step of actually calling the picklist file from the Info Desktop. 
Info handles this acceptably if you only need your picklist to update up to a few times a day.
For dynamic picks with CE, amurgett, read this:
Naith
Info handles this acceptably if you only need your picklist to update up to a few times a day.
For dynamic picks with CE, amurgett, read this:
Naith
synapsevampire
Programmer
Naith: Ahhh, right, within SI you can point to a text file for parameters, but this is CE.
There are SDK's for CE also.
-k kai@informeddatadecisions.com
There are SDK's for CE also.
-k kai@informeddatadecisions.com
synapsevampire
Programmer
rhinok:
-you can open the report and refresh it's parameter list, then save it, using some eternal process (such as VB). Not elegant, but it's been done.
-you can create a text file and use it, there's a call that provides for it.
-you can use another product to collect parms in a form and execute the report from it, which is akin to creating custom ASP/CSP.
And there's probably other ways...
None of these methods are truly realtime nor optimal, inclusive of doing a select and then passing it from ASP/CSP. And if you collect them from a form, you lose the ability to refresh reports with current picklists from within the viewer.
I'd prefer not to recode the parm collection process if possible, I just want fresh picklists.
That said, I agree that the method you mention is the cleanest CE solution.
-k kai@informeddatadecisions.com
-you can open the report and refresh it's parameter list, then save it, using some eternal process (such as VB). Not elegant, but it's been done.
-you can create a text file and use it, there's a call that provides for it.
-you can use another product to collect parms in a form and execute the report from it, which is akin to creating custom ASP/CSP.
And there's probably other ways...
None of these methods are truly realtime nor optimal, inclusive of doing a select and then passing it from ASP/CSP. And if you collect them from a form, you lose the ability to refresh reports with current picklists from within the viewer.
I'd prefer not to recode the parm collection process if possible, I just want fresh picklists.
That said, I agree that the method you mention is the cleanest CE solution.
-k kai@informeddatadecisions.com
- Thread starter
- #8
Thank you all for your input to my query. Naith, excellent article, we are currently trying out a CSP approach so hopefully this will sort out the problem.
Crystal is an excellent product, seems kinda strange that Dynamic lookups aren't just part of the package.
Cheers all.
AMurgett.
Crystal is an excellent product, seems kinda strange that Dynamic lookups aren't just part of the package.
Cheers all.
AMurgett.
synapsevampire
Programmer
Amurgett: Please let me know how you proceed, I'll be doing the same thing in the next week or two.
I've seen an example CSP page to do this, it may have been on TEK-Tips.
-k kai@informeddatadecisions.com
I've seen an example CSP page to do this, it may have been on TEK-Tips.
-k kai@informeddatadecisions.com
- Status
Similar threads
- Locked
- Question