DaniWeb Forum Index > Software Development > C#

C# RSS

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

Please support our C# advertiser: Intel Parallel Studio Home

•

Join Date: Oct 2006

Posts: 2

Reputation: gubba_balu is an unknown quantity at this point

Solved Threads: 0

gubba_balu gubba_balu is offline

Offline

Newbie Poster

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

Oct 19th, 2006

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.

•

Join Date: Jan 2007

Posts: 8

Reputation: Aun Muhammad is an unknown quantity at this point

Solved Threads: 1

Aun Muhammad Aun Muhammad is offline

Offline

Newbie Poster

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

Jan 25th, 2007

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