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

Please support our C# advertiser: Intel Parallel Studio Home
Reply

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

 
0
  #1
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.
Reply With Quote Quick reply to this message  
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

 
0
  #2
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
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC