parameter query in datareport

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • RAM28079
    New Member
    • Mar 2008
    • 3

    parameter query in datareport

    i created a dataenvironment command with 2 query parameters which were received from the user through form.
    one for numeric datatype and another for a string datatype.
    when i call the report using the commnd it gives an error as....
    parameter object is improperly defined.Inconsi stent or incomplete information was provided with run time error no as
    2147220992(8004 0200)

    i have defined them as numeric and string datatype in the parameter properly.
    kindly help me in solving the problem pls
  • creative1
    Contributor
    • Sep 2007
    • 274

    #2
    Originally posted by RAM28079
    i created a dataenvironment command with 2 query parameters which were received from the user through form.
    one for numeric datatype and another for a string datatype.
    when i call the report using the commnd it gives an error as....
    parameter object is improperly defined.Inconsi stent or incomplete information was provided with run time error no as
    2147220992(8004 0200)

    i have defined them as numeric and string datatype in the parameter properly.
    kindly help me in solving the problem pls
    How do you pass these parameters? query?

    Comment

    • RAM28079
      New Member
      • Mar 2008
      • 3

      #3
      Originally posted by creative1
      How do you pass these parameters? query?
      hai ..
      good morning...

      here is the coding for passing the parametrer for the query
      the following codes are called as click event of a commd button on a form

      dim param1 as double
      dim param2 as string
      param1=inputbox ("Enter the first number value")
      param2=inputbox ("Enter the string value")
      dataenviroment1 .command param1,param2
      datareport1.sho w

      pl reply

      thanks in advance
      Last edited by RAM28079; Mar 8 '08, 03:14 AM. Reason: to say hello

      Comment

      • QVeen72
        Recognized Expert Top Contributor
        • Oct 2006
        • 1445

        #4
        Hi,

        Check the Order of the parameters, may be you need to pass in the reverse order..?

        param2 and Param1

        Regards
        Veena

        Comment

        Working...