You’re offline. This is a read only version of the page.
Dear All,
We have a requirement where the Item Description is more than 100 character limit of GP. We are planning to enter the detailed extended description on the Note icon next to the item number field. But our biggest challenge is give the user ability to search this by this field and bring the record on SSRS and print the same. Can any of you guide me how to achieve this.
*This post is locked for comments
...from experience I had the feeling that would be the case, which is why I mentioned that limitation, splitting over two fields is not nice either, so back to your original plan.
You can still create a navigation list pointing at a custom SQL view that exposes the notes field for searching in the UI. Same view could be used for reporting services reporting or whatever...
Dear All,
Thanks everyone for your kind reply. I totally forgot about the extender and we do have extender and can use the same, only some items description is having more than 255.
I would go for extender option too. The notes field is not ideal. Extender would allow you to export the SQL for the SQL view that you could build upon in Navigation List builder to allow it to be easily searched by users.
I would expect at some point someone will ask to store more fields against the item, or want multiple languages supported, so using extender this is easy as it just becomes some more fields.
Note that the extender long string type is max of 255 chars. If this is a true bigger html item description listing, like you might find for a catalogue item listing then I would go back to the notes field idea.
Hello,
I don't see any problem displaying Note on SSRS report, Just link to the NOTEINDX in the SY03900 table and return the Note Text. for search i guess you can create a smart list report.
Best,
Srini
One option might be to deploy an ISV product Named Extender. You can create custom fields in minutes and associated them to any GP window/form. Not sure if there is a limitation on the ability to search by these items.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (