Ive definitely got it working now! I actually ended up taking out the Start and End Date parameters and added MaximumDate and MinimumDate formulas and then changed by subreport links to use those formulas.
This was the best way to go since I am planning on running this via the Remedy reporting dialog that comes with ITSM 5.6 and after I made these changes, all my tests worked and I have the report now published for my users to run this report from the Reporting Dialog! Again, I couldn't have done this without you. Have a Happy Thanksgiving! Thanks Peter Lammey ESPN MIT Technical Services & Applications Management 860-766-4761 -----Original Message----- From: Monroe, [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 22, 2006 10:59 AM To: Lammey, Peter A. Subject: RE: Attaching a Crystal Report with Sub Reports to Remedy Report form Peter, I was reading the ARList replies to your note and wanted to let you know that it does work and I have a working Crystal report running right now that queries off of 3 forms. For the query in the sub reports work and I have no Crystal query in the main report. My main report is the help desk form. My sub reports are of help desk, Change Request, Change Task. It doesn't matter what query I run to launch the report because no results are shown on from the main report. They are all suppressed. The sub reports are each in their own separate report footer. Let me know if you want some more screen shots. Just tell me what you want to see. John Monroe -----Original Message----- From: Monroe, [EMAIL PROTECTED] Sent: Wednesday, November 22, 2006 7:48 AM To: '[EMAIL PROTECTED]' Subject: FW: Attaching a Crystal Report with Sub Reports to Remedy Report form Do to recent email glitches I'm sending my email again to make sure you receive it. John Monroe ________________________________ From: Monroe, [EMAIL PROTECTED] Sent: Tuesday, November 21, 2006 12:06 PM To: 'Lammey, Peter A.' Subject: RE: Attaching a Crystal Report with Sub Reports to Remedy Report form Have you fixed it yet? When I talk about links I mean the following (hope you can see these screen shots) >From the links you sent me it looks like you might want to pass variable. This is how you do that: How do I pass date parameters to sub reports and use them in the selection criteria? faq149-1329 <javascript:openindex(450,450,'http://www.tipmaster.com/includes/refinfo .cfm?w=450&h=450')> Posted: 6 Dec 01 The following was developed for Crystal version 7 as there was a problem in linking dates. 1. Introduction This document describes the steps that will allow nested sub reports to share some or all of the selection parameters of the parent report. This document shows reports that will share a date range as their parameters as this is a common link between reports. The instructions assume that both the Primary and Sub reports have been completed and that the sub report has been inserted into the footer of the Primary report. 2. Instructions 2.1. Set up the Primary Report In the primary report, create 2 parameter fields called startdate and enddate. You do not have to show these fields in the report. These parameters are then shown in the report fields list as ?startdate and ?enddate. Then create 2 formulas called startdate and enddate. The startdate formula should only contain the report field value {?startdate} and the enddate formula should only contain the report field value {?enddate}. These Formulas are then shown in the report fields list as @startdate and @enddate. These formulas are required because you cannot create a subreport link based on a parameter field. You must then edit the selection criteria for the main report to include the data range. Go to the menu options Report|Edit Selection Formula|Record and enter/include the following record selection criteria: {table.datefield} >= [EMAIL PROTECTED] and {table.datefield} <= [EMAIL PROTECTED] 2.2. Set up the Sub Report Create the same 2 parameter fields and the same 2 formula fields in the subreport. These do not have to be on the actual report. 2.3. Link the Reports To link the reports go to the menu options Edit|Subreport Links. Select the formula @startdate from the available fields. This will activate field link section at the bottom of the screen. Remove the tick from the checkbox to deactivate this area. Repeat with the formula @enddate. Then select OK to close the window. Now edit the sub report. The above procedure will have created two parameter fields in the sub report, [EMAIL PROTECTED] and [EMAIL PROTECTED] These parameters represent the range value passed from the main report. You will now have to edit the record selection formula for the sub report. Select Report|Edit Selection Formula|Record from the menu and change the record selection to read: {table.datefield} >= [EMAIL PROTECTED] and {table.datefield} <= [EMAIL PROTECTED] Now, when the report is refreshed, the user will enter in the start and end dates in the main report and these values will populate the record selection formula in the subreport. If you don't need to pass a variable then just put stand alone search criteria in each sub report. Remove any links to the main report and try again. Hope this helps. John Monroe ________________________________ From: Lammey, Peter A. [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 21, 2006 5:40 AM To: Monroe, [EMAIL PROTECTED] Subject: RE: Attaching a Crystal Report with Sub Reports to Remedy Report form Thank you for your suggestions. My results from your help is below in blue. Unfortunately, Im not sure where to go though from these results. Thanks Peter Lammey ESPN MIT Technical Services & Applications Management 860-766-4761 ________________________________ From: Monroe, [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, November 20, 2006 5:11 PM To: Lammey, Peter A. Subject: Attaching a Crystal Report with Sub Reports to Remedy Report form I just finished a Crystal report that has 3 sub reports (HD, CR, TSK) and passes 3 variables from the main report to each of the sub reports (beginning date, ending date, group name). I received many of these useless error messages prior to getting it to work. If I was you, the first thing I would do is to put the crystal report in you home/arcmds directory. Then do a search on the Remedy form that you have as your main form in Crystal. From there select tools/reporting and try printing out the report that way. If this is fine then your report is fine and the issue is with the way it was "embedded" into Remedy. I received the same error when I ran the main Crystal report this time from Tools/Reporting. My main report by the way is against SHR:ConsolidatedList. Im not sure if there is something there that might be causing my issues. It this doesn't work then try the above procedure on each of your sub reports. Remember that you have to do a search on the form that the sub report uses and then select tools reporting. Crystal has an easy menu to export your sub report to an "external" report. Both sub reports did work against HPD:HelpDesk and CHG:Change respectively. It the two sub reports work by themselves they you know it's the way they are connected to the main report or the main report it's self. What form does the main form use in Remedy? SHR:ConsolidatedList If they don't work then maybe you are using Crystal reports 9 but the user client installed is not 6.x? (basically verify that you are on the correct Crystal version) I have created these reports in Crystal 9 and I am using the Remedy User tool 6.3 (no patch). If the two sub reports work then try removing any links between the main report and the sub reports. Also try running the main form by itself after deleting the sub reports. I removed the links that the Sub reports had to the main report (in Record Selection Criteria where I had the following clauses: In my Help Desk sub report I removed the following: {HPD_HelpDesk.Arrival_Date} <= {?Pm-?ToDate} and {HPD_HelpDesk.Arrival_Date} >= {?Pm-?FromDate} In my Change sub report I removed the following: {CHG_Change.Create_date} <= {?Pm-?ToDate} and {CHG_Change.Create_date} >= {?Pm-?FromDate} Still receiving the error when attempting to run the report from the Tools/Reporting after entering the SHR:ConsolidatedList form. Just some troubleshooting steps that worked for me. John _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
