SQL Server Performance

want to data drive reports

Discussion in 'SQL Server 2005 Reporting Services' started by MichaelB, Sep 28, 2006.

  1. MichaelB Member

    I 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
  2. Madhivanan Moderator

    Then you should post your question at VB or .NET related forums

    Madhivanan

    Failing to plan is Planning to fail
  3. satya Moderator

    True, for such snippets other than SQL server you would get required solution.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
  4. Babin New Member

    Mr. Michael,
    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.
    Good Luck!!!

Share This Page