Results 1 to 13 of 13

Thread: Associate Datareport with a table at run time

  1. #1

    Thread Starter
    Lively Member rush_shri's Avatar
    Join Date
    Dec 2005
    Location
    Pune,India
    Posts
    78

    Question Associate Datareport with a table at run time

    I am making a project in which I am entering Serial no. to the records at run time. But since the project has already been started the serial no. at the time of running the datareport is not available. Rather I have to close the project and start it once again to get the serial no. for all my records.Is there any way to associate the table with datareport at run time and also how to get the field values in the datareport.

    thanks.
    Last edited by rush_shri; Dec 17th, 2005 at 12:15 AM.
    U KNOW U R INTERNET JUNKIE WHEN U CHAT WITH UR FINGERS NOT FROM MOUTH.

    U KNOW U R INTERNET JUNKIE WHEN UR SPOUSE E-MAIL U 2 CALL U 4 DINNER

    U KNOW U R INTERNET JUNKIE WHEN UR ADDRESS BEGINS WITH http:

    U KNOW U R INTERNET JUNKIE WHEN THE PROGRAM TOLD 2 U HAPPENS 2 B TV PROGRAM.

  2. #2

    Thread Starter
    Lively Member rush_shri's Avatar
    Join Date
    Dec 2005
    Location
    Pune,India
    Posts
    78

    Re: Associate Datareport with a table at run time

    anyone
    U KNOW U R INTERNET JUNKIE WHEN U CHAT WITH UR FINGERS NOT FROM MOUTH.

    U KNOW U R INTERNET JUNKIE WHEN UR SPOUSE E-MAIL U 2 CALL U 4 DINNER

    U KNOW U R INTERNET JUNKIE WHEN UR ADDRESS BEGINS WITH http:

    U KNOW U R INTERNET JUNKIE WHEN THE PROGRAM TOLD 2 U HAPPENS 2 B TV PROGRAM.

  3. #3
    Software Carpenter dee-u's Avatar
    Join Date
    Feb 2005
    Location
    Pinas
    Posts
    11,127

    Re: Associate Datareport with a table at run time

    Would you care to elaborate? How is the serial no. associated with the DataReport? Is it a field?
    Regards,


    As a gesture of gratitude please consider rating helpful posts. c",)

    Some stuffs: Mouse Hotkey | Compress file using SQL Server! | WPF - Rounded Combobox | WPF - Notify Icon and Balloon | NetVerser - a WPF chatting system

  4. #4

    Thread Starter
    Lively Member rush_shri's Avatar
    Join Date
    Dec 2005
    Location
    Pune,India
    Posts
    78

    Re: Associate Datareport with a table at run time

    Actually I have made a field for serial no. and at run time I am entering values to that field.
    U KNOW U R INTERNET JUNKIE WHEN U CHAT WITH UR FINGERS NOT FROM MOUTH.

    U KNOW U R INTERNET JUNKIE WHEN UR SPOUSE E-MAIL U 2 CALL U 4 DINNER

    U KNOW U R INTERNET JUNKIE WHEN UR ADDRESS BEGINS WITH http:

    U KNOW U R INTERNET JUNKIE WHEN THE PROGRAM TOLD 2 U HAPPENS 2 B TV PROGRAM.

  5. #5
    Software Carpenter dee-u's Avatar
    Join Date
    Feb 2005
    Location
    Pinas
    Posts
    11,127

    Re: Associate Datareport with a table at run time

    Then those newly entered serial nos. don't show and only the old ones? How are you showing the DataReport? What is its datasource? Try using a client-side cursor...
    Regards,


    As a gesture of gratitude please consider rating helpful posts. c",)

    Some stuffs: Mouse Hotkey | Compress file using SQL Server! | WPF - Rounded Combobox | WPF - Notify Icon and Balloon | NetVerser - a WPF chatting system

  6. #6

    Thread Starter
    Lively Member rush_shri's Avatar
    Join Date
    Dec 2005
    Location
    Pune,India
    Posts
    78

    Re: Associate Datareport with a table at run time

    through "datareport.show" I am showing the datareport. Can u please tell me how to take a client-side cursor.
    U KNOW U R INTERNET JUNKIE WHEN U CHAT WITH UR FINGERS NOT FROM MOUTH.

    U KNOW U R INTERNET JUNKIE WHEN UR SPOUSE E-MAIL U 2 CALL U 4 DINNER

    U KNOW U R INTERNET JUNKIE WHEN UR ADDRESS BEGINS WITH http:

    U KNOW U R INTERNET JUNKIE WHEN THE PROGRAM TOLD 2 U HAPPENS 2 B TV PROGRAM.

  7. #7

    Thread Starter
    Lively Member rush_shri's Avatar
    Join Date
    Dec 2005
    Location
    Pune,India
    Posts
    78

    Re: Associate Datareport with a table at run time

    datasource - it is taking from a query which I have given in the command of dataenvironment.
    U KNOW U R INTERNET JUNKIE WHEN U CHAT WITH UR FINGERS NOT FROM MOUTH.

    U KNOW U R INTERNET JUNKIE WHEN UR SPOUSE E-MAIL U 2 CALL U 4 DINNER

    U KNOW U R INTERNET JUNKIE WHEN UR ADDRESS BEGINS WITH http:

    U KNOW U R INTERNET JUNKIE WHEN THE PROGRAM TOLD 2 U HAPPENS 2 B TV PROGRAM.

  8. #8
    Software Carpenter dee-u's Avatar
    Join Date
    Feb 2005
    Location
    Pinas
    Posts
    11,127

    Re: Associate Datareport with a table at run time

    What datasource are you using?
    Regards,


    As a gesture of gratitude please consider rating helpful posts. c",)

    Some stuffs: Mouse Hotkey | Compress file using SQL Server! | WPF - Rounded Combobox | WPF - Notify Icon and Balloon | NetVerser - a WPF chatting system

  9. #9

    Thread Starter
    Lively Member rush_shri's Avatar
    Join Date
    Dec 2005
    Location
    Pune,India
    Posts
    78

    Re: Associate Datareport with a table at run time

    See, I am following this method.

    Firstly I have created one dataenvironment - then created one connection -and under that one command and in the properties of that command I am writing my query to take the records from the table.
    U KNOW U R INTERNET JUNKIE WHEN U CHAT WITH UR FINGERS NOT FROM MOUTH.

    U KNOW U R INTERNET JUNKIE WHEN UR SPOUSE E-MAIL U 2 CALL U 4 DINNER

    U KNOW U R INTERNET JUNKIE WHEN UR ADDRESS BEGINS WITH http:

    U KNOW U R INTERNET JUNKIE WHEN THE PROGRAM TOLD 2 U HAPPENS 2 B TV PROGRAM.

  10. #10
    Software Carpenter dee-u's Avatar
    Join Date
    Feb 2005
    Location
    Pinas
    Posts
    11,127

    Re: Associate Datareport with a table at run time

    You could try something like this...

    VB Code:
    1. DataEnvironment1.rsCommand1.Requery
    2. datareport.show
    Regards,


    As a gesture of gratitude please consider rating helpful posts. c",)

    Some stuffs: Mouse Hotkey | Compress file using SQL Server! | WPF - Rounded Combobox | WPF - Notify Icon and Balloon | NetVerser - a WPF chatting system

  11. #11

    Thread Starter
    Lively Member rush_shri's Avatar
    Join Date
    Dec 2005
    Location
    Pune,India
    Posts
    78

    Re: Associate Datareport with a table at run time

    I have just tried. Sorry, it's not working.
    U KNOW U R INTERNET JUNKIE WHEN U CHAT WITH UR FINGERS NOT FROM MOUTH.

    U KNOW U R INTERNET JUNKIE WHEN UR SPOUSE E-MAIL U 2 CALL U 4 DINNER

    U KNOW U R INTERNET JUNKIE WHEN UR ADDRESS BEGINS WITH http:

    U KNOW U R INTERNET JUNKIE WHEN THE PROGRAM TOLD 2 U HAPPENS 2 B TV PROGRAM.

  12. #12
    Software Carpenter dee-u's Avatar
    Join Date
    Feb 2005
    Location
    Pinas
    Posts
    11,127

    Re: Associate Datareport with a table at run time

    Would you post your project (zipped)?
    Regards,


    As a gesture of gratitude please consider rating helpful posts. c",)

    Some stuffs: Mouse Hotkey | Compress file using SQL Server! | WPF - Rounded Combobox | WPF - Notify Icon and Balloon | NetVerser - a WPF chatting system

  13. #13
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Associate Datareport with a table at run time

    Moved to reporting section.

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