Get Rid Of Blank Lines in Report

[Elvis72]

I have a report that rolls up multiple records into one line, BUT it still is leaving the space where they would go, is there a way to get rid of that space?

Thanks!~

 

[KenReay]

Do ypu mean. set the Detail Secition visible property to false?

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Elvis72]

No, it is like this:

Report Headers

Record 1

Duplicate Record (Which Shows Blank)

Duplicate Record (Which Shows Blank

Record 2

Record 3


What I need is to not have the blank spaces when I select hide Duplicates...OR roll up the duplicates in my query?

 

[RivetHed]

If the record is an exact duplicate just change the SQL for the record source from SELECT...... to SELECT DISTINCT.....

 

[Elvis72]

OK, the records are not exact duplicates, they have the same record number, but are from different offices. I am just wanting to show one record and have the cost rolled up.

Which it is doing, but it is showing blank spaces where the hidden records are.

Here is the SQL from the query:

SELECT [Combined Currency Converted Budget and MHR Report].As_Of, [Combined Currency Converted Budget and MHR Report].[2008 Fiscal Year Activity], [Combined Currency Converted Budget and MHR Report].[SumOfTotal Budget $ Converted], [Combined Currency Converted Budget and MHR Report].[SumOfTotal Actual $ Converted], [Combined Currency Converted Budget and MHR Report].[SumOfTotal Budget MHR], [Combined Currency Converted Budget and MHR Report].[SumOfTotal Actual MHR], [Combined Currency Converted Budget and MHR Report].[SumOfExpense Actual $ Converted], [Combined Currency Converted Budget and MHR Report].[SumOfExpense Budget $ Converted], [Combined Currency Converted Budget and MHR Report].[SumOfTotal Labor Budget $ Converted], [Combined Currency Converted Budget and MHR Report].[SumOfTotal Labor Actual $ Converted], [Process Proposals Budget and MHR Report].[Business Division], [Process Proposals Budget and MHR Report].[Cost Code FY 05], [Process Proposals Budget and MHR Report].[FY 05 BUnit], [Process Proposals Budget and MHR Report].CLIENT, [Process Proposals Budget and MHR Report].DESCRIPTION, [Process Proposals Budget and MHR Report].[PROPOSAL MANAGER], [Process Proposals Budget and MHR Report].[PROSPECT STATUS], [Process Proposals Budget and MHR Report].Proposal_Budget, [Process Proposals Budget and MHR Report].Scope, [Process Proposals Budget and MHR Report].Proposal_Office, [Process Proposals Budget and MHR Report].[Date WO Opened]
FROM [Process Proposals Budget and MHR Report] LEFT JOIN [Combined Currency Converted Budget and MHR Report] ON [Process Proposals Budget and MHR Report].[Cost Code FY 05] = [Combined Currency Converted Budget and MHR Report].[Proposal No]
WHERE ((([Combined Currency Converted Budget and MHR Report].[2008 Fiscal Year Activity]) Is Not Null) AND (([Process Proposals Budget and MHR Report].[Date WO Opened]) Is Null Or ([Process Proposals Budget and MHR Report].[Date WO Opened]) Between #9/1/2007# And #8/31/2008#));

 

[KenReay]

Hi

Why not change it into an accgregate query, and sum the values, Group on the duplicate field(s)

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK