I have perfmon data collected in a sql database and now i would like to
display the data captured in the form of report.. But I dont really know how
to go about it ? Is there a pack or set of reports that are out there that I
could use and just plug it to the perfmon collection database ?
Thankshi there
you may want to check out this link - scroll down the page - hopefully
something may help you.
http://sqlblog.com/blogs/andrew_kelly/
Jewel
"Hassan" wrote:
> I have perfmon data collected in a sql database and now i would like to
> display the data captured in the form of report.. But I dont really know how
> to go about it ? Is there a pack or set of reports that are out there that I
> could use and just plug it to the perfmon collection database ?
> Thanks
>
Showing posts with label reports. Show all posts
Showing posts with label reports. Show all posts
Wednesday, March 28, 2012
Pre-defined lists of values as report parameter input
Has anyone come up with a solution for the following scenario yet?
We have many reports which have input parameters that are lists of values.
As an example the user might want to report on 30 of 100 available product
codes, or 12 of 50,000 account numbers.
What might be an idea would be to store the lists of values that userâ's want
to report on, in a general purpose Lists table. One column would be a List
Name and the other a delimited list of values. This List table could then be
used as the input to a Drop Down box for the relevant report parameter.
Has anybody tried something similar, or does anyone have any other
suggestions?
(Weâ're aware that multi-select list boxes will be available in SSRS 2005,
but that would still be a bit tiresome for a user that needs to select a few
values from a long list).
Regards,
John MarshHi John,
I have done similar thing like that.
i have a lookup parameter report which is a webpage with listbox and the
value is populated by calling a param report. The param report contain 2
fileds and it like name- value pair. The report is called programttically and
the result is returned in xml format so that it can be bind to a dataset and
to tht listbox or dropdown box.
So this act as a lists of values as report parameter input..
Regards
Bava
"John Marsh" wrote:
> Has anyone come up with a solution for the following scenario yet?
> We have many reports which have input parameters that are lists of values.
> As an example the user might want to report on 30 of 100 available product
> codes, or 12 of 50,000 account numbers.
> What might be an idea would be to store the lists of values that userâ's want
> to report on, in a general purpose Lists table. One column would be a List
> Name and the other a delimited list of values. This List table could then be
> used as the input to a Drop Down box for the relevant report parameter.
> Has anybody tried something similar, or does anyone have any other
> suggestions?
> (Weâ're aware that multi-select list boxes will be available in SSRS 2005,
> but that would still be a bit tiresome for a user that needs to select a few
> values from a long list).
> Regards,
> John Marsh
>
We have many reports which have input parameters that are lists of values.
As an example the user might want to report on 30 of 100 available product
codes, or 12 of 50,000 account numbers.
What might be an idea would be to store the lists of values that userâ's want
to report on, in a general purpose Lists table. One column would be a List
Name and the other a delimited list of values. This List table could then be
used as the input to a Drop Down box for the relevant report parameter.
Has anybody tried something similar, or does anyone have any other
suggestions?
(Weâ're aware that multi-select list boxes will be available in SSRS 2005,
but that would still be a bit tiresome for a user that needs to select a few
values from a long list).
Regards,
John MarshHi John,
I have done similar thing like that.
i have a lookup parameter report which is a webpage with listbox and the
value is populated by calling a param report. The param report contain 2
fileds and it like name- value pair. The report is called programttically and
the result is returned in xml format so that it can be bind to a dataset and
to tht listbox or dropdown box.
So this act as a lists of values as report parameter input..
Regards
Bava
"John Marsh" wrote:
> Has anyone come up with a solution for the following scenario yet?
> We have many reports which have input parameters that are lists of values.
> As an example the user might want to report on 30 of 100 available product
> codes, or 12 of 50,000 account numbers.
> What might be an idea would be to store the lists of values that userâ's want
> to report on, in a general purpose Lists table. One column would be a List
> Name and the other a delimited list of values. This List table could then be
> used as the input to a Drop Down box for the relevant report parameter.
> Has anybody tried something similar, or does anyone have any other
> suggestions?
> (Weâ're aware that multi-select list boxes will be available in SSRS 2005,
> but that would still be a bit tiresome for a user that needs to select a few
> values from a long list).
> Regards,
> John Marsh
>
Precompile asp.net and Reports bomb
If I publish a website in vs05 and Check "Allow this precompiled
website to be updatable", everything works.
If I uncheck the box, then the rdlc files get sent to the website
minus their guts, but with the standard placeholder text you see in
aspx files that are precompiled.
When you request a local report in your web page, it errors out:
An error occurred during local report processing.
The definition of the report 'Main Report' is invalid.
The report definition is not valid. Details: Data at the root level
is invalid. Line 1, position 1.
Any solution for this?
FYI -others
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=232869&SiteID=1Hi Chuck,
Thank you for posting.
Yes, as for the problem you mentioend, it does be an existing problem with
the VS 2005/ASP.NET 2.0 when we use the "publish web site" function with
"not updatable" option. Actually under such mode, the ASP.NET2.0 compiler
will precompile all the pages and other document stuffs in the application
directory and remove the code files (only put a dummy file in the target
directory). So files such as our custom rdlc file will also be corrupted in
such cases.
I've also had a look at the forum thread you mentioned, and that thread
does point out the workarounds we have currently.
#1 One is manually copy the original file to the target server to overwrite
the dummy one(produced by the compiler when using 'nonupdatable' option).
And to do this in VS 2005 IDE, you can consider use the "Copy Web Site"
function to update such individual file, this won't cause recompilation.
#2 Another option will be using automation script or batch build file to do
the precompilation work ( the aspnet_compiler.exe tool is the commandline
tool for precompiling asp.net website application), we can add additional
script to copy the correct rdlc file after the precompilation command
executed.
In addition, I think you can also post this issue in our msdn product
feedback site though some other members may already have pointed out this
issue:
http://lab.msdn.microsoft.com/productfeedback/default.aspx
Anyway, I'm sorry for the inconvenience this brings you as this does be a
big pain when there exists many static documents need publishing under
"non-updatable" precompiling option.
Thanks for your understanding.
Regards,
Steven Cheng
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi Chuck,
How are you doing on this or does the information I mentioned helps a
little on this? If there is still anything we can help, please feel free to
post here.
Regards,
Steven Cheng
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Anyone know if there's been any progress on getting this fixed
From http://developmentnow.com/g/115_2006_5_0_0_753708/Precompile-asp-net-and-Reports-bomb.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com|||Hi Steven
I usually precompiled my site with the aspnet_compiler (with not-updatable) option. Indeed the rdlc file was corrupted during this process ( 1 KB vs original 17 KB). Your fix #2(replacing the rdlc with the original rdlc file) worked well.
Thanks,
Ra
From http://developmentnow.com/g/115_2006_5_0_0_753708/Precompile-asp-net-and-Reports-bomb.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.comsql
website to be updatable", everything works.
If I uncheck the box, then the rdlc files get sent to the website
minus their guts, but with the standard placeholder text you see in
aspx files that are precompiled.
When you request a local report in your web page, it errors out:
An error occurred during local report processing.
The definition of the report 'Main Report' is invalid.
The report definition is not valid. Details: Data at the root level
is invalid. Line 1, position 1.
Any solution for this?
FYI -others
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=232869&SiteID=1Hi Chuck,
Thank you for posting.
Yes, as for the problem you mentioend, it does be an existing problem with
the VS 2005/ASP.NET 2.0 when we use the "publish web site" function with
"not updatable" option. Actually under such mode, the ASP.NET2.0 compiler
will precompile all the pages and other document stuffs in the application
directory and remove the code files (only put a dummy file in the target
directory). So files such as our custom rdlc file will also be corrupted in
such cases.
I've also had a look at the forum thread you mentioned, and that thread
does point out the workarounds we have currently.
#1 One is manually copy the original file to the target server to overwrite
the dummy one(produced by the compiler when using 'nonupdatable' option).
And to do this in VS 2005 IDE, you can consider use the "Copy Web Site"
function to update such individual file, this won't cause recompilation.
#2 Another option will be using automation script or batch build file to do
the precompilation work ( the aspnet_compiler.exe tool is the commandline
tool for precompiling asp.net website application), we can add additional
script to copy the correct rdlc file after the precompilation command
executed.
In addition, I think you can also post this issue in our msdn product
feedback site though some other members may already have pointed out this
issue:
http://lab.msdn.microsoft.com/productfeedback/default.aspx
Anyway, I'm sorry for the inconvenience this brings you as this does be a
big pain when there exists many static documents need publishing under
"non-updatable" precompiling option.
Thanks for your understanding.
Regards,
Steven Cheng
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi Chuck,
How are you doing on this or does the information I mentioned helps a
little on this? If there is still anything we can help, please feel free to
post here.
Regards,
Steven Cheng
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Anyone know if there's been any progress on getting this fixed
From http://developmentnow.com/g/115_2006_5_0_0_753708/Precompile-asp-net-and-Reports-bomb.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com|||Hi Steven
I usually precompiled my site with the aspnet_compiler (with not-updatable) option. Indeed the rdlc file was corrupted during this process ( 1 KB vs original 17 KB). Your fix #2(replacing the rdlc with the original rdlc file) worked well.
Thanks,
Ra
From http://developmentnow.com/g/115_2006_5_0_0_753708/Precompile-asp-net-and-Reports-bomb.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.comsql
Monday, March 26, 2012
PowerPoint format possible?
Hello,
we plan to use Reporting Services in the company in the near future. However, management prefers power point reports, a format which reporting services does not support (please correct me if I am wrong here).
Is there a third party extenstion tool for RS available which can produce PPT reports?
Best regards,
Michael Fuchs
Hello,I'm not aware of any third-party PowerPoint renderer.
Can you explain your scenario that calls for PowerPoint rendering? Any insight you can offer will help to justify the possibility of providing this functionality in the future.
Thanks,
Chris
Hello,
Management presents the reports in periodic meetings, currently pdf slides are used (these pdfs don't come from RS but from a self developed program), but this is not desired by management anymore, as pdf is not optimal for a presentation. What we need is nothing too fancy, just a slide with some formatting options (i.e. different templates) and the relevant charts and data presented on the slide.
I heard that ppt output is planned anyway in the next version of reporting services and that it already is in the testing stage. Is that just a rumor or can you confirm that?
Thanks,
Michael
Tuesday, March 20, 2012
POST Method
We've run into a rather sizable problem here.
When passing querystring values using GET, to our SQL Server Reporting Services Reports, we've discovered that we've exceeded the maximum URL length,.
We are thinking that we need to change how we're passing this data to our reports.
Can we use POST and transfer the data throught hte HTTP header and bypass this limitation?
Thanks.
Doug
Yes you can use a Post method. The following link is an example:
http://blogs.msdn.com/bryanke/articles/73153.aspx
Post Installation error with RS2000 on Win2000 Server
Hello,
I have installed RS2000 with no errors, but when i browse to localhost/Reports i get an RS error page that reads:
"An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
The profile for the user is a temporary profile.
I have checked the LogFiles (C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles) and the error message reads as follows:
aspnet_wp!ui!1608!22/03/2006-14:22:27:: e ERROR: System.Web.Services.Protocols.SoapException: An internal error occurred on the report server. See the error log for more details. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.Runtime.InteropServices.COMException (0x80090024): The profile for the user is a temporary profile.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32 errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String storedProcedureName)
at Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String key)
at Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String name)
at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at Microsoft.ReportingServices.Library.RSService.PathToInternal(String source)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String path, Boolean validate, Boolean convert, Boolean translate)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String path)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTranslator pathTranslator, String userSuppliedPath, String parameterName)
at Microsoft.ReportingServices.Library.RSService.GetPermissions(String item, StringCollection& Operations)
End of inner exception stack trace
at Microsoft.ReportingServices.Library.RSService.GetPermissions(String item, StringCollection& Operations)
at Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String Item, String[]& Permissions)
End of inner exception stack trace
at Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String Item, String[]& Permissions)
aspnet_wp!ui!1608!22/03/2006-14:22:27:: e ERROR: HTTP status code --> 200
-Details--
System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: An internal error occurred on the report server. See the error log for more details. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.Runtime.InteropServices.COMException (0x80090024): The profile for the user is a temporary profile.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32 errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String storedProcedureName)
at Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String key)
at Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String name)
at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at Microsoft.ReportingServices.Library.RSService.PathToInternal(String source)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String path, Boolean validate, Boolean convert, Boolean translate)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String path)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTranslator pathTranslator, String userSuppliedPath, String parameterName)
at Microsoft.ReportingServices.Library.RSService.GetPermissions(String item, StringCollection& Operations)
End of inner exception stack trace
at Microsoft.ReportingServices.Library.RSService.GetPermissions(String item, StringCollection& Operations)
at Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String Item, String[]& Permissions)
End of inner exception stack trace
at Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String Item, String[]& Permissions) at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Microsoft.SqlServer.ReportingServices.ReportingService.GetPermissions(String Item) at Microsoft.SqlServer.ReportingServices.RSConnection.GetPermissions(String Item) at Microsoft.ReportingServices.UI.Permissions.GetPermissions() at Microsoft.ReportingServices.UI.Permissions..ctor(String path) at Microsoft.ReportingServices.UI.Permissions.CurrentUser(String itemPath) at Microsoft.ReportingServices.UI.ReportingPage.get_RSUser() at Microsoft.ReportingServices.UI.FolderPage.Page_Init(Object sender, EventArgs e) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Control.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Page.ProcessRequestMain()
aspnet_wp!ui!1608!22/03/2006-14:22:28:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
Seen as how the only thing in this that makes any sense to me at all is the phrase "The profile for the user is a temporary profile", i assume that this has something significant to do with the problem. However, Knowing this, i'm still not sure what to do to fix it as i'm not a newtowork/server admin.
Also, this server is a domain controller on windows 2000 server with sp4
Can someone please help.
Robbie,
I'm running into the exact same error with the exact same scenario. Did you ever resolve this issue?
Thanks,
Beau Lynch
Post Installation error with RS2000 on Win2000 Server
Hello,
I have installed RS2000 with no errors, but when i browse to localhost/Reports i get an RS error page that reads:
"An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
The profile for the user is a temporary profile.
I have checked the LogFiles (C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles) and the error message reads as follows:
aspnet_wp!ui!1608!22/03/2006-14:22:27:: e ERROR: System.Web.Services.Protocols.SoapException: An internal error occurred on the report server. See the error log for more details. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.Runtime.InteropServices.COMException (0x80090024): The profile for the user is a temporary profile.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32 errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String storedProcedureName)
at Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String key)
at Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String name)
at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at Microsoft.ReportingServices.Library.RSService.PathToInternal(String source)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String path, Boolean validate, Boolean convert, Boolean translate)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String path)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTranslator pathTranslator, String userSuppliedPath, String parameterName)
at Microsoft.ReportingServices.Library.RSService.GetPermissions(String item, StringCollection& Operations)
End of inner exception stack trace
at Microsoft.ReportingServices.Library.RSService.GetPermissions(String item, StringCollection& Operations)
at Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String Item, String[]& Permissions)
End of inner exception stack trace
at Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String Item, String[]& Permissions)
aspnet_wp!ui!1608!22/03/2006-14:22:27:: e ERROR: HTTP status code --> 200
-Details--
System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: An internal error occurred on the report server. See the error log for more details. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.Runtime.InteropServices.COMException (0x80090024): The profile for the user is a temporary profile.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32 errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String storedProcedureName)
at Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String key)
at Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String name)
at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at Microsoft.ReportingServices.Library.RSService.PathToInternal(String source)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String path, Boolean validate, Boolean convert, Boolean translate)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String path)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTranslator pathTranslator, String userSuppliedPath, String parameterName)
at Microsoft.ReportingServices.Library.RSService.GetPermissions(String item, StringCollection& Operations)
End of inner exception stack trace
at Microsoft.ReportingServices.Library.RSService.GetPermissions(String item, StringCollection& Operations)
at Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String Item, String[]& Permissions)
End of inner exception stack trace
at Microsoft.ReportingServices.WebServer.ReportingService.GetPermissions(String Item, String[]& Permissions) at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Microsoft.SqlServer.ReportingServices.ReportingService.GetPermissions(String Item) at Microsoft.SqlServer.ReportingServices.RSConnection.GetPermissions(String Item) at Microsoft.ReportingServices.UI.Permissions.GetPermissions() at Microsoft.ReportingServices.UI.Permissions..ctor(String path) at Microsoft.ReportingServices.UI.Permissions.CurrentUser(String itemPath) at Microsoft.ReportingServices.UI.ReportingPage.get_RSUser() at Microsoft.ReportingServices.UI.FolderPage.Page_Init(Object sender, EventArgs e) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Control.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Page.ProcessRequestMain()
aspnet_wp!ui!1608!22/03/2006-14:22:28:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
Seen as how the only thing in this that makes any sense to me at all is the phrase "The profile for the user is a temporary profile", i assume that this has something significant to do with the problem. However, Knowing this, i'm still not sure what to do to fix it as i'm not a newtowork/server admin.
Also, this server is a domain controller on windows 2000 server with sp4
Can someone please help.
Robbie,
I'm running into the exact same error with the exact same scenario. Did you ever resolve this issue?
Thanks,
Beau Lynch
Monday, March 12, 2012
Possible to set http://localhost/Reports default start report?
SQL 2005
Is it possible to set a default start report? I have a report which contains hyperlinks to all the other reports, I'd like to just load this one by default when a user hits: http://machine/Reports
Is it possible to set a default start report? I have a report which contains hyperlinks to all the other reports, I'd like to just load this one by default when a user hits: http://machine/Reports
Perhaps I'm barking up the wrong tree and need to set this in IIS? I want users to still be able to make their way back to the /Reports folder lists also.
- Thanks in advanceI would rather set a new virtual directory with pointing / redirecting to the new folder than messing with the old settings. But with that there would be not point in returning to the main folder structure, unless you put it as a hyperlink inyour report.
HTH, jens Suessmeyer.
http://www.sqlserver2005.de
Friday, March 9, 2012
Possible to reuse the same SQL dataset in many reports?
Is it possible to create a SQL query and hook this up to more than one
report? I have several reports that are supposed to be standardized to be
deployed to different clients. We want to brand the reports with each
client's name. We can get the name from the SQL Server database that the
reports are using.
Is it possible to just create this dataset "somewhere" in my report project,
and have all reports get the data returned from this dataset? Or do I have
to add this dataset to all my reports?
Sincerely,
Kaisa M. Lindahlyou can do this by using a stored procedure
"Kaisa M. Lindahl" wrote:
> Is it possible to create a SQL query and hook this up to more than one
> report? I have several reports that are supposed to be standardized to be
> deployed to different clients. We want to brand the reports with each
> client's name. We can get the name from the SQL Server database that the
> reports are using.
> Is it possible to just create this dataset "somewhere" in my report project,
> and have all reports get the data returned from this dataset? Or do I have
> to add this dataset to all my reports?
> Sincerely,
> Kaisa M. Lindahl
>
>|||I found that the best way is to put all or most of your query into a stored
procedure or in-line table function on the server so it is easily accessible
from other reports.
"Kaisa M. Lindahl" wrote:
> Is it possible to create a SQL query and hook this up to more than one
> report? I have several reports that are supposed to be standardized to be
> deployed to different clients. We want to brand the reports with each
> client's name. We can get the name from the SQL Server database that the
> reports are using.
> Is it possible to just create this dataset "somewhere" in my report project,
> and have all reports get the data returned from this dataset? Or do I have
> to add this dataset to all my reports?
> Sincerely,
> Kaisa M. Lindahl
>
>|||DavidK or Antoon or someone else:
Can you please explain how to do it? I've looked at articles on the internet
and the "Hitchhiker's" book, and I can't figure out how to use Stored
Procedures properly.
I've managed to create a stored procedure. Unfortunately, this has to be a
sp with dynamic sql. It takes 2 parameters. When I'm testing it, it works
OK, but it doesn't return any fields. So none of the results show up in the
report at all.
Any clues, please? A short explanation or links to resources on the web is
OK. :)
Sincerely,
Kaisa
"DavidK" <DavidK@.discussions.microsoft.com> wrote in message
news:649C3B02-DA26-42EA-8F4E-FD3EB1D15361@.microsoft.com...
>I found that the best way is to put all or most of your query into a stored
> procedure or in-line table function on the server so it is easily
> accessible
> from other reports.
> "Kaisa M. Lindahl" wrote:
>> Is it possible to create a SQL query and hook this up to more than one
>> report? I have several reports that are supposed to be standardized to be
>> deployed to different clients. We want to brand the reports with each
>> client's name. We can get the name from the SQL Server database that the
>> reports are using.
>> Is it possible to just create this dataset "somewhere" in my report
>> project,
>> and have all reports get the data returned from this dataset? Or do I
>> have
>> to add this dataset to all my reports?
>> Sincerely,
>> Kaisa M. Lindahl
>>|||Although u create a Stored Procedure , u need to have a dataset in all
your reports which point to the stored procedure.
In short for every report there shall be a dataset|||"Vishu" <vishwasaj@.gmail.com> wrote in message
news:1121329763.408325.84730@.g43g2000cwa.googlegroups.com...
> Although u create a Stored Procedure , u need to have a dataset in all
> your reports which point to the stored procedure.
> In short for every report there shall be a dataset
Thanks. :)
I recreated the Stored Procedure without parameters. The SP needs to be
added manually to each database anyway, so I will change it to fit with the
database in the stored procedure, not have each report send the parameters.
Adding just one line of code as a dataset + adding a text box to the report
was a lot easier than expected.
In the end I wrote a blog post about it:
http://blogs.spipp.net/kaisa/archive/2005/07/12/1154.aspx
Kaisa M. Lindahl
report? I have several reports that are supposed to be standardized to be
deployed to different clients. We want to brand the reports with each
client's name. We can get the name from the SQL Server database that the
reports are using.
Is it possible to just create this dataset "somewhere" in my report project,
and have all reports get the data returned from this dataset? Or do I have
to add this dataset to all my reports?
Sincerely,
Kaisa M. Lindahlyou can do this by using a stored procedure
"Kaisa M. Lindahl" wrote:
> Is it possible to create a SQL query and hook this up to more than one
> report? I have several reports that are supposed to be standardized to be
> deployed to different clients. We want to brand the reports with each
> client's name. We can get the name from the SQL Server database that the
> reports are using.
> Is it possible to just create this dataset "somewhere" in my report project,
> and have all reports get the data returned from this dataset? Or do I have
> to add this dataset to all my reports?
> Sincerely,
> Kaisa M. Lindahl
>
>|||I found that the best way is to put all or most of your query into a stored
procedure or in-line table function on the server so it is easily accessible
from other reports.
"Kaisa M. Lindahl" wrote:
> Is it possible to create a SQL query and hook this up to more than one
> report? I have several reports that are supposed to be standardized to be
> deployed to different clients. We want to brand the reports with each
> client's name. We can get the name from the SQL Server database that the
> reports are using.
> Is it possible to just create this dataset "somewhere" in my report project,
> and have all reports get the data returned from this dataset? Or do I have
> to add this dataset to all my reports?
> Sincerely,
> Kaisa M. Lindahl
>
>|||DavidK or Antoon or someone else:
Can you please explain how to do it? I've looked at articles on the internet
and the "Hitchhiker's" book, and I can't figure out how to use Stored
Procedures properly.
I've managed to create a stored procedure. Unfortunately, this has to be a
sp with dynamic sql. It takes 2 parameters. When I'm testing it, it works
OK, but it doesn't return any fields. So none of the results show up in the
report at all.
Any clues, please? A short explanation or links to resources on the web is
OK. :)
Sincerely,
Kaisa
"DavidK" <DavidK@.discussions.microsoft.com> wrote in message
news:649C3B02-DA26-42EA-8F4E-FD3EB1D15361@.microsoft.com...
>I found that the best way is to put all or most of your query into a stored
> procedure or in-line table function on the server so it is easily
> accessible
> from other reports.
> "Kaisa M. Lindahl" wrote:
>> Is it possible to create a SQL query and hook this up to more than one
>> report? I have several reports that are supposed to be standardized to be
>> deployed to different clients. We want to brand the reports with each
>> client's name. We can get the name from the SQL Server database that the
>> reports are using.
>> Is it possible to just create this dataset "somewhere" in my report
>> project,
>> and have all reports get the data returned from this dataset? Or do I
>> have
>> to add this dataset to all my reports?
>> Sincerely,
>> Kaisa M. Lindahl
>>|||Although u create a Stored Procedure , u need to have a dataset in all
your reports which point to the stored procedure.
In short for every report there shall be a dataset|||"Vishu" <vishwasaj@.gmail.com> wrote in message
news:1121329763.408325.84730@.g43g2000cwa.googlegroups.com...
> Although u create a Stored Procedure , u need to have a dataset in all
> your reports which point to the stored procedure.
> In short for every report there shall be a dataset
Thanks. :)
I recreated the Stored Procedure without parameters. The SP needs to be
added manually to each database anyway, so I will change it to fit with the
database in the stored procedure, not have each report send the parameters.
Adding just one line of code as a dataset + adding a text box to the report
was a lot easier than expected.
In the end I wrote a blog post about it:
http://blogs.spipp.net/kaisa/archive/2005/07/12/1154.aspx
Kaisa M. Lindahl
Possible to make "Detail View" default in Report Mgr?
Is there a config file where this can be modified such that the views in http://SomeWebServer/Reports will be Details view by default?Still wondering about this. I reviewed the CSS one day for the site, but didn't see this in there.
Possible to make "Detail View" default in Report Mgr?
Is there a config file where this can be modified such that the views in http://SomeWebServer/Reports will be Details view by default?Still wondering about this. I reviewed the CSS one day for the site, but didn't see this in there.
Possible to have a "tabbed" report
I know you can do this in Crystal Reports but is it available in MSRS?You could simulate tabs with several data regions or subreports and a
document map to easily navigate to them.
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
<Gord.Drillon@.gmail.com> wrote in message
news:0acc5232-5d8b-4c5d-bd73-b5033d53d472@.d4g2000prg.googlegroups.com...
>I know you can do this in Crystal Reports but is it available in MSRS?
document map to easily navigate to them.
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
<Gord.Drillon@.gmail.com> wrote in message
news:0acc5232-5d8b-4c5d-bd73-b5033d53d472@.d4g2000prg.googlegroups.com...
>I know you can do this in Crystal Reports but is it available in MSRS?
Possible to grab Report Authors name to use in report?
Hi all,
We would like to put the Report Authors name in the footer of our reports. I
know there is a global "User!UserID" that picks up whoever runs the report,
but is it possible to pick up the windows logon, or something to
automatically fill in a field for report author?
Thanks
JHThere are two ways to do it...
:)
Of course, what you are asking, I have to make an assumption:
"The user that uploads the report or deploy's the report is the user that
created it"
Use the following T-SQL and have a dataset in your report get the author:
select * from reportserver.dbo.[catalog] cat
inner join reportserver.dbo.users usr
on (cat.createdbyid = usr.userid)
where name = @.ReportName
In the dataset properties - bind @.ReportName to the global property for the
report name.
The second way is if you want the TRUE author of the report and that they
have FILLED IN the author name field in report properties in the designer
AND then if you are using an application (as we are) to render the reports
instead of the web interface, you can get the report author by loading the
report properties for Author, then return the author name to pass it as a
parameter to your reports to be displayed:
Note: I have left out code -> I just wanted to show you how it is done to
give you just the necessary points:
' Create the property to retrieve.
Dim retrieveProp As New RSPolarisReports.[Property]
retrieveProp.Name = "Author"
Dim props(0) As RSPolarisReports.[Property]
props(0) = retrieveProp
Try
Dim properties As RSPolarisReports.[Property]() = rs.GetProperties(sPath,
props)
Catch e As Exception
bExists = False
End Try
=-Chris
"JH" <JH@.discussions.microsoft.com> wrote in message
news:58E724E9-12A4-4F95-B83E-578E9E9D64CA@.microsoft.com...
> Hi all,
> We would like to put the Report Authors name in the footer of our reports.
> I
> know there is a global "User!UserID" that picks up whoever runs the
> report,
> but is it possible to pick up the windows logon, or something to
> automatically fill in a field for report author?
> Thanks
> JH
>
We would like to put the Report Authors name in the footer of our reports. I
know there is a global "User!UserID" that picks up whoever runs the report,
but is it possible to pick up the windows logon, or something to
automatically fill in a field for report author?
Thanks
JHThere are two ways to do it...
:)
Of course, what you are asking, I have to make an assumption:
"The user that uploads the report or deploy's the report is the user that
created it"
Use the following T-SQL and have a dataset in your report get the author:
select * from reportserver.dbo.[catalog] cat
inner join reportserver.dbo.users usr
on (cat.createdbyid = usr.userid)
where name = @.ReportName
In the dataset properties - bind @.ReportName to the global property for the
report name.
The second way is if you want the TRUE author of the report and that they
have FILLED IN the author name field in report properties in the designer
AND then if you are using an application (as we are) to render the reports
instead of the web interface, you can get the report author by loading the
report properties for Author, then return the author name to pass it as a
parameter to your reports to be displayed:
Note: I have left out code -> I just wanted to show you how it is done to
give you just the necessary points:
' Create the property to retrieve.
Dim retrieveProp As New RSPolarisReports.[Property]
retrieveProp.Name = "Author"
Dim props(0) As RSPolarisReports.[Property]
props(0) = retrieveProp
Try
Dim properties As RSPolarisReports.[Property]() = rs.GetProperties(sPath,
props)
Catch e As Exception
bExists = False
End Try
=-Chris
"JH" <JH@.discussions.microsoft.com> wrote in message
news:58E724E9-12A4-4F95-B83E-578E9E9D64CA@.microsoft.com...
> Hi all,
> We would like to put the Report Authors name in the footer of our reports.
> I
> know there is a global "User!UserID" that picks up whoever runs the
> report,
> but is it possible to pick up the windows logon, or something to
> automatically fill in a field for report author?
> Thanks
> JH
>
Wednesday, March 7, 2012
Possible to create an OPTIONAL multi-value field that can be left empty?
Greetings,
I have several reports for which the user has asked to have an optional muti-value parameter. They want to be able to select zero, one, many, or all values in the parameter list. The parm list is created through a query and the values are not static.
I would like to allow the user to leave the muti-value field empty if they want to allow all values to appear on the report. I've read some discussion about populating a multi-value default with the same query that produces the multi-value list values - presto, everything is selected. However, this is not a desirable solution for me because I "echo" the users parameter selections in the report heading. Selecting all values (and some parms have a lot of values) would cause the "parm feedback" section to grow large and unreadable.
In short, I don't want to tell the user they have to select everything when they really want to select nothing.
Is there any way to have a muti-value parm that won't insist the user select one or more values?
Thanks,
BCB
Make your query which is populating your parameter to have another value "All" and make that as the default value instead of an empty value that indicates all.
Shyam
Possible to assign a value to a textbox?
Hi,
Is it possible to assign a value to a textbox when viewing reports, depending on certain values of the fields. E.g if Fields!Month.Value = Parameters!Month.Value, i want to display some message in the textbox.
Hi eeyore21
It is possible unless I'm not understanding the question correctly. Try this:
Select the textbox properties. In the 'Value: ' property select 'Expression' (button next to textbox)
type in '=IIF( Parameters!PamaterName.Value = Fields!FieldName.Value,"Print this if true","Print this if False")'
whereParameters!PamaterName.Value - this is the parameter value which you want to compare to Fields!FieldName.Value ( dataset field name)
In your case it would be :=IIF(Fields!Month.Value = Parameters!Month.Value,"IT IS TRUE DO SOMETHING","NOT TRUE DO SOMETHING ELSE")'
Is it possible to assign a value to a textbox when viewing reports, depending on certain values of the fields. E.g if Fields!Month.Value = Parameters!Month.Value, i want to display some message in the textbox.
Hi eeyore21
It is possible unless I'm not understanding the question correctly. Try this:
Select the textbox properties. In the 'Value: ' property select 'Expression' (button next to textbox)
type in '=IIF( Parameters!PamaterName.Value = Fields!FieldName.Value,"Print this if true","Print this if False")'
whereParameters!PamaterName.Value - this is the parameter value which you want to compare to Fields!FieldName.Value ( dataset field name)
In your case it would be :=IIF(Fields!Month.Value = Parameters!Month.Value,"IT IS TRUE DO SOMETHING","NOT TRUE DO SOMETHING ELSE")'
Possible SOAP version mismatch
Hi,
I am getting an error when I go to view my websites Report Manager. i go to
http://www.mysite.com/Reports (reports maps to the Report Manager folder).
when ever i go there i keep getting some generic Error Page. the only
information it has on there is: Possible SOAP version mismatch: Envelope
namespace http://schemas.xmlsoap.org/wsdl/ was unexpected. Expecting
http://schemas.xmlsoap.org/soap/envelope/.
I dont know how this has happened. Can anyone help me?
Thank you,
PaulHave you come up with a solution yet?
I have the same error. I had installed the Enterprise version of RS with
the database and report manager on one server - and applied SP1. I then
installed the Enterprise RS Report Manger on another machine and am using the
first server's SQL Server to house another instance of the Report Server DB.
Once installed, I get the 'SOAP version mismatch' error when trying to view
the Report Manager.
I tried upgrading to SP1, but still get the error. Anyone see this issue
before?
"Paul W" wrote:
> Hi,
> I am getting an error when I go to view my websites Report Manager. i go to
> http://www.mysite.com/Reports (reports maps to the Report Manager folder).
> when ever i go there i keep getting some generic Error Page. the only
> information it has on there is: Possible SOAP version mismatch: Envelope
> namespace http://schemas.xmlsoap.org/wsdl/ was unexpected. Expecting
> http://schemas.xmlsoap.org/soap/envelope/.
> I dont know how this has happened. Can anyone help me?
> Thank you,
> Paul
>
>|||I also have the same error. Were you able to find out what the answer is?
If you haven't I'll break down and pay Microsoft for the answer and then post
it here. Can you please reply.
"Paul W" wrote:
> Hi,
> I am getting an error when I go to view my websites Report Manager. i go to
> http://www.mysite.com/Reports (reports maps to the Report Manager folder).
> when ever i go there i keep getting some generic Error Page. the only
> information it has on there is: Possible SOAP version mismatch: Envelope
> namespace http://schemas.xmlsoap.org/wsdl/ was unexpected. Expecting
> http://schemas.xmlsoap.org/soap/envelope/.
> I dont know how this has happened. Can anyone help me?
> Thank you,
> Paul
>
>|||I had some other staff work this issue out on the server side and will need
to double check with them for the exact solution. But, if I remember
correctly, it had something to do with the server name being uppercase - but
RS was trying to access it using all lowercase letters (or vice versa).
I'll see if I can get the exact story posted.
-mike
"Shane McEwan" wrote:
> I also have the same error. Were you able to find out what the answer is?
> If you haven't I'll break down and pay Microsoft for the answer and then post
> it here. Can you please reply.
> "Paul W" wrote:
> > Hi,
> > I am getting an error when I go to view my websites Report Manager. i go to
> > http://www.mysite.com/Reports (reports maps to the Report Manager folder).
> > when ever i go there i keep getting some generic Error Page. the only
> > information it has on there is: Possible SOAP version mismatch: Envelope
> > namespace http://schemas.xmlsoap.org/wsdl/ was unexpected. Expecting
> > http://schemas.xmlsoap.org/soap/envelope/.
> >
> > I dont know how this has happened. Can anyone help me?
> > Thank you,
> > Paul
> >
> >
> >
I am getting an error when I go to view my websites Report Manager. i go to
http://www.mysite.com/Reports (reports maps to the Report Manager folder).
when ever i go there i keep getting some generic Error Page. the only
information it has on there is: Possible SOAP version mismatch: Envelope
namespace http://schemas.xmlsoap.org/wsdl/ was unexpected. Expecting
http://schemas.xmlsoap.org/soap/envelope/.
I dont know how this has happened. Can anyone help me?
Thank you,
PaulHave you come up with a solution yet?
I have the same error. I had installed the Enterprise version of RS with
the database and report manager on one server - and applied SP1. I then
installed the Enterprise RS Report Manger on another machine and am using the
first server's SQL Server to house another instance of the Report Server DB.
Once installed, I get the 'SOAP version mismatch' error when trying to view
the Report Manager.
I tried upgrading to SP1, but still get the error. Anyone see this issue
before?
"Paul W" wrote:
> Hi,
> I am getting an error when I go to view my websites Report Manager. i go to
> http://www.mysite.com/Reports (reports maps to the Report Manager folder).
> when ever i go there i keep getting some generic Error Page. the only
> information it has on there is: Possible SOAP version mismatch: Envelope
> namespace http://schemas.xmlsoap.org/wsdl/ was unexpected. Expecting
> http://schemas.xmlsoap.org/soap/envelope/.
> I dont know how this has happened. Can anyone help me?
> Thank you,
> Paul
>
>|||I also have the same error. Were you able to find out what the answer is?
If you haven't I'll break down and pay Microsoft for the answer and then post
it here. Can you please reply.
"Paul W" wrote:
> Hi,
> I am getting an error when I go to view my websites Report Manager. i go to
> http://www.mysite.com/Reports (reports maps to the Report Manager folder).
> when ever i go there i keep getting some generic Error Page. the only
> information it has on there is: Possible SOAP version mismatch: Envelope
> namespace http://schemas.xmlsoap.org/wsdl/ was unexpected. Expecting
> http://schemas.xmlsoap.org/soap/envelope/.
> I dont know how this has happened. Can anyone help me?
> Thank you,
> Paul
>
>|||I had some other staff work this issue out on the server side and will need
to double check with them for the exact solution. But, if I remember
correctly, it had something to do with the server name being uppercase - but
RS was trying to access it using all lowercase letters (or vice versa).
I'll see if I can get the exact story posted.
-mike
"Shane McEwan" wrote:
> I also have the same error. Were you able to find out what the answer is?
> If you haven't I'll break down and pay Microsoft for the answer and then post
> it here. Can you please reply.
> "Paul W" wrote:
> > Hi,
> > I am getting an error when I go to view my websites Report Manager. i go to
> > http://www.mysite.com/Reports (reports maps to the Report Manager folder).
> > when ever i go there i keep getting some generic Error Page. the only
> > information it has on there is: Possible SOAP version mismatch: Envelope
> > namespace http://schemas.xmlsoap.org/wsdl/ was unexpected. Expecting
> > http://schemas.xmlsoap.org/soap/envelope/.
> >
> > I dont know how this has happened. Can anyone help me?
> > Thank you,
> > Paul
> >
> >
> >
Possible self-join question
Suppose I have a table of employees, and who each one reports to, like so:
EmployeeID ManagerID EmployeeName
1 Caroline
2 1 Teresa
3 2 John
4 2 Brent
5 3 Sherry
6 5 Rudy
Ok, so what I need to happen is, suppose I run a query on Employee #2,
Teresa Switzer. What I need to see are all employees that ultimately report
up to her (her employees, her employees' employees, and so on). So in my
results I should see John, Brent, Sherry, and Rudy, since all those employee
report to someone who eventually reports to Teresa. If I were to query on
Employee #3, John Maxwell, I'd see just Sherry and Rudy. Does anyone have an
y
ideas how to make this happen?
Many thanks for any suggestions.In SQL 2005 use a Common Table Expression (there are several good examples i
n
Books Online) , for SQL 2000 take a look at this example:
http://milambda.blogspot.com/2005/0...or-monkeys.html
ML
http://milambda.blogspot.com/|||ML - you rock. I think this example does exactly what I need. Thanks so much
for the help.
"ML" wrote:
> In SQL 2005 use a Common Table Expression (there are several good examples
in
> Books Online) , for SQL 2000 take a look at this example:
> http://milambda.blogspot.com/2005/0...or-monkeys.html
>
> ML
> --
> http://milambda.blogspot.com/|||You make me blush. :)
ML
http://milambda.blogspot.com/
EmployeeID ManagerID EmployeeName
1 Caroline
2 1 Teresa
3 2 John
4 2 Brent
5 3 Sherry
6 5 Rudy
Ok, so what I need to happen is, suppose I run a query on Employee #2,
Teresa Switzer. What I need to see are all employees that ultimately report
up to her (her employees, her employees' employees, and so on). So in my
results I should see John, Brent, Sherry, and Rudy, since all those employee
report to someone who eventually reports to Teresa. If I were to query on
Employee #3, John Maxwell, I'd see just Sherry and Rudy. Does anyone have an
y
ideas how to make this happen?
Many thanks for any suggestions.In SQL 2005 use a Common Table Expression (there are several good examples i
n
Books Online) , for SQL 2000 take a look at this example:
http://milambda.blogspot.com/2005/0...or-monkeys.html
ML
http://milambda.blogspot.com/|||ML - you rock. I think this example does exactly what I need. Thanks so much
for the help.
"ML" wrote:
> In SQL 2005 use a Common Table Expression (there are several good examples
in
> Books Online) , for SQL 2000 take a look at this example:
> http://milambda.blogspot.com/2005/0...or-monkeys.html
>
> ML
> --
> http://milambda.blogspot.com/|||You make me blush. :)
ML
http://milambda.blogspot.com/
Saturday, February 25, 2012
Possible BUG: SP2 Printing Linked Reports in Report Manager
Hello,
I may have discovered a possible bug with the new SP2 Client Printing
capabilities.
To reproduce:
1) Create a report with margins of 0.3in top, left, bottom and right, and
page size of 8.5 x 11 (standard US letter size)
2) Deploy the report to Report Manager
3) Confirm that client printing respects margins set in report. Click on
the print button, click on Print Preview, click on Margins, you should now
see 0.3in margins all around
4) Create a linked report by going to Properties and clicking Create Link
Report button.
5) Click on the print button, click on Print Preview, click on Margins, you
should now see 0.5in margins all around, instead of 0.3in. This does not
occur while exporting linked report to PDF format.
I confirmed this behaviour numerous times, and it's not only with margin but
also with page-layout. Is there a work-around?
Many thanks,
EdgarThe work around is to call SetProperties for the linked report, setting the
PageHeight, PageWidth, TopMargin, BottomMargin, LeftMargin and RightMargin
to the values you wish. All values should be expressed in mm.
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Edgar Allik" <Edgar Allik@.discussions.microsoft.com> wrote in message
news:0F3C537B-ECBF-4B69-BCE3-BFF8143B7BED@.microsoft.com...
> Hello,
> I may have discovered a possible bug with the new SP2 Client Printing
> capabilities.
> To reproduce:
> 1) Create a report with margins of 0.3in top, left, bottom and right, and
> page size of 8.5 x 11 (standard US letter size)
> 2) Deploy the report to Report Manager
> 3) Confirm that client printing respects margins set in report. Click on
> the print button, click on Print Preview, click on Margins, you should now
> see 0.3in margins all around
> 4) Create a linked report by going to Properties and clicking Create Link
> Report button.
> 5) Click on the print button, click on Print Preview, click on Margins,
> you
> should now see 0.5in margins all around, instead of 0.3in. This does not
> occur while exporting linked report to PDF format.
> I confirmed this behaviour numerous times, and it's not only with margin
> but
> also with page-layout. Is there a work-around?
> Many thanks,
> Edgar
>|||Hi, I am also experiencing the same error in SP2 where the page layout
properties don't seem to be set as they should be in a linked report.
I'm presuming "call SetProperties" is done via code - is there a work
around or way of doing this via Report Manager to fix this problem?
I'm not using any code with my reports, just URL access.
Thanks
Jeanine
Daniel Reib (MSFT) wrote:
> The work around is to call SetProperties for the linked report,
setting the
> PageHeight, PageWidth, TopMargin, BottomMargin, LeftMargin and
RightMargin
> to the values you wish. All values should be expressed in mm.
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Edgar Allik" <Edgar Allik@.discussions.microsoft.com> wrote in
message
> news:0F3C537B-ECBF-4B69-BCE3-BFF8143B7BED@.microsoft.com...
> > Hello,
> >
> > I may have discovered a possible bug with the new SP2 Client
Printing
> > capabilities.
> >
> > To reproduce:
> > 1) Create a report with margins of 0.3in top, left, bottom and
right, and
> > page size of 8.5 x 11 (standard US letter size)
> > 2) Deploy the report to Report Manager
> > 3) Confirm that client printing respects margins set in report.
Click on
> > the print button, click on Print Preview, click on Margins, you
should now
> > see 0.3in margins all around
> > 4) Create a linked report by going to Properties and clicking
Create Link
> > Report button.
> > 5) Click on the print button, click on Print Preview, click on
Margins,
> > you
> > should now see 0.5in margins all around, instead of 0.3in. This
does not
> > occur while exporting linked report to PDF format.
> >
> > I confirmed this behaviour numerous times, and it's not only with
margin
> > but
> > also with page-layout. Is there a work-around?
> >
> > Many thanks,
> >
> > Edgar
> >
I may have discovered a possible bug with the new SP2 Client Printing
capabilities.
To reproduce:
1) Create a report with margins of 0.3in top, left, bottom and right, and
page size of 8.5 x 11 (standard US letter size)
2) Deploy the report to Report Manager
3) Confirm that client printing respects margins set in report. Click on
the print button, click on Print Preview, click on Margins, you should now
see 0.3in margins all around
4) Create a linked report by going to Properties and clicking Create Link
Report button.
5) Click on the print button, click on Print Preview, click on Margins, you
should now see 0.5in margins all around, instead of 0.3in. This does not
occur while exporting linked report to PDF format.
I confirmed this behaviour numerous times, and it's not only with margin but
also with page-layout. Is there a work-around?
Many thanks,
EdgarThe work around is to call SetProperties for the linked report, setting the
PageHeight, PageWidth, TopMargin, BottomMargin, LeftMargin and RightMargin
to the values you wish. All values should be expressed in mm.
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Edgar Allik" <Edgar Allik@.discussions.microsoft.com> wrote in message
news:0F3C537B-ECBF-4B69-BCE3-BFF8143B7BED@.microsoft.com...
> Hello,
> I may have discovered a possible bug with the new SP2 Client Printing
> capabilities.
> To reproduce:
> 1) Create a report with margins of 0.3in top, left, bottom and right, and
> page size of 8.5 x 11 (standard US letter size)
> 2) Deploy the report to Report Manager
> 3) Confirm that client printing respects margins set in report. Click on
> the print button, click on Print Preview, click on Margins, you should now
> see 0.3in margins all around
> 4) Create a linked report by going to Properties and clicking Create Link
> Report button.
> 5) Click on the print button, click on Print Preview, click on Margins,
> you
> should now see 0.5in margins all around, instead of 0.3in. This does not
> occur while exporting linked report to PDF format.
> I confirmed this behaviour numerous times, and it's not only with margin
> but
> also with page-layout. Is there a work-around?
> Many thanks,
> Edgar
>|||Hi, I am also experiencing the same error in SP2 where the page layout
properties don't seem to be set as they should be in a linked report.
I'm presuming "call SetProperties" is done via code - is there a work
around or way of doing this via Report Manager to fix this problem?
I'm not using any code with my reports, just URL access.
Thanks
Jeanine
Daniel Reib (MSFT) wrote:
> The work around is to call SetProperties for the linked report,
setting the
> PageHeight, PageWidth, TopMargin, BottomMargin, LeftMargin and
RightMargin
> to the values you wish. All values should be expressed in mm.
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Edgar Allik" <Edgar Allik@.discussions.microsoft.com> wrote in
message
> news:0F3C537B-ECBF-4B69-BCE3-BFF8143B7BED@.microsoft.com...
> > Hello,
> >
> > I may have discovered a possible bug with the new SP2 Client
Printing
> > capabilities.
> >
> > To reproduce:
> > 1) Create a report with margins of 0.3in top, left, bottom and
right, and
> > page size of 8.5 x 11 (standard US letter size)
> > 2) Deploy the report to Report Manager
> > 3) Confirm that client printing respects margins set in report.
Click on
> > the print button, click on Print Preview, click on Margins, you
should now
> > see 0.3in margins all around
> > 4) Create a linked report by going to Properties and clicking
Create Link
> > Report button.
> > 5) Click on the print button, click on Print Preview, click on
Margins,
> > you
> > should now see 0.5in margins all around, instead of 0.3in. This
does not
> > occur while exporting linked report to PDF format.
> >
> > I confirmed this behaviour numerous times, and it's not only with
margin
> > but
> > also with page-layout. Is there a work-around?
> >
> > Many thanks,
> >
> > Edgar
> >
Possible bug with excel export
We're having a problem with the excel export in one of our reports. The data region in the report is filtered by the value of a parameter chosen by the user. Everything displays and works fine until it is exported to excel. When a user does this it outputs the results for the same parameter no matter what parameter is actually selected. It's specifically related to the excel export because every other one works as expected. Can anyone reproduce this problem?Are you running the latest service pack?
Can you try copying the report to another report & then exporting?|||This is actually in 2005. Copying the report to another one doesn't help and unfortunately we don't have our new test server in yet to try it on another machine.
Can you try copying the report to another report & then exporting?|||This is actually in 2005. Copying the report to another one doesn't help and unfortunately we don't have our new test server in yet to try it on another machine.
Monday, February 20, 2012
positioning text object dynamically
I want to set the position of a text / field object in a Crystal reports during runtimeu can do it with the help of front end.|||create object of textobject type and use their properties in front end application
Subscribe to:
Posts (Atom)