How to get the same line of data in a subreport

[maas]

Hello All,

I am having a problem while developing this report. In my report these are the fieldsL
Deal No, Amount, Price, Type, Settle date, Deal Date, Total Value (E.x):
123, 121212, 22.2, AAA, 12-Dec-2009, 23-Dec-2010, 12321
124, 125885, 23.2, BBB, 1-Jan-2010, 23-May-2010, 454544

My condition is that if the settle date = 1-Jan-2010 and Deal Date > 1-Jan-2010, then create the same line again becauseI need to get all of them and convert the amounts into negative values as per the user requirement.

124, 125885, 23.2, BBB, 1-Jan-2010, 23-May-2010, So how to do that in a subreport? Do, I have to make them all as shared? Or I have to create the same report again and filter? What is the proper way to do that?

Thanks

 

[fisheromacse]

i may be misunderstanding, but ...
could you place the fields you need in a second details section (ie: details b) and then use suppression formula to only show the details b when your criteria are met.

 

[maas]

The result which I am looking for is:
124, 125885, 23.2, BBB, 1-Jan-2010, 23-May-2010, 454544

Do you mean that I have to replicate again the whole columns in details B?

 

[fisheromacse]

yes, if i am understanding your needs, put all the fields in another details section and then suppress that section and only show it if your suppression criteria are not met.

If you need to transform any of the values, use formulas in place of the fields.

so...in your section suppression x+1 formula you would put:
{table.settle date} <> 1-Jan-2010
and
{table.Deal Date} < 1-Jan-2010

which results in the detail section only being displayed if the settle date = 1-Jan-2010 and the deal date is greater than 1-Jan-2010.