none
SQL Server Reporting Services FAQ

Все ответы

  • Part I: SQL Server Reporting Services General Topics

    Question 1: How to migrate SQL Server 2008 Reporting Services to another computer?

    Answer:

     

    The migration process for Reporting Services includes manual and automated steps. The following tasks are part of a report server migration:

     

    1.       Back up database, application, and configuration files.

    2.       Back up the encryption key.

    3.       Install a new instance of SQL Server 2008. If you are using the same hardware, you can install SQL Server 2008 side-by-side your existing SQL Server 2000 or 2005 installation. Be aware that if you do this, you might need to install SQL Server 2008 as a named instance.

    4.       Move the report server database and other application files from your SQL Server 2000 or 2005 installation to your new SQL Server 2008 installation.

    5.       Move any custom application files to the new installation.

    6.       Configure the report server.

    7.       Edit RSReportServer.config to include any custom settings from your previous installation.

    8.       Optionally, configure custom Access Control Lists (ACLs) for the new Reporting Services Windows service group.

    9.       Test your installation.

    10.   Remove unused applications and tools after you have confirmed that the new instance is fully operational.

     

    If you are reusing an existing report server database that you created in a previous installation, be aware that there are restrictions on the editions of SQL Server you use to host the report server database.

     

    For more information, please refer to the following link:

     

    Migration (Reporting Services)

    How to: Migrate a Reporting Services Installation

     


    Microsoft Online Community Support
    23 апреля 2009 г. 10:38
  • 1.        Question 2: How to combine connecting string via parameter?

    Answer:

    You can include parameter reference in the data source connection string and allow the user to choose a data source for the report. For example, with an expression-based connection string, a user who is running a sales report can select a data source for a particular county before running the report.

    The following example illustrates the use of a data source expression in a SQL Server connection string. The example assumes you have created a report parameter named ServerName:

    ="Data Source=" & Parameters! ServerName.Value & "; initial catalog=AdventureWorks" 


    Microsoft Online Community Support
    23 апреля 2009 г. 10:44
  • 1.        Question 3: How to install a 32-bit version of SQL Server 2005 Reporting Services on a computer that is running a 64-bit version of Windows?

     


    Answer:
     

     

    To install the 32-bit version of Reporting Services on a computer that is running the 64-bit version of IIS 6.0, we can follow these following steps:

    1.       Uninstall the 64-bit version of Reporting Services.

    Note: Side-by-side installations of 32-bit versions of Reporting Services and 64-bit versions of Reporting Services are not supported.

    2.       Run the Dotnetfx64.exe file to manually install the .NET Framework.

    The Dotnetfx64.exe file is in the Tools\redist\2.0 folder on the SQL Server 2005 Setup media. To download the Dotnetfx64.exe file, visit the following Microsoft Web site:

    http://go.microsoft.com/fwlink/?LinkId=70186

    3.       In IIS Manager, click Web Server Extensions.

    4.       In the Details pane, right-click ASP.NET V2.0.50727, and then click Allow.

    5.       Right-click Web Sites, and then click Properties.

    6.       Click the ISAPI Filters tab.

    7.       In the Filter Name column, click ASP.NET_2.0.50727, and then click Edit.

    8.       Replace C:\WINDOWS\Microsoft.NET\Framework64\v2.0.50727\aspnet_filter.dll with C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_filter.dll.

    Note
    : The Aspnet_filter.dll file in the C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\ folder is a 32-bit version of the file.

    9.       Click OK two times, and then close IIS Manager.

    10.   At a command prompt, run the following command:


    cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1

    11.   Install the 32-bit version of Reporting Services.

    12.   After setup is complete, open IIS Manager, and then click Web Server Extensions.

    13.   In the Details pane, right-click ASP.NET V2.0.50727 (32-bit), and then click Allow.


    To install the 32-bit version of Reporting Services on a computer that is running the 64-bit version of IIS 7.0, follow these steps:

    1.       Enable ASP.NET and IIS before you install Reporting Services.

    2.       Open a command prompt. To do this, click Start, point to All Programs, point to Accessories, right-click Command Prompt, and then click Run as administrator.

    3.       In the User Account Control dialog box, click Continue.

    4.       Copy the following script:


    cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1

    5.       In the upper-left corner of the Command Prompt window, right-click the command prompt icon, click Edit, and then click Paste.

    6.       Press ENTER to run the script.

    7.       Install the 32-bit version of Reporting Services. You must apply SQL Server 2005 Service Pack 2 (SP2) after you install Reporting Services in Windows Vista. If you install SQL Server 2005 Express Edition with Advanced Services, you can run SQL Server 2005 Express Edition with Advanced Services SP2.


    For more information, visit the following Microsoft Web site:
    Microsoft SQL Server 2005 Express Edition with Advanced Services Service Pack 2
    http://go.microsoft.com/fwlink/?LinkID=63922


    8.       Reset IIS.

    9.       Configure the report server for local administration. To access the report server and Report Manager locally, follow these steps:

    a.       Start Microsoft Internet Explorer.

    b.      On the Tools menu, click Internet Options.

    c.       Click Security.

    d.      Click Trusted Sites.

    e.      Click Sites.

    f.        Under Add this website to the zone, type http://servername.

    g.       If you are not using HTTPS for the default site, click to clear the Require server certification (https:) for all sites in this zone check box.

    h.      Click Add.

    i.         Repeat steps f and g to add http://localhost, and then click Close.

    10.   This step lets you start Internet Explorer either to localhost or to the network computer name of the server for both Report Server and Report Manager.

    a.       Create role assignments that explicitly grant you full-permissions access. To do this, follow these steps:  

    b.      Start Internet Explorer by using the Run as administrator option. To do this, click Start, click All Programs, right-click Internet Explorer, and then click Run as administrator.

    c.       Start Report Manager.

    d.      Note By default, the Report Manager URL is http://servername/reports. If you are using SQL Server 2005 Express Edition with Advanced Services SP2, the Report Manager URL is http://servername/reports$sqlexpress. If you are using a named instance of Reporting Services, the Report Manager URL is http://servername/reports$InstanceName

    e.      On the Home page, click Properties.

    f.        Click New Role Assignment.

    g.       Type a Windows user account in the following format: domain\user

    h.      Click to select the Content Manager check box.

    i.         Click OK.

    j.        In the upper-right corner of the Home page, click Site Settings.

    k.       Click Configure site-wide security.

    l.         Click New Role Assignment.

    m.    Type a Windows user account in the following format: domain\user

    n.      Click to select the System Administrator check box.

    o.      Click OK.

    p.      Close Report Manager.

    11.   Open Report Manager in Internet Explorer without using the Run as administrator option.




    Microsoft Online Community Support
    23 апреля 2009 г. 10:48
  • Question 4: Error of EXECUTE permission denied on object 'xp_sqlagent_notify'.

     

    Problem:

     

    In some special cases, you may receive the following error when trying to select the option execution from a report:

     

    EXECUTE permission denied on object 'xp_sqlagent_notify', database '######', schema '###'.

     

    Cause:

     

    Usually, this error is caused by the user missing the "RSExecRole" role in the Master and MSDB system databases.

     

    Solution:

     

    Reporting Services uses a predefined database role called "RSExecRole" to grant report server permissions to the report server database. If you get the error mentioned above, try to create and provision the  "RSExecRole" role in Master and MSDB system database.

     

    For more information, see:

    How to: Create the RSExecRole
    http://technet.microsoft.com/en-us/library/cc281308.aspx


    Microsoft Online Community Support
    23 апреля 2009 г. 11:14
  • Question 5: How to enable anonymous access to Report Server, and is there any security consideration?

     

     

    Answer:

     

    Please note that when using anonymous access, every person accesses the reports under the anonymous user context, and no one will have rights to administer Reporting Services through Report Manager. This is the reason why it is not recommended to use anonymous access in Reporting Services.

     

    In order to differentiate between users, we need to either disable anonymous access or use a custom security extension.  We have a sample using Forms Authentication:

    Using Forms Authentication in Reporting Services

     

    In some special situations, it may be necessary to use anonymous access. For security considerations, we can use the steps as below:

     

    1.       Add the anonymous user to the System User role

    2.       Create an Item-level role with all of the tasks you want this user to be able to use, and then assign the anonymous user to that role at the root level.

    3.       Check permissions for the anonymous user on folders that SRS uses:

    For example:
    C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services  (and subfolders)

    C:\<windows>\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET Files

    The temp folder for the anonymous user

     

    Note: Step1 & Step2 can be accomplished through Report Manager only if anonymous access is disabled and the logged-on user is a member of the System Administrator role.


    Microsoft Online Community Support
    23 апреля 2009 г. 11:17
  •  Question 6: How to create a custom report template in Reporting Services?


    Answer:

     

    A report template also exists as a normal report (RDL file). If you want to customize your own report templates, you can put the previously prepared reports (which will be used as new templates) in a specific folder. By default, the path is:

     

    C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject

     

    Then, to use these templates, you can right click on the Reports folder in your project and select New Item. You will then see the name of the report templates you added in the above folder.


    Microsoft Online Community Support
    23 апреля 2009 г. 11:20
  • Question 7: Does SQL Server 2005 Reporting Services support horizontal tables which have fixed rows and dynamic columns?

     

     

    Answer:


    Note: This Q&A is only for  SQL Server 2005 Reporting Services.


    By default, there is no native "horizontal table" report item. We can use Matrix to simulate simple horizontal tables:

     

    1.       Add a matrix to your report.

    2.       Add static rows to the matrix: Right-click in the Data cell and select "Add Row".  Repeat for the number of fixed rows you want.

    3.       Drag fields into the Data cells:

    You'll notice that the design tool automatically wraps your field reference in the "First" aggregate (e.g. =First(Fields!City.Value)).  Since you're doing this in the context of a matrix, the design tool is ensuring that the expression is meaningful even in the context of a subtotal or if the matrix is showing aggregated data rather than detail data. 

     

    Note: Please do NOT remove the aggregate expression.

    4.       Add a column grouping:


    1) Right-click on the column header and select "Edit Group". 

    2) Enter this for the group expression: =RowNumber(Nothing). This will cause the matrix to give you one column per row of data. Since horizontal tables can end up rather wide, you may want your table wrap around to the next "line" after a specific number of columns.

     

    5.       Add a list to your report and drag the table into it.

    6.       Group by a number of rows:

    1) Right-click on the list and select Properties.  Then click on Edit Details Group.
    2) Enter this for the group expression: =Ceiling(RowNumber(Nothing)/3)

    This will cause the list to group on every three rows.  So you'll get a separate table for every three rows.

     

    7.       Adjust the group expression in the matrix:

    Edit the column group expression in your matrix and change the RowNumber argument to be the list group name. For example: =RowNumber("list1_Details_Group")

     

    More Information: SQL Server 2008 Reporting Services has a new Date Region control named Tablix, which can be used for the same requirement easily. For more information about Tablix, Please refer to the documents below:

     

    What's New in Report Authoring

    Report Definition Tablix Overview Diagram

    Understanding the Tablix Data Region

    Working with Tablix Data Regions


    Microsoft Online Community Support
    23 апреля 2009 г. 11:25
  • Question 8: How to reset the page number back to 1 every time the report gets a group break?

     

     

    Answer:

     

    Resetting the page number on group breaks is not natively supported. There is a workaround: you can track group breaks in a shared variable, and reset this variable to 1 when reaches a new group break.

     

    Here are the steps:

     

    1.       Make sure there's a textbox in the report which contains the group expression.

    2.       Add shared variables to track the current group and page offset:

     

    Shared offset as Integer

    Shared currentgroup as Object

     

    3.       Add a custom function to set the shared variables and retrieve the group page number:

     

    Public Function GetGroupPageNumber(group as Object, pagenumber as Integer) as Object

      If Not (group = currentgroup)

       offset = pagenumber - 1

       currentgroup = group

      End If

      Return pagenumber - offset

     End Function

     

    4.       Use the function in the page header or footer:

     

    =Code.GetGroupPageNumber(ReportItems!Category.Value,Globals!PageNumber)


    Microsoft Online Community Support
    23 апреля 2009 г. 11:28
  • Question 9: How to open the drill- through report in a new browser window?

     

     

     

    Answer:


    Generally, if you use the "Jump to URL" option for a textbox, it will redirect to the specific URL in the same browser when the user clicks on the textbox.

     

    To open the link in a new window, you can use syntax similar to this:


    ="javascript:void window.open ('http://servername/reportserver?/freportfolder/ReportName&Parameter1=" & Fields!Field1.Value & "&Field2=" & Fields!Field2.Value & "&rs:Command=Render','_blank','resizeable=1,toolbar=0,status=0,menu=0,top=20,left=20,width=740,height=730')"

    Microsoft Online Community Support
    23 апреля 2009 г. 11:30
  • Question 10: How to verify the version of SQL Server?

     

    Answer:

     

    There are a few ways to verify the version of SQL Server.

     

    Method 1. You can run a query "SELECT @@VERSION" and note the version number returned in the string. SQL Server 2005 SP1 would return something like the following:

     

            Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86)

            Sep 22 2006 23:44:32

            Copyright (c) 1988-2005 Microsoft Corporation

            Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

     

    Method 2. you can also look at the file version for sqlservr.exe.

     

    Method 3. If you look in Add\Remove Programs, you would also see an entry for Service Pack 1 for SQL Server <component name>. Each patched component would have its own entry. Please note that you will need to select the "Show Updates" check box in the Add\Remove Programs dialog.

     

    Method 4. You can check the registry keys and values under:

     

    HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server

     

    There are several other areas that contain version information. Shared components generally have a Setup sub-key under "HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server \90\<Component>". For example:

     

    ...\90\DTS\Setup

    ...\90\Tools\Setup

    ...\90\NS\Setup

     

    Then for each instance of SQL\Analysis Services\Reporting Services, you can look under the instance specific key. These keys are numbered as MSSQL.x (where x is the instance number). These are created in the order of installation. So if you have only a single instance of SQL Server, the instance key would be MSSQL.1. Under each instance key you'll find a Setup key as well.

     

    In all cases, the Setup sub-key contains a value of PatchLevel, which equals the version of the instance.

     

    For example, for SQL Server 2005 RTM, the value should be 9.0.1399, and SP1 would be 9.0.2047.


    Microsoft Online Community Support
    23 апреля 2009 г. 11:36
  • Question 11: How to use multiple datasets?

     

    Answer:

     

    You can combine two or more datasets in one report. There are multiple options to achieve this:

     

    ·         If the data comes from different tables in the same database, join the datasets based on a common key present in both tables.

     

    ·         Use the Linked Server functionality.

     

    For more information, see Accessing External Data

     

    ·         Use the OpenRowSet functionality to join data from another database server into the current query.

     

    For more information, see OPENROWSET (Transact-SQL)


    Microsoft Online Community Support
    23 апреля 2009 г. 11:39
  •   Question 12: How to upgrade report from SQL Server 2000 to SQL Server 2005?

     

    Answer:

     

    You can use the following steps:

     

    1.       Back up ReportServer and ReportServerTemDB.

    2.       Back up encryption keys from Reporting services 2000 by using RsKeyMgmt.

    3.       Restore the databases backed up from step 1.

    4.       Connect to newly restored databases from step 3 from Reporting Services 2005 Configuration manager and database setup.

    5.       By using the provided credentials, Reporting Services will connect to new databases and perform the upgrade operations.

    6.       Confirm Reporting services upgrading the database and granting adequate rights to the credential account.

    7.       Restore backed up keys from step 2. Confirm that everything is displayed as green now.

    Reference: 


    How to: Start Reporting Services Configuration

    How to: Back Up the Reporting Services Encryption Key

    Reporting Services Configuration How-to Topics

    How to: Create a Report Server Database (Reporting Services Configuration)

    Upgrading a Report Server Database

     


    Microsoft Online Community Support
    23 апреля 2009 г. 11:41
  • Question 13: Out of memory error when exporting reports to Excel.

     

    Problem:

     

    We may encounter Out of memory error when exporting reports to Excel.

     

    Cause:

     

    Generally, this kind problem is complicated. There are some possible factors that may cause this issue:

     

    1.       On the x86 platform using the /3GB switch, the OS makes about 1.8 GB (maximum) available to be shared by all applications.

    2.       The .NET Framework 1.1/2.0 supports the use of the /3GB switch. However, it must share the OS-imposed limit of approximately 1.8 GB memory.

    3.       Using the /3GB switch cuts down the amount non-paged pool (NPP) memory HTTP.SYS (a kernel-mode driver IIS 6.0) uses to manage its connections, to 128 MB from 250 MB. This could negatively impact performance of IIS, should other sites be hosted on the server.

    4.       NET applications (of which SSRS is one) typically encounter out-of-memory issues at approximately 1.1 GB (+/- a wide margin, depending on many factors).

    5.       SSRS currently uses in-memory data caching and rendering; a “streaming” design
    needed to process extremely large reports simply does not exist at this time.

     

    Solution:

     

    You may try the following suggestions first:

     

    1.       Please refer to this KB: You may receive the "System.OutOfMemoryException" error message when you use SQL Server Reporting Services

    2.       Break the report to get smaller amount of data.

    3.       You can try using a 64-bit machine which doesn't have limitation of 2GB of usermode space.

    4.       You can test /3GB switch (of course not recommended on a production server) which allows to allocate 1GB to Kernel mode and 3GB to user mode.
    http://www.microsoft.com/technet/prodtechnol/windowsserver2003/library/ServerHelp/927bfe25-1705-4b60-91d4-2ed64d6aa85f.mspx

    5.       In general the 3GB switch should be used only for testing purposes since this setting shrinks the available address space for the Kernel mode. Below is a KB article that briefly talks about this:
    A description of the 4 GB RAM Tuning feature and the Physical Address Extension

    switch

    6.       Ensure that the Memory recycling checkboxes are unchecked for the SSRS app pool in IIS.

     

    Note: Excel rendering is improved in the Reporting Services 2008 and this issue may not occur in Reporting Services 2008.


    Microsoft Online Community Support
    23 апреля 2009 г. 11:44
  • Question 14: How to improve PDF quality of the report exported in Reporting Services 2005?

     

     

    Answer:

     

    The PDF renderer in Reporting Services 2005 resizes all images that it is given at 96 DPI no matter what DPI the image is when you pass it to the renderer. That means that a 300 DPI image or even a 600 DPI image will be sized in the PDF as if it is only 96 DPI. In other words, your high DPI image may render larger than expected.

      

    Despite sizing the images as if they were 96 DPI, the PDF renderer appears to render higher DPI images at a higher quality than 96 DPI. Even if the sizing being wrong, the image actually is rendering at a higher quality.

     

    A necessary workaround is to size the image to the proper number of inches based on 96 DPI calculations. Then use Bitmap.SetResolution to set the  images to at least 300 DPI.  That may provide a higher quality image that is the proper number of pixels to fit properly in the report.


    Microsoft Online Community Support
    23 апреля 2009 г. 11:47
  • Question 15: How to enable the Select All option for a multi-value parameter?

     

    Problem:

     

    When a user defines an available values list for a multi-value parameter, a Select ALL option on the report parameter drop-down list automatically appears. However, if you don’t want to make the parameter multi-value, how to enable the Select All option for the query parameter?

     

    Solution:

     

    Since the single-value query parameter does not provide the Select All option, you cannot query the data without any limitations. Sometimes, the end user may want to ignore the condition for the parameterized query. In this case, you can add the "Select All" option to the parameter dataset by using SQL statement.

     

    Here are the detailed steps:

     

    1. Create a dataset for the parameter using the following query string:

     

    SELECT ‘ALL’

    UNION ALL

    SELECT Field from table

     

    1. Edit your base dataset query:

     

    The original query:

    … AND Field=@Parameter…

    Change it to this:

    …AND (( Field=@Parameter ))OR(@Parameter=’ALL’))…

     

    1. Set the report parameter.

     

    1) Set the available values as the field created in Step 1.

    2) Set the default value of parameter to All.


    Microsoft Online Community Support
    23 апреля 2009 г. 11:48
  • Part II: SQL Server Reporting Services SharePoint Integrated Mode Topics

    Question 1: How to deploy reports to SQL Server Reporting Services in SharePoint Services integrated mode?

     

    Question:

     

    How to deploy reports to SQL Server Reporting Services in SharePoint Services integrated mode?

     

    Answer:

     

    You can use the following steps:

     

    1.       Create a web application in SharePoint with Report Center template.

    2.       Open Business Intelligence Development Studio and modify report solution properties as below:

     

    TargetDataSourceFolder

    The format for this URL like:
    http<s>://<server>/<site>/<report center>/<data source>

     

    TargetReportFolder

    The format for this URL like:
    http<s>://<server>/<site>/< report center>/<folder>

     

    TargetServerURL

    The format for this URL like:
    http<s>://<server>/<site>/< report center>

     

    3.       Deploy the report.


    Microsoft Online Community Support
    23 апреля 2009 г. 11:55
  • Question 2: How to integrate SQL Server Reporting Services and SharePoint Services?


    Answer:

     

    1. Check the requirements for running reporting service in SharePoint integrated mode:


    Requirements for Running Reporting Services in SharePoint Integrated Mode

     

    2. Follow the documents below to configure the server:


    Configuring Reporting Services for SharePoint 3.0 Integration

     

    For more information for Reporting Services and SharePoint Technology Integration, please refer to:
    Reporting Services and SharePoint Technology Integration


    Microsoft Online Community Support
    23 апреля 2009 г. 12:00
  • Question 3: How to refer the reports on the Report Server in SharePoint Services?

     

    Answer:

     

    After integrating SQL Server Reporting Services with SharePoint Services, you can refer a SSRS report in SharePoint Services. Here is the steps:

     

    1.       Install the SQL Server Reporting Services Add-in for SharePoint

     

    For more information, see How to: Install or Uninstall the Reporting Services Add-in

     

    2.       Refer to the documents below for using SQL Server Reporting Services Add-in:

    Using the Report Viewer Web Part on a SharePoint Site


    Microsoft Online Community Support
    23 апреля 2009 г. 12:02
  • Question 4: How to manage user to view reports in SharePoint integrated mode?

     

    Answer:

     

    In SharePoint website, if the default security settings do not meet your requirements, you can create new permission levels for the specific report server items or operations. Custom security settings are helpful if restricting access to a particular report is required.

     

    To customize permissions of viewing reports, please refer to the following documents:


    Granting Permissions on Report Server Items on a SharePoint Site
    How to: Set Permissions for Report Server Items on a SharePoint Site (Reporting Services in SharePoint Integrated Mode)


    Microsoft Online Community Support
    23 апреля 2009 г. 12:03
  • Question 5: What information is needed when posting questions regarding SharePoint integrated mode?

     

    Answer:

     

    To efficiently troubleshoot issues in forums, please provide the following information when posting questions:

     

    1.         Detailed Error Information.

    2.         Operation System Edition and Version.

    3.         SQL Server Edition and Version.

    4.         SharePoint Service Edition and Version.

    5.         SQL Server log. By default, the path is as below:


    For SQL 2005: “C:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting Services\LogFiles\”

    For SQL 2008: “C:\Program Files\Microsoft SQL Server\MSRS10.<instance_name>\Reporting Services\LogFiles\”

     

    6.         Detailed SharePoint log. By default, the path is “C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\LOGS\”

    7.         The SQL Server Error information in Windows Application Event.


    Microsoft Online Community Support
    23 апреля 2009 г. 12:03
  • Question 6: Is Report Builder available in SharePoint Integrated Mode?Reporting Services and SharePoint Technology Integration

     

    Answer:

     

    Yes. After integrating with SharePoint, what you need to do is to add Report Builder Model through Content Types:

     

    1. Open SharePoint website as administrator.
    2. Click Report Center website.
    3. Click Site Actions list.
    4. Select Site Settings and then select Modify Pages Library Settings.
    5. On Content Types part, click Add from existing site content types.
    6. Select Report Server Content Types from site content types drop-down list.
    7. Select Report Builder.
    8. Click OK to finish.

     

    After that, you will be able to use Report Builder.

     

    Please Note: Currently, Report Builder 2.0 has been released as a stand-alone installation for SQL Server 2008 Reporting Service. However, Report Builder 1.0 can still be used for SharePoint as  a "click-once" application. This function will be included in the future service pack of SQL Server 2008.

     

    ------------------------------

     

    More references on SQL Server Reporting Services SharePoint Integrated Mode:

     

     

    Security Overview for Reporting Services in SharePoint Integrated Mode

    Viewing and Managing Report Server Items from a SharePoint Site

    Security Overview for Reporting Services in SharePoint Integrated Mode

     

    23 апреля 2009 г. 12:05
  • Hi Thanks  for documentation but I have some problem in below line 

     
    Add a list to your report and drag the table into it
    from where I will get the list Is it any control or something  else.

    any example for using espression .
    thanks
  • @Joe - Wu

    For Question 10 :-
    I think we can use this query :-
    SELECT SERVERPROPERTY('productversion')as ProductVersion, SERVERPROPERTY ('productlevel')as ProductLevel, SERVERPROPERTY ('edition') as ServerEdition

    above query will give more meaningful result.

    For question 2:-
    This dynamic query thing does not work in case of Shared Connection .
    It work perfectly in case of Inbuilt report connection.
    ~~ Mark it as Answer if you find it correct~~
  • Hi, Its not enough to thank for this useful thread. PLease post some more useful interview questions along with answers in the same thread. Thanks & Regards, Mahasweta
    Mahasweta das
  • Very sorry to write in this section of this forum but I really do not find where to write my question:
    since several days I am trying to download from https://msdn.microsoft.com/en-us/subscriptions/securedownloads/default.aspx
    SQL Server 2008 Web (x86, x64) - DVD (English)
    But it seems impossible because after 80% downloading the download stops. Can you help me to solve the problem?
    Thank you very much for helping.

    11 октября 2009 г. 14:56
  • Thanks very much for this solution... thanks thanks.

    Capa
    http://capa.bhipglobal.com

    15 января 2010 г. 16:00
  • Hi Joe,
    I have an issue with reporting services 2008, i need to set a system-level security to my server (exp : add my login as a system administrator) using rs.exe tool.
    I have used microsoft sample AddItemSecurity.rss to add an item-level, but there is no sample how to add a new system administrator to my reportServer site ( Site settings --> security-->new role Assignement)
    if you have any sample, please let me know

    Thank-you!
    29 января 2010 г. 21:42
  • I cannot determine how to start a new thread, but my question is as follows:

    Why is "Generate Model" missing from my data source? Is there something wrong with my data source? It's a SQL Server data source.
    20 февраля 2010 г. 5:58
  • Is this forum still active and allowing new threads, or has it been shut down like so many others?
    20 февраля 2010 г. 5:59
  • Thanks Joe!
    A concrete example would help here.  If we start with an image that is intended to cover an area of 8.0 inches by 10.5 inches at a resolution of 300 dpi, how should the file be configured? 

    I'm confused by the directive "size the image to the proper number of inches based on 96 DPI calculations".  Does this mean that we're actually adding pixels to the file or maybe that we're adding bogus attributes?

    Does this apply only to the PDF renderer and not to printing from the viewers?

    Does this not apply to Reporting Services 2008 or 2010?

    BillVo
    15 марта 2010 г. 23:03
  • can we get similar information for SQL server 2008 R2 upgrade from SQL 2k8  ? Specially for Reporting services.

    regards,

    Mit

     


    mitkush
  • can we get similar information for SQL server 2008 R2 upgrade from SQL 2k8  ? Specially for Reporting services.

    After upgrade i got following error when i tried to run report from MOSS 2007 sharepoint farm.

    An error occurred during client rendering.

    • Unsupported RPL stream version detected: 34.62.1836345404. Expected version: 10.3.

     

    My original post

    http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/44992b65-a404-4798-b5bd-8f5a3e930daa

    regards,

    Mit


    mitkush
  • Question 9: How to open the drill- through report in a new browser window?

     

     

     

    Answer:


    Generally, if you use the "Jump to URL" option for a textbox, it will redirect to the specific URL in the same browser whn the user clicks on the textbox.

     

    To open the link in a new window, you can use syntax similar to this:


    ="javascript:void window.open ('http://servername/reportserver?/freportfolder/ReportName&Parameter1=" & Fields!Field1.Value & "&Field2=" & Fields!Field2.Value & "&rs:Command=Render','_blank','resizeable=1,toolbar=0,status=0,menu=0,top=20,left=20,width=740,height=730')"
    

    Microsoft Online Community upport

    Glad to follow what you said, Here is also the same case.
    22 августа 2010 г. 2:26
  • I cannot determine how to start a new thread, but my question is as follows:

    Just click on Ask a Question on the top right of the selected forum.


    Kalman Toth SQL SERVER 2012 & BI TRAINING
    New Book: Beginner Database Design & SQL Programming Using Microsoft SQL Server 2012



    • Изменено Kalman Toth 28 сентября 2012 г. 22:13
    28 октября 2010 г. 5:16
  • Thanks very much for this solution... !!

    reputation managemant
    27 января 2012 г. 5:57
  • Very much informational...Thanks for sharing this useful stuff.
    27 июля 2012 г. 13:07
  • This is very useful information. Thank you.

    Ray Yagubyan

    21 сентября 2012 г. 15:46
  • Very Helpful. Thanks.

    Thanks, Srikanth Kammadanam.

    1 октября 2012 г. 21:16
  • Hello MS

    Any chance to elaborate the steps for this?

    I am guessing also that changing the size of the image to begin with, causes massive degradation and even though we output to 300dpi, we have already destroyed the quality of the image. Is that correct?

    Regards

    19 февраля 2014 г. 17:22