How can I create table with borders in report?

[bartek185]

How can I create table with borders in report?
I've tried to do it with borders of fields but either lines were multiple or there was no line at all.

I want to have simple table with the same single border.

Do you have any ideas how to do it.

Thanks for help.

 

[Madawc]

Could your data be expressed as a Crosstab? They automatically have borders, unless you choose to suppress them.

If that's not the answer, please check how you set borders. Right-click and 'Format Field' gives you control.

It always helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options.


Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP

 

[lbass]

I wonder whether you are looking for a crosstab. Try inserting a crosstab.

-LB

 

[bartek185]

I am using CR 2008 version.

I dont now if i am right but crosstab is sumarizing, gruping fields, and i want to show simple table for example 100 records (username, frist name, last name, date of birth). Is it possible to do it in a crosstab???

 

[Madawc]

Crosstabs work by grouping things. Of course you could use a value like 'Account Number' for your crosstab rows, which would show each one separately.

Or you can do it by detail lines if you format the fields correctly. I already told you how.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP

 

[bartek185]

I now I can set borders to fields, but it does not work in every condition.

If I set all borders to every fields than i will have multiple borders inside table and single outside.

If I set border in more sophisticated way: left and upper border for all fields but last. And left, right, upper border to last field, and last record gets bottom border than I do not have bottom border at the last record on page when report has more than one page.

 

[IanWaterman]

Using borders on fields is fraught with problems as null fields are blank and lose borders too. Also you run risk of double lines as you have seen.

Two options
My preference is to use boxes and/or lines. If you place a box with top in detail and move bottom of a box into group footer it will grow with data. You can then place a line at the bottom of the detail and you have a table.
Careful placement of underline and bottom of box will cause them to overlay and you will not see double line.

Alternatively place your data fields in text boxes and place borders on the text box. This over comes the Null problem but is still very fiddly.

Ian