Friday, March 30, 2012
i Get rsReportServerNotActivated error message although it is activated.
I get this error when I want to view a report in a browser:
Reporting Services Error
----
--
The report server installation is not initialized. Check the documentation
for more information. (rsReportServerNotActivated) Get Online Help
----
--
Microsoft Reporting Services
But when I run rsactivate I get the following message:
Failure initializing remote NT Service:
The service is already activated
Any suggestions?
My OS is WinXP Pro if it is of any use.Problem solved - uninstall an re-install did the trick.
"Howzit" <hrbotha@.absa.co.za> wrote in message
news:OW2Sn8PZEHA.3016@.tk2msftngp13.phx.gbl...
> Hi
> I get this error when I want to view a report in a browser:
> Reporting Services Error
> ----
--
> --
> The report server installation is not initialized. Check the documentation
> for more information. (rsReportServerNotActivated) Get Online Help
> ----
--
> --
> Microsoft Reporting Services
> But when I run rsactivate I get the following message:
> Failure initializing remote NT Service:
> The service is already activated
> Any suggestions?
> My OS is WinXP Pro if it is of any use.
>
Wednesday, March 28, 2012
I don't understand why is nothing is always evaluated to false
= iif ( Fields!Package_Pack_Value is Nothing, "<Null>", Str ( Fields!Package_Pack_Value.Value ) & " " & Fields!Package_Pack_Unit.Value )
I have read all the forum and search a whole day but nothing...
Maybe is the answer very stupid...
If anyone can help me it would be appreciatedCStr to convert
And try this
ISNULL(Fields!Package_Pack_Value)
|||IsNull is not defined in the Micorsoft.VisualBasic namespace and it give compiling error tryng to use it.
But you give me a part of the answer using CStr :
= iif ( CSTR(Fields!Package_Pack_Value.Value) = "", "<null>", CStr ( Fields!Package_Pack_Value.Value ) & " " & Fields!Package_Pack_Unit.Value )
This give well "<null>" when Fields!Package_Pack_Unit.Value is null.
Thank To you VectorR3|||
You need to use IsNothing(). We convert nulls to empty objects. Does this not work?
=iif ( IsNothing(Fields!Package_Pack_Value.Value), "<null>", CStr ( Fields!Package_Pack_Value.Value ) & " " & Fields!Package_Pack_Unit.Value )
sqlI dont see rendered report.
Hello, when I navigate to this url I can see the report, with the parameters toolbar.
http://agamenon:90/Reports/Pages/Report.aspx?ItemPath=%2fGescomRpts%2fRPT_EvaluacionRequisitos
But when I try to do it with reportviewer; I see the report parameters, then I click Generate Report, and I dont see nothing.
private
void cargarReporte(){
string reportserver =ConfigurationSettings.AppSettings["ReportServer"].ToString();string reportfolder =ConfigurationSettings.AppSettings["ReportFolder"].ToString();int NmCiclo =Convert.ToInt32(Request.QueryString["NmCiclo"]);int NmEmpresa =Convert.ToInt32(Request.QueryString["NmEmpresa"]);int NmCargoEvaluada =Convert.ToInt32(Request.QueryString["NmCargoEvaluada"]);int NmPersonaEvaluada =Convert.ToInt32(Request.QueryString["NmPersonaEvaluada"]);rptviewer.ServerReport.ReportServerUrl =
newUri(reportserver);rptviewer.ServerReport.ReportPath = reportfolder +
"RPT_EvaluacionRequisitos";rptviewer.ShowParameterPrompts =
true;}
I had a similar problem. It was caused by setting the height attribute of the ReportViewer web control to "100%" and using asynchronous rendering. Apparently there is a bug in the way the report table is rendered when the height is a percent (http://msdn2.microsoft.com/en-us/library/ms252090.aspx). I changed to synchronous rendering and everything worked fine.
Ojala que esto le ayudaba.
Mike
|||I have the same issue but I set it to FALSE and my reports that have parameters still don't display after I click on the View Report button. However if I run reports that do not have parameters they generate.|||Hi,Even Iam facing the same problem , did u get any solution? please let me know..
I do want Collapsed Columns (+/-) to export in excel.
I have a simple requirement, I do want to show columns in collapsed
mode(with +/-) when it is exported to excel.
i.e I have some groups in report and by default they are in collapsed mode,
so when we click on export to excel, data in excel also shows with +/- which
I don't want.
Any idea how this expected behaviour can be changed for export funtionality ?
--
SanjayIn a tricky way, you can create a copy of the same report with expanded items.
In your main report create an "Action" and put this report. name the box as
"Save as Excel" ofcourse you need to give in URL access.
Otherwise what you see is what you export.
Amarnath
"Sanjay" wrote:
> Hi,
> I have a simple requirement, I do want to show columns in collapsed
> mode(with +/-) when it is exported to excel.
> i.e I have some groups in report and by default they are in collapsed mode,
> so when we click on export to excel, data in excel also shows with +/- which
> I don't want.
> Any idea how this expected behaviour can be changed for export funtionality ?
> --
> Sanjay
Monday, March 26, 2012
I changed a report name, and get error "Execution 'fralkj45eeyh0te5opip4455' cannot be fo
hi
What I did is in VS2005, right click the report name, change it and then rebuilt it, deploy it. And then go to Report Manager, I can see the new one, but when i run it, it shows this error:
thanks.
It should be fine after changing the name.
I delete it from report manager, and re-build, delopy to the report server, then it works fine.
I can't show a calculated member
Reports works fine with calculated measures, but when you try to use a calculated member then raises an error which says The following system error ocurred. Invalid procedure call or argument.
Any ideas?
Can I use calculated members?
I'm using RS 2005 April CTP.
Thanks in advance.I would very much recommend moving to the June CTP. Many things are more stable, including Analysis Services. There is no reason why calculated members shouldn't work.|||Using the Sept CTP, when I create a data source that includes a hierarchy that includes a calculated member, I get an error message approximately "Encountered a set that cannot include a calculated member".
So it seems, there is a real issue here not solved by recent releases.|||
I also am having difficulties with calculated members using the Eval version of AS2005 and RS2005.
1) I am sure that everyone knows about this error: Add a calculated member (in BI Management Studio or RS), choose a parent heirarchy other than Measures, choose a parent member. If the dimension and hierarchy were both called Stock then the parent hierarchy would be Stock.Stock and the parent member would be [Stock].[Stock]. An error is given when the script/query is run. Changing to text mode shows that the designer form has placed an extra level in the WITH/CREATE MEMBER statement, ie [Stock].[Stock].[Stock].[Stock].[Calculated Member Name]. I worked out that you could work around this by deleting one of the repeated levels, BUT in RS, some extra problems arise: 1a) I can't change back to form mode because my query will be lost and, 1b) If I try to add this calculated member to my set of displayed members, it simply won't show.
2) I attempted to get around the problems described above by creating the same calculated member in the source cube. When I try to include it I get the same error about "Encoutered a set that cannot contain calculated members". This error also occurs if I paste the same RS built query into SQL Mgmt Studio. Is it possible to use calculated members that are not Measures in RS?
3) I have another problem which is related to the fact that RS can't accept anything but Measures for the columns of the query. My fact table has only one value column and hence my cube has only one Measure. Is there any way of making the RS query return multiple value columns if the source is a cube with only one Measure?
Anybody got any ideas?
Aranda
|||We submitted an issue with MS about this and were told that this was by design. If I remember correctly, it had something to do with how RS uses a subcube and calc members not being supported in subcubes.|||On your point #3, our cubes are constructed the same way.
I was able to solve this (sort of) by creating calculated members on the measures dimension that picked up data from other dimensions -- that is, I used calculated members to pivot the data. It's quite tedious, but effective. However there are some limitations I found:
a. those calculated members don't rollup to higher levels very well
b. I frequently encountered an unsecified "query error" when running the data. the e rror appears to be data-dependant but I haven't been able to track it down.
My bottom line is that RS really can't be used effectively with AS because of the following limitations:
1. Only measures as columns and pivoting measures are unstable
2. You really can't effectively use a cube that has any calculated members defined in any dimiension other than measures. So If you put in a CM on a dimension for some other use, you have contaminated that dimension and it can't be used in RS. Further, RS's reliance on subqueries renders CM's useless.
So these two facts tell me that microsoft has broken its promise (?) that AS would be a general platform whose results can be accessed by a multitude of applications. If you want to use AS with RS, you have to get rid of all Calculated members and calculated cells (except on measures dimension). (btw calculated cells fly below the radar on RS -- so it won't mask them out -- but the calculations don't work if you're using subqueries). Combine this with the fact that MS has eliminated the ability to create a calculated member in a query that has a solve order lower than one in the cube and have those calculations executed inthe proper sequence. So really, MS is telling us that calculated members do not belong in cubes -- only at the query level. what a giant take-away that is.
|||
Thank's Stan H for your useful reply, but it looks like the situation is as I feared. My bottom line is pretty much the same as yours - it really is a massive take-away because calculated members are pretty much what makes cubes worthwile for me.
I will give pivoting measures a try but it doesn't sound too hopeful.
|||The 'A set has been encountered that cannot contain calculated members' error comes when you try to slice by a set which contains a calculated member in the RS MDX query designer (I've not had any problems putting calculated members on rows in my queries in the RTM version), and as has already been said it's to do with the fact that RS uses subcubes to do its filtering. You can get round this limitation by editing the MDX directly, though, and although you then lose the ability to use the query designer you can at least get your queries to run...
Here's an example in Adventure Works. Say I've got a hierarchy created by the Time Intelligence Wizard on the Date dimension called [Calendar Date Calculations], with one calculated member on it called [Year to Date]. If you try to slice by this member you get the aforementioned error; switching to view the MDX, you see something like this:
SELECT NON EMPTY { [Measures].[Internet Order Count] }
ON COLUMNS,
NON EMPTY { ([Date].[Calendar].[Calendar Semester].ALLMEMBERS ) }
DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME
ON ROWS
FROM
( SELECT ( { [Date].[Calendar Date Calculations].[Year to Date] } ) ON COLUMNS FROM [Adventure Works]) WHERE ( [Date].[Calendar Date Calculations].[Year to Date] )
CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS
To get the desired effect, you need to edit the query to replace the subcube filter with a standard WHERE clause filter:
SELECT NON EMPTY { [Measures].[Internet Order Count] }
ON COLUMNS,
NON EMPTY { ([Date].[Calendar].[Calendar Semester].ALLMEMBERS ) }
DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME
ON ROWS
FROM [Adventure Works]
WHERE ( [Date].[Calendar Date Calculations].[Year to Date] )
CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS
In my experience you can almost always write MDX to make RS do what you want, but I 100% agree that RS shouldn't expect you to do this and the MDX query designer should be able to handle this particular scenario.
HTH,
Chris
|||
Thanks Chris, that was quite helpful.
I wish there was a way to instruct the query builder to avoid subqueries. I am finding their limitations to overwhelm their value.
I can't show a calculated member
Reports works fine with calculated measures, but when you try to use a calculated member then raises an error which says The following system error ocurred. Invalid procedure call or argument.
Any ideas?
Can I use calculated members?
I'm using RS 2005 April CTP.
Thanks in advance.I would very much recommend moving to the June CTP. Many things are more stable, including Analysis Services. There is no reason why calculated members shouldn't work.|||Using the Sept CTP, when I create a data source that includes a hierarchy that includes a calculated member, I get an error message approximately "Encountered a set that cannot include a calculated member".
So it seems, there is a real issue here not solved by recent releases.
|||
I also am having difficulties with calculated members using the Eval version of AS2005 and RS2005.
1) I am sure that everyone knows about this error: Add a calculated member (in BI Management Studio or RS), choose a parent heirarchy other than Measures, choose a parent member. If the dimension and hierarchy were both called Stock then the parent hierarchy would be Stock.Stock and the parent member would be [Stock].[Stock]. An error is given when the script/query is run. Changing to text mode shows that the designer form has placed an extra level in the WITH/CREATE MEMBER statement, ie [Stock].[Stock].[Stock].[Stock].[Calculated Member Name]. I worked out that you could work around this by deleting one of the repeated levels, BUT in RS, some extra problems arise: 1a) I can't change back to form mode because my query will be lost and, 1b) If I try to add this calculated member to my set of displayed members, it simply won't show.
2) I attempted to get around the problems described above by creating the same calculated member in the source cube. When I try to include it I get the same error about "Encoutered a set that cannot contain calculated members". This error also occurs if I paste the same RS built query into SQL Mgmt Studio. Is it possible to use calculated members that are not Measures in RS?
3) I have another problem which is related to the fact that RS can't accept anything but Measures for the columns of the query. My fact table has only one value column and hence my cube has only one Measure. Is there any way of making the RS query return multiple value columns if the source is a cube with only one Measure?
Anybody got any ideas?
Aranda
|||We submitted an issue with MS about this and were told that this was by design. If I remember correctly, it had something to do with how RS uses a subcube and calc members not being supported in subcubes.|||On your point #3, our cubes are constructed the same way.
I was able to solve this (sort of) by creating calculated members on the measures dimension that picked up data from other dimensions -- that is, I used calculated members to pivot the data. It's quite tedious, but effective. However there are some limitations I found:
a. those calculated members don't rollup to higher levels very well
b. I frequently encountered an unsecified "query error" when running the data. the e rror appears to be data-dependant but I haven't been able to track it down.
My bottom line is that RS really can't be used effectively with AS because of the following limitations:
1. Only measures as columns and pivoting measures are unstable
2. You really can't effectively use a cube that has any calculated members defined in any dimiension other than measures. So If you put in a CM on a dimension for some other use, you have contaminated that dimension and it can't be used in RS. Further, RS's reliance on subqueries renders CM's useless.
So these two facts tell me that microsoft has broken its promise (?) that AS would be a general platform whose results can be accessed by a multitude of applications. If you want to use AS with RS, you have to get rid of all Calculated members and calculated cells (except on measures dimension). (btw calculated cells fly below the radar on RS -- so it won't mask them out -- but the calculations don't work if you're using subqueries). Combine this with the fact that MS has eliminated the ability to create a calculated member in a query that has a solve order lower than one in the cube and have those calculations executed inthe proper sequence. So really, MS is telling us that calculated members do not belong in cubes -- only at the query level. what a giant take-away that is.
|||
Thank's Stan H for your useful reply, but it looks like the situation is as I feared. My bottom line is pretty much the same as yours - it really is a massive take-away because calculated members are pretty much what makes cubes worthwile for me.
I will give pivoting measures a try but it doesn't sound too hopeful.
|||The 'A set has been encountered that cannot contain calculated members' error comes when you try to slice by a set which contains a calculated member in the RS MDX query designer (I've not had any problems putting calculated members on rows in my queries in the RTM version), and as has already been said it's to do with the fact that RS uses subcubes to do its filtering. You can get round this limitation by editing the MDX directly, though, and although you then lose the ability to use the query designer you can at least get your queries to run...
Here's an example in Adventure Works. Say I've got a hierarchy created by the Time Intelligence Wizard on the Date dimension called [Calendar Date Calculations], with one calculated member on it called [Year to Date]. If you try to slice by this member you get the aforementioned error; switching to view the MDX, you see something like this:
SELECT NON EMPTY { [Measures].[Internet Order Count] }
ON COLUMNS,
NON EMPTY { ([Date].[Calendar].[Calendar Semester].ALLMEMBERS ) }
DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME
ON ROWS
FROM
( SELECT ( { [Date].[Calendar Date Calculations].[Year to Date] } ) ON COLUMNS FROM [Adventure Works]) WHERE ( [Date].[Calendar Date Calculations].[Year to Date] )
CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS
To get the desired effect, you need to edit the query to replace the subcube filter with a standard WHERE clause filter:
SELECT NON EMPTY { [Measures].[Internet Order Count] }
ON COLUMNS,
NON EMPTY { ([Date].[Calendar].[Calendar Semester].ALLMEMBERS ) }
DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME
ON ROWS
FROM [Adventure Works]
WHERE ( [Date].[Calendar Date Calculations].[Year to Date] )
CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS
In my experience you can almost always write MDX to make RS do what you want, but I 100% agree that RS shouldn't expect you to do this and the MDX query designer should be able to handle this particular scenario.
HTH,
Chris
|||
Thanks Chris, that was quite helpful.
I wish there was a way to instruct the query builder to avoid subqueries. I am finding their limitations to overwhelm their value.
I can't show a calculated member
Reports works fine with calculated measures, but when you try to use a calculated member then raises an error which says The following system error ocurred. Invalid procedure call or argument.
Any ideas?
Can I use calculated members?
I'm using RS 2005 April CTP.
Thanks in advance.I would very much recommend moving to the June CTP. Many things are more stable, including Analysis Services. There is no reason why calculated members shouldn't work.|||Using the Sept CTP, when I create a data source that includes a hierarchy that includes a calculated member, I get an error message approximately "Encountered a set that cannot include a calculated member".
So it seems, there is a real issue here not solved by recent releases.|||
I also am having difficulties with calculated members using the Eval version of AS2005 and RS2005.
1) I am sure that everyone knows about this error: Add a calculated member (in BI Management Studio or RS), choose a parent heirarchy other than Measures, choose a parent member. If the dimension and hierarchy were both called Stock then the parent hierarchy would be Stock.Stock and the parent member would be [Stock].[Stock]. An error is given when the script/query is run. Changing to text mode shows that the designer form has placed an extra level in the WITH/CREATE MEMBER statement, ie [Stock].[Stock].[Stock].[Stock].[Calculated Member Name]. I worked out that you could work around this by deleting one of the repeated levels, BUT in RS, some extra problems arise: 1a) I can't change back to form mode because my query will be lost and, 1b) If I try to add this calculated member to my set of displayed members, it simply won't show.
2) I attempted to get around the problems described above by creating the same calculated member in the source cube. When I try to include it I get the same error about "Encoutered a set that cannot contain calculated members". This error also occurs if I paste the same RS built query into SQL Mgmt Studio. Is it possible to use calculated members that are not Measures in RS?
3) I have another problem which is related to the fact that RS can't accept anything but Measures for the columns of the query. My fact table has only one value column and hence my cube has only one Measure. Is there any way of making the RS query return multiple value columns if the source is a cube with only one Measure?
Anybody got any ideas?
Aranda
|||We submitted an issue with MS about this and were told that this was by design. If I remember correctly, it had something to do with how RS uses a subcube and calc members not being supported in subcubes.|||On your point #3, our cubes are constructed the same way.
I was able to solve this (sort of) by creating calculated members on the measures dimension that picked up data from other dimensions -- that is, I used calculated members to pivot the data. It's quite tedious, but effective. However there are some limitations I found:
a. those calculated members don't rollup to higher levels very well
b. I frequently encountered an unsecified "query error" when running the data. the e rror appears to be data-dependant but I haven't been able to track it down.
My bottom line is that RS really can't be used effectively with AS because of the following limitations:
1. Only measures as columns and pivoting measures are unstable
2. You really can't effectively use a cube that has any calculated members defined in any dimiension other than measures. So If you put in a CM on a dimension for some other use, you have contaminated that dimension and it can't be used in RS. Further, RS's reliance on subqueries renders CM's useless.
So these two facts tell me that microsoft has broken its promise (?) that AS would be a general platform whose results can be accessed by a multitude of applications. If you want to use AS with RS, you have to get rid of all Calculated members and calculated cells (except on measures dimension). (btw calculated cells fly below the radar on RS -- so it won't mask them out -- but the calculations don't work if you're using subqueries). Combine this with the fact that MS has eliminated the ability to create a calculated member in a query that has a solve order lower than one in the cube and have those calculations executed inthe proper sequence. So really, MS is telling us that calculated members do not belong in cubes -- only at the query level. what a giant take-away that is.
|||
Thank's Stan H for your useful reply, but it looks like the situation is as I feared. My bottom line is pretty much the same as yours - it really is a massive take-away because calculated members are pretty much what makes cubes worthwile for me.
I will give pivoting measures a try but it doesn't sound too hopeful.
|||The 'A set has been encountered that cannot contain calculated members' error comes when you try to slice by a set which contains a calculated member in the RS MDX query designer (I've not had any problems putting calculated members on rows in my queries in the RTM version), and as has already been said it's to do with the fact that RS uses subcubes to do its filtering. You can get round this limitation by editing the MDX directly, though, and although you then lose the ability to use the query designer you can at least get your queries to run...
Here's an example in Adventure Works. Say I've got a hierarchy created by the Time Intelligence Wizard on the Date dimension called [Calendar Date Calculations], with one calculated member on it called [Year to Date]. If you try to slice by this member you get the aforementioned error; switching to view the MDX, you see something like this:
SELECT NON EMPTY { [Measures].[Internet Order Count] }
ON COLUMNS,
NON EMPTY { ([Date].[Calendar].[Calendar Semester].ALLMEMBERS ) }
DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME
ON ROWS
FROM
( SELECT ( { [Date].[Calendar Date Calculations].[Year to Date] } ) ON COLUMNS FROM [Adventure Works]) WHERE ( [Date].[Calendar Date Calculations].[Year to Date] )
CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS
To get the desired effect, you need to edit the query to replace the subcube filter with a standard WHERE clause filter:
SELECT NON EMPTY { [Measures].[Internet Order Count] }
ON COLUMNS,
NON EMPTY { ([Date].[Calendar].[Calendar Semester].ALLMEMBERS ) }
DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME
ON ROWS
FROM [Adventure Works]
WHERE ( [Date].[Calendar Date Calculations].[Year to Date] )
CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS
In my experience you can almost always write MDX to make RS do what you want, but I 100% agree that RS shouldn't expect you to do this and the MDX query designer should be able to handle this particular scenario.
HTH,
Chris
|||
Thanks Chris, that was quite helpful.
I wish there was a way to instruct the query builder to avoid subqueries. I am finding their limitations to overwhelm their value.
Friday, March 23, 2012
I can't get ANY query with Report Builder to work!
I can't get any of my querying (whether from a dropdown or not) to do
anything other than display entire table...I'm creating report from
report wizard.
Help IS appreciated.
TrintTrint,
Each report has one, or more, datasets assigned to it.
Each dataset is independant of each other (except foe the datasources of
course), and each table on any report can be assigned to one of those data
sets.
I would finish with the wizard (I NEVER use those wizards) open the report
in design view, look at the dataset associated with the report, and alter it
accordingly. The dataset GUI in VS2003 is exactly the same as Enterprise
Manager for SQL.
Any further problems, just ask,
Hope this assists,
Tony
"trint" wrote:
> I don't want to use a stored procedure, or do I have to?
> I can't get any of my querying (whether from a dropdown or not) to do
> anything other than display entire table...I'm creating report from
> report wizard.
> Help IS appreciated.
> Trint
>
i can't deploy a report from SQL Server Business Intellegience Development Studio
TITLE: Microsoft Report Designer
A connection could not be made to the report server http://localhost/ReportServer.
ADDITIONAL INFORMATION:
The request failed with HTTP status 405: Method not allowed. (Microsoft.ReportingServices.Designer)
BUTTONS:
OK
I have installed:
* SQL Server 2005 Express Edition SP1
* SQL Management Studio Express
* SQL Server 2005 Express Edition with Advanced Services SP1
* SQL Server 2005 Express Edition Toolkit SP1
I'm trying to create a simple report, that display only a list of names. "Select * From Table"
Any ideas?
Hi,
switch the logging mode of SQL Server Reporting Services to Verbose and try it again, post the specific log snippets of the log according the error to the forum.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||Hey, Jens
I uninstalled SQL Server Express and all its components, and reinstalled the SQL Express SP1 Edition, i'm no longer going to use the reporting services anymore, as long as i know that SQL Server Express can create reports and deploy it to, other computers. I'm ok, and Thanks for the reply to my Message.
Lloyd Arcales
i can't deploy a report from SQL Server Business Intellegience Development Studio
TITLE: Microsoft Report Designer
A connection could not be made to the report server http://localhost/ReportServer.
ADDITIONAL INFORMATION:
The request failed with HTTP status 405: Method not allowed. (Microsoft.ReportingServices.Designer)
BUTTONS:
OK
I have installed:
* SQL Server 2005 Express Edition SP1
* SQL Management Studio Express
* SQL Server 2005 Express Edition with Advanced Services SP1
* SQL Server 2005 Express Edition Toolkit SP1
I'm trying to create a simple report, that display only a list of names. "Select * From Table"
Any ideas?
Hi,
switch the logging mode of SQL Server Reporting Services to Verbose and try it again, post the specific log snippets of the log according the error to the forum.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||Hey, Jens
I uninstalled SQL Server Express and all its components, and reinstalled the SQL Express SP1 Edition, i'm no longer going to use the reporting services anymore, as long as i know that SQL Server Express can create reports and deploy it to, other computers. I'm ok, and Thanks for the reply to my Message.
Lloyd Arcales
I cant deploy
Hello, I just did a report and it compiles ok, when I try to deploy then popups a window asking username and password, I put my username and password of active directory and it asks again and again, I am supposed to be an administrator on the report server.
What can I do?
When I try to connecto from sql management studio to reporting service Instance I got this error
TITLE: Connect to Server
Cannot connect to agamenon.
ADDITIONAL INFORMATION:
The request failed with HTTP status 401: Unauthorized. (Microsoft.SqlServer.Management.UI.RSClient)
BUTTONS:
OK
but the strange thing is that I can see the report manager
|||Do I have to change something on the config file? or in IIS?
Here it is the config file
<ConnectionType>Default</ConnectionType>
<LogonUser></LogonUser>
<LogonDomain></LogonDomain>
<LogonCred></LogonCred>
<InstanceId>MSSQL.3</InstanceId>
<InstallationID>{fece13ec-acc5-4ebd-84bf-2534c30f2f7f}</InstallationID>
<Add Key="SecureConnectionLevel" Value="0"/>
<Add Key="ProcessRecycleOptions" Value="0"/>
<Add Key="CleanupCycleMinutes" Value="10"/>
<Add Key="SQLCommandTimeoutSeconds" Value="60"/>
<Add Key="MaxActiveReqForOneUser" Value="20"/>
<Add Key="DatabaseQueryTimeout" Value="120"/>
<Add Key="RunningRequestsScavengerCycle" Value="60"/>
<Add Key="RunningRequestsDbCycle" Value="60"/>
<Add Key="RunningRequestsAge" Value="30"/>
<Add Key="MaxScheduleWait" Value="5"/>
<Add Key="DisplayErrorLink" Value="true"/>
<Add Key="WebServiceUseFileShareStorage" Value="false"/>
<!-- <Add Key="WatsonFlags" Value="0x0430" /> full dump-->
<!-- <Add Key="WatsonFlags" Value="0x0428" /> minidump -->
<!-- <Add Key="WatsonFlags" Value="0x0002" /> no dump-->
<Add Key="WatsonFlags" Value="0x0428"/>
<Add Key="WatsonDumpOnExceptions" Value="Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException"/>
<Add Key="WatsonDumpExcludeIfContainsExceptions" Value="System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException"/>
<Service>
<IsSchedulingService>True</IsSchedulingService>
<IsNotificationService>True</IsNotificationService>
<IsEventService>True</IsEventService>
<PollingInterval>10</PollingInterval>
<WindowsServiceUseFileShareStorage>False</WindowsServiceUseFileShareStorage>
<MemoryLimit>60</MemoryLimit>
<RecycleTime>720</RecycleTime>
<MaximumMemoryLimit>80</MaximumMemoryLimit>
<MaxAppDomainUnloadTime>30</MaxAppDomainUnloadTime>
<MaxQueueThreads>0</MaxQueueThreads>
<UrlRoot>http://agamenon:90/reportserver</UrlRoot>
<UnattendedExecutionAccount>
<UserName></UserName>
<Password></Password>
<Domain></Domain>
</UnattendedExecutionAccount>
<PolicyLevel>rssrvpolicy.config</PolicyLevel>
<WebServiceAccount>NT Authority\NetworkService</WebServiceAccount>
<IsWebServiceEnabled>True</IsWebServiceEnabled>
<FileShareStorageLocation>
<Path></Path>
</FileShareStorageLocation>
</Service>
Wednesday, March 21, 2012
i cant activate the report
I set up a enviroment of report services:
windows 2000+mssql 2000+vs.net 2003+report service.
after finished installing the report ,it told me cant activate
automatically,
i should activate the report service by hand,
so i fount the command in help file: rsacivate command
so
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer>reac
tivate -c "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\Report
Server\rsreportserver.config" -t
and it shows:
Failure starting the web service:
System.Exception: Unexpected database error (-2147159548)
0x80004002 -->
System.Exception: 0x80004002
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.RSActivate.RSActivate.RpcActivateService(Int32
clientType)
at Microsoft.ReportingServices.RSActivate.RSActivate.InstanceMain()
at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
Bas
eCmdLine instance)
any1 can help me out.
thank youHi Asher!
Did you find a solution?
I have the same problem too and i noticed other users with this problem,
nobody has found a solution til now...
I'd appreciate help from microsoft staff on this topic.
I'm on Windows 2000
MDAC 2.8 SP1
SQL Server 2000 SP4, with all the Service Packs for Reporting Services
installed.
--
ErrorMessage when executing rsactivate -c"C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config" -t
Failure starting the web service:
System.Exception: Unexpected database error (-2147159548) 0x80040154
-->
System.Exception: 0x80040154
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.RSActivate.RSActivate.RpcActivateService(Int32
clientType)
at Microsoft.ReportingServices.RSActivate.RSActivate.InstanceMain()
at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
BaseCmdLine instance)
--
Error Message when executing rskeymgmt -d -t:
System.Exception: Unexpected database error (-2147159548) 0x80040154
-->
System.Exception: 0x80040154
-- End of inner exception stack trace --
at Microsoft.ReportingServices.RSKeyMgmt.RSKeyMgmt.InstanceMain()
at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
BaseCmdLine instance)
Thx for any help
yara
"Asher Wu" wrote:
> Hi all
> I set up a enviroment of report services:
> windows 2000+mssql 2000+vs.net 2003+report service.
> after finished installing the report ,it told me cant activate
> automatically,
> i should activate the report service by hand,
> so i fount the command in help file: rsacivate command
> so
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer>reac
> tivate -c "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\Report
> Server\rsreportserver.config" -t
> and it shows:
> Failure starting the web service:
> System.Exception: Unexpected database error (-2147159548)
> 0x80004002 -->
> System.Exception: 0x80004002
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.RSActivate.RSActivate.RpcActivateService(Int32
> clientType)
> at Microsoft.ReportingServices.RSActivate.RSActivate.InstanceMain()
> at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
> Bas
> eCmdLine instance)
>
> any1 can help me out.
> thank you
>
>
I can't access a report by URL
I'm new at using Report Services and I don't understand what I am
supposed to do to access a report by URL.
For the moment, I'm still working on report samples and I try to
create an URL access to Employee Sales Summary. I've made a small web
page with this link:
<a href="http://links.10026.com/?link=http://localhost/Reports/Pages/Report.aspx?Itempath=/Sample
Reports/Employee Sales
Summary&rc:Parameters=false&rs:Command=Render&rs:format=HTML4.0&EmpId=20&ReportYear=2003&ReportMonth=12">lien
direct</a>
It accesses the page but asks me for the parameters as if they were
not in the url.
The real goal behind this is to access to the report using a
multiple-values parameter for the Employee ID. As it doesn't seem to
be possible from the basic interface of Report Sevices, I thought I
could make a form and then pass the list in the parameters and making
the "where" clause like this in the report:
where SalesPersonID IN (@.EmpID)You should use the report server URL not the Report Manager URL.
So try this:
http://localhost/reportsever?/Sample&rs:Command=Render
The full documentation on how to do this is available in Books online (also
on MSDN). Search for URL Access.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jocelyn" <j_chaumette@.yahoo.fr> wrote in message
news:15fe105b.0407190102.cb43a71@.posting.google.com...
> Hi every body,
> I'm new at using Report Services and I don't understand what I am
> supposed to do to access a report by URL.
> For the moment, I'm still working on report samples and I try to
> create an URL access to Employee Sales Summary. I've made a small web
> page with this link:
> <a href="http://links.10026.com/?link=http://localhost/Reports/Pages/Report.aspx?Itempath=/Sample
> Reports/Employee Sales
> Summary&rc:Parameters=false&rs:Command=Render&rs:format=HTML4.0&EmpId=20&ReportYear=2003&ReportMonth=12">lien
> direct</a>
> It accesses the page but asks me for the parameters as if they were
> not in the url.
> The real goal behind this is to access to the report using a
> multiple-values parameter for the Employee ID. As it doesn't seem to
> be possible from the basic interface of Report Sevices, I thought I
> could make a form and then pass the list in the parameters and making
> the "where" clause like this in the report:
> where SalesPersonID IN (@.EmpID)|||Thanks a lot!
It did work :) .
But actually, it was only the first step of my tests and I have now a
new issue.
As I have explained earlier (I think I did...), I need a multi-value
field parameter. This is the only reason why I'm making this html
page.
For the moment, the single value field works but I can't make it with
a multi-value field. It seems that my query is simply not good.
SELECT FirstName, MiddleName, LastName, AddressID
FROM Employee
WHERE (EmployeeID IN (@.EmpId))
I also tried to test the syntax of the list in the parameter, using
this query:
SELECT FirstName, MiddleName, LastName, AddressID
FROM Employee
WHERE (EmployeeID IN (20,21))
and then I tried
SELECT FirstName, MiddleName, LastName, AddressID
FROM Employee
WHERE (EmployeeID IN ('20','21'))
The report appears empty (the value 20 and 21 are good and the report
parameter is an integer).
Any Idea of how I should do?|||Jocelyn,
You can't use a variable in an IN clause. You need to use a Function like
the one below and either JOIN to it or use a nested SELECT.
e.g.
SELECT FirstName, MiddleName, LastName, AddressID
FROM Employee
INNER JOIN dbo.fnIntList(@.EmpId) ON EmployeeID=Value
brian
---
CREATE FUNCTION dbo.fnIntList ( @.InputString varchar(2000) )
RETURNS @.IntList TABLE (Value int)
AS
BEGIN
DECLARE @.Temp int
DECLARE @.Delimiter varchar(1)
SET @.Delimiter = ','
-- remove any surrounding spaces
SET @.InputString = RTRIM(LTRIM(@.InputString ))
WHILE (CHARINDEX(@.Delimiter, @.InputString)) > 0
BEGIN
SET @.Temp = RTRIM(LTRIM(LEFT(@.InputString, CHARINDEX(@.Delimiter,
@.InputString)-1)))
IF @.Temp != ''
INSERT @.IntList Values(@.Temp)
SET @.InputString = RIGHT(@.InputString, LEN(@.InputString) -
CHARINDEX(@.Delimiter,@.InputString))
END
SET @.Temp = RTRIM(LTRIM(@.InputString))
IF @.Temp != ''
INSERT @.IntList Values(@.Temp)
RETURN
END
GO
----
"Jocelyn" <j_chaumette@.yahoo.fr> wrote in message
news:15fe105b.0407202353.225402c4@.posting.google.com...
> Thanks a lot!
> It did work :) .
> But actually, it was only the first step of my tests and I have now a
> new issue.
> As I have explained earlier (I think I did...), I need a multi-value
> field parameter. This is the only reason why I'm making this html
> page.
> For the moment, the single value field works but I can't make it with
> a multi-value field. It seems that my query is simply not good.
> SELECT FirstName, MiddleName, LastName, AddressID
> FROM Employee
> WHERE (EmployeeID IN (@.EmpId))
> I also tried to test the syntax of the list in the parameter, using
> this query:
> SELECT FirstName, MiddleName, LastName, AddressID
> FROM Employee
> WHERE (EmployeeID IN (20,21))
> and then I tried
> SELECT FirstName, MiddleName, LastName, AddressID
> FROM Employee
> WHERE (EmployeeID IN ('20','21'))
> The report appears empty (the value 20 and 21 are good and the report
> parameter is an integer).
> Any Idea of how I should do?
I Cant "show sql query" - Crystal Report 8.5
I created a report and using 3 tables( or more) with joins, group and etc. And this report calls a subreport. Well, the report is perfect, no problems! But, i can't see your sql definition(In crystal report, menu database,Show sql query) and, in Visual Basic i need to set a similar sql of report, only changing the where clause, by filter controls in VB.
In old times, i have used crystal report 8, and can show sql query.
In VB, how i can input a sql string in report, after execute it ?
How i can show sql query in CR?
Please, i need this help with urgency! The rope is in my neck! =(]
Thanks a lot!"Show SQL Query" option is very much present in crystal reports 8.5, if you don't have the option, then you try re-installing crystal reports.
Monday, March 19, 2012
I can not start (initialise) report server status from reporting services configuration ma
I have reporting services installed on my machine and just a couple of days back every thing was working correctly until some thing i have no idea of happened and screwed up every thing. No i can not access report manager and report sever. When i open reporting services configuration manager, the server status is not initialised and results in following error in the computers event log.
Service cannot be started. System.IO.FileLoadException: Could not load file or assembly 'ReportingServicesNativeServer, Version=0.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem. (Exception from HRESULT: 0x800736B1)
File name: 'ReportingServicesNativeServer, Version=0.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' --> System.Runtime.InteropServices.COMException (0x800736B1): This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem. (Exception from HRESULT: 0x800736B1)
at Microsoft.ReportingServices.Library.ServiceAppDomainController..ctor()
at Microsoft.ReportingServices.NTService.ReportService.OnStart(String[] args)
at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)
For more information, see Help and Support Center athttp://go.microsoft.com/fwlink/events.asp.
Accessing report manager from the browser also throws this exception.
Server Error in '/ReportServer$SQLExpress' Application.
Configuration Error
Description: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.
Parser Error Message:An error occurred loading a configuration file: Failed to start monitoring changes to 'c:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer' because access is denied.
Source Error:
[No relevant source lines]
Source File:c:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\web.config Line:0
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210
I'm having the same problem and I was just wondering if you managed to get your report server working
|||Okay so I got it working.
I got this solution fromAaron Stebner's blog.
Create a batch file with the following commands:
cd %SYSTEMROOT%\WinSXS
for /D %%i in (*vc80*) do rd %%i /s /q
del manifests\*vc80* /q
cd policies
for /D %%i in (*vc80*) do del %%i\* /q
Run the batch file
Then run a repair install of SQL reporting services.
And it should come back.
|||
On my side, i got it working by just un-installing and then re-installing reporting services.
Monday, March 12, 2012
I am viewing reports through a .Net interface. I want to hide
check out the new webform controls that ship with VS 2005. The other option
is to use web services instead of URL integration URL integration is easier
but it really is not suitable if you are trying to hide things from the
user.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"OriginalStealth" <OriginalStealth@.discussions.microsoft.com> wrote in
message news:F77A8831-CD45-4431-8DF6-E89D487C3F80@.microsoft.com...
> the URL when the report is rendered. How can I do this?
I am using the reportingservice web service, everything runs fine but does'nt display report
Please am i doing something wrong, i debug the code no where it is giving me an error:
I am using the reportservice.asmx web service to render the report, but it is not displaying the report at all. it just shows me on IE saying Done with out any error, please can you tell me am i doing something wrong, after a very hard time i reached upto this point, on my form i just have a button on its click event i wrote the following code. and i have no other control on the form. except this code. just referencing the webservice.
thank you.
Dim rs As New ReportingService
Dim LogonCredentials As System.Net.NetworkCredential
Dim Items As CatalogItem
LogonCredentials = New System.Net.NetworkCredential("username", "password", "mydomainname")
rs.Credentials = LogonCredentials
'rs.Credentials = System.Net.CredentialCache.DefaultCredentials
rs.PreAuthenticate = True
' Render arguments
Dim result As Byte() = Nothing
Dim reportPath As String = "/PCSnetReports/StatusReport"
Dim format As String = "MHTML"
Dim historyID As String = Nothing
Dim devInfo As String = "<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>"
' Prepare report parameter.
Dim parameters(1) As ParameterValue
parameters(0) = New ParameterValue
parameters(0).Name = "eStatus"
parameters(0).Value = "All"
parameters(1) = New ParameterValue
parameters(1).Name = "UserName"
parameters(1).Value = "johnsmith" ' June
Dim credentials As DataSourceCredentials() = Nothing
Dim showHideToggle As String = Nothing
Dim encoding As String
Dim mimeType As String
Dim warnings As Warning() = Nothing
Dim reportHistoryParameters As ParameterValue() = Nothing
Dim streamIDs As String() = Nothing
Dim sh As New SessionHeader
rs.SessionHeaderValue = sh
Try
result = rs.Render(reportPath, format, historyID, devInfo, parameters, _
credentials, showHideToggle, encoding, mimeType, reportHistoryParameters, warnings, streamIDs)
sh.SessionId = rs.SessionHeaderValue.SessionId
Console.WriteLine("SessionID after call to Render: {0}", rs.SessionHeaderValue.SessionId)
Console.WriteLine("Execution date and time: {0}", rs.SessionHeaderValue.ExecutionDateTime)
Console.WriteLine("Is new execution: {0}", rs.SessionHeaderValue.IsNewExecution)
Catch e1 As SoapException
Console.WriteLine(e1.Detail.OuterXml)
End Try
' Write the contents of the report to an MHTML file.
Try
Dim stream As FileStream = File.Create("report.mhtml", result.Length)
Console.WriteLine("File created.")
stream.Write(result, 0, result.Length)
Console.WriteLine("Result written to the file.")
stream.Close()
Catch e2 As Exception
Console.WriteLine(e2.Message)
End Try
Hi,
You need to call the LoadReport method on the RS object before you call the Render method. For example:
rsExecService.ExecutionInfo execInfo = new rsExecService.ExecutionInfo();
rsExecService.ExecutionHeader execHeader = new rsExecService.ExecutionHeader();
rsExec.ExecutionHeaderValue = execHeader;
execInfo = rsExec.LoadReport(reportPath, historyID);
rsExec.SetExecutionParameters(execParameterValues, "en-gb");
String SessionId = rsExec.ExecutionHeaderValue.ExecutionID;
try
{
// Cache the results within the report definition.
report.Data = rsExec.Render(format, devInfo, out extension, out encoding, out mimeType, out warnings, out streamIDs);
}
catch (SoapException e)
{
Console.WriteLine(e.Detail.OuterXml);
}
Regards
Sanjay
Friday, March 9, 2012
I am not getting calender in front of the Date textbox.Pls Help!!!
I created a reoport using wizard.In my quesry i took two date parameters.But when i run my report i get two texboxes StartDate and EndDate.How do i get calender button in front of the text boxes.Below is my query.
SELECT dbo.tblReferralTransferStatus.RefId
FROM dbo.tblReferralTransferStatus INNER JOIN
dbo.tblDownloadTracking ON dbo.tblReferralTransferStatus.VendorId = dbo.tblDownloadTracking.VendorId AND
dbo.tblReferralTransferStatus.DateModified < dbo.tblDownloadTracking.DateModified INNER JOIN
dbo.tblVENDOR ON dbo.tblReferralTransferStatus.VendorId = dbo.tblVENDOR.VendorId
WHERE (dbo.tblVENDOR.VendorName = @.vendorname)AND (dbo.tblReferralTransferStatus.DateModified >= CAST(@.StartDate AS varchar)) AND (dbo.tblReferralTransferStatus.DateModified < CAST(@.EndDate AS varchar))
Hello,
Can you verify that your parameters are set to the DateTime data type? Open Report Parameters from the Report menu, select StartDate and EndDate and make sure the Data type is set to DateTime.
Jarret
I am not able to open my report through URL It's URGENT!!!!!1
<A HREF="http://localhost/Reports?NTIEE Reports/NTSID_LookUp">View Report</A>
When i click on this link it opens report manager and the NTIEE Reports folder.But i want to open direclty the report.Name of the report is NTSID_LookUp which is depoyed inside NTIEE Reports folder.Pls let me know how i can open a report through my web application.
Run the report in Report Manager and then right-click inside the report to get the Properties. The URL to link directly to the report is there.
If you don't want to see the manager, you should user Reportserver? instead of Reports.
cheers,
Andrew
|||Try this
<A HREF="http://localhost/ReportServer?NTIEE Reports/NTSID_LookUp&rs:Command=render">View Report</A>
or this
<A HREF="http://localhost/ReportServer/Pages/ReportViewer.aspx?NTIEE Reports/NTSID_LookUp&rs:Command=Render">View Report</A>
Pls also make sure you use the correct the virtual directory - ReportServer (which is the default).
Cheers,
Henary