Results 1 to 5 of 5

Thread: [RESOLVED] An addendum to a preivous post - Parameter Prompt!

  1. #1

    Thread Starter
    PowerPoster
    Join Date
    Jan 2004
    Location
    Southern California
    Posts
    5,034

    Resolved [RESOLVED] An addendum to a preivous post - Parameter Prompt!

    I have tried everything I can think of, searched the net far and wide and found no answers to eliminate the "Parameter Prompt" for a Crystal Report. So, I was wondering this:

    I have a main report that has 2 parameters. This report has 3 subreports with the exact same parameters.

    Is it possible to remove the parameters from the main report and pass the values into the main report via a SelectionFormula coded in the VB app and then move these values into the subreport parameters?

    If this is possible, can someone show me how to do it in the CR IDE?

    Thanks,
    Blake

  2. #2
    Hyperactive Member
    Join Date
    Jul 2007
    Posts
    479

    Re: An addendum to a preivous post - Parameter Prompt!

    Normally I use the Edit, Subreport Links option to link the parameters in the main form to the same parameters copied to the subreport. Do this for each of the subreports. Then you can pass the values to the paramaters to the main form and then the report will carry it forward.

    Hope this helps

  3. #3

    Thread Starter
    PowerPoster
    Join Date
    Jan 2004
    Location
    Southern California
    Posts
    5,034

    Re: An addendum to a preivous post - Parameter Prompt!

    I think I already do this. I'm in my subreport...I right click on a parameter from the field explorer list and select "Edit". Is that what you mean. But I don't see any option on the "Edit" form that does any linking to the main report.

    Or do you mean right-clicking on a subreport from the main report and using the "Change Subreport Links" option?
    Blake

  4. #4
    Hyperactive Member
    Join Date
    Jul 2007
    Posts
    479

    Re: An addendum to a preivous post - Parameter Prompt!

    Try the actual Edit Menu from the Main Report either in Design or Preview modes.

  5. #5

    Thread Starter
    PowerPoster
    Join Date
    Jan 2004
    Location
    Southern California
    Posts
    5,034

    Re: An addendum to a preivous post - Parameter Prompt!

    Rasinc,

    I have resolved this problem by taking a completely different approach. These 3 subreports were driven by Stored Procedures (1 for each report). So, iInstead of using parameters I created a dynamic dataset as a result of each SP and created a Datasource XSD and then made the datasets the actual datasource for each report. That solved the problem.
    Blake

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width