Improve company productivity with a Business Account.Sign Up

x
?
Solved

Crystal Reports XI R2 - Can we relative position two cells?

Posted on 2011-09-16
2
Medium Priority
?
587 Views
Last Modified: 2012-05-12
Hi,
   I have a report, which has address fields, placed below one another.  
   Can i relatively position these address these cell fields so that if the top one has no address, then that cell will show "no addess found" and the below address will move up, to avoid the white space?

 Basically, the underlying issue is with the white space on a report.
My report is like a "Form".
If there is no data in some of the fields, then the below cells should be moved up and the the white space should be avoided. Is this possible?

Please advise.
 
0
Comment
Question by:pvsbandi
2 Comments
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 total points
ID: 36552956
Crystal doesn't work that way.

However there are ways to get what you want.

Are these fields in a single record or does someone with 2 addresses have 2 records?

If this is a multifield address then
One way to handle this is through a formula

Local StringVar strAddress;
strAddress := ""

If Not IsNull({Addresfield1}) then
     strAddress := {Addresfield1};

If Not  IsNull({Addresfield2}) then
   If  strAddress = "" then
        strAddress := {Addresfield2}
Else
     strAddress := strAddress  & chr(13) & {Addresfield1};

etc for each field in the address.

Drop this on the report making it 1 "row" tall.  
You can format it to grow so it can handle the extra lines.

mlmcc
0
 

Author Closing Comment

by:pvsbandi
ID: 36553921
that seems an excellent solution to my problem! I'll try it out.

Thanks so much for the help!
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Watch the video to learn how one can deal with PST file corruption issue with an outstanding Kernel for Outlook PST Repair Tool easily. Using this tool, non-technical users can swiftly perform the repair process to restore their essential data witho…
Watch the software video of Kernel Import PST to Office 365 tools which can easily import PST and OST files to Office 365 for bulk mailboxes. The process of migration is simple and user can map source and destination mailboxes and easily import data…

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question