Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
obaids
Starting Member
2 Posts |
Posted - 2009-08-14 : 23:50:13
|
| hi allhow r u ??please tell me how to create fields from database for .rdl reports. im the beginer in programming i need your help.thanksobaids |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-08-15 : 02:58:46
|
| what you need to do is create a query or procedure our databased on requirements in your database. Then open up a new reporting services project and create a new datasource to connect to your db. Once this is done,create a new dataset which has a command type of text if query and procedure otherwise. then copy your query or put procedure name and click apply.then click ! icon on top to run the query. it will ask for parameters if any. after running, results will get populated in grid on data tab.click refresh to add column,parameter info to dataset. now you can move to design tab and click view-> dataset from top menu to see dataset with all fields. you can then add containers on design layout and drag and drop fields from dataset |
 |
|
|
|
|
|