Results 1 to 3 of 3

Thread: DataReport Questions

Hybrid View

  1. #1

    Thread Starter
    Addicted Member rpk_20061975's Avatar
    Join Date
    Jun 2001
    Location
    India
    Posts
    234

    DataReport Questions

    I have 3 questions:

    (1) I want to display an animation when the user clicks the "Print"
    button of the DataReport. The animation is displayed in a different
    form.

    (2) I want the DataReport window to automatically close when the printing of all the pages has finished. How to do so?

    (3) I want to send certain calculated values in a function to the
    DataReport without using Database method. How to do so?

  2. #2
    Addicted Member
    Join Date
    Mar 2005
    Posts
    174

    Re: DataReport Questions

    I want to display an animation when the user clicks the "Print"
    button of the DataReport. The animation is displayed in a different
    form
    .

    Try the following code:

    form1.show
    unload datareport1

    and in the activate event of form1 enter the codes for the animatin part.



    I want the DataReport window to automatically close when the printing of all the pages has finished. How to do so?
    Try the following code:

    unload datareport1

    I want to send certain calculated values in a function to the
    DataReport without using Database method. How to do so?
    calculate the values and store them in a variable(say var1)
    suppose you want to print that value in the details part of the datareport which is the section 3 normally.
    try using this function:


    Function formatLabel(lblX as rptLabel,caption as string)
    with lblX
    .Caption=caption
    end with
    end function

    call this function in the event where you are opening the datareport in the following form:

    formatlabel datareport1.sections(3).controls(control name), var1
    datareport1.show

    instead of control name you can call the control number in that section. The control number is automatically generated serially when you place the control in the datareport section. For each section the control starts from 1.

  3. #3
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263

    Re: DataReport Questions

    jobs_arghya - are you the person who e-mailed me about DataReport issues over the weekend?

    Where is the thread that you referred to in your second e-mail to me?

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:
    [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008

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