Add the field to the main and subreport, check what values are coming through.
Ben Cantatore Remedy Administrator Avon (914) 935-2946 Susan Palmer <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 07/17/2007 08:55 AM Please respond to [email protected] To [email protected] cc Subject Re: Client v701P3 and Crystal Reports 11 ** Hi Ben, Those were good ideas. I had already checked them. Had deleted them and reselected them. I can't tell if the Task ID isn't going to the subreports or if the parameter just isn't being picked up at all even for the main report. I re-recorded the macro and actually have a 2nd button just for user tool v7 people. The original doesn't work for them. Thanks, Susan On 7/17/07, Ben Cantatore <[EMAIL PROTECTED]> wrote: ** I'm not sure if I understand the problem 100% but it sounds like the Task ID isn't being passed correctly to the subreports. In Crystal, right click your subreport and select Change subreport links option. Then check the field that is supose to be passing that value to the subreport. I'd further check the report selection criteria in the subreport and see what its referencing. I suspect if you look at the links/criteria you'll find something a tad off. Worst case, delete the link and put them back in Ben Cantatore Remedy Administrator Avon (914) 935-2946 Susan Palmer <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" < [email protected] > 07/16/2007 06:53 PM Please respond to [email protected] To [email protected] cc Subject Client v701P3 and Crystal Reports 11 ** I have a Crystal Report that was originally in v9. Now that we're on ARS v701P2 I needed to upgrade it to Crystal v11. The report saved nicely and it does run (yes, somethings do work out). This report has two subreports and everything is reliant on the Task ID. I have it as part of a macro attached to an active link. You're on the task and you click the button, and whaalaa, you get a Packing List report. When we were on client v5.1.2 we just clicked the button. But now on client v701P3, a window appears and wants a Discrete Value, which is the Task ID. Before we didn't have to key in that number, the macro filled it in. How do I get it to work that way in the new version? I've searched the menu options and help in Crystal for a clue. But no clues are there. We also get a message the first time we run this type of report asking if we want to override the Embedded Query. If we say No, you get headings and white space. If you say Yes, you get the what you expected. Apparently this Yes or No hold true for the whole session. What is this about? I need Crystal guru help !!! At our last MWRUG meeting, one company actually has a Crystal Reports person ... I was so jealous. Thanks for all your help, Susan Side note: The report we have with 14 subreports actually saved well in Crystal 11. Only had to delete a few fields that still existed on the form but v11 didn't like and it WORKS! I was so thankful I didn't have to start from scratch. ARS 701P2 Oracle 10g Clients (many old 5.1.2v1348), moving to 701P3 Windows 2003 server Susan Palmer ShopperTrak 200 W Monroe St 11th Floor Chicago, IL 60606 Office: 312-529-5325 Cell: 312-502-7687 [EMAIL PROTECTED] __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
