It's a grain of salt (and I need to avoid that), but it might just fly. The odd thing, is when I use one of the reports in the user tool on my 7.6.1 system it works. But when I use the same report (also on the user tool) in the 7.6.4 system, it does not display any data and I can find the data by doing a simple search.
Thanks this idea is something worth looking into. Howard -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, LJ CTR MDA/IC Sent: Friday, July 06, 2012 2:57 PM To: arslist@ARSLIST.ORG Subject: Re: Looking for a cheap way to run OOB crystal reports in 7.6.4 Howard, I know not of what sort of difficulty I speak when I say this....so please take it with a grain of salt as either complete lunacy or a doable solution, depending on your personal and team capabilities. Now...when we look at the fact that the user tool can utilize these reports yet the web can't....let's analyze the 'why' of that. The native client has access to the Crystal Reports runtime engine, where the Mid-Tier does not. This tells that in order to run/print the reports, you do NOT need to purchase the crystal reports server...you simply need to be able to interact with the CR runtime. So....this is my proposal, and it is off the top of my head with completely 0 research as to its feasibility. Write yourself either a C or a Java application that can do two things. 1 - Log into the Remedy server to get at the report 2 - Interact with the CR runtime (this is the part that I have NO clue about) Once written, this application should be able to be called with a button press, or an escalation, or whatever manner you chose, and it should be able to log on, get the report in question, process the data in Remedy through the report, and provide the output in any manner that you deem desirable. I know, I know....easier said than done...but certainly in the feasible realm....in fact, a quick google on 'crystal reports runtime java' came up with an article as the first entry http://j-integra.intrinsyc.com/support/com/doc/other_examples/Crystal_Report s.htm that describes a VERY simple java program that executes a report. It uses a DSN to connect...which could obviously be setup with the Remedy ODBC as the data source....if I'm not mistaken the 'query' is also readily accessible as well I see this as a VERY doable solution to being able to run the reports from server command line, and even mail the darn things out :) -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Remedy Sent: Friday, July 06, 2012 12:46 PM To: arslist@ARSLIST.ORG Subject: Looking for a cheap way to run OOB crystal reports in 7.6.4 ** Happy Friday to all, I have a request to find a cheap way to run the BMC provided OOB crystal reports that came with 7.6.4. Since we use Hyperion for reporting, we do not need to create any new crystal reports and are not looking to print them. Just run them and save off the file. So I am looking for a cheap way of getting around the requirement to buy and then build a crystal server. Too bad that we can't use the user tool in ITSM 7.6.4. Any ideas? Also a Friday thought, Only Robinson Crusoe had everything done by Friday. ~Author Unknown Take care, Howard _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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
