Results 1 to 4 of 4

Thread: [RESOLVED] CR Passing Parameter

  1. Mar 14th, 2006, 04:08 PM #1
    Besoup
    Besoup is offline

    Thread Starter
    Frenzied Member
    Join Date
    Nov 2001
    Location
    Mass USA
    Posts
    1,674

    Resolved [RESOLVED] CR Passing Parameter

    How would I pass a paramater to a report and display it concatinated(sp?) with more text?

    Thanks!
    Reply With Quote Reply With Quote
  2. Mar 15th, 2006, 08:11 AM #2
    Besoup
    Besoup is offline

    Thread Starter
    Frenzied Member
    Join Date
    Nov 2001
    Location
    Mass USA
    Posts
    1,674

    Re: CR Passing Parameter

    Anyone know how to do this? I think I need to create a formula field and put the parameter field in with some text... the problem is when it is being run I am getting a prompt to enter the value for the parameter field.
    Reply With Quote Reply With Quote
  3. Mar 15th, 2006, 08:42 AM #3
    GaryMazzone
    GaryMazzone is offline
    A SQL Server fool GaryMazzone's Avatar
    Join Date
    Aug 2005
    Location
    Dover,NH
    Posts
    7,493

    Re: CR Passing Parameter

    What version of CR?
    Sometimes the Programmer
    Sometimes the DBA

    Mazz1
    Reply With Quote Reply With Quote
  4. Mar 15th, 2006, 08:57 AM #4
    Besoup
    Besoup is offline

    Thread Starter
    Frenzied Member
    Join Date
    Nov 2001
    Location
    Mass USA
    Posts
    1,674

    Re: CR Passing Parameter

    CR 11...

    I figured it out. I had a "On Error Resume Next" in my sub. I commented it out and found that there was a type mismatch... Appearently CR doesn't like date parameter fields. I ended up changed the datatype of the parameter to Text and it worked.

    Beginning to see why everyone hates CR... :P
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width