SQL Server Reporting Services Help


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 7 of 7

Thread: SQL Server Reporting Services Help

Hybrid View

  1. #1
    Join Date
    Oct 2005
    Posts
    95

    SQL Server Reporting Services Help

    Hi

    I have a quick question on SQL Server reporting services . I have to make a report using SQL server reporting Services and have to call the Report (.RDL ) file from a VB.NET windows form . There is a button on the form which user will click to get to the Reporting service reports . I have made the reports But How do I call the Report file ( .RDL ) file from the VB.NET windows File . I have the button made for the reporting services but need the code to call the Reporting services file

    Thanks

  2. #2
    Join Date
    Dec 2004
    Posts
    717
    Did you use ReportViewer?
    Best Regards,
    Michael Sync
    http://michaelsync.net

    The more you share,The more you get

  3. #3
    Join Date
    Oct 2005
    Posts
    95

    SQL Server Reporting services help

    Hi

    Thanks for the reply . I have used Report Viewer and Report Designer

    Thanks

  4. #4
    Join Date
    Dec 2004
    Posts
    717
    This coding is used for Loading report from Web Project. I hope you can change this coding to use in Windows Project also..
    public void LoadReport(string strFromDate ,string strToDate)
    {

    bool boolSuccess=true; //for handling exception
    try
    {
    rpt.ServerUrl=@strServerPath;
    rpt.ReportPath=@strReportPath+"/RECScheduledCandidateReport";
    rpt.SetQueryParameter("FromDate",strFromDate);
    rpt.SetQueryParameter("ToDate",strToDate);

    // the following line supresses the Parameter input part of the tool bar
    rpt.Parameters=Microsoft.Samples.ReportingServices.ReportViewer.multiState.False;
    //ReportViewer
    rpt.Format="HTML4.0";
    }
    catch(Exception ex)
    {
    lblMessage.Text = "Enter Valid entries."+ ex.Message ;
    lblMessage.Visible = true ;
    rpt.Visible = false ;
    boolSuccess=false ;
    }
    if(boolSuccess==true)rpt.Visible = true ;
    }
    Best Regards,
    Michael Sync
    http://michaelsync.net

    The more you share,The more you get

  5. #5
    Join Date
    Oct 2005
    Posts
    95

    Reporting Service Help

    Hi

    Thanks for the reply . I will modify the code you send to use with my Windows Project . I have a another question . I am developing this application for one of our client using SQL Server 2000, VB.NET & SQL Server Reporting Services . When we have finish development we have to install it on the client's computer . We do not want client to see our code ans SQL Store procedures . How do we hide the SQL Store procedure from the client when install the system on their computer . We would like client to use the system but not modify it as we have the copy write .

    Thanks again

  6. #6
    Join Date
    Dec 2004
    Posts
    717
    As far as I know, we can use two approaches for this case that u want.
    1) Firstly, you have put one admin account on your database and then, you should use this account from windows applications when you want your application to connect with database. You should also remove all access acount for your database except the admin account used by windows application. After your deployed your application on your client's computer, they don't know the admin's password so that they are not able to see everything included in your database even your windows application can connect with your database using the admin account only.

    2)You can encrypt your stored procedure. Check "CREATE PROCEDURE" statement in SQL Book Online.

    I think approach 1 is more better.
    Best Regards,
    Michael Sync
    http://michaelsync.net

    The more you share,The more you get

  7. #7
    Join Date
    Oct 2005
    Posts
    95

    SQL Reporting Service help

    Hi

    Thanks so much for your help . I will try to set up our SQL Stored procedure the way you said . I have completed the reports using SQL Server reporting services . But it is running very slow . I have a main report and 15 subreports . I have added all the sub reports to the mail report . Now when I run the preview to generate the report it runs very slow . I have not deployed the report on the report server . We have same report created in Crystal report and it works very fast . Do you know if there is a way to tune up the SQL Reporting Services to make it work faster .

    Thanks again

Similar Threads

  1. SQL Mail Problem
    By alex in forum Database
    Replies: 3
    Last Post: 11-03-2005, 06:27 AM
  2. Replies: 2
    Last Post: 03-24-2005, 06:49 PM
  3. Access & SQL Server
    By David Jones in forum Database
    Replies: 0
    Last Post: 08-31-2001, 01:22 PM
  4. Changing Server Name
    By Levi Nkata in forum Database
    Replies: 3
    Last Post: 04-11-2001, 10:31 AM
  5. Problem with SQL Server OLAP Services SP2
    By William in forum Database
    Replies: 0
    Last Post: 07-28-2000, 06:00 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center