11/26/2024 6:21:29 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.
|
|
|
|
Getting non-existent fields into Crystal Reports
Posted: 29 Sep 06 1:06 PM
|
fiogf49gjkf0d I've noticed that the SalesLogix folks have managed to make many reports with non-existent fields. For example, most of the Ticket reports use a calcuated field to report the prettified ticketID. That calculated field has as the calculation "{Ticket.TicketNumber}" and that TicketNumber also shows up in the fields list. But it's not really part of the Ticket table. Where did it come from and, more importantly, how can I use it in my own reports?
Thanks |
|
|
| |
|
Re: Getting non-existent fields into Crystal Reports
Posted: 30 Sep 06 1:59 PM
|
fiogf49gjkf0d Actually, I know that calculated fields will show up in the field list. The question here is where did the TicketNumber field come from? If you verify the database, CR will not recognize that field, yet if you run the report it runs fine. I'd like to do a few Ticket-based reports and show the pretty version of the TicketID so I'm interested.
And, I appologize now for putting this thread in the wrong forum. |
|
|
|
Re: Getting non-existent fields into Crystal Reports
Posted: 02 Oct 06 4:33 PM
|
fiogf49gjkf0d Not sure if I am understanding your question then. The field named "TicketNumber" is a calculated field. If you look in the calculated fields, you'll see it listed there with the calculation:
Ticket.Alternatekeyprefix-Ticket.Alternatekeysuffix
As far as adding it to the report, you can just select it from the fields list as usual. One thing to point out however, is that the ability to see and use calculated fields via a connection using the SLX provider is an option that can be turned on or off. See the extended property IncludeCalcFields listed here: http://www.slxdeveloper.com/page.aspx?action=viewarticle&articleid=55 |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|