.net – How to grow height or all fields of a “textboxes made” grid if one column’s height grows in crystal reports

crystal-reportscrystal-reports-2008crystal-reports-xinet

I am attaching an image to elaborate what i want to know
enter image description here

Crystal reports dont have any specific grid control

I have made a grid using textboxes in crystal reports 2011 for vs2010, But the problem is, if one of the column grows, i want to grow all text boxes of a row, as i have placed the grid in Details section of crystal report.
In image attached, you can see, description's height increases because extra text and "can grow" checked, i want if description increases whole row's height should be increased.

I made the columns using textboxes because if i use box or other rectangle control, it has very bad layout, i hid the textboxes right and top border, and joined all the fields together to make a row.

Thanks in advance.

Best Answer

Crystals text boxes are awful, as shown above they do not format nicely and are not consistent. The below is not a brilliant solution; but our work around the produce consistent and nicely formatted expanding tables.

Instead of using text boxes I suggest you use normal boxes and line objects (graphic objects) instead.

Use one box as the outline to your table, draw it so it is at the top of the header and extends to the bottom of the group. This will then dynamically expand and give you a consistent border.

I would then add another details section underneath the main one. Fill it with a horizontal line extending to the box. This will then rule under each detail line. You can do the same in the header.

Draw vertical lines using the line tool, connecting the top and bottom of the outer box.

When placed correctly the lines and the box will adjust vertically in respect to your data. Make sure all sections containing a horizontal line are squeezed up so there is no "whitespace" surrounding the line. You can also supress the last horizontal line if you have problems with it matching up to your footer.

Related Solutions

Addition of string fields in Crystal Reports

Create a new formula in your report like so:

if (IsNull({Testing.Amount}) or not IsNumeric({Testing.Amount}) or {Testing.Amount} = "")
Then 0 
Else
ToNumber({Testing.Amount})

And display the formula on the report.

How to point Crystal Reports at a new database

Use the Database menu and "Set Datasource Location" menu option to change the name or location of each table in a report.

This works for changing the location of a database, changing to a new database, and changing the location or name of an individual table being used in your report.

To change the datasource connection, go the Database menu and click Set Datasource Location.

Change the Datasource Connection:
1. From the Current Data Source list (the top box), click once on the datasource connection that you want to change.
2. In the Replace with list (the bottom box), click once on the new datasource connection.
3. Click Update.
Change Individual Tables:
1. From the Current Data Source list (the top box), expand the datasource connection that you want to change.
2. Find the table for which you want to update the location or name.
3. In the Replace with list (the bottom box), expand the new datasource connection.
4. Find the new table you want to update to point to.
5. Click Update.
6. Note that if the table name has changed, the old table name will still appear in the Field Explorer even though it is now using the new table. (You can confirm this be looking at the Table Name of the table's properties in Current Data Source in Set Datasource Location. Screenshot http://i.imgur.com/gzGYVTZ.png) It's possible to rename the old table name to the new name from the context menu in Database Expert -> Selected Tables.
Change Subreports:
1. Repeat each of the above steps for any subreports you might have embedded in your report.
2. Close the Set Datasource Location window.
Any Commands or SQL Expressions:
1. Go to the Database menu and click Database Expert.
2. If the report designer used "Add Command" to write custom SQL it will be shown in the Selected Tables box on the right.
3. Right click that command and choose "Edit Command".
4. Check if that SQL is specifying a specific database. If so you might need to change it.
5. Close the Database Expert window.
6. In the Field Explorer pane on the right, right click any SQL Expressions.
7. Check if the SQL Expressions are specifying a specific database. If so you might need to change it also.
8. Save and close your Formula Editor window when you're done editing.

And try running the report again.

The key is to change the datasource connection first, then any tables you need to update, then the other stuff. The connection won't automatically change the tables underneath. Those tables are like goslings that've imprinted on the first large goose-like animal they see. They'll continue to bypass all reason and logic and go to where they've always gone unless you specifically manually change them.

To make it more convenient, here's a tip: You can "Show SQL Query" in the Database menu, and you'll see table names qualified with the database (like "Sales"."dbo"."Customers") for any tables that go straight to a specific database. That might make the hunting easier if you have a lot of stuff going on. When I tackled this problem I had to change each and every table to point to the new table in the new database.

Best Answer

Related Solutions

Addition of string fields in Crystal Reports

How to point Crystal Reports at a new database

Related Topic