Hi, Table itself is picking up value from some form. So you have to find the condition on which the table is getting populated. Then you can use the same conditions in ur CR to extract data from the base form. CR allows data to be extracted based on certain conditions. You can use that. Rakshit
On 12/1/06, Siti Hawa Bee SHAIK FARID <[EMAIL PROTECTED]> wrote:
Hi Rakshit, I believe you must already been a pro in working with crystal reports and AR. Can give me some pointer on how to print cases in the table list? How can I extract the cases in the table list into CR report design? ------------------------------ *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *rakshit bhandary *Sent:* Sunday, 26 November, 2006 19:03 *To:* [email protected] *Subject:* Re: Remedy 6.3 with Crystal Report XI ** What you can do is turn on the Remedy user logs by going into tool->options and into the logging lab. check the sql checkbox and select the path where you want to save the file. Try saving a new ticket in HPD:Helpdesk. then go and check the log. check where the table is getting updated by the ticket number by doing a simple search. that is the table you are looking for. my guess is the T00...0021 table. verify. And working with crystal reports is also pretty simple. Just a matter of getting to know how it works. Regards, Rakshit On 11/21/06, *Siti Hawa Bee SHAIK FARID* <[EMAIL PROTECTED]> wrote: ** My dear listers, We are currently running AR 6.3 patch 018 and helpdesk 6.0. We had bought Crystal Report XI, however Remedy support told us that it's not compatible. Compatibility Matrix for 6.3 at the URL below. http://www.bmc.com/support/bmcremedycomp/AR_System_6_3_Compatibility_Matrix_v27.htm#Other_Components_and_3rd_Party_Products In the compatibility matrix, it showed that AR ODBC (Windows) is compatible with Crystal 9 Reports (Professional, Developer, Advanced). I had thus contacted Crystal Report representative and was informed that CR 9.0 is completely not available in the market. However CR version 10 onwards is available. Thus, why BMC showed something compatible which already not available in the market? A representative from Crystal Report told me that it's because of the compatibility of Remedy application with CR via AR ODBC and not the compatibility of Crystal Reports. He had guided me to create connection to Remedy SQL Database by OLE DB(ADO). I followed the instructions and was able to connect successfully. However, it showed all the table name in ARsystem database in SQL. How do i know which form goes to which table. Most of my table manipulation comes from HPD: Helpdesk. I'm really very new to Crystal Report. In beginner stage. Infact just got it installed yesterday and stuggling with the user guide. So before i proceed any further, i really need your expert advise if i can proceed using CR XI with my current setup. Should i use the AR ODBC connection of OLE DB? Where can i get information that which table my HPD:Helpdesk data saved into when i submit a case. Pls help. *Best Regards,* *Siti Hawa** Bee* *||||* UOB Group, TSD - IT Helpdesk *: <* <*<<mailto: [EMAIL PROTECTED] <[EMAIL PROTECTED]>>>*>*> *My Favourite **Quote " No person can be a great leader unless he takes genuine joy in successes of those under him" - W A Nance** * United Overseas Bank Limited Singapore Company Reg No. 193500026Z Privileged/Confidential information may be contained in this communication (which includes any attachment). If you are not an intended recipient, you must not use, copy, disclose, distribute or retain this communication or any part of it. Instead, please delete all copies of this communication from your computer system and notify the sender immediately by reply email. Thank you. __20060125_______________________This posting was submitted with HTML in it___ -- Take a break... Have a kitkat... __20060125_______________________This posting was submitted with HTML in it___
-- Take a break... Have a kitkat... _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
