How to create static tables in Crystal reports 11

[mastek456]

Hi ,
I am using Crystal reports 11 and would like to know how do I create a static table in the report with rows and cloumns.Can anyone please tell me how to go about it.Currenlty I use a combination of box and lines to do it , Is there a better way of doing it????

 

[Durango122]

hi
try formatting the detail section with collumn and row



Durango122

 

[IdoMillet]

More detail about what you need to achieve would be useful.

Cheers,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[mastek456]

I want to draw a table with say 4 rows and three columns.The kind of table we can draw in MS word.

 

[Madawc]

Have you tried crosstabs? Choose Insert > Crosstab and check what it can do. You'll find it useful for other tasks even if it doesn't solve this one.

Crosstabs are the closest to a Word table that I know about, but not that close. The drawback is that they won't create a column or row where there is no data: i.e. if you did it by days of the week and had nothing for Wednesday, it would go from Tuesday to Thursday.

To overcome this, people create Manual Crosstabs. These are a grid of running totals, each individually defined and places, meaning that they are a lot of work.

Your Crystal software should have come with examples of crosstabs, and the folder for crosstabs will inclue a manual crosstab, at least it does for Crystal 10.

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

 

[mastek456]

Hi ,
Thanks for your suggestion I have tried using cross tabs but it does not work in this condition.Asssume I have no data to be displayed from database and want to have a static text reports with few text feilds and tables in it Any ideas what could be the best approach , as mentioned i am using a combination of box and line but it is difficult to format

 

[IdoMillet]

One option is to create the table with another program and then import it as an image into Crystal.

Cheers,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[malcolmt]

Hello there,

Try these steps:

Set up a simple report.

Draw a box around your column headings in page header and extend through your detail section into the section below.

Increase your magnification, then draw a virtical line to divide your columns. Start the line at the top of the box and extend down to the bottom of the box.

Draw a horizontal line across the bottom of your detail section to divide each row.

Preview the report and you should start to see the beginnings of a table.

You could then place other boxes over your headings with a background to start to shade your headings etc.

I recently had to do this for one report and crosstabs don't give you what you need.

To get separate tables within groups I needed to create a subreport in a group header in the main report. The subreport contains the constructed table.

It's, messy & tedious but it can be done. It would be nice to have an easier way to do this though.

Regards,

Malcolm.

 

[synapsevampire]

If you don't have data, you can just build out a static sql statement to return what it is that you want and then use a supreort with a cross-tab.

Your descriptions leave a bit too much to the imagination, why not post:

Database/connectivity used
Example data
Expected output

It's OK if the data doesn't exist, you can create a Command object in Crystal to create the data using your database.

-k