SQL Server Performance Forum – Threads Archive
want to data drive reportsI have SQL2005 standard, but want to data drive report creation. [}<img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />] I am a newbie with .Net and looking for sample code that would allow me to produce reports or pdfs based on parms I pass from a db table that will put the reports in a directory. I am lookng for just a vb app that would job this up.<br />Thanks in advance for any direction!<br /><br />Michael B<br />Sr. DBA<br /><br />"The fear of the Lord is the beginning of knowledge,<br />but fools despise wisdom and instruction." Proverbs 1:7
Then you should post your question at VB or .NET related forums Madhivanan Failing to plan is Planning to fail
True, for such snippets other than SQL server you would get required solution. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing.
I can give you a bit of information to start with. I dont have any sample codes with me, sorry for that. Initially you will have to create a report template and upload the same to the report manager as you are doing with the normal SQL reporting. Now coming to calling the report from your project, it is more or less similar to how you call a XML link. More over, there are some built in methods for SQL reoporting with which you can do all the activities which are normally done thru report manager. You can very well inherit and use the same methods in your application to deploy, create snapshot, what and what not. Better drill advanced topics in SQL reporting where you will find more information.