how to add database fields dynamically to a crystal report in .net 2003

Expand Post »

hi please anybody help me in this situation

i am having 3 sql server tables namely

1.Req Items 108 kalasa pooja(fields: ItemName,Qty )
2.Req Items Laksharchana(fields: ItemName,Qty )
3.Req Items Ganapathi homam(fields: ItemName,Qty )

i had added these items to a combo box

based on the user selection the particular table should be made as report source and the corresponding fields should be added to the crystal report using c# coding.

Similar Threads

ASP.NET Crystal Report ODBC MySQL in ASP.NET
Crystal report in vb.net, printing problems in VB.NET
display data in crystal report using vb in Visual Basic 4 / 5 / 6
How to set database location via code in Crystal Report XI....? in Visual Basic 4 / 5 / 6
Using Crystal Reports XI with Visual Studio .NET 2003 in VB.NET

gubba_balu

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Oct 2006

Permalink

Jan 25th, 2007

Re: how to add database fields dynamically to a crystal report in .net 2003

this can be done by passing the selected value in the query..
like;;
select * from tbl_something where itemname='"+cmbo.text+";

then pass this qery to command or adapterand bind the data to report

it will work:regards

Aun Muhammad

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

8 posts
since Jan 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in C# Forum Timeline: combobox & dataset SOS!!!

Next Thread in C# Forum Timeline: .xsd

DaniWeb Message

Cancel Changes

User Name
Password