Post reply

New to Reporting Services

  • January 24, 2006 at 8:36 am

    #188932

    I am new to this forum and new to SQL Reporting Services.  I guess I just need some guidance and direction.

    I am used to using Crystal Reports when I programmed with Visual Studio 2003.  Now I have Visual Studio 2005 with SQL Server 2005.  I have created a company intranet with a couple of reports.  These reports work fine when I set the processing mode to local reporting, however I want to be able to use Server Reports.

    I have the report server on the local machine.  The first error I was getting is "The path of the item /Reports/report.rdlc" is not valid.  The path must be less than 260 character long and restrictions apply (rsInvalidItemPath)."  I believe I have cleared this problem, but now the problem I am having is "The item '/Reports/report.rdlc' cannot be found. (rsItemNotFound)".

    Do I need to do something more than just create the report in Visual Studio 2005 and import it to SQL Reporting server?

    I have not found much good information online.

    Thanks for any help anyone can give.

  • January 27, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • February 2, 2006 at 7:41 pm

    #618559

    Brad,

    A rough overview of the process is:

    1. create the report in VS, test run it etc in VS

    2. assuming step1 is all good and ready to go live, within the solution explorer right click the project name and select properties.  In the server textbox, type the path to the RS server (typically <A href="http:///reportserver">http://<servername>/reportserver ).

    3. either at the project or report level, right click and select 'deploy' - this publishes the report/project to the server along with any required datasources

    4. to test this report on the server, go to <A href="http:///reports">http://<servername>/reports  (not a type, use just reports, this fire ReportManager).  If you changed nothing, you should see a folder with the same name as your project, and within this will be the report/s.  Click on one to test execute it.

    5. everything else from there is just customization - do you want reports to go into a folder with a different name to the proect; do you need to change the security/access mode for the datasource (typically integrated security by default) etc

    I hope this helps.  Post how you go or ay stumbling blocks and we'll try to help.

    Cheers,

    Steve.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply