cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Crystal Report

Go to solution
Former Member

on ‎04-11-2017 12:23 PM

0 Kudos

In my detail section I have a text field where cangrow = true, I have also a field with numbers (currency). I want the numbers to be in line with the bottom row of the text field - is that possible?

like this:

Assistance with
designing a new report 1 000:-

Show replies
Show replies
Former Member
‎05-31-2017 9:33 AM
0 Kudos
Is there any other solution to this? As you can see I have tried both HTML and CSS, but as Crystal do not accept all HTML and CSS code, it does not work.
Answer

Accepted Solutions (1)

Accepted Solutions (1)

ido_millet
Active Contributor
‎05-31-2017 1:37 PM
0 Kudos

One of the 3rd-party Crystal Reports UFLs listed here provides a function that returns the height of a wrapped text given its width, font, font size, and style. This allows you to shift another text down by prefixing it with blank new lines until it matches the height of the first text. Here's an image of a demo report demonstrating this technique.

Show replies
Show replies
Former Member
‎06-15-2017 1:01 PM
0 Kudos

Thanks ! this solved my problem.

Answers (2)

Answers (2)

Former Member
‎04-12-2017 9:37 AM
0 Kudos

You can create a formula which concatenates the fields and uses HTML tags to justify two fields as you want.

Then format text field on paragraph tab select Text interpretation as HTML.

I am not an html developer so will be something like this, however, this puts number on line below.

'<p align="left">'&{TextField}&'</p><p align="right">'&totext({numberfield})&'</p>'

Ian

Show replies
Show replies
Former Member
‎04-21-2017 2:31 PM
0 Kudos

I have tried with HTML - but it did not work - in CR <td> table is not working.

Now I tried with the CSS below which I have put in a formula - but it does not work . Is there any other way to solve this?

'<html>' +
'<head>' +
'<style>' +
'div' +
'{' +
' width: 100%;' +
'}' +
'div.text' +
'{' +
' display: inline-block;' +
' width: 75%;' +
'}' +
'div.belopp' +
'{' +
' position: relative;' +
' bottom: 0;' +
' width: 20%;' +
' display: inline-block;' +
' text-align: right;' +
'}' +
'</style>' +
'</head>' +
'<body>' + '</head>' +
'<body>' +
'<div>' +
'<div>'

+ {FakturaRader.Text} +
'</div>' +
'<div>'
+ totext({FakturaRader.Belopp}) +
'</div>' +
'</body>' +
'</html>'

Former Member
‎04-11-2017 12:27 PM
0 Kudos

Place the two fields into a single text box and set that to can grow.

Ian

Show replies
Show replies
Former Member
‎04-12-2017 8:40 AM
0 Kudos

Thanks for your answer!

But I want the text field that can grow to justify left and the number right justify. It is an invoice and the numbers must be in the same position to the right.

Ask a Question