Results 1 to 9 of 9

Thread: Datareport SQL Problem

  1. Apr 6th, 2000, 11:07 PM #1
    Andy_C
    Andy_C is offline

    Thread Starter
    New Member
    Join Date
    Apr 2000
    Posts
    8
    Hi, I have prepared a datareport in VB6, that works fine but I want to be able to alter what it shows by a user selection form.

    I have tried to change the source and various other properties before entering the report but it always reverts back to the sql statement I have placed in a design time, can anyone help?
    Reply With Quote Reply With Quote
  2. Apr 6th, 2000, 11:41 PM #2
    LG
    LG is offline
    Hyperactive Member
    Join Date
    Jun 1999
    Posts
    308
    Hi, Andy.

    Do you use DataReport1.Refresh in your code?
    Reply With Quote Reply With Quote
  3. Apr 7th, 2000, 12:56 AM #3
    Andy_C
    Andy_C is offline

    Thread Starter
    New Member
    Join Date
    Apr 2000
    Posts
    8
    Hi thanks for replying, No I have not used the data refresh option, but I have set up message boxes showing the source, I set the source with a new SQL Statement with a form before showing the report, the message box clearly shows the source has changed. I then show a message box whilst the report initalises and the source sql has changed back to what it was a design time. I have tried various different points of trying to change tje source SQL, and its starting to drive me crackers!

    I'll give the refresh a try but I thought that just aplied to the datagrids etc.
    Reply With Quote Reply With Quote
  4. Apr 10th, 2000, 04:51 AM #4
    Andy_C
    Andy_C is offline

    Thread Starter
    New Member
    Join Date
    Apr 2000
    Posts
    8
    The Refresh did not work, if anybody has got any further suggestions I would be really gratefull.
    Reply With Quote Reply With Quote
  6. Apr 10th, 2000, 04:51 AM #5
    Andy_C
    Andy_C is offline

    Thread Starter
    New Member
    Join Date
    Apr 2000
    Posts
    8
    The Refresh did not work, if anybody has got any further suggestions I would be really gratefull.
    Reply With Quote Reply With Quote
  7. Apr 10th, 2000, 04:52 AM #6
    Andy_C
    Andy_C is offline

    Thread Starter
    New Member
    Join Date
    Apr 2000
    Posts
    8
    The Refresh did not work, if anybody has got any further suggestions I would be really gratefull.
    Reply With Quote Reply With Quote
  8. Apr 10th, 2000, 07:33 AM #7
    LG
    LG is offline
    Hyperactive Member
    Join Date
    Jun 1999
    Posts
    308
    Hi, Andy.

    Can you post your SQL statement?

    Larisa
    Reply With Quote Reply With Quote
  9. Apr 10th, 2000, 10:12 PM #8
    Andy_C
    Andy_C is offline

    Thread Starter
    New Member
    Join Date
    Apr 2000
    Posts
    8
    Hi Larissa,

    Is there any way I could send you a little app showing you what I am trying to do?

    Andy
    Reply With Quote Reply With Quote
  11. Apr 10th, 2000, 11:12 PM #9
    LG
    LG is offline
    Hyperactive Member
    Join Date
    Jun 1999
    Posts
    308
    Hi, Andy. In Profile you'll find my e-mail address.
    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