We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

Cannot delete crystal report field

Sheldon Livingston
on
Medium Priority
727 Views
Last Modified: 2012-05-06
I have a CRXI report that whenever I delete a certain fields, it screws up another section (expands it).
Pretend there are 8 lines in the page header.  When I delete a field, say from line 7, 3 lines are inserted between lines 3 and 4.  Undo puts everything back... including the unwanted field.
Comment
Watch Question

Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
When you say lines what do you eman?
Is it white space or actual lines?

If you move the report in the ide so that part is not visible do they disappear?

mlmcc
Sheldon LivingstonConsultant

Author

Commented:
By lines I meant invision that the page header is 6 centimeters tall.  You delete a field and it pops to 9 centimeters tall.
The fields will delete, it's just that they mess up the section as they are being deleted.
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
I haven't seen that.

What kind of field are you deleting?

mlmcc
Sheldon LivingstonConsultant

Author

Commented:
Just a regular field from a database table...
CERTIFIED EXPERT

Commented:
You said that "it screws up another section".  Are you deleting a field from one section and the height of a different section changes?  That's a little odd, but I could see it if maybe you were deleting a detail field and the corresponding header or summary was removed.  However, in all of those cases, if other sections changed, they would get shorter, not taller.

 The simplest thing might be if you could post your report here so that we could take a look at it.

 James
Sheldon LivingstonConsultant

Author

Commented:
The same section messes up.
How do I post the report?  Attach it?
summarybreakout.txt
CERTIFIED EXPERT

Commented:
Yep, just like that.

 You didn't say exactly which field(s) you were deleting, but I tried several and got similar results with most of them.

 The problem seems to have something to do with your horizontal guidelines.  I'm not sure what exactly.  And I think the picture (OLE Object) may also be a factor.  I don't normally use guidelines or pictures, so maybe there's some known interaction that's causing this.  Or maybe it's just CR being weird.  :-)

 I found that when I delete fields in your page heading, one or more of the horizontal guidelines above that field shifts slightly, and the gap that you referred to opens up.  I can cause the same effect by simply clicking on the second horizontal guideline in the page header section.  It shifts up slightly and a gap opens up lower in the section.

 I say that the picture may be a factor because I found that if I removed that first, then when I deleted other fields, some of the guidelines, and the fields aligned with them, might shift slightly, but I didn't get any gaps.

 Also, FWIW, I found that if I deleted one of the text fields (eg. "System"), I'd get a gap, but then if I used undo and then deleted that text field a second time, I did not get the gap the second time.  I don't know why.  Undoing and redeleting did not work on the datasource fields.  I still got gaps when I redeleted those.

 No guarantees, but I found that if I removed the horizontal guideline between "System" and "www.acesestimating.com" (just click on the guideline and drag it to the left, off of the report), I did not get any more gaps when I deleted any fields in the page header.  So, it seems like that specific guideline may be the one that's causing the trouble.


 One last thing:

 I happened to notice that you're using PrintDate and DataTime.  Presumably those should both be the same (PrintX or DataX).  I've seen this kind of thing before, which may be why I noticed it.

 James
Senior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013
Commented:
Interesting.

I had no problem deleting any field in CR2008.

In CR XI deleting fields or the guidelines caused the problem you state.
If I delete the picture/logo first then the effect is minimized.

I was able to get around it.
Right click the PAGE HEADER in the left margin
Click SECTION EXPERT
Make sure FREE FORM PLACEMENT is checked.
  With that checked apparently deleting fields doesn't affect the others or the guidelines.

mlmcc

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
CERTIFIED EXPERT

Commented:
I didn't think to mention it, but I'm using CR 10.

 FWIW, I tried mlmcc's suggestion of turning on the free form placement option for the page header section and that also seemed to eliminate the problem in CR 10.

 So, I guess you can either remove that one guideline or use free form placement to get rid of the problem.  Whichever works best for you.

 James
Sheldon LivingstonConsultant

Author

Commented:
Thank you!  I had turned off "Snap to Grid" trying to accomplish the same thing.  Your way worked!
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.