Crystal Report 7 Help

I make an application using VB and Crystal Report 7.0, i want to print an invoices.

I have a problem when i print an invoices with 2 detail (record) the invoices footer position is moving up  but when the report have 5 detail (example) the invoices footer position is moving down.

So i want to put the invoices footer in a fixed position. Can you tell me about that ? Thanks.


hotbcAsked:
Who is Participating?
 
StingRaYConnect With a Mentor Commented:
Sorry, I am weak in english...
I am not sure did I understand your question properly or not.

By the way, if you want to use a constance that represent newline character like vbCrLf in VB, try this...

StringVar cpNewLine := Chr(13);

You can use "cpNewLine" in your formula.

I am amazed, why don't you use detail section to repeat them?...

and what do you mean 2detail/records and 5 detail...?...

you mean like this??

there are Table1 and Table2.
you want to list like...
Table1.R1     Table2.R1
Table1.R2     Table2.R2
                        Table2.R3
                        Table2.R4
                        Table2.R5
---------------     -----------------
Sum(Table1)  Sum(Table2)

isn't it??

0
 
syedAliFCommented:
Make sure that all the footer fields are in the page footer section of the report.
0
 
StingRaYCommented:
Try this:
-Open "Format Section" Dialog box.
-Check checkbox "Print at bottom of Page" as True.
-Enlarge Report footer (Invoice Footer) as you want.
That's all.

0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
hotbcAuthor Commented:
Adjusted points from 100 to 125
0
 
hotbcAuthor Commented:
Thanks syedAlif and StingRay i will split the points to you ...

I have another question ... can i order detail (in cystal report) to move down 1 lines ( like vbcrlf in vb ?)

so if i have 2 detail / records and 5 detail it will look like this :

  record 1          record 1      
  record 2          record 2
                    record 3
                    record 4
                    record 5  

  --------          --------
  footer            footer
0
 
gcs001Commented:
You must use Grouping in your Crystal Report to group detail lines together.
0
 
AshokKumarCommented:
Just include another details section say Details Section B by using Insert Section Below and then hide the Second Detail Section.

NOw, u can see that footer is always fixed iirespective of the number of records in details section.
0
 
hotbcAuthor Commented:
Thanks guy i already request community support to split point. Thanks for waiting ...
0
 
ianBCommented:
Community Support has reduced points from 125 to 50
0
 
ianBCommented:
Hi,

hotbc wishes to split the point as follows :

sting ray : 50, ashokkumar : 50 , syedalif : 15 and qcs001 : 10


I have reduced the points on this question to 50 points (and refunded the rest) so that hotbc can post separate questions for each expert.

Any queries/problems see :

http://www1.experts-exchange.com/Customer_Service/Experts_Exchange/Q_10339717.html

Ian
Community Support @ Experts Exchange
0
 
hotbcAuthor Commented:
thanks i will post question again
0
All Courses

From novice to tech pro — start learning today.