Results 1 to 11 of 11

Thread: Crystal Reports - ODBC error: Invalid Parameter number

  1. Oct 23rd, 2002, 04:52 PM #1
    JohnSmith
    JohnSmith is offline

    Thread Starter
    Fanatic Member
    Join Date
    Feb 2002
    Location
    Hampton Beach
    Posts
    513

    Question Crystal Reports - ODBC error: Invalid Parameter number

    I am connecting to two backends. One backend is a ODBC data source and the second is a Access database on my local PC. When I run the report I get the error Invalid Parameter number. The only parameter fields I have are dates. In my odbc I am connecting to a date\time field and in the Access database the data shows as date only. I do not know if this is the cause or not?

    I am using a Subreport (connects to Access database) and the ODBC connects on the Main report...

    Any help is greatly appreciated!!!

    Johnny
    Reply With Quote Reply With Quote
  2. Oct 23rd, 2002, 04:59 PM #2
    MartinLiss
    MartinLiss is offline
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,431
    I copied your post to this new forum. You are the first post
    Tips, Examples & Tutorials:
    A valuable forum tool • Generate unique TreeView keys • TreeView with "open" and "closed folder" icons • Time code using GetTickCount • How to trap the Tab key • Scroll a form • NumberBox ActiveX control • Color a ListView row • An InputBox form • How to use SaveSetting and GetSetting • A program registration scheme • Spellcheck a Textbox • Resize controls • Open Windows Explorer at Last Visited Path • A Blackjack Game • Count lines of code • Private Message Viewer • Copy/Paste VB Code • Paste VB Code Add-In • Insert Procedure Names Add-In • A calculator for the game of Spider • My review of REALbasic 2008 • VB6 Debug Tutorial • Picture/Video Viewer • VBF Photo Contest Winners


    2009 - 2016
    Reply With Quote Reply With Quote
  3. Oct 23rd, 2002, 07:26 PM #3
    glyptar
    glyptar is offline
    Addicted Member glyptar's Avatar
    Join Date
    Sep 2002
    Location
    The Netherlands
    Posts
    138
    and it will never be answered since noone will come here
    Glyptar
    Reply With Quote Reply With Quote
  4. Oct 23rd, 2002, 07:48 PM #4
    MartinLiss
    MartinLiss is offline
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,431
    Originally posted by glyptar
    and it will never be answered since noone will come here
    You just proved yourself wrong, but that's no surprise.
    Tips, Examples & Tutorials:
    A valuable forum tool • Generate unique TreeView keys • TreeView with "open" and "closed folder" icons • Time code using GetTickCount • How to trap the Tab key • Scroll a form • NumberBox ActiveX control • Color a ListView row • An InputBox form • How to use SaveSetting and GetSetting • A program registration scheme • Spellcheck a Textbox • Resize controls • Open Windows Explorer at Last Visited Path • A Blackjack Game • Count lines of code • Private Message Viewer • Copy/Paste VB Code • Paste VB Code Add-In • Insert Procedure Names Add-In • A calculator for the game of Spider • My review of REALbasic 2008 • VB6 Debug Tutorial • Picture/Video Viewer • VBF Photo Contest Winners


    2009 - 2016
    Reply With Quote Reply With Quote
  6. Oct 24th, 2002, 01:45 AM #5
    pnish
    pnish is offline
    Frenzied Member pnish's Avatar
    Join Date
    Aug 2002
    Location
    Tassie, Oz
    Posts
    1,918
    What form is your ODBC data source? Is it a table or a query? If it's a query, perhaps it's expecting one or more parameters to be passed to it.

    Just a thought. I don't think the date/time fields are causing the problem.

    Try creating a new report using the ODBC data source only and see if you get the same errors. This may help narrow down the problem area.
    Reply With Quote Reply With Quote
  7. Oct 24th, 2002, 02:48 AM #6
    swatty
    swatty is offline
    Frenzied Member swatty's Avatar
    Join Date
    Aug 2002
    Location
    somewhere on earth
    Posts
    1,478
    Same here don't think the error is caused by the report.

    Try to put the query in the query designer, bet you'll get the same error.
    Code:
    If Question = Incomplete Then
   AnswerNextOne
Else
   ReplyIfKnown
End If
    cu Swatty
    Reply With Quote Reply With Quote
  8. Oct 24th, 2002, 07:38 AM #7
    Joffies
    Joffies is offline
    Lively Member Joffies's Avatar
    Join Date
    Aug 2002
    Location
    London
    Posts
    119

    How ?

    Are you just running the report through crystal or are you calling the report though another application ?
    Do, or do not. There is no 'try'.
    Reply With Quote Reply With Quote
  9. Oct 24th, 2002, 07:39 AM #8
    JohnSmith
    JohnSmith is offline

    Thread Starter
    Fanatic Member
    Join Date
    Feb 2002
    Location
    Hampton Beach
    Posts
    513
    I am running the report from Crystal reports itself..
    Reply With Quote Reply With Quote
  11. Oct 24th, 2002, 07:46 AM #9
    Joffies
    Joffies is offline
    Lively Member Joffies's Avatar
    Join Date
    Aug 2002
    Location
    London
    Posts
    119

    Lets see

    Have Tried running the main report wihtout the subreport ? Do that so if it works you can narrow it down to where the problem might be. Try and use the same field type parameter as to the field in your database. There could be lots of problems like your linking etc.

    Sometimes Crystal doesn't allow to set up a parameter with a date type field in your selection expert. What you need to do then is the following

    1. Create a parameter using the Date/Time type.
    2. Select the parameter in your selection expert.
    3. Now go back and edit the parameter and change the type to just Date.


    Hope this helps.
    Do, or do not. There is no 'try'.
    Reply With Quote Reply With Quote
  12. Nov 26th, 2008, 06:36 AM #10
    bonave
    bonave is offline
    New Member
    Join Date
    Jul 2008
    Posts
    5

    Re: Crystal Reports - ODBC error: Invalid Parameter number

    here is the help for passing date parameter to crystal reports:

    http://vb.net-informations.com/cryst...meter_date.htm

    bonave.
    Reply With Quote Reply With Quote
  13. Nov 26th, 2008, 10:54 AM #11
    jggtz
    jggtz is offline
    Frenzied Member
    Join Date
    May 2006
    Location
    some place in the cloud
    Posts
    1,886

    Re: Crystal Reports - ODBC error: Invalid Parameter number

    You really started from the beginning !
    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