How do i Supress a record in sub-report when main report record equals

[satyakumar]

Guys,

I have a main report and a subreport. In the main report i am getting a date value also in the subreport i am getting a date value.

My question is that the user want to suprress the date in the sub report if the date in the main report equals to sub report date.
Also if the date in the subreport and main report equals they want me to get the previous latest date from the sub report.

how do i need to handle it. Please let me know ASAP.

 

[lbass]

Add a subreport link on the date field. Then in the subreport, go to report->selection formula->record and change the formula to:

{subreport.date} < {?pm-main.date}

Then still in the sub, go to report->selection formula->GROUP and enter:

{subreport.date} = maximum({subreport.date})

This assumes that the subreport is also linked on the group field that corresponds to the section it is located in in the main report.

-LB

 

[satyakumar]

Hi,

It seems not working. Can you suggest something.

 

[lbass]

You need to be more specific about the results you are getting and explain how they are different from what you expect.

Also, please go into the subreport->selection formula->record and copy the formula into the thread. Repeat for the group selection formula.

-LB

 

[satyakumar]

The result i am getting is same as the original previous one.

In the sub report selection formulae --record level i have written

{BE_CUR_Employee.Anticipated Term Date} = {?Pm-BE_Employee.Anticipated Term Date}

in the group selection formulae i have written

{BE_CUR_Employee.Anticipated Term Date} = maximum ({BE_CUR_Employee.Anticipated Term Date})

also i have attached the report in the gmail.

gmail user id is: kirankumar6767
Password: zxascvdf

 

[satyakumar]

sorry Bro,

I put = instead of <

I changed it, Worked fine. Thanks for the quick reply..