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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 how to create fields from database for .rdl report

Author  Topic 

obaids
Starting Member

2 Posts

Posted - 2009-08-14 : 23:50:13
hi all
how r u ??
please tell me how to create fields from database for .rdl reports. im the beginer in programming i need your help.
thanks

obaids

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
Go to Top of Page
   

- Advertisement -