on 07-25-2012 9:45 AM
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
Hi Sunil&Amith ,
thanks a lot for your valuable reply . actually my database is SQL . the requirement is like this below
Req :
Ex: DATA
| |||||||||||||||||||||||
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 must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
| |||||||||||||||||||||||
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
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
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 | |||
emp | date | before | ofter |
1001 | 01-07-2008 | 1307206 | 1307206 |
1001 | 10-06-2008 | 1216206 | 1216206 |
1001 | 04-01-2009 | 1216206 | |
1001 | 02-03-2010 | 1216206 | |
1001 | 09-02-2010 | 1216206 | |
1001 | 01-12-2011 | 1216206 | |
1001 | 04-08-2011 | 1216206 | |
1001 | 04/28/2011 | 1216206 | |
1001 | 08-03-2011 | 111999 | 111999 |
1001 | 03/13/2012 | 128999 | 128999 |
1001 | 04-04-2012 | 155999 |
but i want to see output like below (only these records reaming hide/remove) :
1001 | 08-03-2011 | 111999 | 111999 |
1001 | 03/13/2012 | 128999 | 128999 |
please find the solution .
Regards
Durgasaiprasad.Y
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
DurgaPrasad,
Looks like your are missing some imp logic part.
out of these last records
1001 | 08-03-2011 | 111999 | 111999 |
1001 | 03/13/2012 | 128999 | 128999 |
1001 | 04-04-2012 | 155999 |
Why you need only 2 records
1001 | 08-03-2011 | 111999 | 111999 |
1001 | 03/13/2012 | 128999 | 128999 |
Do you want recent 2 records by date?
if yes, you will get these 2 records
1001 | 03/13/2012 | 128999 | 128999 |
1001 | 04-04-2012 | 155999 |
regards
Sunil
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
Hi Sunil&Amith ,
thanks a lot for your valuable reply . actually my database is SQL . the requirement is like this below
Req :
Ex: DATA
| |||||||||||||||||||||||
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 must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Durgaprasad,
Do you want to show result with selected begin date followed with previous one record or all records?
Regards,
-Amit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.