How to hide Duplicate Records in a Reports when there are sub-reports

[KLaksomuch]

Hi,

From a report Form, the user selects some criteria to narrow down the report data. So, when calling the report there is a filter.

The report, calls a query with the filter sent to it. It also has a sub-report that shows some total allocations. The detail line consists of account number, comments, prior year allocation, expenses etc.

If there is duplicate data, all fields are the exact same except for 1 field.

Example of Data
Acct. FundingSortCode
----------------------------------
2255 a
2255 c
2255 d
2255 e

This FundingSortCode is not shown on the report, but it is used in the report Form selection criteria. (i.e.: when calling the report it sends ([FundingSortCode] <> 'a') ).

The report has 2 groupings: Community Name and Project Number.

Since I can't hide the sub-report, I had to put it under the Project Number grouping.

Between each detail grouping is a line. I need to only show 1 detail line.

But, when the duplicates records, the report gets:

line
detail information
line
sub-report information
line

I need to remove the middle line, this line is the first field in the detail section. This is happening because of the dupicate records.

Any ideas?

Thanks so much.

Karen

 

[adevera]

On your query property, set the Unique Values to YES...this way you rquery will only give you unique values and no duplicates

 

[KLaksomuch]

The data is unique except for 1 field: FundingSortCode.

Acct. FundingSortCode
----------------------------------
2255 a
2255 c
2255 d
2255 e

I am not displaying the FundingSortCode on the report. But it is used in the seleciton criteria. This is my problem.

Thanks.

 

[KLaksomuch]

Can anyone offer help?

Can anyone offer any help?

 

[adevera]

I will be happy to help you...Is ther a chance you can attached your db ? Remove all confidential data...

 

[KLaksomuch]

Unfortunately, I can't attach the db. It is to complex, it links to 10 other dbs. Plus my work wouldn't allow it.