Skip to Content
author's profile photo Former Member
Former Member

how to upload database tab(ztable) before executing of report

hi all,

I have developed a report , in which i have a check box in selection screen, when ever i check this and give inputs to report(year, period), upto that year and period , the database table(ztable), have to be updated (the data is inturn fetched from standarad database table and inserted into my ztable)and that results from the ztable are selected in report.Can any one help me where i shoud write code for this(is it in at selection screen) or not.what commands i have to use to achieve this. Can any one suggest me how to do this, if possible with a sample code

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Mar 22, 2008 at 03:26 AM

    Kiran,

    In your report first select the data from the standard table and update the ztable and then display the output fetched from the ztable.

    I guess the selection criteria that you are using for fetching from the standard table and selection criteria that you intend to fetch from the ztable for displaying the output are the same.If it is not then do the filtering in the program as per your need and then display the output.

    By the way I didn't get why you need a ztable when already the data is available in the standard table.

    K.Kiran.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      the report which i develop, has to fetch a large amount of data, from the database, for example when i enter the current year then it has to fetch the data upto current year and period since inception, which will time out. to avoid it, i placed a ztable, where i shall first update based on upto which year and period the user want the data, and then data has to be displayed in report. but my doubt here is how to write code, when i just keep the tick to the check box in report, the data has to updated into ztable from database until that year and period.my doubt is how to write the code, which commands i have to use here,because every thing has to be done in background(the uodating of ztable), then repotind data has to be displayed

  • author's profile photo Former Member
    Former Member
    Posted on Mar 23, 2008 at 04:26 PM

    hi

    i'm not sure .this code may be helpful.check it out once

    at selection

    parameters:

    check type c as checkbox

    at selection-screen on check

    if check = 'X'

    update values into ztable

    endif.

    here we check the date & year entered r not ok

    this is logic will be helpful to u

    Edited by: ravi kumar on Mar 24, 2008 5:50 PM

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.