How To Create Dynamic Columns In Crystal Report

Creating dynamic columns in crystal report using C# 2005

Author

Message

Senthil A

Posted: Crystal Reports for Visual Studio, Creating dynamic columns in crystal report using C# 2005

Top

Hi,

We are delevoping C# windows application where we want to embed new crystal reports.

Is there anyway to create and place the Report Objects(fields, Textbox, Subreport etc) in ReportDocument through C# code at runtime . For ourcase, the number of columns in the report will vary for different scenarios. So we have to control the number of columns and positions at runtime. Is this possible to do it through crystal report

Could you give any method in CrystalReport to achieve the above task

Thanks,

Senthil A

Visual Studio22

Arun S

Posted: Crystal Reports for Visual Studio, Creating dynamic columns in crystal report using C# 2005

Top

I am having the same problem, if u found the answer pls write

Thanks

Arun

MarkX

Posted: Crystal Reports for Visual Studio, Creating dynamic columns in crystal report using C# 2005

Top

Hi,

What I've read is that if you have the complete version of crystal reports, meaning 11.5 release 2, it is possible. With the standard version that comes with visual studio 2005, is not possible.

Senthil A

Posted: Crystal Reports for Visual Studio, Creating dynamic columns in crystal report using C# 2005

Top

thank Mark

MuraliMD

Posted: Crystal Reports for Visual Studio, Creating dynamic columns in crystal report using C# 2005

Top

Hello Senthil,

we r developing web application, where we need to generating dynamic reports based on selected columns. as like u r's.

if u don't mine let me know r u got solutiong for this

thanks & regards

murali.

Senthil A

Posted: Crystal Reports for Visual Studio, Creating dynamic columns in crystal report using C# 2005

Top

Hi Murali,

We are not using Crystal report which is come up with VS2005 as it is not supporting the Dynamic columns. So we have designed the report in C#.

I have got one reply regarding this issue which was sent by someone.

Below is the reply.

Can't add columns or subreports at runtime using the Version you have. You need to have a version that has a Report Application Server (RAS) to do report creation type things at runtime. The only versions that you can use with VS 2005 are Business Objects Enterprise XI release 2, or Crystal Reports Server XI release 2.

Thanks,

Senthil A

Raja Dain

Posted: Crystal Reports for Visual Studio, Creating dynamic columns in crystal report using C# 2005

Top

I had the exact same problem, and even though I'm more of a VB guy rather than a C# one, I thought I should share this:
http://www.c-sharpcorner.com/UploadFile/uditsingh/CR1111022006055359AM/CR11.aspxIts a rather dodgy method, but it works!

captJackSparrow

Posted: Crystal Reports for Visual Studio, Creating dynamic columns in crystal report using C# 2005

Top

Older versions dont allow you to create columns at runtime but you can supress and enable columns.

Here is a sample using Oracle, it can be further improved , read the readme

www.angelfire.com/realm3/runeblade/files/Report.zip

Another post

http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1595639&SiteID=1

manjulapw

Posted: Crystal Reports for Visual Studio, Creating dynamic columns in crystal report using C# 2005

Top

Hi,
You can find a solution for this question by reading the "Dynamic Crystal Report using .NET 2005 (C#)" articale published on CodeProject site that published by my self.

http://www.codeproject.com/useritems/Dynamic_Crystal_Report.asp