Re: Crystal report Question
I know it is linked since it runs ok on the fat client. This only happens on the Mid Tier. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Bhavsar, Bipin Sent: Monday, May 18, 2009 5:44 AM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** Before running report, please verify database separately (Main Sub Report). Please check sub-report is linked with main report. Thanks Regards, Bipin Bhavsar / Capgemini India / Airoli (Mumbai). Consultant / ITSM (AOS) Phone: +91-22-39194300 Extn: 2211236 VoIP : + 1 312 799 Extn: 2212003. Cell : +91- 99 20 90 4470. Email : bipin.bhav...@capgemini.com Web: www.in.capgemini.com http://www.in.capgemini.com/ Together. Free your energies From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Saturday, May 16, 2009 1:51 AM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** One other thing I noticed. if I run this from the fat client it works fine. Both the main report and subreport display. If I run it from the Mid tier I am prompted for ID/password for the sub report. Even if I put in proper id/password the window just pops back up again. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lammey, Peter A. Sent: Friday, May 15, 2009 2:50 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** In that sub report are you using a parameter field that is set with List of Values set to Dynamic? Thanks Peter Lammey ESPN IT Client Architecture and Automation 860-766-4761 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Friday, May 15, 2009 2:25 PM To: arslist@ARSLIST.ORG Subject: Crystal report Question ** We are using Crystal 10 here for reporting. I recently retired my old server and moved Crystal over to a new server. Everything works Ok except one thing. I have a report which contains a sub report. When I try to run the report I get the pop up below asking for credentials. If I put in a valid ID and password the screen keeps popping back up. The report worked ok on the old server. Other reports (without sub reports) print OK. Anyone point me in the right direction? The pop up says enter your user ID and password for the database used by the sub report: po report Details.rpt there are fields for ID and password. There is also a field for database Name. this field is also blank but is grayed out. Brian Sokol Manager, Desktop Services and IT Customer Care Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.Scholastic.com http://www.scholastic.com/ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ Please consider the environment before printing this e-mail. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are image001.gifimage002.gif
Re: Crystal report Question
Ok it was set to False. I changed it to true. When I went to make this change I was prompted for credentials. I logged in and made the change. I ten went into the Report form and deleted the old attached report and attached the new version. After that it still works in the fat client but not the Mid Tier. the sub report is still asking to log in. even if I give my credentials it prompts again and does not load the sub report. Any other ideas? I don't see why it would work in the fat client but not the web. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Leonard Neely - FOJ Sent: Saturday, May 16, 2009 4:42 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** You may just need to update the Datasource Location properties in the sub report and re-save it again. Check the setting in (Database | Set Datasource Location | Properties) called Use DSN Default Properties. If the value there is set to False, try setting it to True. HTH Leonard Neely. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Friday, May 15, 2009 1:21 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** One other thing I noticed. if I run this from the fat client it works fine. Both the main report and subreport display. If I run it from the Mid tier I am prompted for ID/password for the sub report. Even if I put in proper id/password the window just pops back up again. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lammey, Peter A. Sent: Friday, May 15, 2009 2:50 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** In that sub report are you using a parameter field that is set with List of Values set to Dynamic? Thanks Peter Lammey ESPN IT Client Architecture and Automation 860-766-4761 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Friday, May 15, 2009 2:25 PM To: arslist@ARSLIST.ORG Subject: Crystal report Question ** We are using Crystal 10 here for reporting. I recently retired my old server and moved Crystal over to a new server. Everything works Ok except one thing. I have a report which contains a sub report. When I try to run the report I get the pop up below asking for credentials. If I put in a valid ID and password the screen keeps popping back up. The report worked ok on the old server. Other reports (without sub reports) print OK. Anyone point me in the right direction? The pop up says enter your user ID and password for the database used by the sub report: po report Details.rpt there are fields for ID and password. There is also a field for database Name. this field is also blank but is grayed out. Brian Sokol Manager, Desktop Services and IT Customer Care Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.Scholastic.com http://www.scholastic.com/ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ Please consider the environment before printing this e-mail. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Crystal report Question
Brian, Does the current problem exist for any user running the report, from any workstation? Also, when you moved Crystal to a new server, did you verify that the AR System ODBC configuration was the same? I have also seen issues similar to this when the AR ODBC was configured as a User DSN instead of a System DSN. Leonard Neely From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Monday, May 18, 2009 7:48 AM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** Ok it was set to False. I changed it to true. When I went to make this change I was prompted for credentials. I logged in and made the change. I ten went into the Report form and deleted the old attached report and attached the new version. After that it still works in the fat client but not the Mid Tier. the sub report is still asking to log in. even if I give my credentials it prompts again and does not load the sub report. Any other ideas? I don't see why it would work in the fat client but not the web. _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Leonard Neely - FOJ Sent: Saturday, May 16, 2009 4:42 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** You may just need to update the Datasource Location properties in the sub report and re-save it again. Check the setting in (Database | Set Datasource Location | Properties) called Use DSN Default Properties. If the value there is set to False, try setting it to True. HTH Leonard Neely. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Friday, May 15, 2009 1:21 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** One other thing I noticed. if I run this from the fat client it works fine. Both the main report and subreport display. If I run it from the Mid tier I am prompted for ID/password for the sub report. Even if I put in proper id/password the window just pops back up again. _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lammey, Peter A. Sent: Friday, May 15, 2009 2:50 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** In that sub report are you using a parameter field that is set with List of Values set to Dynamic? Thanks Peter Lammey ESPN IT Client Architecture and Automation 860-766-4761 _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Friday, May 15, 2009 2:25 PM To: arslist@ARSLIST.ORG Subject: Crystal report Question ** We are using Crystal 10 here for reporting. I recently retired my old server and moved Crystal over to a new server. Everything works Ok except one thing. I have a report which contains a sub report. When I try to run the report I get the pop up below asking for credentials. If I put in a valid ID and password the screen keeps popping back up. The report worked ok on the old server. Other reports (without sub reports) print OK. Anyone point me in the right direction? The pop up says enter your user ID and password for the database used by the sub report: po report Details.rpt there are fields for ID and password. There is also a field for database Name. this field is also blank but is grayed out. Brian Sokol Manager, Desktop Services and IT Customer Care Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.scholastic.com/ http://www.Scholastic.com _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _ Please consider the environment before printing this e-mail. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Crystal report Question
Ah...I think I know. The Mid Tier has its own storage of the reports from the Report form I think. I havent worked with the Mid Tier setup for web reporting much but I think that might be your issue. I think when you configure the Crystal Enterprise server to run reports from the web there is a Reports directory on the server that will store the reports locally on that server. Thanks Peter Lammey ESPN IT Client Architecture and Automation 860-766-4761 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Monday, May 18, 2009 10:48 AM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** Ok it was set to False. I changed it to true. When I went to make this change I was prompted for credentials. I logged in and made the change. I ten went into the Report form and deleted the old attached report and attached the new version. After that it still works in the fat client but not the Mid Tier. the sub report is still asking to log in. even if I give my credentials it prompts again and does not load the sub report. Any other ideas? I don't see why it would work in the fat client but not the web. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Leonard Neely - FOJ Sent: Saturday, May 16, 2009 4:42 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** You may just need to update the Datasource Location properties in the sub report and re-save it again. Check the setting in (Database | Set Datasource Location | Properties) called Use DSN Default Properties. If the value there is set to False, try setting it to True. HTH Leonard Neely. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Friday, May 15, 2009 1:21 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** One other thing I noticed. if I run this from the fat client it works fine. Both the main report and subreport display. If I run it from the Mid tier I am prompted for ID/password for the sub report. Even if I put in proper id/password the window just pops back up again. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lammey, Peter A. Sent: Friday, May 15, 2009 2:50 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** In that sub report are you using a parameter field that is set with List of Values set to Dynamic? Thanks Peter Lammey ESPN IT Client Architecture and Automation 860-766-4761 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Friday, May 15, 2009 2:25 PM To: arslist@ARSLIST.ORG Subject: Crystal report Question ** We are using Crystal 10 here for reporting. I recently retired my old server and moved Crystal over to a new server. Everything works Ok except one thing. I have a report which contains a sub report. When I try to run the report I get the pop up below asking for credentials. If I put in a valid ID and password the screen keeps popping back up. The report worked ok on the old server. Other reports (without sub reports) print OK. Anyone point me in the right direction? The pop up says enter your user ID and password for the database used by the sub report: po report Details.rpt there are fields for ID and password. There is also a field for database Name. this field is also blank but is grayed out. Brian Sokol Manager, Desktop Services and IT Customer Care Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.Scholastic.comhttp://www.scholastic.com/ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ Please consider the environment before printing this e-mail. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Crystal report Question
Crystal report Question and the midtier must have access to the crystal's report directory - shared access, etc. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Lammey, Peter A. Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Monday, May 18, 2009 12:19 PM Subject: Re: Crystal report Question ** Ah...I think I know. The Mid Tier has its own storage of the reports from the Report form I think. I havent worked with the Mid Tier setup for web reporting much but I think that might be your issue. I think when you configure the Crystal Enterprise server to run reports from the web there is a Reports directory on the server that will store the reports locally on that server. Thanks Peter Lammey ESPN IT Client Architecture and Automation 860-766-4761 -- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Monday, May 18, 2009 10:48 AM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** Ok it was set to False. I changed it to true. When I went to make this change I was prompted for credentials. I logged in and made the change. I ten went into the Report form and deleted the old attached report and attached the new version. After that it still works in the fat client but not the Mid Tier. the sub report is still asking to log in. even if I give my credentials it prompts again and does not load the sub report. Any other ideas? I don't see why it would work in the fat client but not the web. -- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Leonard Neely - FOJ Sent: Saturday, May 16, 2009 4:42 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** You may just need to update the Datasource Location properties in the sub report and re-save it again. Check the setting in (Database | Set Datasource Location | Properties) called Use DSN Default Properties. If the value there is set to False, try setting it to True. HTH Leonard Neely. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Friday, May 15, 2009 1:21 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** One other thing I noticed. if I run this from the fat client it works fine. Both the main report and subreport display. If I run it from the Mid tier I am prompted for ID/password for the sub report. Even if I put in proper id/password the window just pops back up again. -- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lammey, Peter A. Sent: Friday, May 15, 2009 2:50 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** In that sub report are you using a parameter field that is set with List of Values set to Dynamic? Thanks Peter Lammey ESPN IT Client Architecture and Automation 860-766-4761 -- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Friday, May 15, 2009 2:25 PM To: arslist@ARSLIST.ORG Subject: Crystal report Question ** We are using Crystal 10 here for reporting. I recently retired my old server and moved Crystal over to a new server. Everything works Ok except one thing. I have a report which contains a sub report. When I try to run the report I get the pop up below asking for credentials. If I put in a valid ID and password the screen keeps popping back up. The report worked ok on the old server. Other reports (without sub reports) print OK. Anyone point me in the right direction? The pop up says enter your user ID and password for the database used by the sub report: po report Details.rpt there are fields for ID and password. There is also a field for database Name. this field is also blank but is grayed out. Brian Sokol Manager, Desktop Services and IT Customer Care Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.Scholastic.com _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ -- Please consider the environment before printing this e-mail. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_
Re: Crystal report Question
Maybe a simple Mid Tier Flush cache will do the trick? Thanks Peter Lammey ESPN IT Client Architecture and Automation 860-766-4761 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Nicky Madjarov Sent: Monday, May 18, 2009 12:40 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** and the midtier must have access to the crystal's report directory - shared access, etc. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Lammey, Peter A.mailto:peter.a.lam...@espn.com Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Sent: Monday, May 18, 2009 12:19 PM Subject: Re: Crystal report Question ** Ah...I think I know. The Mid Tier has its own storage of the reports from the Report form I think. I havent worked with the Mid Tier setup for web reporting much but I think that might be your issue. I think when you configure the Crystal Enterprise server to run reports from the web there is a Reports directory on the server that will store the reports locally on that server. Thanks Peter Lammey ESPN IT Client Architecture and Automation 860-766-4761 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Monday, May 18, 2009 10:48 AM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** Ok it was set to False. I changed it to true. When I went to make this change I was prompted for credentials. I logged in and made the change. I ten went into the Report form and deleted the old attached report and attached the new version. After that it still works in the fat client but not the Mid Tier. the sub report is still asking to log in. even if I give my credentials it prompts again and does not load the sub report. Any other ideas? I don't see why it would work in the fat client but not the web. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Leonard Neely - FOJ Sent: Saturday, May 16, 2009 4:42 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** You may just need to update the Datasource Location properties in the sub report and re-save it again. Check the setting in (Database | Set Datasource Location | Properties) called Use DSN Default Properties. If the value there is set to False, try setting it to True. HTH Leonard Neely. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Friday, May 15, 2009 1:21 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** One other thing I noticed. if I run this from the fat client it works fine. Both the main report and subreport display. If I run it from the Mid tier I am prompted for ID/password for the sub report. Even if I put in proper id/password the window just pops back up again. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lammey, Peter A. Sent: Friday, May 15, 2009 2:50 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** In that sub report are you using a parameter field that is set with List of Values set to Dynamic? Thanks Peter Lammey ESPN IT Client Architecture and Automation 860-766-4761 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Friday, May 15, 2009 2:25 PM To: arslist@ARSLIST.ORG Subject: Crystal report Question ** We are using Crystal 10 here for reporting. I recently retired my old server and moved Crystal over to a new server. Everything works Ok except one thing. I have a report which contains a sub report. When I try to run the report I get the pop up below asking for credentials. If I put in a valid ID and password the screen keeps popping back up. The report worked ok on the old server. Other reports (without sub reports) print OK. Anyone point me in the right direction? The pop up says enter your user ID and password for the database used by the sub report: po report Details.rpt there are fields for ID and password. There is also a field for database Name. this field is also blank but is grayed out. Brian Sokol Manager, Desktop Services and IT Customer Care Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.Scholastic.comhttp://www.scholastic.com/ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ Please consider the environment before printing this e-mail. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum
Re: Crystal report Question
Crystal is installed on the same server as my MidTier. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Nicky Madjarov Sent: Monday, May 18, 2009 12:40 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** and the midtier must have access to the crystal's report directory - shared access, etc. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Lammey, Peter A. mailto:peter.a.lam...@espn.com Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Monday, May 18, 2009 12:19 PM Subject: Re: Crystal report Question ** Ah...I think I know. The Mid Tier has its own storage of the reports from the Report form I think. I havent worked with the Mid Tier setup for web reporting much but I think that might be your issue. I think when you configure the Crystal Enterprise server to run reports from the web there is a Reports directory on the server that will store the reports locally on that server. Thanks Peter Lammey ESPN IT Client Architecture and Automation 860-766-4761 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Monday, May 18, 2009 10:48 AM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** Ok it was set to False. I changed it to true. When I went to make this change I was prompted for credentials. I logged in and made the change. I ten went into the Report form and deleted the old attached report and attached the new version. After that it still works in the fat client but not the Mid Tier. the sub report is still asking to log in. even if I give my credentials it prompts again and does not load the sub report. Any other ideas? I don't see why it would work in the fat client but not the web. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Leonard Neely - FOJ Sent: Saturday, May 16, 2009 4:42 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** You may just need to update the Datasource Location properties in the sub report and re-save it again. Check the setting in (Database | Set Datasource Location | Properties) called Use DSN Default Properties. If the value there is set to False, try setting it to True. HTH Leonard Neely. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Friday, May 15, 2009 1:21 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** One other thing I noticed. if I run this from the fat client it works fine. Both the main report and subreport display. If I run it from the Mid tier I am prompted for ID/password for the sub report. Even if I put in proper id/password the window just pops back up again. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lammey, Peter A. Sent: Friday, May 15, 2009 2:50 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** In that sub report are you using a parameter field that is set with List of Values set to Dynamic? Thanks Peter Lammey ESPN IT Client Architecture and Automation 860-766-4761 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Friday, May 15, 2009 2:25 PM To: arslist@ARSLIST.ORG Subject: Crystal report Question ** We are using Crystal 10 here for reporting. I recently retired my old server and moved Crystal over to a new server. Everything works Ok except one thing. I have a report which contains a sub report. When I try to run the report I get the pop up below asking for credentials. If I put in a valid ID and password the screen keeps popping back up. The report worked ok on the old server. Other reports (without sub reports) print OK. Anyone point me in the right direction? The pop up says enter your user ID and password for the database used by the sub report: po report Details.rpt there are fields for ID and password. There is also a field for database Name. this field is also blank but is grayed out
Re: Crystal report Question
Crystal report QuestionHi, You may consider using tcptrace or similar utility to capture what's wrong with your environment. It usually brings more information than the logs in similar cases. There is free eval of tcptrace.exe at www.pocketsoap.com. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Sokol, Brian Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Monday, May 18, 2009 2:35 PM Subject: Re: Crystal report Question ** Crystal is installed on the same server as my MidTier. -- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Nicky Madjarov Sent: Monday, May 18, 2009 12:40 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** and the midtier must have access to the crystal's report directory - shared access, etc. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Lammey, Peter A. Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Monday, May 18, 2009 12:19 PM Subject: Re: Crystal report Question ** Ah...I think I know. The Mid Tier has its own storage of the reports from the Report form I think. I havent worked with the Mid Tier setup for web reporting much but I think that might be your issue. I think when you configure the Crystal Enterprise server to run reports from the web there is a Reports directory on the server that will store the reports locally on that server. Thanks Peter Lammey ESPN IT Client Architecture and Automation 860-766-4761 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Monday, May 18, 2009 10:48 AM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** Ok it was set to False. I changed it to true. When I went to make this change I was prompted for credentials. I logged in and made the change. I ten went into the Report form and deleted the old attached report and attached the new version. After that it still works in the fat client but not the Mid Tier. the sub report is still asking to log in. even if I give my credentials it prompts again and does not load the sub report. Any other ideas? I don't see why it would work in the fat client but not the web. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Leonard Neely - FOJ Sent: Saturday, May 16, 2009 4:42 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** You may just need to update the Datasource Location properties in the sub report and re-save it again. Check the setting in (Database | Set Datasource Location | Properties) called Use DSN Default Properties. If the value there is set to False, try setting it to True. HTH Leonard Neely. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Friday, May 15, 2009 1:21 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** One other thing I noticed. if I run this from the fat client it works fine. Both the main report and subreport display. If I run it from the Mid tier I am prompted for ID/password for the sub report. Even if I put in proper id/password the window just pops back up again. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lammey, Peter A. Sent: Friday, May 15, 2009 2:50 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** In that sub report are you using a parameter field that is set with List of Values set to Dynamic? Thanks Peter Lammey ESPN IT Client Architecture and Automation 860-766-4761 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Friday, May 15, 2009 2:25 PM To: arslist@ARSLIST.ORG Subject: Crystal report Question ** We are using Crystal 10 here for reporting. I recently retired my old server and moved Crystal over to a new server. Everything works Ok except one thing. I have a report which contains a sub report. When I try to run
Re: Crystal report Question
You may just need to update the Datasource Location properties in the sub report and re-save it again. Check the setting in (Database | Set Datasource Location | Properties) called Use DSN Default Properties. If the value there is set to False, try setting it to True. HTH Leonard Neely. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Friday, May 15, 2009 1:21 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** One other thing I noticed. if I run this from the fat client it works fine. Both the main report and subreport display. If I run it from the Mid tier I am prompted for ID/password for the sub report. Even if I put in proper id/password the window just pops back up again. _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lammey, Peter A. Sent: Friday, May 15, 2009 2:50 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** In that sub report are you using a parameter field that is set with List of Values set to Dynamic? Thanks Peter Lammey ESPN IT Client Architecture and Automation 860-766-4761 _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Friday, May 15, 2009 2:25 PM To: arslist@ARSLIST.ORG Subject: Crystal report Question ** We are using Crystal 10 here for reporting. I recently retired my old server and moved Crystal over to a new server. Everything works Ok except one thing. I have a report which contains a sub report. When I try to run the report I get the pop up below asking for credentials. If I put in a valid ID and password the screen keeps popping back up. The report worked ok on the old server. Other reports (without sub reports) print OK. Anyone point me in the right direction? The pop up says enter your user ID and password for the database used by the sub report: po report Details.rpt there are fields for ID and password. There is also a field for database Name. this field is also blank but is grayed out. Brian Sokol Manager, Desktop Services and IT Customer Care Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.scholastic.com/ http://www.Scholastic.com _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _ Please consider the environment before printing this e-mail. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Crystal report Question
We are using Crystal 10 here for reporting. I recently retired my old server and moved Crystal over to a new server. Everything works Ok except one thing. I have a report which contains a sub report. When I try to run the report I get the pop up below asking for credentials. If I put in a valid ID and password the screen keeps popping back up. The report worked ok on the old server. Other reports (without sub reports) print OK. Anyone point me in the right direction? The pop up says enter your user ID and password for the database used by the sub report: po report Details.rpt there are fields for ID and password. There is also a field for database Name. this field is also blank but is grayed out. Brian Sokol Manager, Desktop Services and IT Customer Care Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.Scholastic.com http://www.scholastic.com/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Crystal report Question
In that sub report are you using a parameter field that is set with List of Values set to Dynamic? Thanks Peter Lammey ESPN IT Client Architecture and Automation 860-766-4761 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Friday, May 15, 2009 2:25 PM To: arslist@ARSLIST.ORG Subject: Crystal report Question ** We are using Crystal 10 here for reporting. I recently retired my old server and moved Crystal over to a new server. Everything works Ok except one thing. I have a report which contains a sub report. When I try to run the report I get the pop up below asking for credentials. If I put in a valid ID and password the screen keeps popping back up. The report worked ok on the old server. Other reports (without sub reports) print OK. Anyone point me in the right direction? The pop up says enter your user ID and password for the database used by the sub report: po report Details.rpt there are fields for ID and password. There is also a field for database Name. this field is also blank but is grayed out. Brian Sokol Manager, Desktop Services and IT Customer Care Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.Scholastic.comhttp://www.scholastic.com/ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ Please consider the environment before printing this e-mail. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Crystal report Question
Honestly I know next to nothing about designing reports. I was able to create several mostly simple reports as well as this one with a subreport. I created them over a year ago so I do not remember how I linked them. Do you know where I would check for this? If I go into Edit Subreport Links it shows an instance id field from my database there. I do not see this field on my primary form. Does it need to be there? From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lammey, Peter A. Sent: Friday, May 15, 2009 2:50 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** In that sub report are you using a parameter field that is set with List of Values set to Dynamic? Thanks Peter Lammey ESPN IT Client Architecture and Automation 860-766-4761 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Friday, May 15, 2009 2:25 PM To: arslist@ARSLIST.ORG Subject: Crystal report Question ** We are using Crystal 10 here for reporting. I recently retired my old server and moved Crystal over to a new server. Everything works Ok except one thing. I have a report which contains a sub report. When I try to run the report I get the pop up below asking for credentials. If I put in a valid ID and password the screen keeps popping back up. The report worked ok on the old server. Other reports (without sub reports) print OK. Anyone point me in the right direction? The pop up says enter your user ID and password for the database used by the sub report: po report Details.rpt there are fields for ID and password. There is also a field for database Name. this field is also blank but is grayed out. Brian Sokol Manager, Desktop Services and IT Customer Care Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.Scholastic.com http://www.scholastic.com/ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ Please consider the environment before printing this e-mail. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Crystal report Question
One other thing I noticed. if I run this from the fat client it works fine. Both the main report and subreport display. If I run it from the Mid tier I am prompted for ID/password for the sub report. Even if I put in proper id/password the window just pops back up again. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lammey, Peter A. Sent: Friday, May 15, 2009 2:50 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Question ** In that sub report are you using a parameter field that is set with List of Values set to Dynamic? Thanks Peter Lammey ESPN IT Client Architecture and Automation 860-766-4761 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Friday, May 15, 2009 2:25 PM To: arslist@ARSLIST.ORG Subject: Crystal report Question ** We are using Crystal 10 here for reporting. I recently retired my old server and moved Crystal over to a new server. Everything works Ok except one thing. I have a report which contains a sub report. When I try to run the report I get the pop up below asking for credentials. If I put in a valid ID and password the screen keeps popping back up. The report worked ok on the old server. Other reports (without sub reports) print OK. Anyone point me in the right direction? The pop up says enter your user ID and password for the database used by the sub report: po report Details.rpt there are fields for ID and password. There is also a field for database Name. this field is also blank but is grayed out. Brian Sokol Manager, Desktop Services and IT Customer Care Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.Scholastic.com http://www.scholastic.com/ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ Please consider the environment before printing this e-mail. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Crystal Report Question - SOLVED
Huge thanks to all! Using a combination of ideas from you, here is what I used (in case anyone wants to know): Formula field 1: AM/PM = if Time({Times__eSight.Start}) Time(12,00,00) then AM else PM Formula field 2: Day = DayOfWeek ({Times__eSight.Start}) Formula field 3: Day/Shift = ~ if ([EMAIL PROTECTED] and [EMAIL PROTECTED]/PM} = PM or [EMAIL PROTECTED] and [EMAIL PROTECTED]/PM} =AM) then S-M Shift else if ([EMAIL PROTECTED] and [EMAIL PROTECTED]/PM} = PM or [EMAIL PROTECTED] and [EMAIL PROTECTED]/PM} =AM) then M-T Shift else if ([EMAIL PROTECTED] and [EMAIL PROTECTED]/PM} = PM or [EMAIL PROTECTED] and [EMAIL PROTECTED]/PM} =AM) then T-W Shift else if ([EMAIL PROTECTED] and [EMAIL PROTECTED]/PM} = PM or [EMAIL PROTECTED] and [EMAIL PROTECTED]/PM} =AM) then W-T Shift else if ([EMAIL PROTECTED] and [EMAIL PROTECTED]/PM} = PM or [EMAIL PROTECTED] and [EMAIL PROTECTED]/PM} =AM) then T-F Shift ~ Then I was able to group by Day/Shift, which gave me everything I needed! Huge thanks to all again!!! Shawn ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Crystal Report Question
Greetings List! Nor a Remedy question, but hopefully someone can help me anyway. I'm trying to write a report to show all records created between Sunday 7pm through Friday 7am between the hours of 7am and 7pm. I've tried Time({Form.Create Date})Time (18, 59, 59) or Time({Form.Create Date})Time (7, 00, 00)) and DayOfWeek({Form.Create Date})7 however, this gives me records created between Friday 7pm and Sunday 7am as well, which need to be excluded. I tried thinking of a way to exclude Sunday AM and Friday PM, but couldn't think how to do this. Ideally, I'd like to also group them by Sunday PM/Monday AM, Monday PM/TuesdayAM, etc. Does anyone have any ideas? HUGE THX IN ADVANCE!!! Shawn Stonequist EMNS Inc. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Crystal Report Question
Hi Shawn, A rather easier way of doing this would be to use Select Expert. Your records probably need grouping via Day/Date. Once the records are grouped you can use select expert to define the criteria for your report. Please consider the following formula as an example. [EMAIL PROTECTED] in Time (0, 00, 40) to Time (0, 20, 40) and {Form.Date/Time} in DateTime (2008, 08, 13, 00, 06, 40) to DateTime (2008, 09, 07, 12, 32, 01) In the above formula @Time is a variable that I created which basically returns Time from DateTime field. Hope this approach would help you. Regards, Mohtashim Abbasi Remedy Consultant Technosys UK Limited DDI : +44208 429 5954 Main: +44208 429 5955 Mobile: +447590554781 Email: [EMAIL PROTECTED] Web: http://www.technosysuk.com 204 - 226 Imperial Drive Rayners Lane, Harrow Middlesex HA2 7HH -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shawn Stonequist Sent: 28 October 2008 14:10 To: arslist@ARSLIST.ORG Subject: Crystal Report Question Greetings List! Nor a Remedy question, but hopefully someone can help me anyway. I'm trying to write a report to show all records created between Sunday 7pm through Friday 7am between the hours of 7am and 7pm. I've tried Time({Form.Create Date})Time (18, 59, 59) or Time({Form.Create Date})Time (7, 00, 00)) and DayOfWeek({Form.Create Date})7 however, this gives me records created between Friday 7pm and Sunday 7am as well, which need to be excluded. I tried thinking of a way to exclude Sunday AM and Friday PM, but couldn't think how to do this. Ideally, I'd like to also group them by Sunday PM/Monday AM, Monday PM/TuesdayAM, etc. Does anyone have any ideas? HUGE THX IN ADVANCE!!! Shawn Stonequist EMNS Inc. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Crystal Report Question
This is how I attacked the problem. I created two formulas. * DayOfWeek oDayOfWeek ({HPD_HelpDesk.Create Time}) * Hour oHour ({HPD_HelpDesk.Create Time}) I then used them in the Select Statement. {HPD_HelpDesk.Create Time} in LastFullWeek and (([EMAIL PROTECTED] = 1 AND [EMAIL PROTECTED] 19) OR ([EMAIL PROTECTED] = 2) OR ([EMAIL PROTECTED] = 3) OR ([EMAIL PROTECTED] = 4) OR ([EMAIL PROTECTED] = 5) OR ([EMAIL PROTECTED] = 6 AND [EMAIL PROTECTED] 19)) -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shawn Stonequist Sent: Tuesday, October 28, 2008 9:10 AM To: arslist@ARSLIST.ORG Subject: Crystal Report Question Greetings List! Nor a Remedy question, but hopefully someone can help me anyway. I'm trying to write a report to show all records created between Sunday 7pm through Friday 7am between the hours of 7am and 7pm. I've tried Time({Form.Create Date})Time (18, 59, 59) or Time({Form.Create Date})Time (7, 00, 00)) and DayOfWeek({Form.Create Date})7 however, this gives me records created between Friday 7pm and Sunday 7am as well, which need to be excluded. I tried thinking of a way to exclude Sunday AM and Friday PM, but couldn't think how to do this. Ideally, I'd like to also group them by Sunday PM/Monday AM, Monday PM/TuesdayAM, etc. Does anyone have any ideas? HUGE THX IN ADVANCE!!! Shawn Stonequist EMNS Inc. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are *** Confidentiality Notice *** This email, its electronic document attachments, and the contents of its website linkages may contain confidential health information. This information is intended solely for use by the individual or entity to whom it is addressed. If you have received this information in error, please notify the sender immediately and arrange for the prompt destruction of the material and any accompanying attachments. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Crystal Report Question
As far as grouping goes, You can create the first group on DayOfWeek and create a formula for AM/PM and create a second group on that. AM/PM formula If [EMAIL PROTECTED] 12 Then AM Else If [EMAIL PROTECTED] = 12 Then PM -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shawn Stonequist Sent: Tuesday, October 28, 2008 9:10 AM To: arslist@ARSLIST.ORG Subject: Crystal Report Question Greetings List! Nor a Remedy question, but hopefully someone can help me anyway. I'm trying to write a report to show all records created between Sunday 7pm through Friday 7am between the hours of 7am and 7pm. I've tried Time({Form.Create Date})Time (18, 59, 59) or Time({Form.Create Date})Time (7, 00, 00)) and DayOfWeek({Form.Create Date})7 however, this gives me records created between Friday 7pm and Sunday 7am as well, which need to be excluded. I tried thinking of a way to exclude Sunday AM and Friday PM, but couldn't think how to do this. Ideally, I'd like to also group them by Sunday PM/Monday AM, Monday PM/TuesdayAM, etc. Does anyone have any ideas? HUGE THX IN ADVANCE!!! Shawn Stonequist EMNS Inc. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are *** Confidentiality Notice *** This email, its electronic document attachments, and the contents of its website linkages may contain confidential health information. This information is intended solely for use by the individual or entity to whom it is addressed. If you have received this information in error, please notify the sender immediately and arrange for the prompt destruction of the material and any accompanying attachments. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Crystal Report Question
Sorry, I realized after rereading your email that I missed a portion. (([EMAIL PROTECTED] = 1 AND [EMAIL PROTECTED] 19) OR ([EMAIL PROTECTED] = 2) And [EMAIL PROTECTED] In [7,8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18] OR ([EMAIL PROTECTED] = 3) And [EMAIL PROTECTED] In [7,8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18] OR ([EMAIL PROTECTED] = 4) And [EMAIL PROTECTED] In [7,8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18] OR ([EMAIL PROTECTED] = 5) And [EMAIL PROTECTED] In [7,8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18] OR ([EMAIL PROTECTED] = 6) And [EMAIL PROTECTED] In [7,8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18]) and {HPD_HelpDesk.Create Time} in LastFullWeek -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shawn Stonequist Sent: Tuesday, October 28, 2008 9:10 AM To: arslist@ARSLIST.ORG Subject: Crystal Report Question Greetings List! Nor a Remedy question, but hopefully someone can help me anyway. I'm trying to write a report to show all records created between Sunday 7pm through Friday 7am between the hours of 7am and 7pm. I've tried Time({Form.Create Date})Time (18, 59, 59) or Time({Form.Create Date})Time (7, 00, 00)) and DayOfWeek({Form.Create Date})7 however, this gives me records created between Friday 7pm and Sunday 7am as well, which need to be excluded. I tried thinking of a way to exclude Sunday AM and Friday PM, but couldn't think how to do this. Ideally, I'd like to also group them by Sunday PM/Monday AM, Monday PM/TuesdayAM, etc. Does anyone have any ideas? HUGE THX IN ADVANCE!!! Shawn Stonequist EMNS Inc. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are *** Confidentiality Notice *** This email, its electronic document attachments, and the contents of its website linkages may contain confidential health information. This information is intended solely for use by the individual or entity to whom it is addressed. If you have received this information in error, please notify the sender immediately and arrange for the prompt destruction of the material and any accompanying attachments. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Crystal Report Question
Thank you! Say Hello to NYC for me it's been sometime since I've been in the Big Apple. John Atherly American Power Conversion [EMAIL PROTECTED] 401-789-5735 Ext. 2120 1-800-788-2208 Ext. 2120 Benedetto Cantatore [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 06/16/2008 06:08 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Crystal Report Question ** John, The crosstab is dependant on the selection criteria for the most part to select records that said I'm thinking the way you can get what you want is to put that crosstab in a group and have the group filter out the records you don't need. The group can be something as simple as true/false, and you supress the false records. Alternatively, you can create a mock crosstab report which will probably work best. See Business Object's website for that info. Also tek-tips.com is an excellent source for Crystal reports help. Ben Cantatore Remedy Manager (914) 457-6209 Emerging Health IT 3 Odell Plaza Yonkers, New York 10701 [EMAIL PROTECTED] 06/16/08 3:01 PM ** I'm trying to use Cross-Tab to display Incidents that are closed in the first hour after the Helpdesk person takes it. I have my formula that pulls the tickets to be counted. [EMAIL PROTECTED] three months} AND {HPD_HelpDesk.Assigned_To_Group_}= 'Service_Desk_NAM' AND {HPD_HelpDesk.Status} = ['Resolved', 'Closed'] AND ({HPD_HelpDesk.Status_History_Resolved_TIME}-{HPD_HelpDesk.Status_History_New_TIME})= .04 Which works if the formula is in the record selection. If I move the formula to a field on the Cross-Tab I get all tickets not just the ones I'm looking for. There is a button on the Cross-Tab to add a formula but if seems that Cross-Tab do not use formulas. Is there a box I need to check off to have the formula run in the Cross-Tab? The bottom line I'm lookingg for is the percent closed in the first hour over the total number of ticket for given month. I tried creating a sub report with a Cross-Tab showing all tickets but could not find a way to percent the two fields (One from the first Cross-Tab the second from the sub report Cross-Tab. John Atherly American Power Conversion [EMAIL PROTECTED] 401-789-5735 Ext. 2120 1-800-788-2208 Ext. 2120 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Crystal Report Question
Glad that was helpful and if that nudged you in the right direction, that's great. If you need additional help let me know. Big Apple, is doing fine :). Ben Cantatore Remedy Manager (914) 457-6209 Emerging Health IT 3 Odell Plaza Yonkers, New York 10701 [EMAIL PROTECTED] 06/17/08 8:11 AM ** Thank you! Say Hello to NYC for me it's been sometime since I've been in the Big Apple. John Atherly American Power Conversion [EMAIL PROTECTED] 401-789-5735 Ext. 2120 1-800-788-2208 Ext. 2120 Benedetto Cantatore [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 06/16/2008 06:08 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Crystal Report Question ** John, The crosstab is dependant on the selection criteria for the most part to select records that said I'm thinking the way you can get what you want is to put that crosstab in a group and have the group filter out the records you don't need. The group can be something as simple as true/false, and you supress the false records. Alternatively, you can create a mock crosstab report which will probably work best. See Business Object's website for that info. Also tek-tips.com is an excellent source for Crystal reports help. Ben Cantatore Remedy Manager (914) 457-6209 Emerging Health IT 3 Odell Plaza Yonkers, New York 10701 [EMAIL PROTECTED] 06/16/08 3:01 PM ** I'm trying to use Cross-Tab to display Incidents that are closed in the first hour after the Helpdesk person takes it. I have my formula that pulls the tickets to be counted. [EMAIL PROTECTED] three months} AND {HPD_HelpDesk.Assigned_To_Group_}= 'Service_Desk_NAM' AND {HPD_HelpDesk.Status} = ['Resolved', 'Closed'] AND ({HPD_HelpDesk.Status_History_Resolved_TIME}-{HPD_HelpDesk.Status_History_New_TIME})= .04 Which works if the formula is in the record selection. If I move the formula to a field on the Cross-Tab I get all tickets not just the ones I'm looking for. There is a button on the Cross-Tab to add a formula but if seems that Cross-Tab do not use formulas. Is there a box I need to check off to have the formula run in the Cross-Tab? The bottom line I'm lookingg for is the percent closed in the first hour over the total number of ticket for given month. I tried creating a sub report with a Cross-Tab showing all tickets but could not find a way to percent the two fields (One from the first Cross-Tab the second from the sub report Cross-Tab. John Atherly American Power Conversion [EMAIL PROTECTED] 401-789-5735 Ext. 2120 1-800-788-2208 Ext. 2120 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Crystal Report Question
I'm trying to use Cross-Tab to display Incidents that are closed in the first hour after the Helpdesk person takes it. I have my formula that pulls the tickets to be counted. [EMAIL PROTECTED] three months} AND {HPD_HelpDesk.Assigned_To_Group_}= 'Service_Desk_NAM' AND {HPD_HelpDesk.Status} = ['Resolved', 'Closed'] AND ({HPD_HelpDesk.Status_History_Resolved_TIME}-{HPD_HelpDesk.Status_History_New_TIME})= .04 Which works if the formula is in the record selection. If I move the formula to a field on the Cross-Tab I get all tickets not just the ones I'm looking for. There is a button on the Cross-Tab to add a formula but if seems that Cross-Tab do not use formulas. Is there a box I need to check off to have the formula run in the Cross-Tab? The bottom line I'm lookingg for is the percent closed in the first hour over the total number of ticket for given month. I tried creating a sub report with a Cross-Tab showing all tickets but could not find a way to percent the two fields (One from the first Cross-Tab the second from the sub report Cross-Tab. John Atherly American Power Conversion [EMAIL PROTECTED] 401-789-5735 Ext. 2120 1-800-788-2208 Ext. 2120 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Crystal Report Question
Another option: Have a control panel that launches the report, into which you enter your variables. Then base your report on a join between the control panel and the form the report is really about. This control panel has a single record. In addition to the input fields it also has a button that calls an active link. The link first saves the record, which puts the variables into the database, then displays the report. Dwayne Martin James Madison University Original message Date: Wed, 8 Aug 2007 13:35:47 -0700 From: Pargeter, Christie [EMAIL PROTECTED] Subject: Re: Crystal Report Question To: arslist@ARSLIST.ORG ** When you do a open window of a report you can type in the qualifications you would like the report to use. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Welton Bryant Sent: Wednesday, August 08, 2007 12:22 PM To: arslist@ARSLIST.ORG Subject: Crystal Report Question ** Hello, Is there a way to pass a variable to a crystal report from an active link? If so could someone give me an example. Thanks Welton Bryant MCSE,MCP Sr. Business Applications Analyst CareTech Solutions Inc. 248-823-0341 Office 313-408-5188 Cell 800-428-4781 Pager [EMAIL PROTECTED] www.caretechsolutions.com __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ Dwayne Martin Computing Support James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Crystal Report Question
Hello, Is there a way to pass a variable to a crystal report from an active link? If so could someone give me an example. Thanks Welton Bryant MCSE,MCP Sr. Business Applications Analyst CareTech Solutions Inc. 248-823-0341 Office 313-408-5188 Cell 800-428-4781 Pager [EMAIL PROTECTED] www.caretechsolutions.com http://www.caretechsolutions.com/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Crystal Report Question
You can create variables in Crystal Reports itself and prompt a user for the same when the reports are run. These variables could be dynamic if you wanted them that way and query the database to generate menus of possible values. Wouldn't that be useful to you? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Welton Bryant Sent: Wednesday, August 08, 2007 3:22 PM To: arslist@ARSLIST.ORG Subject: Crystal Report Question ** Hello, Is there a way to pass a variable to a crystal report from an active link? If so could someone give me an example. Thanks Welton Bryant MCSE,MCP Sr. Business Applications Analyst CareTech Solutions Inc. 248-823-0341 Office 313-408-5188 Cell 800-428-4781 Pager [EMAIL PROTECTED] www.caretechsolutions.com __20060125___This posting was submitted with HTML in it___ No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.476 / Virus Database: 269.11.8/941 - Release Date: 8/7/2007 4:06 PM ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Crystal Report Question
When you do a open window of a report you can type in the qualifications you would like the report to use. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Welton Bryant Sent: Wednesday, August 08, 2007 12:22 PM To: arslist@ARSLIST.ORG Subject: Crystal Report Question ** Hello, Is there a way to pass a variable to a crystal report from an active link? If so could someone give me an example. Thanks Welton Bryant MCSE,MCP Sr. Business Applications Analyst CareTech Solutions Inc. 248-823-0341 Office 313-408-5188 Cell 800-428-4781 Pager [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] www.caretechsolutions.com http://www.caretechsolutions.com/ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are