I am trying to step thru the June SQL 2005 CTP Book on Line Tutorial on Reporting Services (ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqltut9/html/95c9c883-12e5-47af-8da1-b77c6ef7484c.htm)
However the steps don't seem to match what is in the GUI. Is there an updated version of this tutorial?
Thanks in advance.
Ned
Never mind, I selected REPORT MODEL instead of REPORT PROJECT.
Thanks,
Ned
I am working with CTP release on SQL Server 2005 Reporting Service using SQL Server 2000 as data source in Report Model Project.
I was working with RS2000 earlier, since we are interested in "End user tool" for reporting building, I started working on RS2005.
I have created a model and trying build a Report using Report builder. I have more than 75 fields to select on single report.
My questions are,
1. By using Report builder, I am selecting (by dragging fields) on report. While dragging first field, Report Builder > explorer is showing only directly dependant entities and its attributes. Here, I am not able to select attributes from Report Builder > explorer which are not dependant on other entities because explorer is not showing other entities. While dragging first attributes from one entity, explorer is not showing entities which are not depend on my first selected entities. How can I get other attributes available which is not relevant to my first selected attributes?
2. How to change print orientation of my report in to "landscape"? All of my reports will be printed on "landscape".
3. I am using "Report Builder" using keyboard and without mouse which makes it very difficult to work. Any shortcuts will be available for Report Manager (e.g. Menu Items: New Folder, New Data Source, Upload File, Report Builder etc.) or Report Builder (Explorer, Fields, Run Report, Design Report, Filter, selecting fields etc.)?
4. When will RS2005 will support export to Microsoft Word format?
5. I assume that database structure and Report Model are two separate things, and I can create my own relationship between existing entities in report Model. Is this correct?
6. I assume that RS 2005 Report Manager is accessible via web without any upgrades of Internet Explorer etc. is this correct? At present, I am not able to see all contents of Report Manager.
Above queries are influenced by my client who is using our customised tool as a Report Engine which is tightly coupled with development team and often changing requirements.Comments inline:
1. By using Report builder, I am selecting (by dragging fields) on report. While dragging first field, Report Builder > explorer is showing only directly dependant entities and its attributes. Here, I am not able to select attributes from Report Builder > explorer which are not dependant on other entities because explorer is not showing other entities. While dragging first attributes from one entity, explorer is not showing entities which are not depend on my first selected entities. How can I get other attributes available which is not relevant to my first selected attributes?
For your report to make sense, you have to have a path between the entities in your report. You should be able to navigate between entities by clicking on them. You can also use the find button (not sure how well that was working in CTP June).
2. How to change print orientation of my report in to "landscape"? All of my reports will be printed on "landscape".
In Report Builder, it is in the page properties dialog (not sure if that was fully implemented in CTP June). In Report Designer, make your page width greater than your page height.
3. I am using "Report Builder" using keyboard and without mouse which makes it very difficult to work. Any shortcuts will be available for Report Manager (e.g. Menu Items: New Folder, New Data Source, Upload File, Report Builder etc.) or Report Builder (Explorer, Fields, Run Report, Design Report, Filter, selecting fields etc.)?
Shortcuts will be added for the released product.
4. When will RS2005 will support export to Microsoft Word format?
Unfortunately, we were not able to get it into RS 2005. This is high on the list for a future release.
5. I assume that database structure and Report Model are two separate things, and I can create my own relationship between existing entities in report Model. Is this correct?
Sort of. The relationship has to be defined in the DSV so that we can generate the SQL. You never have to modify the database schema itself.
6. I assume that RS 2005 Report Manager is accessible via web without any upgrades of Internet Explorer etc. is this correct? At present, I am not able to see all contents of Report Manager.
Report Manager works with IE 5.5 and later. Not sure what you are running into.|||
1. By using Report builder, I am selecting (by dragging fields) on report. While dragging first field, Report Builder > explorer is showing only directly dependant entities and its attributes. Here, I am not able to select attributes from Report Builder > explorer which are not dependant on other entities because explorer is not showing other entities. While dragging first attributes from one entity, explorer is not showing entities which are not depend on my first selected entities. How can I get other attributes available which is not relevant to my first selected attributes?
-->>For your report to make sense, you have to have a path between the entities in your report. You should be able to navigate between entities by clicking on them. You can also use the find button (not sure how well that was working in CTP June).
This couldn't be more wrong , if you have 2 fact table sales and customer, and dimension time and product , you can't do a report that show sales , customers that make that purchases by product and time .
This is a very basic feature that report builder can't do......
Plase give us a beter tool
sqlI am working with CTP release on SQL Server 2005 Reporting Service using SQL Server 2000 as data source in Report Model Project.
I was working with RS2000 earlier, since we are interested in "End user tool" for reporting building, I started working on RS2005.
I have created a model and trying build a Report using Report builder. I have more than 75 fields to select on single report.
My questions are,
1. By using Report builder, I am selecting (by dragging fields) on report. While dragging first field, Report Builder > explorer is showing only directly dependant entities and its attributes. Here, I am not able to select attributes from Report Builder > explorer which are not dependant on other entities because explorer is not showing other entities. While dragging first attributes from one entity, explorer is not showing entities which are not depend on my first selected entities. How can I get other attributes available which is not relevant to my first selected attributes?
2. How to change print orientation of my report in to "landscape"? All of my reports will be printed on "landscape".
3. I am using "Report Builder" using keyboard and without mouse which makes it very difficult to work. Any shortcuts will be available for Report Manager (e.g. Menu Items: New Folder, New Data Source, Upload File, Report Builder etc.) or Report Builder (Explorer, Fields, Run Report, Design Report, Filter, selecting fields etc.)?
4. When will RS2005 will support export to Microsoft Word format?
5. I assume that database structure and Report Model are two separate things, and I can create my own relationship between existing entities in report Model. Is this correct?
6. I assume that RS 2005 Report Manager is accessible via web without any upgrades of Internet Explorer etc. is this correct? At present, I am not able to see all contents of Report Manager.
Above queries are influenced by my client who is using our customised tool as a Report Engine which is tightly coupled with development team and often changing requirements.Comments inline:
1. By using Report builder, I am selecting (by dragging fields) on report. While dragging first field, Report Builder > explorer is showing only directly dependant entities and its attributes. Here, I am not able to select attributes from Report Builder > explorer which are not dependant on other entities because explorer is not showing other entities. While dragging first attributes from one entity, explorer is not showing entities which are not depend on my first selected entities. How can I get other attributes available which is not relevant to my first selected attributes?
For your report to make sense, you have to have a path between the entities in your report. You should be able to navigate between entities by clicking on them. You can also use the find button (not sure how well that was working in CTP June).
2. How to change print orientation of my report in to "landscape"? All of my reports will be printed on "landscape".
In Report Builder, it is in the page properties dialog (not sure if that was fully implemented in CTP June). In Report Designer, make your page width greater than your page height.
3. I am using "Report Builder" using keyboard and without mouse which makes it very difficult to work. Any shortcuts will be available for Report Manager (e.g. Menu Items: New Folder, New Data Source, Upload File, Report Builder etc.) or Report Builder (Explorer, Fields, Run Report, Design Report, Filter, selecting fields etc.)?
Shortcuts will be added for the released product.
4. When will RS2005 will support export to Microsoft Word format?
Unfortunately, we were not able to get it into RS 2005. This is high on the list for a future release.
5. I assume that database structure and Report Model are two separate things, and I can create my own relationship between existing entities in report Model. Is this correct?
Sort of. The relationship has to be defined in the DSV so that we can generate the SQL. You never have to modify the database schema itself.
6. I assume that RS 2005 Report Manager is accessible via web without any upgrades of Internet Explorer etc. is this correct? At present, I am not able to see all contents of Report Manager.
Report Manager works with IE 5.5 and later. Not sure what you are running into.|||
1. By using Report builder, I am selecting (by dragging fields) on report. While dragging first field, Report Builder > explorer is showing only directly dependant entities and its attributes. Here, I am not able to select attributes from Report Builder > explorer which are not dependant on other entities because explorer is not showing other entities. While dragging first attributes from one entity, explorer is not showing entities which are not depend on my first selected entities. How can I get other attributes available which is not relevant to my first selected attributes?
-->>For your report to make sense, you have to have a path between the entities in your report. You should be able to navigate between entities by clicking on them. You can also use the find button (not sure how well that was working in CTP June).
This couldn't be more wrong , if you have 2 fact table sales and customer, and dimension time and product , you can't do a report that show sales , customers that make that purchases by product and time .
This is a very basic feature that report builder can't do......
Plase give us a beter tool
Thanks in advance
MartinI'm not positive, but I don't think you're going to be able to do this - The June CTP is based on Whidbey Beta 2, and I'm betting a fair number of changes happened between B2 and RTM...
Hi,
I am trying to implement a report using reprorting services and have just finished deploying it. I am using the June SQL 2005 CTP.
Books online then says to select Debug and Start after setting the TargetServerUrl. However, I get the error message below. Any help would be appreciated.
Regards,
Ned
TITLE: Microsoft Report Designer
A connection could not be made to the report server http://localhost/reportserver.
ADDITIONAL INFORMATION:
Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>Configuration Error</title>
<style>
body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;}
p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px}
b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px}
H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red }
H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon }
pre {font-family:"Lucida Console";font-size: .9em}
.marker {font-weight: bold; color: black;text-decoration: none;}
.version {color: gray;}
.error {margin-bottom: 10px;}
.expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; }
</style>
</head>
<body bgcolor="white">
<span><H1>Server Error in '/ReportServer' Application.<hr width=100% size=1 color=silver></H1>
<h2> <i>Configuration Error</i> </h2></span>
<font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif ">
<b> Description: </b>An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
<br><br>
<b> Parser Error Message: </b>The format of the file 'ReportingServicesWebServer' is invalid.<br><br>
<b>Source Error:</b> <br><br>
<table width=100% bgcolor="#ffffcc">
<tr>
<td>
<code><pre>
Line 27: <assemblies>
Line 28: <clear />
<font color=red>Line 29: <add assembly="ReportingServicesWebServer" />
</font>Line 30: </assemblies>
Line 31: </compilation></pre></code>
</td>
</tr>
</table>
<br>
<b> Source File: </b> C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config<b> Line: </b> 29
<br><br>
<b>Assembly Load Trace:</b> The following information can be helpful to determine why the assembly 'ReportingServicesWebServer' could not be loaded.<br><br>
<table width=100% bgcolor="#ffffcc">
<tr>
<td>
<code><pre>
=== Pre-bind state information ===
LOG: DisplayName = ReportingServicesWebServer
(Partial)
LOG: Appbase = file:///C:/Program Files/Microsoft SQL Server/MSSQL.3/Reporting Services/ReportServer
LOG: Initial PrivatePath = bin
Calling assembly : (Unknown).
===
LOG: Policy not being applied to reference at this time (private, custom, partial, or location-based assembly bind).
LOG: Post-policy reference: ReportingServicesWebServer
LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET Files/reportserver/a118fdc2/4881a74/ReportingServicesWebServer.DLL.
LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET Files/reportserver/a118fdc2/4881a74/ReportingServicesWebServer/ReportingServicesWebServer.DLL.
LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/MSSQL.3/Reporting Services/ReportServer/bin/ReportingServicesWebServer.DLL.
</pre></code>
</td>
</tr>
</table>
<br>
<hr width=100% size=1 color=silver>
<b>Version Information:</b> Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300
</font>
</body>
</html>
<!--
[BadImageFormatException]: The format of the file 'ReportingServicesWebServer' is invalid.
at System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Boolean isStringized, Evidence assemblySecurity, Boolean throwOnFileNotFound, Assembly locationHint, StackCrawlMark& stackMark)
at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Boolean stringized, Evidence assemblySecurity, StackCrawlMark& stackMark)
at System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark)
at System.Reflection.Assembly.Load(String assemblyString)
at System.Web.UI.CompilationConfiguration.LoadAssemblies(Hashtable original)
[ConfigurationException]: The format of the file 'ReportingServicesWebServer' is invalid. (C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config line 29)
at System.Web.UI.CompilationConfiguration.LoadAssemblies(Hashtable original)
at System.Web.UI.TemplateParser.AppendConfigAssemblies()
at System.Web.UI.TemplateParser.PrepareParse()
at System.Web.UI.TemplateParser.Parse()
at System.Web.UI.TemplateParser.GetParserCacheItemThroughCompilation()
at System.Web.UI.TemplateParser.GetParserCacheItemInternal(Boolean fCreateIfNotFound)
at System.Web.UI.TemplateParser.GetParserCacheItemWithNewConfigPath()
at System.Web.UI.TemplateParser.GetParserCacheItem()
at System.Web.UI.ApplicationFileParser.GetCompiledApplicationType(String inputFile, HttpContext context, ApplicationFileParser& parser)
at System.Web.HttpApplicationFactory.CompileApplication(HttpContext context)
at System.Web.HttpApplicationFactory.Init(HttpContext context)
at System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext context)
at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
-->
--. (Microsoft.ReportingServices.Designer)
BUTTONS:
OK
From the error message it seems like the report server virtual roots of your CTP June installation are explicitly configured to use ASP.NET 1.1. This won't work. CTP June requires that the virtual roots are configured to use ASP.NET 2.0.-- Robert|||Hi Robert,
Is there an easy way to reconfigure this?
Regards,
Ned|||SQL Server 2005 Setup should configure virtual roots automatically to use ASP.NET 2.0 during installation.
The IIS administration tool (e.g. part of compmgmt.msc) also may have an option to set the ASP.NET version of virtual roots explicitly.
Furthermore, you can use the aspnet_regiis command line tool:
* aspnet_regiis /lk ... to check the current virtual root ASP.NET mappings
* aspnet_regiis /s path ... to change the version mappings
You could also install e.g. CTP September and use the new RS configuration tool to recreate the virtual roots and apply correct configuration settings.
-- Robert|||
Thanks Robert,
I'll give this a try.
|||i dont know if you resolve the problem or no but oi think i resolve it
the problem is the configurations of the current version of .net frame work installed on the system is not compatible with reporting services to reconfigurate it u can access to the directory:
"c:\Windows\Microsoft.NET\Framework\v2.0.50727"
there you will find several exe files one of them can reconfigure trully your configurations i tried them all (arrange files by type will be helpful) and after thats i deployed my report on the directory(http://localhost/ReportServer)
hope that will be helpful
Hi,
I am trying to implement a report using reprorting services and have just finished deploying it. I am using the June SQL 2005 CTP.
Books online then says to select Debug and Start after setting the TargetServerUrl. However, I get the error message below. Any help would be appreciated.
Regards,
Ned
TITLE: Microsoft Report Designer
A connection could not be made to the report server http://localhost/reportserver.
ADDITIONAL INFORMATION:
Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>Configuration Error</title>
<style>
body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;}
p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px}
b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px}
H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red }
H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon }
pre {font-family:"Lucida Console";font-size: .9em}
.marker {font-weight: bold; color: black;text-decoration: none;}
.version {color: gray;}
.error {margin-bottom: 10px;}
.expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; }
</style>
</head>
<body bgcolor="white">
<span><H1>Server Error in '/ReportServer' Application.<hr width=100% size=1 color=silver></H1>
<h2> <i>Configuration Error</i> </h2></span>
<font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif ">
<b> Description: </b>An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
<br><br>
<b> Parser Error Message: </b>The format of the file 'ReportingServicesWebServer' is invalid.<br><br>
<b>Source Error:</b> <br><br>
<table width=100% bgcolor="#ffffcc">
<tr>
<td>
<code><pre>
Line 27: <assemblies>
Line 28: <clear />
<font color=red>Line 29: <add assembly="ReportingServicesWebServer" />
</font>Line 30: </assemblies>
Line 31: </compilation></pre></code>
</td>
</tr>
</table>
<br>
<b> Source File: </b> C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config<b> Line: </b> 29
<br><br>
<b>Assembly Load Trace:</b> The following information can be helpful to determine why the assembly 'ReportingServicesWebServer' could not be loaded.<br><br>
<table width=100% bgcolor="#ffffcc">
<tr>
<td>
<code><pre>
=== Pre-bind state information ===
LOG: DisplayName = ReportingServicesWebServer
(Partial)
LOG: Appbase = file:///C:/Program Files/Microsoft SQL Server/MSSQL.3/Reporting Services/ReportServer
LOG: Initial PrivatePath = bin
Calling assembly : (Unknown).
===
LOG: Policy not being applied to reference at this time (private, custom, partial, or location-based assembly bind).
LOG: Post-policy reference: ReportingServicesWebServer
LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET Files/reportserver/a118fdc2/4881a74/ReportingServicesWebServer.DLL.
LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET Files/reportserver/a118fdc2/4881a74/ReportingServicesWebServer/ReportingServicesWebServer.DLL.
LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/MSSQL.3/Reporting Services/ReportServer/bin/ReportingServicesWebServer.DLL.
</pre></code>
</td>
</tr>
</table>
<br>
<hr width=100% size=1 color=silver>
<b>Version Information:</b> Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300
</font>
</body>
</html>
<!--
[BadImageFormatException]: The format of the file 'ReportingServicesWebServer' is invalid.
at System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Boolean isStringized, Evidence assemblySecurity, Boolean throwOnFileNotFound, Assembly locationHint, StackCrawlMark& stackMark)
at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Boolean stringized, Evidence assemblySecurity, StackCrawlMark& stackMark)
at System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark)
at System.Reflection.Assembly.Load(String assemblyString)
at System.Web.UI.CompilationConfiguration.LoadAssemblies(Hashtable original)
[ConfigurationException]: The format of the file 'ReportingServicesWebServer' is invalid. (C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config line 29)
at System.Web.UI.CompilationConfiguration.LoadAssemblies(Hashtable original)
at System.Web.UI.TemplateParser.AppendConfigAssemblies()
at System.Web.UI.TemplateParser.PrepareParse()
at System.Web.UI.TemplateParser.Parse()
at System.Web.UI.TemplateParser.GetParserCacheItemThroughCompilation()
at System.Web.UI.TemplateParser.GetParserCacheItemInternal(Boolean fCreateIfNotFound)
at System.Web.UI.TemplateParser.GetParserCacheItemWithNewConfigPath()
at System.Web.UI.TemplateParser.GetParserCacheItem()
at System.Web.UI.ApplicationFileParser.GetCompiledApplicationType(String inputFile, HttpContext context, ApplicationFileParser& parser)
at System.Web.HttpApplicationFactory.CompileApplication(HttpContext context)
at System.Web.HttpApplicationFactory.Init(HttpContext context)
at System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext context)
at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
-->
--. (Microsoft.ReportingServices.Designer)
BUTTONS:
OK
From the error message it seems like the report server virtual roots of your CTP June installation are explicitly configured to use ASP.NET 1.1. This won't work. CTP June requires that the virtual roots are configured to use ASP.NET 2.0.-- Robert|||Hi Robert,
Is there an easy way to reconfigure this?
Regards,
Ned|||SQL Server 2005 Setup should configure virtual roots automatically to use ASP.NET 2.0 during installation.
The IIS administration tool (e.g. part of compmgmt.msc) also may have an option to set the ASP.NET version of virtual roots explicitly.
Furthermore, you can use the aspnet_regiis command line tool:
* aspnet_regiis /lk ... to check the current virtual root ASP.NET mappings
* aspnet_regiis /s path ... to change the version mappings
You could also install e.g. CTP September and use the new RS configuration tool to recreate the virtual roots and apply correct configuration settings.
-- Robert|||
Thanks Robert,
I'll give this a try.
|||i dont know if you resolve the problem or no but oi think i resolve it
the problem is the configurations of the current version of .net frame work installed on the system is not compatible with reporting services to reconfigurate it u can access to the directory:
"c:\Windows\Microsoft.NET\Framework\v2.0.50727"
there you will find several exe files one of them can reconfigure trully your configurations i tried them all (arrange files by type will be helpful) and after thats i deployed my report on the directory(http://localhost/ReportServer)
hope that will be helpful
