Dynamic Columns in Crystal reports

crystal-reports crystal-reports-2008 dynamic-columns
Siva picture Siva · Aug 27, 2013 · Viewed 13.5k times · Source

I got a requirement to create dynamic reports where if a column is added in database that column should automatically need to be reflected in crystal reports.

I am wondering if dynamic column possible in crystal reports?

If yes.. How to achieve?

Answer

Umm E Habiba Siddiqui picture Umm E Habiba Siddiqui · Aug 27, 2013

As far as I know by adding a column in db you can't get it on crystal reports via datatable but you can get it via stored procedure but you have to drag and drop the field. Go through this link hope it will help you

Crystal report with Dynamic Column

Related questions

How do I point Crystal Reports at a new database

I have a Crystal Reports 2008 user that has over 100 custom developed reports. The reports all query Sql Server databases (SQL 2005). This database server is getting replaced with a new system (running SQL 2008 R2) and the existing databases will be moved …

Read More
Crystal Reports Custom IsNull Function

I am trying to create a custom IsNull Function in Crystal Reports; the function must act the same way as the IsNull Function in MS SQL Server. I want to specify a field, and if the field is null, then …

Read More
extract raw SQL query from a Crystal Report .rpt file

I've got an .rpt file that I did not write and can find no documentation about. I want to be able to review the SQL that is generated from this report so that I can figure out, well, what data …

Read More