There are a few things you can do. If you are using 7.6.04, Crystal Reports will not be viewed unless you are using Crystal Enterprise or BO. In 7.6.04 you can create canned reports using either ARSystem or Web reports and make them available to your users. The Web reports will give you basic chart capabilities. You also have really robust reporting capabilities with BMC Analytics. Analytics is built on BO Universes. You can create a canned set of reports in here too. With Analytics you can also schedule your canned reports and have them emailed out or put somewhere like SharePoint. This feature is nice because your users have the reports they need when they need them.
As far as figuring out the database ids. You can go through the painful process of looking through Dev Studio to look at the field ids. You can also run a simple select statement on the database. At the database level you will see a number of tables. The arschema table will give you the form names and ids. There is a fields table that will give you the field information. Brian From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Remedy Sent: Thursday, February 16, 2012 12:41 AM To: arslist@ARSLIST.ORG Subject: Re: Issues with advanced search ** Thanks On Thu, Feb 16, 2012 at 12:55 AM, benny shell <xosi...@gmail.com> wrote: ** The most stable and versatile solution would be for your team to create a few canned Crystal reports and embed them in Remedy. On Wed, Feb 15, 2012 at 2:00 AM, Remedy <bmcremed...@gmail.com> wrote: ** Hi All, Could any one please provide me a suggestion to pull an accurate report in the either in normal search or in advanced search in any ARS form rather than using the database id of the particular field. As per my understanding there are duplicate labels in the ARS forms and hence we use database id of a field to pull the report but my concern here is how do the end user know whether they have pulled the accurate report or not, by using the field name's instead of database id's, as we found variance in the report by using the same criteria in two different search methods ( default search & advanced search) . Moreover is there any easy way of finding the database id's of all the field's in a form say in Help desk form. -- Thanks & Regards Remedy User _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ -- Thanks & Regards Remedy User _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"