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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Looking for a cheap way to run OOB crystal reports in 7.6.4
Hi, you can still use the User Tool in 7.6.04 to run the Reports, I do this all the time. It is still provided, but is now end of life. Cheers Carl http://www.missingpiecessoftware.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Remedy Sent: 06 July 2012 19:46 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"
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 thisso 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'tlet'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. Sothis 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 knoweasier said than done...but certainly in the feasible realmin 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_Reports.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 sourceif 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"
Re: Looking for a cheap way to run OOB crystal reports in 7.6.4
Carl, Thanks. We are trying not to push out the user tool at this point. I can see some trying to open incident with it, then say the system is broken. Howard From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Carl Wilson Sent: Friday, July 06, 2012 2:55 PM To: arslist@ARSLIST.ORG Subject: Re: Looking for a cheap way to run OOB crystal reports in 7.6.4 ** Hi, you can still use the User Tool in 7.6.04 to run the Reports, I do this all the time. It is still provided, but is now end of life. Cheers Carl http://www.missingpiecessoftware.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Remedy Sent: 06 July 2012 19:46 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"_ _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"
Re: Looking for a cheap way to run OOB crystal reports in 7.6.4
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 thisso 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'tlet'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. Sothis 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 knoweasier said than done...but certainly in the feasible realmin 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 sourceif 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"
Re: Looking for a cheap way to run OOB crystal reports in 7.6.4
Another option is to utilize the OOTB web reports provided with ITSM 7.6.04. Those reports were created to duplicate the most commonly utilized Crystal reports found in previous releases. Using the OOTB web reports requires no additional infrastructure, works on the web client and comes at no additional cost. Using the web reports therefore "gets around" the requirement to buy and build a crystal server. It allows you to run the reports and save off the file into a variety of formats. -David J. Easter Manager of Product Management, AR System BSM & Atrium Solutions Management BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Remedy Sent: Friday, July 06, 2012 11:46 AM 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"
Re: Looking for a cheap way to run OOB crystal reports in 7.6.4
Howard: First off, really glad you're feeling well enough to Remedy again. :) Check this out -- it seems promising: http://wiki.sdn.sap.com/wiki/display/BOBJ/Deploying+Crystal+Reports+for+Visual+Studio+2010+Runtime . HTH, --Phil -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Howard Richter Sent: Friday, July 06, 2012 15:03 To: arslist@ARSLIST.ORG Subject: Re: Looking for a cheap way to run OOB crystal reports in 7.6.4 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 thisso 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'tlet'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. Sothis 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 knoweasier said than done...but certainly in the feasible realmin 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 sourceif 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" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Looking for a cheap way to run OOB crystal reports in 7.6.4
David, I am glad you popped into this. The reason for the request is due to the reports that are OOB and were created for crystal reports. I have asked support for a list of the reports not converted and only received a list of the Web reports, but not one that shows what reports were not converted. So I have been asked to find some way so we can run the OOB Crystal reports included with ITSM 7.6.4 and not converted (or might be) to a Web report. Our goal is to use the new OOB reporting tool, however, the example Crystal reports supplied by BMC are reason for this request. Thanks and take care, Howard From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Easter, David Sent: Friday, July 06, 2012 3:11 PM To: arslist@ARSLIST.ORG Subject: Re: Looking for a cheap way to run OOB crystal reports in 7.6.4 ** Another option is to utilize the OOTB web reports provided with ITSM 7.6.04. Those reports were created to duplicate the most commonly utilized Crystal reports found in previous releases. Using the OOTB web reports requires no additional infrastructure, works on the web client and comes at no additional cost. Using the web reports therefore "gets around" the requirement to buy and build a crystal server. It allows you to run the reports and save off the file into a variety of formats. -David J. Easter Manager of Product Management, AR System BSM & Atrium Solutions Management BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Remedy Sent: Friday, July 06, 2012 11:46 AM 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"_ _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"
Re: Looking for a cheap way to run OOB crystal reports in 7.6.4
Phil, Thanks, lets say its been a very strange year. I will check into this. Howard -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Murnane, Phil Sent: Friday, July 06, 2012 3:16 PM To: arslist@ARSLIST.ORG Subject: Re: Looking for a cheap way to run OOB crystal reports in 7.6.4 Howard: First off, really glad you're feeling well enough to Remedy again. :) Check this out -- it seems promising: http://wiki.sdn.sap.com/wiki/display/BOBJ/Deploying+Crystal+Reports+for+Visu al+Studio+2010+Runtime . HTH, --Phil -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Howard Richter Sent: Friday, July 06, 2012 15:03 To: arslist@ARSLIST.ORG Subject: Re: Looking for a cheap way to run OOB crystal reports in 7.6.4 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 thisso 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'tlet'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. Sothis 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 knoweasier said than done...but certainly in the feasible realmin 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 sourceif 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" ___ UNSUBSCRIBE or access ARSlist
Re: Looking for a cheap way to run OOB crystal reports in 7.6.4
You may want to check this out. http://www.reportalsoftware.com/ We used this a few years back, and it worked great. cheers, M On Fri, Jul 6, 2012 at 4:12 PM, Remedy wrote: > Phil, > > Thanks, lets say its been a very strange year. > > I will check into this. > > Howard > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Murnane, Phil > Sent: Friday, July 06, 2012 3:16 PM > To: arslist@ARSLIST.ORG > Subject: Re: Looking for a cheap way to run OOB crystal reports in 7.6.4 > > Howard: > > First off, really glad you're feeling well enough to Remedy again. :) > > Check this out -- it seems promising: > > http://wiki.sdn.sap.com/wiki/display/BOBJ/Deploying+Crystal+Reports+for+Visu > al+Studio+2010+Runtime . > > HTH, > --Phil > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Howard Richter > Sent: Friday, July 06, 2012 15:03 > To: arslist@ARSLIST.ORG > Subject: Re: Looking for a cheap way to run OOB crystal reports in 7.6.4 > > 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 thisso 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'tlet'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. Sothis 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 knoweasier said than done...but certainly in the feasible > realmin 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 sourceif 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 ITS
Re: Looking for a cheap way to run OOB crystal reports in 7.6.4
Hi, you can look into this site: http://www.kenhamady.com/bookmarks.html The site list a comparison of tools, some free, for running, viewing, automating, etc for Crystal reports. Hope this helps. Cheers Carl http://www.missingpiecessoftware.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Howard Richter Sent: 06 July 2012 19:59 To: arslist@ARSLIST.ORG Subject: Re: Looking for a cheap way to run OOB crystal reports in 7.6.4 ** Carl, Thanks. We are trying not to push out the user tool at this point. I can see some trying to open incident with it, then say the system is broken. Howard From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Carl Wilson Sent: Friday, July 06, 2012 2:55 PM To: arslist@ARSLIST.ORG Subject: Re: Looking for a cheap way to run OOB crystal reports in 7.6.4 ** Hi, you can still use the User Tool in 7.6.04 to run the Reports, I do this all the time. It is still provided, but is now end of life. Cheers Carl http://www.missingpiecessoftware.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Remedy Sent: 06 July 2012 19:46 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"_ _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _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"
Re: Looking for a cheap way to run OOB crystal reports in 7.6.4
Hi Howard! We've been using CRExport for years and have even developed a Remedy App around it that schedules reports to be run and uses an escalation to kick off the reports and optionally mail them out in .pdf attachments to users using the AR Email engine. See http://www.rainforestnet.com/crystal-reports-exporter/ Best Regards, Theo Sent from my Black/Silver Personal Computer "Try not to become a person of success, but a person of value." - Albert Einstein From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Carl Wilson Sent: 07 July 2012 13:18 To: arslist@ARSLIST.ORG Subject: Re: Looking for a cheap way to run OOB crystal reports in 7.6.4 ** Hi, you can look into this site: http://www.kenhamady.com/bookmarks.html The site list a comparison of tools, some free, for running, viewing, automating, etc for Crystal reports. Hope this helps. Cheers Carl http://www.missingpiecessoftware.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Howard Richter Sent: 06 July 2012 19:59 To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: Looking for a cheap way to run OOB crystal reports in 7.6.4 ** Carl, Thanks. We are trying not to push out the user tool at this point. I can see some trying to open incident with it, then say the system is broken. Howard From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Carl Wilson Sent: Friday, July 06, 2012 2:55 PM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: Looking for a cheap way to run OOB crystal reports in 7.6.4 ** Hi, you can still use the User Tool in 7.6.04 to run the Reports, I do this all the time. It is still provided, but is now end of life. Cheers Carl http://www.missingpiecessoftware.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]<mailto:[mailto:arslist@ARSLIST.ORG]> On Behalf Of Remedy Sent: 06 July 2012 19:46 To: arslist@ARSLIST.ORG<mailto: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<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com<http://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"
Re: Looking for a cheap way to run OOB crystal reports in 7.6.4
Howard: While doing something completely different, I ran across this web page: http://www.sap.com/solutions/sme/business-intelligence-crystal-solutions/sap-crystal-server/requirements.epx -- read the part about SAP Crystal Viewer; it may be exactly what you're looking for. --Phil From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Theo Fondse Sent: Monday, July 09, 2012 03:31 To: arslist@ARSLIST.ORG Subject: Re: Looking for a cheap way to run OOB crystal reports in 7.6.4 ** Hi Howard! We've been using CRExport for years and have even developed a Remedy App around it that schedules reports to be run and uses an escalation to kick off the reports and optionally mail them out in .pdf attachments to users using the AR Email engine. See http://www.rainforestnet.com/crystal-reports-exporter/ Best Regards, Theo Sent from my Black/Silver Personal Computer "Try not to become a person of success, but a person of value." - Albert Einstein From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Carl Wilson Sent: 07 July 2012 13:18 To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: Looking for a cheap way to run OOB crystal reports in 7.6.4 ** Hi, you can look into this site: http://www.kenhamady.com/bookmarks.html The site list a comparison of tools, some free, for running, viewing, automating, etc for Crystal reports. Hope this helps. Cheers Carl http://www.missingpiecessoftware.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Howard Richter Sent: 06 July 2012 19:59 To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: Looking for a cheap way to run OOB crystal reports in 7.6.4 ** Carl, Thanks. We are trying not to push out the user tool at this point. I can see some trying to open incident with it, then say the system is broken. Howard From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Carl Wilson Sent: Friday, July 06, 2012 2:55 PM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: Looking for a cheap way to run OOB crystal reports in 7.6.4 ** Hi, you can still use the User Tool in 7.6.04 to run the Reports, I do this all the time. It is still provided, but is now end of life. Cheers Carl http://www.missingpiecessoftware.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]<mailto:[mailto:arslist@ARSLIST.ORG]> On Behalf Of Remedy Sent: 06 July 2012 19:46 To: arslist@ARSLIST.ORG<mailto: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<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com<http://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"