X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> How to Remove Blank Lines in a Report    
 
   
sabboud1
post Jan 5 2010, 11:00 AM
Post #1

New Member
Posts: 14



I was wondering how to remove blank spaces from my report. The report is showing gaps in the report where I'm grouping data.
eport Example:
200 - Lot Costs
Original Estimate
Actual Cost
(I need to remove the extra lines between Original Estimate and Actual Costs)
How the report is Designed:
Group - Item Number
Group - Original Estimate
Detail - Actual Costs
The report is based off a union query where each line as an item assigned, but not an original estimate, so I'm guessing this has some impact. Any help would be appreciated.
Go to the top of the page
 
+
datAdrenaline
post Jan 5 2010, 11:06 AM
Post #2

UtterAccess Editor
Posts: 16,812
From: Northern Virginia, USA



Check out the Can Grow and Can Shrink properties for the controls and sections involved. The Can Shrink should be set to True ...
Go to the top of the page
 
+
sabboud1
post Jan 5 2010, 11:16 AM
Post #3

New Member
Posts: 14



I did prevously try that so I have can shrink set to true. One thing I did notice is that on the report I usually delete the text box label. If I leave the text box label on I see two text box labels. One has the value and the other is blank.
For example:
Original Estimate: $500.00
Original Estimate:
Thanks for all your help!
Go to the top of the page
 
+
datAdrenaline
post Jan 5 2010, 12:12 PM
Post #4

UtterAccess Editor
Posts: 16,812
From: Northern Virginia, USA



Many times when I want to have a label for the value in the fashion you have shown, I create an unbound text box with an appropriate name (ie: txtOriginalEstimate), then I set the Control Source property to something like this:
"Original Estimate:" + [Original Estimate]
By using the (+) operator to concatenate text, Nulls are propogated in VBA, then the Can Shrink property will shrink the control when the field is Null.
Go to the top of the page
 
+
sabboud1
post Jan 5 2010, 12:59 PM
Post #5

New Member
Posts: 14



I tried that and I still get the null values. Is there a way to maybe use the iif function to say if the value is null discard the value to shrink the space?
Thanks.
Go to the top of the page
 
+
Bob_L
post Jan 5 2010, 01:11 PM
Post #6

Utterly Banned
Posts: 7,038



You may have missed the part where Brent said, to also make sure that the sections involved have their Can Grow and Can Shrink properties set to YES. So, if you haven't done so, go select the DETAILS SECTION and also set the properties for that (as well as each control needing to have the Can Grow/Can Shrink property set).
Go to the top of the page
 
+
sabboud1
post Jan 5 2010, 01:19 PM
Post #7

New Member
Posts: 14



Thanks, I went ahead and set everything I could to can grow/shrink. I still have the same issue.
Go to the top of the page
 
+
Bob_L
post Jan 5 2010, 01:24 PM
Post #8

Utterly Banned
Posts: 7,038



Can you post a sample of your database? (if so, make sure to go to the Big Office Button > Manage > Compact and Repair and then zip the file - right-click on it and select SEND TO > COMPRESSED FOLDER).
nce compacted and zipped the file needs to be at or below 500Kb in order to upload here.
Go to the top of the page
 
+
sabboud1
post Jan 5 2010, 01:43 PM
Post #9

New Member
Posts: 14



Attached is the database
Attached File(s)
Attached File  Database1.zip ( 17.06K ) Number of downloads: 6
 
Go to the top of the page
 
+
Bob_L
post Jan 5 2010, 01:50 PM
Post #10

Utterly Banned
Posts: 7,038



Well, we seem to have another problem. You are using linked Excel spreadsheet and did not include that. We will need that as well so we can actually run the report.
Go to the top of the page
 
+
datAdrenaline
post Jan 5 2010, 02:08 PM
Post #11

UtterAccess Editor
Posts: 16,812
From: Northern Virginia, USA



>> I tried that and I still get the null values. <<
Are you sure they are Null ... could they be Zero Length Strings? ...
Try an expression like this:
=IIf(Len([Original Estimate] & "") > 0, "Original Estimate: " & [Original Estimate], Null)
Go to the top of the page
 
+
sabboud1
post Jan 5 2010, 02:15 PM
Post #12

New Member
Posts: 14



Excel File 1 of 2
Attached File(s)
Attached File  1800 Estimate.zip ( 8.09K ) Number of downloads: 3
 
Go to the top of the page
 
+
sabboud1
post Jan 5 2010, 02:16 PM
Post #13

New Member
Posts: 14



Excel file 2 of 2
Attached File(s)
Attached File  1800 Job Cost.zip ( 24.25K ) Number of downloads: 2
 
Go to the top of the page
 
+
Bob_L
post Jan 5 2010, 02:24 PM
Post #14

Utterly Banned
Posts: 7,038



The problem is your label (and your footer for the Item) and the sizing of the other control.
See attached (you'll have to use Linked Table Manager to link back to your original Excel files).
Attached File(s)
Attached File  Database1_revBL.zip ( 16.68K ) Number of downloads: 3
 
Go to the top of the page
 
+
sabboud1
post Jan 5 2010, 02:29 PM
Post #15

New Member
Posts: 14



I tried that and it still gave me the same result:
riginal Estimate: $600.00
Original Estimate:
Thanks for all your help.
Go to the top of the page
 
+
Bob_L
post Jan 5 2010, 02:33 PM
Post #16

Utterly Banned
Posts: 7,038



Which record are you seeing that on? I'm not seeing it. I all records having
CODE
Original Estimate                             Original-23434
Go to the top of the page
 
+
sabboud1
post Jan 5 2010, 02:37 PM
Post #17

New Member
Posts: 14



Thanks a million Bob. That worked perfectly. How exactly did you get it to work. Was it formatting in the propties that you adjusted.
Thanks, Scott
Go to the top of the page
 
+
Bob_L
post Jan 5 2010, 02:44 PM
Post #18

Utterly Banned
Posts: 7,038



It was first getting rid of the TEXT43 label that was there. Then I got rid of the ITEMS FOOTER that didn't have anything in there. And then third, I made the size of the OriginalEstimate box the same size as the other text box that was on the same line and moved the spacing up a bit tighter.
Go to the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Search  ·  Go to Top  ·  Lo-Fi Version Time is now: 20th December 2014 - 10:18 PM