Skip to Content
author's profile photo Former Member
Former Member

Lines placed one above another will not appear at same position in report

In my crystal report i have placed 5 horizontal lines in a detail section one above another.The line will has suppress condition based on a value of particular column from a database.(I have made the lines to print in such a way that when report has 5 columns the line with less width appear and when 6 columns line higher width appears and so on.). So only difference between them is line width(which varies) according to me. But in report the for different samples, i observed that line is not at same position and it is little bit varies in y position. In crystal report preview i observed the report and found that some lines take large width while some other less in report. So why this happens even though i have placed line one above another? Please help

Please download sample files Here.

RPT files are 10.rpt and 11.rpt .(Both rpt files are same. I just used it to show difference by keeping both rpt files open so to get the difference i am getting)

Set the database location for 10.rpt to table "10" of "Template.mdb"

Set the database location for 11.rpt to table "11" of "Template.mdb"

Now you can see the difference which i was describing above.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 07, 2014 at 06:21 AM

    Hey i had set Can grow property of those objects to true. When i unchecked the checkbox for all the objects having lines my problem solved. So what was really happening when i set the can grow property? Is there any problem if i not set this property?

    Add a comment
    10|10000 characters needed characters exceeded

    • this would probably be considered a bug. in earlier versions there was one issue that i know of where text objects would move from a manually entered postion. this issue however differs. as this is an old version of crystal there will most likely not be any patches available for it. i searched scn for older versions and couldn't find anything. websmp only has the currently supported versions. you could always put a question to here. perhaps Ludek would know.

  • Posted on Jan 03, 2014 at 06:26 PM

    hi IT researcher,

    if you've got a later version of crystal, you may wish to look into using the dynamic Width property using only a single line in a single Details section. the line width is then based on your condition. this way you don't have to mess around with trying to align objects in underlayed sections.

    right click on one of your current Text Objects > choose Size & Position > go to the Width conditional formula dialogue. note that the output Width is based on twips (1440 twips per inch.)

    you can see a bit more about using this property here.

    cheers,

    jamie

    Add a comment
    10|10000 characters needed characters exceeded

    • in that case you may wish to consider using a formula as the output for the line with a box drawing character such as

      numbervar c;

      if condition A then c:= 50 else

      if condition B then c:= 60...

      replicatestring('─',c);

      this way you would only have one details section and no underlays. ensure that the formula width is already set / stretched out to the maximum width you need.

  • author's profile photo Former Member
    Former Member
    Posted on Jan 03, 2014 at 09:21 AM

    Can anyone please help me to solve this problem?

    Add a comment
    10|10000 characters needed characters exceeded

    • Jamie Wiseman Dell Stinnett-Christy

      i've seen this one as well Dell back in my tech support days for the earlier versions of crystal. if i remember correctly it was treated as a bug but i can't remember a fix / workaround for it. perhaps also try setting the grid size in File > Options > Layout to .01 which is the minimum.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.