Hi there,
I have a SQL database with a table called invoiceLine. My report brings in these invoice lines to display the results for a invoice.
I'm trying to make it so in between each invoice line it is only one spacing every time. When a invoice line description field is only one line long it works correctly. But when this field is more than one line long it adds in a additional line space at the end of the description. I don't want this to happen, I want it to always be the same line spacing. Here is a image example.
http://i.imgur.com/KgGOQYo.jpg
Here is a image of my invoiceline databand.
http://i.imgur.com/6Vn5apP.jpg
How can I make it so that everytime a new InvoiceLine is brought into the databand the spacing between each is always right above one another?
Thanks.
Single Line Spacing on InvoiceLine Databand
-
- Posts: 3
- Joined: Fri Nov 01, 2013 6:52 am
Re: Single Line Spacing on InvoiceLine Databand
Hello,
Can you please send us your report with test data which reproduce the issue for analysis.
Thank you.
Can you please send us your report with test data which reproduce the issue for analysis.
Thank you.
-
- Posts: 3
- Joined: Fri Nov 01, 2013 6:52 am
Re: Single Line Spacing on InvoiceLine Databand
I uploaded a sample with it, but I'm not sure how to create a sample for you since it is only going to work with my Data Members.
Pretty much, you need to just set up a Database and in the database have a table called InvoiceLine. Inside invoiceLine you need the Item, Description, Quantity, Rate, Amount columns. Make some of the descriptions a few words and others much longer so they take up more than one line.
Create a databand with source as InvoiceLine. When you print them out on a report anyone with a multi line description (that has to use the Can Grow Attribute of the text box) will add an extra line space at the end before starting the next InvoiceLine.
Pretty much, you need to just set up a Database and in the database have a table called InvoiceLine. Inside invoiceLine you need the Item, Description, Quantity, Rate, Amount columns. Make some of the descriptions a few words and others much longer so they take up more than one line.
Create a databand with source as InvoiceLine. When you print them out on a report anyone with a multi line description (that has to use the Can Grow Attribute of the text box) will add an extra line space at the end before starting the next InvoiceLine.
- Attachments
-
- sample.mrt
- (172.49 KiB) Downloaded 159 times
Re: Single Line Spacing on InvoiceLine Databand
Hello,
Please send us a test data for your report. You can save it as xml:
InvoiceLine.DataTable.DataSet.WriteXml("e:\\data.xml");
Also please check the last prerelease build.
Thank you.
Please send us a test data for your report. You can save it as xml:
InvoiceLine.DataTable.DataSet.WriteXml("e:\\data.xml");
Also please check the last prerelease build.
Thank you.
Re: Single Line Spacing on InvoiceLine Databand
Hello.
You are using very old version of your product.
There was a lot of improvements.
Please, try to download the latest prerelease build from our site.
Thank you.
You are using very old version of your product.
There was a lot of improvements.
Please, try to download the latest prerelease build from our site.
Thank you.