cancel
Showing results for 
Search instead for 
Did you mean: 

WebI prompt before data

former_member309630
Active Participant
0 Kudos

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 

60007/18/201102/26/201212541008-03-2011
650002/27/201203/25/2012164578403/13/2012

thank a lot in advance.

Regards

Durgaprasad.Y

Accepted Solutions (1)

Accepted Solutions (1)

former_member309630
Active Participant
0 Kudos

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

Former Member
0 Kudos

Hi Durgaprasad,

1. Place your date field under query filters

2. change logical operator to "Between"

3. change choose value type to prompt.

4. Run the query.

Or

you can use @prompt Function at designer level for the 'entered data' object.

Regards

Sunil

Former Member
0 Kudos

Hi Durgaprasad,

I hope u are now clear with how to set prompts to your report according to requirements(Sunil has explained well)...

So,now I am proceeding for your output part

Durgasaiprasad Yelluri wrote:

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

You need to use required variable with following formula

= If (Previous([Object])<>[Object]) Then([Object]) Else("---------")

Hope this will help you.....

Reply, if still you have any issues

Regards,

-Amit

former_member309630
Active Participant
0 Kudos

Hi Sunil ,

ThankS for reply . actually they already putted prompt on date that as u said like that means between prompt .if they are selected between dates inthat bet ween dates we want get all the data bet ween user selected dates but my question is

if

Prompt on  01-01-2012 to 01-08-2012 normally it showing below data

ex:   data

DATE

emp

salary

emp group

01-01-2012

1

10000

IT

01-02-2012

1

10000

IT

01-03-2012

1

10000

TL

01-04-2012

1

10000

TL

01-05-2012

1

10000

TL

01-06-2012

1

10000

TL

01-07-2012

1

30000

TL

01-08-2012

2

25000

IT

01-01-2012

2

25000

IT

01-02-2012

2

25000

IT

01-03-2012

2

25000

IT

01-04-2012

2

25000

IT

01-05-2012

2

25000

TL

01-06-2012

2

25000

TL

01-07-2012

2

25000

TL

01-08-2012

2

40000

TL

but my user wants those who are get  salary hike  and those who are change their emp group that particular record only  it will show in the out put. and what their salary/emp group in before It means witch i mention in bold letters data  and that above/previous data.

witch means the out put should be shown as below. remaining data not required

EMP

DATE

SALARY

Emp group

Before

After

Before

After

1

01-07-2012

10000

30000

-----

-------

1

01-03-2012

-----

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

IT

TL

2

01-05-2012

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

----------

IT

TL

2

01-08-2012

25000

40000

----

--------

They want to see out put who are the employees get hike/ change emp group and whats is their present salary/emp group (after) and whats their previous salary/emp group(Before) 

Regards

Durgaprasad.Y

former_member309630
Active Participant
0 Kudos

Hi Amith ,

Thank you very much for reply . what ever you said the function is almost correct but . i need some more modifications on this formula . actually i got out put like this

                                       
                     salary
empdatebeforeofter
100101-07-200813072061307206
100110-06-200812162061216206
100104-01-20091216206
100102-03-20101216206
100109-02-20101216206
100101-12-20111216206
100104-08-20111216206
100104/28/20111216206
100108-03-2011111999111999
100103/13/2012128999128999
100104-04-2012155999

but i want to see output like below (only these records reaming hide/remove) :

100108-03-2011111999111999
100103/13/2012128999128999

please find the solution .

Regards

Durgasaiprasad.Y

former_member309630
Active Participant
0 Kudos

Hi Amith ,

Please help me .may be the problem with my formula please correct it my formula i write like this

= If (Previous([Object])<>[Object]) Then([Object]) ;0)                        

and also i try with this formula

= If (Previous([Object])<>[Object]) Then([Object]) )

please help .

I am Really thankful to you.

Regards

Durgaprasad.Y

Former Member
0 Kudos

DurgaPrasad,

Looks like your are missing some imp logic part.

out of these last records

100108-03-2011111999111999
100103/13/2012128999128999
100104-04-2012155999

Why you need only 2 records

100108-03-2011111999111999
100103/13/2012128999128999

Do you want recent 2 records by date?

if yes, you will get these 2 records

100103/13/2012128999128999
100104-04-2012155999

regards

Sunil

former_member309630
Active Participant
0 Kudos

Hi Sunil ,

Sorry i could't find this .. yes what ever u said is right . please help me  how to get these 2 records only . but not by date based on emp salary and what he is getting salary after hike   and what is the salary  before he got the hike . means if his salary is jan to nov 10000 per every month and dec he got a hike  12000 means if user runs a report between jan to dec the output showing jan 10000 feb 10000......nov 10000 and dec 12000 means total 12 records  but he  want to see only  dec 12000 and nov 10000 like below

                           salary

date              previous    after

  nov            10000      10000

  dec           10000       12000    other wise  

   dec          10000      20000  this record

Regards

Durgaprasad.Y

Former Member
0 Kudos

Hi Durgaprasad,

Your issue can be resolved with the help of RelativeValue()

Please, use proper parameters to get your expected output...........

Regards,

-Amit

Answers (2)

Answers (2)

former_member309630
Active Participant
0 Kudos

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

Former Member
0 Kudos

Hi Durgaprasad,

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

Regards,

-Amit