MasterVB.NET

Hi all

we are working on crystal report to develop verious report for our asp.net web application..
my query fetch the recods as follows.

party id rating agency name rating
1 crisil aa+
1 moodys aa
2 crisil bb
2 moody bb+

i want to display these records in crystal report as follows.

party id moody crisil ...
1 aa aa+
2 bb+ bb

the proble is agency are not fixed. write now there are only 2 agecny in my database.

later these agancies will be added..

My problem is how to add column programatically to crystal report using asp.net + c#
i am using asp.net 2.0 with .net cyrstal report

Need ur help

Thanks and warm regards,

Kalpesh

we are developing web application using asp.net 2.0 and c#..

I m

Try this.....

Get your data in DataTable and then manipulate to add whatever rows colums .... once done with that use the final DataTable as DataSource for your report and disply it.

Raj

Try this.....

Get your data in DataTable and then manipulate to add whatever rows colums .... once done with that use the final DataTable as DataSource for your report and disply it.

Raj

Hi Raj,

Thanks for the reply..

I am using xsd approch where i define all the column which are going to display in report.

I already prepare one datatable programatically which contains all this data

Now Is it possible to bind this data table to the crystal report...

Also then what will be the role of my xsd schema...Also how i inserted company logo or title in the report if i directly bind the datatable to the report.. I am relatively new in the crystal report..

Can u explain through code.

Thanks and Warm Regards,

Kalpesh

Again thanks for ur reply....

Raj wrote:

I am not sure about XSD but I'll try to find out more abt it. Btw if you find any solution please let me know.

Raj

Hi,

i expecting ur solution.

If i solve this problem i will revert back to u.

Thanks and warm regards,

Kalpesh

Raj wrote: