Skip to Content

WebI prompt before data

Hi Experts ,

i have a report like personno , begindate ,end date , entereddate , costcenter.

prompt on begin date if user select begin date. the out put should be shown as per user prompt dates and as well as before 1 record also

for ex: prompt on begin date 02/27/2012 the out put should be as below. means before (COST CENTER) record also how do this. plz ASAP.

ex:

person begin date end date cost center entered date

600 07/18/2011 02/26/2012 125410 08-03-2011 6500 02/27/2012 03/25/2012 1645784 03/13/2012

thank a lot in advance.

Regards

Durgaprasad.Y

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Jul 27, 2012 at 06:52 AM

    Hi Sunil&Amith ,

    thanks a lot for your valuable reply . actually my database is SQL . the requirement is like this below

    Req :

    Ex: DATA

    ENTERED DATE

    emp

    salary

    emp group

    01-01-2012

    1

    10000

    IT

    02-01-2012

    1

    15000

    IT

    03-01-2012

    1

    15000

    TL

    01-01-2012

    2

    20000

    IT

    IF prompt on ENTERED DATE between 01/01/2012 to 03/01/2012 . the output should be

    Change Date

    salary

    Emp group

    Before

    After

    Before

    After

    02/01/2012

    10000

    15000

    -----

    -------

    03/01/2012

    -----

    -----------------

    IT

    TL

    Based on user selection range the data will be shown only those salary or employ group change data only will be shown other data (witch means those who are not change emp group orsalary(Between that user input dates) ) not required please help out . ASAP

    I Really thankful to all.

    Regards

    Durgaprasad.Y

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 27, 2012 at 06:06 AM

    Hi Durgaprasad,

    Do you want to show result with selected begin date followed with previous one record or all records?

    Regards,

    -Amit

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 27, 2012 at 06:52 AM

    Hi Sunil&Amith ,

    thanks a lot for your valuable reply . actually my database is SQL . the requirement is like this below

    Req :

    Ex: DATA

    ENTERED DATE

    emp

    salary

    emp group

    01-01-2012

    1

    10000

    IT

    02-01-2012

    1

    15000

    IT

    03-01-2012

    1

    15000

    TL

    01-01-2012

    2

    20000

    IT

    IF prompt on ENTERED DATE between 01/01/2012 to 03/01/2012 . the output should be

    Change Date

    salary

    Emp group

    Before

    After

    Before

    After

    02/01/2012

    10000

    15000

    -----

    -------

    03/01/2012

    -----

    -----------------

    IT

    TL

    Based on user selection range the data will be shown only those salary or employ group change data only will be shown other data (witch means those who are not change emp group orsalary(Between that user input dates) ) not required please help out . ASAP

    I Really thankful to all.

    Regards

    Durgaprasad.Y

    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.