Hello:
We are running SQL Server 2000 RS. We are just starting to deploy reports
and we are running into a strange problem.
We have given users access to their reports via various Windows security
groups. When an Sysadmin runs a report, it's runs fine and displays
everything in a timely fashion.
When a regular user runs a report, there is a significant delay while the
Report is Being Generated icon spins. Finally, the report displays but some
graphics are not displayed and are replaced by a box with a red X.
This behavior is consistent on any user who is not a sysadmin.
Any suggestions on how to correct this problem would be appreciated.
ThanksBrennan,
Do the images exist on a location where the group to which the user's
belong does not have permission?
I bet if you set the permission on the image to 'Everyone'/Anonymous
you'll get the images in the report.
Andy Potter
Showing posts with label report. Show all posts
Showing posts with label report. Show all posts
Wednesday, March 28, 2012
problems in creating report (parent child hierarchy)
hello,
im working with as/rs 2005 and need help in creating a report.
my cube has a parent child hierarchy in "category".
structur is as follows:
Aa1
2b
B Cf
g10
1112
I like to have a function or something, that gives me the unique names of all children of maybe A (result should be: a,1,2,b,3,4,...)
there is a function called children, but i am not able to obtain my desired result. (in fact, i dont get any result with this fuction)
every little bit that shows me the right direction is highly appreciated ...
sincerely,
Rhapsody
i will provide you with some more details ... maybe you can help me than...
im using the adventure works dw.
measures: fact finance
dimension: dim organization (esp. parent child hierarchy: parent organization key)
i have a query parameter "DimOrganizationParentOrganizationKey", which is a multivalue parameter and user can choose IDs (from different levels) he/she wants to see.
the structure of the IDs looks as follows:
1|||
im working with as/rs 2005 and need help in creating a report.
my cube has a parent child hierarchy in "category".
structur is as follows:
Aa1
2b
B Cf
g10
1112
I like to have a function or something, that gives me the unique names of all children of maybe A (result should be: a,1,2,b,3,4,...)
there is a function called children, but i am not able to obtain my desired result. (in fact, i dont get any result with this fuction)
every little bit that shows me the right direction is highly appreciated ...
sincerely,
Rhapsody
If I understand you correctly, this should do the trick:
with
member [Measures].[UNMChildren]
as 'GENERATE(EXCEPT(descendants([Category].currentmember,10,SELF_BEFORE_AFTER),[Category].currentmember),
[Category].currentmember.uniquename, ","
)'
select {[Measures].[UNMChildren]}
on columns,
{[Category].members} on rows
from CubeName
Hope this helps,
Santi
|||thank you santi, but that was not it ... or i didnt apply it the right way ...i will provide you with some more details ... maybe you can help me than...
im using the adventure works dw.
measures: fact finance
dimension: dim organization (esp. parent child hierarchy: parent organization key)
i have a query parameter "DimOrganizationParentOrganizationKey", which is a multivalue parameter and user can choose IDs (from different levels) he/she wants to see.
the structure of the IDs looks as follows:
1|||
I'm sorry, but I can't help you with Reporting Services.
As far as I know, the mdx should be able to return the uniquenames of a dimension member's descendants separated by commas.
Maybe if you have a secondary datasource in Reporting Services which returns the Unique Names of the members passed by parameter, you could be able to use that to make visible/invisible the appropriate members. Not sure though...
sqlMonday, March 26, 2012
Problems Exporting To Excel When Using Report Subscription
Hi,
I'm having a problem with Reporting Services report subscriptions.
I have a set of reports that need to be sent via email on a schedule. I need
to send them in Excel format, but the files sent to my email account are
unreadable in Excel. I am using Excel 2003 and can manually export reports
and open them in Excel without any problems, yet when I use a subscription to
email the Excel files they are not valid files. They have the .xls extension,
but Excel can't open them properly, it just opens them as a load of
unintelligible text.
The same thing happens when I set up a subscription to email a report in XML
format, I could export it manually and it worked fine, yet when I run the
subscription to email the XML report to me I get an invalid XML file.
Has anyone else had this problem or does anyone know how to fix it?
If it helps, the report server is stored on a network server, not my local PC.
The server is running Windows Server 2003 Pro, my PC is running Windows XP
Pro and has Office 2003. Office is not installed on the server, but I doubt
that makes any difference, since I can manually export to Excel without any
problems.
Thanks in advance
TabbyWhen you run them "locally" due you mean from VS.NET on your workstation?
If yes... I found that generating reports "locally" can have totally
different results than running them on the report server.
If this is the case...try loading the report via a browser from the report
server.
If this is not the case... try pdf/html or other output formats to narrow
down the problem. I found problems exporting to excel but not other formats
when report objects are overlapping.
Tabby Cool wrote:
>Hi,
>I'm having a problem with Reporting Services report subscriptions.
>I have a set of reports that need to be sent via email on a schedule. I need
>to send them in Excel format, but the files sent to my email account are
>unreadable in Excel. I am using Excel 2003 and can manually export reports
>and open them in Excel without any problems, yet when I use a subscription to
>email the Excel files they are not valid files. They have the .xls extension,
>but Excel can't open them properly, it just opens them as a load of
>unintelligible text.
>The same thing happens when I set up a subscription to email a report in XML
>format, I could export it manually and it worked fine, yet when I run the
>subscription to email the XML report to me I get an invalid XML file.
>Has anyone else had this problem or does anyone know how to fix it?
>If it helps, the report server is stored on a network server, not my local PC.
>The server is running Windows Server 2003 Pro, my PC is running Windows XP
>Pro and has Office 2003. Office is not installed on the server, but I doubt
>that makes any difference, since I can manually export to Excel without any
>problems.
>Thanks in advance
>Tabby
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200509/1|||No, I am not running htem from Visual Studio, I am running them direct from
the Report Manager.
When you run reports in Visual Studio, can you actually export them? I
thought you could only preview them, there is no option to export a report
from the preview screen.
I have tried exporting them to both XML and Excel, I can do this perfectly
from the Report Manager, yet when I use a subscription to email the reports
to me in either of these formats the files are unusable.
William N wrote:
>When you run them "locally" due you mean from VS.NET on your workstation?
>If yes... I found that generating reports "locally" can have totally
>different results than running them on the report server.
>If this is the case...try loading the report via a browser from the report
>server.
>If this is not the case... try pdf/html or other output formats to narrow
>down the problem. I found problems exporting to excel but not other formats
>when report objects are overlapping.
>>Hi,
>[quoted text clipped - 23 lines]
>>Tabby|||I have tried exporting to PDF, again, this works fine when performed manually,
but the email attachments from the subscription are not valid PDFs and can't
be opened by Adobe Acrobat.
It seems there is something different with the export procedure when using a
subscription as opposed to exporting manually, I don't understand why it
would work perfectly one way and not the other.|||Seems like the report is not getting the the data?
Are you saving the credentials in your data connection?
Tabby Cool wrote:
>I have tried exporting to PDF, again, this works fine when performed manually,
>but the email attachments from the subscription are not valid PDFs and can't
>be opened by Adobe Acrobat.
>It seems there is something different with the export procedure when using a
>subscription as opposed to exporting manually, I don't understand why it
>would work perfectly one way and not the other.
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200509/1|||Yes, the credentials are stored in the data source.
William N wrote:
>Seems like the report is not getting the the data?
>Are you saving the credentials in your data connection?
>>I have tried exporting to PDF, again, this works fine when performed manually,
>>but the email attachments from the subscription are not valid PDFs and can't
>[quoted text clipped - 3 lines]
>>subscription as opposed to exporting manually, I don't understand why it
>>would work perfectly one way and not the other.
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200509/1|||Not sure what else to suggest.
I always try to simplify as much as possible first. Maybe try creating a
report with just a "Hello" text box and see if that works (no data sets or
anything else).
If it doesn't, then it's probably a server/install issue.
Good luck.
Tabby Cool wrote:
>Yes, the credentials are stored in the data source.
>>Seems like the report is not getting the the data?
>[quoted text clipped - 5 lines]
>>subscription as opposed to exporting manually, I don't understand why it
>>would work perfectly one way and not the other.
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200509/1
I'm having a problem with Reporting Services report subscriptions.
I have a set of reports that need to be sent via email on a schedule. I need
to send them in Excel format, but the files sent to my email account are
unreadable in Excel. I am using Excel 2003 and can manually export reports
and open them in Excel without any problems, yet when I use a subscription to
email the Excel files they are not valid files. They have the .xls extension,
but Excel can't open them properly, it just opens them as a load of
unintelligible text.
The same thing happens when I set up a subscription to email a report in XML
format, I could export it manually and it worked fine, yet when I run the
subscription to email the XML report to me I get an invalid XML file.
Has anyone else had this problem or does anyone know how to fix it?
If it helps, the report server is stored on a network server, not my local PC.
The server is running Windows Server 2003 Pro, my PC is running Windows XP
Pro and has Office 2003. Office is not installed on the server, but I doubt
that makes any difference, since I can manually export to Excel without any
problems.
Thanks in advance
TabbyWhen you run them "locally" due you mean from VS.NET on your workstation?
If yes... I found that generating reports "locally" can have totally
different results than running them on the report server.
If this is the case...try loading the report via a browser from the report
server.
If this is not the case... try pdf/html or other output formats to narrow
down the problem. I found problems exporting to excel but not other formats
when report objects are overlapping.
Tabby Cool wrote:
>Hi,
>I'm having a problem with Reporting Services report subscriptions.
>I have a set of reports that need to be sent via email on a schedule. I need
>to send them in Excel format, but the files sent to my email account are
>unreadable in Excel. I am using Excel 2003 and can manually export reports
>and open them in Excel without any problems, yet when I use a subscription to
>email the Excel files they are not valid files. They have the .xls extension,
>but Excel can't open them properly, it just opens them as a load of
>unintelligible text.
>The same thing happens when I set up a subscription to email a report in XML
>format, I could export it manually and it worked fine, yet when I run the
>subscription to email the XML report to me I get an invalid XML file.
>Has anyone else had this problem or does anyone know how to fix it?
>If it helps, the report server is stored on a network server, not my local PC.
>The server is running Windows Server 2003 Pro, my PC is running Windows XP
>Pro and has Office 2003. Office is not installed on the server, but I doubt
>that makes any difference, since I can manually export to Excel without any
>problems.
>Thanks in advance
>Tabby
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200509/1|||No, I am not running htem from Visual Studio, I am running them direct from
the Report Manager.
When you run reports in Visual Studio, can you actually export them? I
thought you could only preview them, there is no option to export a report
from the preview screen.
I have tried exporting them to both XML and Excel, I can do this perfectly
from the Report Manager, yet when I use a subscription to email the reports
to me in either of these formats the files are unusable.
William N wrote:
>When you run them "locally" due you mean from VS.NET on your workstation?
>If yes... I found that generating reports "locally" can have totally
>different results than running them on the report server.
>If this is the case...try loading the report via a browser from the report
>server.
>If this is not the case... try pdf/html or other output formats to narrow
>down the problem. I found problems exporting to excel but not other formats
>when report objects are overlapping.
>>Hi,
>[quoted text clipped - 23 lines]
>>Tabby|||I have tried exporting to PDF, again, this works fine when performed manually,
but the email attachments from the subscription are not valid PDFs and can't
be opened by Adobe Acrobat.
It seems there is something different with the export procedure when using a
subscription as opposed to exporting manually, I don't understand why it
would work perfectly one way and not the other.|||Seems like the report is not getting the the data?
Are you saving the credentials in your data connection?
Tabby Cool wrote:
>I have tried exporting to PDF, again, this works fine when performed manually,
>but the email attachments from the subscription are not valid PDFs and can't
>be opened by Adobe Acrobat.
>It seems there is something different with the export procedure when using a
>subscription as opposed to exporting manually, I don't understand why it
>would work perfectly one way and not the other.
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200509/1|||Yes, the credentials are stored in the data source.
William N wrote:
>Seems like the report is not getting the the data?
>Are you saving the credentials in your data connection?
>>I have tried exporting to PDF, again, this works fine when performed manually,
>>but the email attachments from the subscription are not valid PDFs and can't
>[quoted text clipped - 3 lines]
>>subscription as opposed to exporting manually, I don't understand why it
>>would work perfectly one way and not the other.
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200509/1|||Not sure what else to suggest.
I always try to simplify as much as possible first. Maybe try creating a
report with just a "Hello" text box and see if that works (no data sets or
anything else).
If it doesn't, then it's probably a server/install issue.
Good luck.
Tabby Cool wrote:
>Yes, the credentials are stored in the data source.
>>Seems like the report is not getting the the data?
>[quoted text clipped - 5 lines]
>>subscription as opposed to exporting manually, I don't understand why it
>>would work perfectly one way and not the other.
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200509/1
Problems exporting reports to Excel
Hello all
I have a problem with an aplication that developed in .Net to view Crystal 9.0 reports, in my dev PC I can export any report to Excel without a problem, but on my client Pc's, click directly on the Export button, the app show the file location window, select Excel file on type file field and click ok, appear an error, it is in spanish but it is the translation ...
"Error in file c:\pathfile\filename.rpt:
Exportation DLL or format file invalid"
Then appear a new message box:
"Unable to export"
Checking on the web I found tow possible solutions, download the last Hot Fix from seagate site or check and replace the U2F*.dll files located in my user's PC Crystal folder. I tried with both but I'm where I started...
Any idea ?
ThanxDid you have latest service pack of CR?
Refer this for more info
http://www.businessobjects.com/support/default.asp
I have a problem with an aplication that developed in .Net to view Crystal 9.0 reports, in my dev PC I can export any report to Excel without a problem, but on my client Pc's, click directly on the Export button, the app show the file location window, select Excel file on type file field and click ok, appear an error, it is in spanish but it is the translation ...
"Error in file c:\pathfile\filename.rpt:
Exportation DLL or format file invalid"
Then appear a new message box:
"Unable to export"
Checking on the web I found tow possible solutions, download the last Hot Fix from seagate site or check and replace the U2F*.dll files located in my user's PC Crystal folder. I tried with both but I'm where I started...
Any idea ?
ThanxDid you have latest service pack of CR?
Refer this for more info
http://www.businessobjects.com/support/default.asp
Problems exporting Reports programatically
I am simply trying to use ActiveX to export a Report to another format, programatically, i.e. without the user having to select a format using the Export dialog.
I can set up all the properties in the ExportOptions object that is part of the Report Object itself, but these do not appear to have any effect when I call the the Export() method on the Report object; which simply brings up the Export dialog with default values.
In fact, even after entering different values through the Export dialog, these do not appear to change the properties that are found in the ExportOptions object. These properties are as what they were coded previously, i.e. unchanged
It's as though the IReport::Export() method and the ExportOptions object are totally separate... Can anyone help to see what I am missing?Try passing "False" to Export so that it does not prompt for the values - from memory, that's what I had to do to get it working.
I can set up all the properties in the ExportOptions object that is part of the Report Object itself, but these do not appear to have any effect when I call the the Export() method on the Report object; which simply brings up the Export dialog with default values.
In fact, even after entering different values through the Export dialog, these do not appear to change the properties that are found in the ExportOptions object. These properties are as what they were coded previously, i.e. unchanged
It's as though the IReport::Export() method and the ExportOptions object are totally separate... Can anyone help to see what I am missing?Try passing "False" to Export so that it does not prompt for the values - from memory, that's what I had to do to get it working.
Problems exporting from reporting services 2005 to excel with a lot of rows
Hello,
When I export to excel a report made in Reporting Services 2005, and it has a lot of rows in a table (in the detail section), I have to wait a lot of time, and when it finish the size of the file is bigger than the excel file exported from the old reports in crystal report 6. When I open this exported documents, I have to wait more time until I can see them.
The document have 3 sheets, the first have the document map, the second has a report header, and the last one the page header and the body section (with the table). We thought that it could be the document map because it has hyperlinks to the third sheet, but I have tried to delete this sheet in the excel document and the size is more or less the same.
I tried also exporting to CSV but the results aren't what we need.
What could I do?
Anybody can help me? :/|||Hi ,
I suggest you to align your report items perfectly to the standards of reporting services
what can you notice when the Excel is opened.if you can see unnecessary columns with zero width.then my expectation is right.
if you can see the dots on report layout tab,when you design the report
,make sure that a report item should not end between these two dots
(size should be the multiple of 0.125 inch)
Follow the same for each Report item in the Report and let me know what did you end up with ?
Thank you,
Raj Deep>A
|||Hi Raj Deep,
Thanks for your response, but my report items are not between any dots, and the size of every textbox is 0.5. The problem must be because there are too many data in the table, I think, but it wasn′t a matter for crystal reports 8. Any other idea? :)
Thank you,
Pablo
problems during the deployment phase
I used the Business Intelligence Studio to make a report. I also enabled the tcp/ip protocol but during the deployment of the report i get the following error. I can see the report in Preview-Layout mode but i can t run the project. Could you help me
Thanks In Advance
===================================
A connection could not be made to the report server http://localhost/ReportServer$DVLP002_SQL2005/Reports. (Microsoft Report Designer)
===================================
Client found response content type of '', but expected 'text/xml'.
The request failed with an empty response. (Microsoft.ReportingServices.Designer)
Program Location:
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetItemType(String Item)
at Microsoft.ReportDesigner.Project.ReportServiceClient.GetItemType(String item)
at Microsoft.ReportDesigner.Project.ReportServiceClient.CheckAuthorized()
at Microsoft.ReportDesigner.Project.ReportClientManager.GetCredentials(String url)
at Microsoft.ReportDesigner.Project.ReportProjectDeployer.PrepareDeploy()
It sounds like the specified ReportServerUrl is incorrect in your VS solution. You want to publish reports to the RS server web service - not to the RS report manager.
You should set the ReportServerUrl to: http://localhost/ReportServer$DVLP002_SQL2005
-- Robert
|||Everything now is OK
Thank You Very Much
Nick Macis
Problems during the deployment of a report
Hello,
I just made a fresh install of Win2003 with VS.NET and SQL server 2000 with
reporting services. When I started to do some test projects to see if
everything was working again and to see what the reporting services where I
ran into some problems:
- first I started a new reporting project and after setting up a test report
I tried to build the project what worked, but when it came to the stage of
deploying it during the build process it came with the error: " The
permissions granted to user 'MYDOMAIN\IUSR_MYDOMAIN' are insufficient for
performing this operation.". After searching the Internet I didn't found a
sollution, so I tried the following:
- I started a new web application (as allways) placed a button and textbox
on it and ran it. It didn't work, it came with the following error "Error:
Project Is Not Configured To Be Debugged". Looking in IIS admin I found out
that there was only a virtual directory but no application made for it
(properties "create" application). After doing this the web app worked.
So it looks like VS.NET 2003 doesn't have enhough rights to work properly
(because the reportingservices are still not working)? How can I fix this?
BTW:
- When I click within VS.NET on the internalt browser tab it display's mine
reports properly, I can browse through multiple pages, save my report to pdf.
- I posted this already to the dotnet.general newsgroup, and they told me to
post the question on this forum.
Thanks,
Charl1. I am getting the same error "The permissions granted to user
'MYDOMAIN\IUSR_MYDOMAIN' are insufficient for
performing this operation." I thought it was because we installed a
certifercate and applied SSL.
2. How do I use SSL in Interdev with Report Services?
"Charl" wrote:
> Hello,
> I just made a fresh install of Win2003 with VS.NET and SQL server 2000 with
> reporting services. When I started to do some test projects to see if
> everything was working again and to see what the reporting services where I
> ran into some problems:
> - first I started a new reporting project and after setting up a test report
> I tried to build the project what worked, but when it came to the stage of
> deploying it during the build process it came with the error: " The
> permissions granted to user 'MYDOMAIN\IUSR_MYDOMAIN' are insufficient for
> performing this operation.". After searching the Internet I didn't found a
> sollution, so I tried the following:
> - I started a new web application (as allways) placed a button and textbox
> on it and ran it. It didn't work, it came with the following error "Error:
> Project Is Not Configured To Be Debugged". Looking in IIS admin I found out
> that there was only a virtual directory but no application made for it
> (properties "create" application). After doing this the web app worked.
> So it looks like VS.NET 2003 doesn't have enhough rights to work properly
> (because the reportingservices are still not working)? How can I fix this?
> BTW:
> - When I click within VS.NET on the internalt browser tab it display's mine
> reports properly, I can browse through multiple pages, save my report to pdf.
> - I posted this already to the dotnet.general newsgroup, and they told me to
> post the question on this forum.
> Thanks,
> Charl
>|||Hello Charl,
This issue can occur if the virutal folders of IIS for reporting service
allow anonymouse.
Please check the following settings:
Right click Reports /ReportServer in IIS->Properties->Directory Security
Make sure "Intergrated Windows authentication" is checked and "enable
anonymouse access" is unchecked.
For SSL setting, please refer to
Using Secure Sockets Layer (SSL) for SQL Server 2000 Reporting Services
http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnsql2k/html
/sslsetup.asp
Hope this helps.
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: Problems during the deployment of a report
| thread-index: AcUD43GQazYXHSyvSkKGiJUt0NAIzw==| X-WBNR-Posting-Host: 144.141.194.3
| From: "=?Utf-8?B?UlMtR2lybA==?=" <RSGirl@.discussions.microsoft.com>
| References: <84A55AEC-F91F-49D2-BFED-5474968DD8D3@.microsoft.com>
| Subject: RE: Problems during the deployment of a report
| Date: Wed, 26 Jan 2005 12:13:04 -0800
| Lines: 43
| Message-ID: <ABFED987-6704-4F7E-BA22-A4CC5893B14B@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:40960
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| 1. I am getting the same error "The permissions granted to user
| 'MYDOMAIN\IUSR_MYDOMAIN' are insufficient for
| performing this operation." I thought it was because we installed a
| certifercate and applied SSL.
|
|
| 2. How do I use SSL in Interdev with Report Services?
|
|
| "Charl" wrote:
|
| > Hello,
| >
| > I just made a fresh install of Win2003 with VS.NET and SQL server 2000
with
| > reporting services. When I started to do some test projects to see if
| > everything was working again and to see what the reporting services
where I
| > ran into some problems:
| >
| > - first I started a new reporting project and after setting up a test
report
| > I tried to build the project what worked, but when it came to the stage
of
| > deploying it during the build process it came with the error: " The
| > permissions granted to user 'MYDOMAIN\IUSR_MYDOMAIN' are insufficient
for
| > performing this operation.". After searching the Internet I didn't
found a
| > sollution, so I tried the following:
| >
| > - I started a new web application (as allways) placed a button and
textbox
| > on it and ran it. It didn't work, it came with the following error
"Error:
| > Project Is Not Configured To Be Debugged". Looking in IIS admin I found
out
| > that there was only a virtual directory but no application made for it
| > (properties "create" application). After doing this the web app worked.
| > So it looks like VS.NET 2003 doesn't have enhough rights to work
properly
| > (because the reportingservices are still not working)? How can I fix
this?
| >
| > BTW:
| > - When I click within VS.NET on the internalt browser tab it display's
mine
| > reports properly, I can browse through multiple pages, save my report
to pdf.
| >
| > - I posted this already to the dotnet.general newsgroup, and they told
me to
| > post the question on this forum.
| >
| > Thanks,
| > Charl
| >
||||Thanks Peter,
This solved mine problem!
So what you are saying is that it isn't possible to use the reportingservice
with anonymouse access enabled? Because that is what I would like to do for
my reports?!?
Thanks,
Charl
"Peter Yang [MSFT]" wrote:
> Hello Charl,
> This issue can occur if the virutal folders of IIS for reporting service
> allow anonymouse.
> Please check the following settings:
> Right click Reports /ReportServer in IIS->Properties->Directory Security
> Make sure "Intergrated Windows authentication" is checked and "enable
> anonymouse access" is unchecked.
> For SSL setting, please refer to
> Using Secure Sockets Layer (SSL) for SQL Server 2000 Reporting Services
> http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnsql2k/html
> /sslsetup.asp
> Hope this helps.
> Thanks & Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> Business-Critical Phone Support (BCPS) provides you with technical phone
> support at no charge during critical LAN outages or "business down"
> situations. This benefit is available 24 hours a day, 7 days a week to all
> Microsoft technology partners in the United States and Canada.
> This and other support options are available here:
> BCPS:
> https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
> Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
> If you are outside the United States, please visit our International
> Support page:
> http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> --
> | Thread-Topic: Problems during the deployment of a report
> | thread-index: AcUD43GQazYXHSyvSkKGiJUt0NAIzw==> | X-WBNR-Posting-Host: 144.141.194.3
> | From: "=?Utf-8?B?UlMtR2lybA==?=" <RSGirl@.discussions.microsoft.com>
> | References: <84A55AEC-F91F-49D2-BFED-5474968DD8D3@.microsoft.com>
> | Subject: RE: Problems during the deployment of a report
> | Date: Wed, 26 Jan 2005 12:13:04 -0800
> | Lines: 43
> | Message-ID: <ABFED987-6704-4F7E-BA22-A4CC5893B14B@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:40960
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | 1. I am getting the same error "The permissions granted to user
> | 'MYDOMAIN\IUSR_MYDOMAIN' are insufficient for
> | performing this operation." I thought it was because we installed a
> | certifercate and applied SSL.
> |
> |
> | 2. How do I use SSL in Interdev with Report Services?
> |
> |
> | "Charl" wrote:
> |
> | > Hello,
> | >
> | > I just made a fresh install of Win2003 with VS.NET and SQL server 2000
> with
> | > reporting services. When I started to do some test projects to see if
> | > everything was working again and to see what the reporting services
> where I
> | > ran into some problems:
> | >
> | > - first I started a new reporting project and after setting up a test
> report
> | > I tried to build the project what worked, but when it came to the stage
> of
> | > deploying it during the build process it came with the error: " The
> | > permissions granted to user 'MYDOMAIN\IUSR_MYDOMAIN' are insufficient
> for
> | > performing this operation.". After searching the Internet I didn't
> found a
> | > sollution, so I tried the following:
> | >
> | > - I started a new web application (as allways) placed a button and
> textbox
> | > on it and ran it. It didn't work, it came with the following error
> "Error:
> | > Project Is Not Configured To Be Debugged". Looking in IIS admin I found
> out
> | > that there was only a virtual directory but no application made for it
> | > (properties "create" application). After doing this the web app worked.
> | > So it looks like VS.NET 2003 doesn't have enhough rights to work
> properly
> | > (because the reportingservices are still not working)? How can I fix
> this?
> | >
> | > BTW:
> | > - When I click within VS.NET on the internalt browser tab it display's
> mine
> | > reports properly, I can browse through multiple pages, save my report
> to pdf.
> | >
> | > - I posted this already to the dotnet.general newsgroup, and they told
> me to
> | > post the question on this forum.
> | >
> | > Thanks,
> | > Charl
> | >
> |
>|||HI...
We are usining both Annyonymous and Windows Integrations. This seems to
work. Are we doing something wrong?
:)
"Charl" wrote:
> Thanks Peter,
> This solved mine problem!
> So what you are saying is that it isn't possible to use the reportingservice
> with anonymouse access enabled? Because that is what I would like to do for
> my reports?!?
> Thanks,
> Charl
>
> "Peter Yang [MSFT]" wrote:
> > Hello Charl,
> >
> > This issue can occur if the virutal folders of IIS for reporting service
> > allow anonymouse.
> >
> > Please check the following settings:
> >
> > Right click Reports /ReportServer in IIS->Properties->Directory Security
> >
> > Make sure "Intergrated Windows authentication" is checked and "enable
> > anonymouse access" is unchecked.
> >
> > For SSL setting, please refer to
> >
> > Using Secure Sockets Layer (SSL) for SQL Server 2000 Reporting Services
> > http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnsql2k/html
> > /sslsetup.asp
> >
> > Hope this helps.
> >
> > Thanks & Regards,
> >
> > Peter Yang
> > MCSE2000/2003, MCSA, MCDBA
> > Microsoft Online Partner Support
> >
> > When responding to posts, please "Reply to Group" via your newsreader so
> > that others may learn and benefit from your issue.
> >
> > =====================================================> >
> > Business-Critical Phone Support (BCPS) provides you with technical phone
> > support at no charge during critical LAN outages or "business down"
> > situations. This benefit is available 24 hours a day, 7 days a week to all
> > Microsoft technology partners in the United States and Canada.
> >
> > This and other support options are available here:
> >
> > BCPS:
> > https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
> >
> > Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
> >
> > If you are outside the United States, please visit our International
> > Support page:
> > http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
> >
> > =====================================================> >
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > --
> > | Thread-Topic: Problems during the deployment of a report
> > | thread-index: AcUD43GQazYXHSyvSkKGiJUt0NAIzw==> > | X-WBNR-Posting-Host: 144.141.194.3
> > | From: "=?Utf-8?B?UlMtR2lybA==?=" <RSGirl@.discussions.microsoft.com>
> > | References: <84A55AEC-F91F-49D2-BFED-5474968DD8D3@.microsoft.com>
> > | Subject: RE: Problems during the deployment of a report
> > | Date: Wed, 26 Jan 2005 12:13:04 -0800
> > | Lines: 43
> > | Message-ID: <ABFED987-6704-4F7E-BA22-A4CC5893B14B@.microsoft.com>
> > | MIME-Version: 1.0
> > | Content-Type: text/plain;
> > | charset="Utf-8"
> > | Content-Transfer-Encoding: 7bit
> > | X-Newsreader: Microsoft CDO for Windows 2000
> > | Content-Class: urn:content-classes:message
> > | Importance: normal
> > | Priority: normal
> > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> > | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> > | Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:40960
> > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> > |
> > | 1. I am getting the same error "The permissions granted to user
> > | 'MYDOMAIN\IUSR_MYDOMAIN' are insufficient for
> > | performing this operation." I thought it was because we installed a
> > | certifercate and applied SSL.
> > |
> > |
> > | 2. How do I use SSL in Interdev with Report Services?
> > |
> > |
> > | "Charl" wrote:
> > |
> > | > Hello,
> > | >
> > | > I just made a fresh install of Win2003 with VS.NET and SQL server 2000
> > with
> > | > reporting services. When I started to do some test projects to see if
> > | > everything was working again and to see what the reporting services
> > where I
> > | > ran into some problems:
> > | >
> > | > - first I started a new reporting project and after setting up a test
> > report
> > | > I tried to build the project what worked, but when it came to the stage
> > of
> > | > deploying it during the build process it came with the error: " The
> > | > permissions granted to user 'MYDOMAIN\IUSR_MYDOMAIN' are insufficient
> > for
> > | > performing this operation.". After searching the Internet I didn't
> > found a
> > | > sollution, so I tried the following:
> > | >
> > | > - I started a new web application (as allways) placed a button and
> > textbox
> > | > on it and ran it. It didn't work, it came with the following error
> > "Error:
> > | > Project Is Not Configured To Be Debugged". Looking in IIS admin I found
> > out
> > | > that there was only a virtual directory but no application made for it
> > | > (properties "create" application). After doing this the web app worked.
> > | > So it looks like VS.NET 2003 doesn't have enhough rights to work
> > properly
> > | > (because the reportingservices are still not working)? How can I fix
> > this?
> > | >
> > | > BTW:
> > | > - When I click within VS.NET on the internalt browser tab it display's
> > mine
> > | > reports properly, I can browse through multiple pages, save my report
> > to pdf.
> > | >
> > | > - I posted this already to the dotnet.general newsgroup, and they told
> > me to
> > | > post the question on this forum.
> > | >
> > | > Thanks,
> > | > Charl
> > | >
> > |
> >
> >|||Hello Charl,
If you want to anonymouse to be able to run report properly, usually you
shall grant proper permission to ASP.net and USR_machinename accout.
- Chang the anonymous account to use IUSR_machinename
- Add aspnet/IUSR_machinename as a RM account and assigned browse, View
reports and View folder.
Usually you can check "enable anonymous access" in Reports virtual
directory but you shall not check it in ReportServer folder.
If the issue persists, try to add aspnet to the Admins group. Hope this
helps.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: Problems during the deployment of a report
| thread-index: AcUEbXeOmZUeArSJTFSbCQ/6IpLr7w==| X-WBNR-Posting-Host: 62.194.205.63
| From: "=?Utf-8?B?Q2hhcmw=?=" <Charl@.noemail.nospam>
| References: <84A55AEC-F91F-49D2-BFED-5474968DD8D3@.microsoft.com>
<ABFED987-6704-4F7E-BA22-A4CC5893B14B@.microsoft.com>
<5AaE0XCBFHA.2732@.cpmsftngxa10.phx.gbl>
| Subject: RE: Problems during the deployment of a report
| Date: Thu, 27 Jan 2005 04:41:05 -0800
| Lines: 151
| Message-ID: <D24DA289-3C1A-4C11-B6CE-847A313DE4BE@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:41027
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Thanks Peter,
|
| This solved mine problem!
| So what you are saying is that it isn't possible to use the
reportingservice
| with anonymouse access enabled? Because that is what I would like to do
for
| my reports?!?
|
| Thanks,
|
| Charl
|
|
| "Peter Yang [MSFT]" wrote:
|
| > Hello Charl,
| >
| > This issue can occur if the virutal folders of IIS for reporting
service
| > allow anonymouse.
| >
| > Please check the following settings:
| >
| > Right click Reports /ReportServer in IIS->Properties->Directory Security
| >
| > Make sure "Intergrated Windows authentication" is checked and "enable
| > anonymouse access" is unchecked.
| >
| > For SSL setting, please refer to
| >
| > Using Secure Sockets Layer (SSL) for SQL Server 2000 Reporting Services
| >
http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnsql2k/html
| > /sslsetup.asp
| >
| > Hope this helps.
| >
| > Thanks & Regards,
| >
| > Peter Yang
| > MCSE2000/2003, MCSA, MCDBA
| > Microsoft Online Partner Support
| >
| > When responding to posts, please "Reply to Group" via your newsreader
so
| > that others may learn and benefit from your issue.
| >
| > =====================================================| >
| > Business-Critical Phone Support (BCPS) provides you with technical
phone
| > support at no charge during critical LAN outages or "business down"
| > situations. This benefit is available 24 hours a day, 7 days a week to
all
| > Microsoft technology partners in the United States and Canada.
| >
| > This and other support options are available here:
| >
| > BCPS:
| >
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
| >
| > Others:
https://partner.microsoft.com/US/technicalsupport/supportoverview/
| >
| > If you are outside the United States, please visit our International
| > Support page:
| > http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
| >
| > =====================================================| >
| > This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| >
| > --
| > | Thread-Topic: Problems during the deployment of a report
| > | thread-index: AcUD43GQazYXHSyvSkKGiJUt0NAIzw==| > | X-WBNR-Posting-Host: 144.141.194.3
| > | From: "=?Utf-8?B?UlMtR2lybA==?=" <RSGirl@.discussions.microsoft.com>
| > | References: <84A55AEC-F91F-49D2-BFED-5474968DD8D3@.microsoft.com>
| > | Subject: RE: Problems during the deployment of a report
| > | Date: Wed, 26 Jan 2005 12:13:04 -0800
| > | Lines: 43
| > | Message-ID: <ABFED987-6704-4F7E-BA22-A4CC5893B14B@.microsoft.com>
| > | MIME-Version: 1.0
| > | Content-Type: text/plain;
| > | charset="Utf-8"
| > | Content-Transfer-Encoding: 7bit
| > | X-Newsreader: Microsoft CDO for Windows 2000
| > | Content-Class: urn:content-classes:message
| > | Importance: normal
| > | Priority: normal
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| > | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| > | Xref: cpmsftngxa10.phx.gbl
microsoft.public.sqlserver.reportingsvcs:40960
| > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > |
| > | 1. I am getting the same error "The permissions granted to user
| > | 'MYDOMAIN\IUSR_MYDOMAIN' are insufficient for
| > | performing this operation." I thought it was because we installed a
| > | certifercate and applied SSL.
| > |
| > |
| > | 2. How do I use SSL in Interdev with Report Services?
| > |
| > |
| > | "Charl" wrote:
| > |
| > | > Hello,
| > | >
| > | > I just made a fresh install of Win2003 with VS.NET and SQL server
2000
| > with
| > | > reporting services. When I started to do some test projects to see
if
| > | > everything was working again and to see what the reporting services
| > where I
| > | > ran into some problems:
| > | >
| > | > - first I started a new reporting project and after setting up a
test
| > report
| > | > I tried to build the project what worked, but when it came to the
stage
| > of
| > | > deploying it during the build process it came with the error: " The
| > | > permissions granted to user 'MYDOMAIN\IUSR_MYDOMAIN' are
insufficient
| > for
| > | > performing this operation.". After searching the Internet I didn't
| > found a
| > | > sollution, so I tried the following:
| > | >
| > | > - I started a new web application (as allways) placed a button and
| > textbox
| > | > on it and ran it. It didn't work, it came with the following error
| > "Error:
| > | > Project Is Not Configured To Be Debugged". Looking in IIS admin I
found
| > out
| > | > that there was only a virtual directory but no application made for
it
| > | > (properties "create" application). After doing this the web app
worked.
| > | > So it looks like VS.NET 2003 doesn't have enhough rights to work
| > properly
| > | > (because the reportingservices are still not working)? How can I
fix
| > this?
| > | >
| > | > BTW:
| > | > - When I click within VS.NET on the internalt browser tab it
display's
| > mine
| > | > reports properly, I can browse through multiple pages, save my
report
| > to pdf.
| > | >
| > | > - I posted this already to the dotnet.general newsgroup, and they
told
| > me to
| > | > post the question on this forum.
| > | >
| > | > Thanks,
| > | > Charl
| > | >
| > |
| >
| >
||||i've a similiar problem the error message is "The permissions granted to user
'DOMAIN\USER are insufficient for performing this operation. (rsAccessDenied)
"
I've changed premission of the fisical directory "ReportingServices" to
everyone full control
and put the aspnet user in the administrators group but it didn't work.
Is there any documentention on how to set a reporting server to anonyous use?
"Peter Yang [MSFT]" wrote:
> Hello Charl,
> If you want to anonymouse to be able to run report properly, usually you
> shall grant proper permission to ASP.net and USR_machinename accout.
> - Chang the anonymous account to use IUSR_machinename
> - Add aspnet/IUSR_machinename as a RM account and assigned browse, View
> reports and View folder.
> Usually you can check "enable anonymous access" in Reports virtual
> directory but you shall not check it in ReportServer folder.
> If the issue persists, try to add aspnet to the Admins group. Hope this
> helps.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> --
> | Thread-Topic: Problems during the deployment of a report
> | thread-index: AcUEbXeOmZUeArSJTFSbCQ/6IpLr7w==> | X-WBNR-Posting-Host: 62.194.205.63
> | From: "=?Utf-8?B?Q2hhcmw=?=" <Charl@.noemail.nospam>
> | References: <84A55AEC-F91F-49D2-BFED-5474968DD8D3@.microsoft.com>
> <ABFED987-6704-4F7E-BA22-A4CC5893B14B@.microsoft.com>
> <5AaE0XCBFHA.2732@.cpmsftngxa10.phx.gbl>
> | Subject: RE: Problems during the deployment of a report
> | Date: Thu, 27 Jan 2005 04:41:05 -0800
> | Lines: 151
> | Message-ID: <D24DA289-3C1A-4C11-B6CE-847A313DE4BE@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:41027
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | Thanks Peter,
> |
> | This solved mine problem!
> | So what you are saying is that it isn't possible to use the
> reportingservice
> | with anonymouse access enabled? Because that is what I would like to do
> for
> | my reports?!?
> |
> | Thanks,
> |
> | Charl
> |
> |
> | "Peter Yang [MSFT]" wrote:
> |
> | > Hello Charl,
> | >
> | > This issue can occur if the virutal folders of IIS for reporting
> service
> | > allow anonymouse.
> | >
> | > Please check the following settings:
> | >
> | > Right click Reports /ReportServer in IIS->Properties->Directory Security
> | >
> | > Make sure "Intergrated Windows authentication" is checked and "enable
> | > anonymouse access" is unchecked.
> | >
> | > For SSL setting, please refer to
> | >
> | > Using Secure Sockets Layer (SSL) for SQL Server 2000 Reporting Services
> | >
> http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnsql2k/html
> | > /sslsetup.asp
> | >
> | > Hope this helps.
> | >
> | > Thanks & Regards,
> | >
> | > Peter Yang
> | > MCSE2000/2003, MCSA, MCDBA
> | > Microsoft Online Partner Support
> | >
> | > When responding to posts, please "Reply to Group" via your newsreader
> so
> | > that others may learn and benefit from your issue.
> | >
> | > =====================================================> | >
> | > Business-Critical Phone Support (BCPS) provides you with technical
> phone
> | > support at no charge during critical LAN outages or "business down"
> | > situations. This benefit is available 24 hours a day, 7 days a week to
> all
> | > Microsoft technology partners in the United States and Canada.
> | >
> | > This and other support options are available here:
> | >
> | > BCPS:
> | >
> https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
> | >
> | > Others:
> https://partner.microsoft.com/US/technicalsupport/supportoverview/
> | >
> | > If you are outside the United States, please visit our International
> | > Support page:
> | > http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
> | >
> | > =====================================================> | >
> | > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> | >
> | >
> | > --
> | > | Thread-Topic: Problems during the deployment of a report
> | > | thread-index: AcUD43GQazYXHSyvSkKGiJUt0NAIzw==> | > | X-WBNR-Posting-Host: 144.141.194.3
> | > | From: "=?Utf-8?B?UlMtR2lybA==?=" <RSGirl@.discussions.microsoft.com>
> | > | References: <84A55AEC-F91F-49D2-BFED-5474968DD8D3@.microsoft.com>
> | > | Subject: RE: Problems during the deployment of a report
> | > | Date: Wed, 26 Jan 2005 12:13:04 -0800
> | > | Lines: 43
> | > | Message-ID: <ABFED987-6704-4F7E-BA22-A4CC5893B14B@.microsoft.com>
> | > | MIME-Version: 1.0
> | > | Content-Type: text/plain;
> | > | charset="Utf-8"
> | > | Content-Transfer-Encoding: 7bit
> | > | X-Newsreader: Microsoft CDO for Windows 2000
> | > | Content-Class: urn:content-classes:message
> | > | Importance: normal
> | > | Priority: normal
> | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | > | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | > | Xref: cpmsftngxa10.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:40960
> | > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> | > |
> | > | 1. I am getting the same error "The permissions granted to user
> | > | 'MYDOMAIN\IUSR_MYDOMAIN' are insufficient for
> | > | performing this operation." I thought it was because we installed a
> | > | certifercate and applied SSL.
> | > |
> | > |
> | > | 2. How do I use SSL in Interdev with Report Services?
> | > |
> | > |
> | > | "Charl" wrote:
> | > |
> | > | > Hello,
> | > | >
> | > | > I just made a fresh install of Win2003 with VS.NET and SQL server
> 2000
> | > with
> | > | > reporting services. When I started to do some test projects to see
> if
> | > | > everything was working again and to see what the reporting services
> | > where I
> | > | > ran into some problems:
> | > | >
> | > | > - first I started a new reporting project and after setting up a
> test
> | > report
> | > | > I tried to build the project what worked, but when it came to the
> stage
> | > of
> | > | > deploying it during the build process it came with the error: " The
> | > | > permissions granted to user 'MYDOMAIN\IUSR_MYDOMAIN' are
> insufficient
> | > for
> | > | > performing this operation.". After searching the Internet I didn't
> | > found a
> | > | > sollution, so I tried the following:
> | > | >
> | > | > - I started a new web application (as allways) placed a button and
> | > textbox
> | > | > on it and ran it. It didn't work, it came with the following error
> | > "Error:
> | > | > Project Is Not Configured To Be Debugged". Looking in IIS admin I
> found
> | > out
> | > | > that there was only a virtual directory but no application made for
> it
> | > | > (properties "create" application). After doing this the web app
> worked.
> | > | > So it looks like VS.NET 2003 doesn't have enhough rights to work
> | > properly
> | > | > (because the reportingservices are still not working)? How can I
> fix
> | > this?
> | > | >
> | > | > BTW:
> | > | > - When I click within VS.NET on the internalt browser tab it
> display's
> | > mine
> | > | > reports properly, I can browse through multiple pages, save my
> report
> | > to pdf.
> | > | >
> | > | > - I posted this already to the dotnet.general newsgroup, and they
> told
> | > me to
> | > | > post the question on this forum.
> | > | >
> | > | > Thanks,
> | > | > Charl
> | > | >
> | > |
> | >
> | >
> |
>sql
I just made a fresh install of Win2003 with VS.NET and SQL server 2000 with
reporting services. When I started to do some test projects to see if
everything was working again and to see what the reporting services where I
ran into some problems:
- first I started a new reporting project and after setting up a test report
I tried to build the project what worked, but when it came to the stage of
deploying it during the build process it came with the error: " The
permissions granted to user 'MYDOMAIN\IUSR_MYDOMAIN' are insufficient for
performing this operation.". After searching the Internet I didn't found a
sollution, so I tried the following:
- I started a new web application (as allways) placed a button and textbox
on it and ran it. It didn't work, it came with the following error "Error:
Project Is Not Configured To Be Debugged". Looking in IIS admin I found out
that there was only a virtual directory but no application made for it
(properties "create" application). After doing this the web app worked.
So it looks like VS.NET 2003 doesn't have enhough rights to work properly
(because the reportingservices are still not working)? How can I fix this?
BTW:
- When I click within VS.NET on the internalt browser tab it display's mine
reports properly, I can browse through multiple pages, save my report to pdf.
- I posted this already to the dotnet.general newsgroup, and they told me to
post the question on this forum.
Thanks,
Charl1. I am getting the same error "The permissions granted to user
'MYDOMAIN\IUSR_MYDOMAIN' are insufficient for
performing this operation." I thought it was because we installed a
certifercate and applied SSL.
2. How do I use SSL in Interdev with Report Services?
"Charl" wrote:
> Hello,
> I just made a fresh install of Win2003 with VS.NET and SQL server 2000 with
> reporting services. When I started to do some test projects to see if
> everything was working again and to see what the reporting services where I
> ran into some problems:
> - first I started a new reporting project and after setting up a test report
> I tried to build the project what worked, but when it came to the stage of
> deploying it during the build process it came with the error: " The
> permissions granted to user 'MYDOMAIN\IUSR_MYDOMAIN' are insufficient for
> performing this operation.". After searching the Internet I didn't found a
> sollution, so I tried the following:
> - I started a new web application (as allways) placed a button and textbox
> on it and ran it. It didn't work, it came with the following error "Error:
> Project Is Not Configured To Be Debugged". Looking in IIS admin I found out
> that there was only a virtual directory but no application made for it
> (properties "create" application). After doing this the web app worked.
> So it looks like VS.NET 2003 doesn't have enhough rights to work properly
> (because the reportingservices are still not working)? How can I fix this?
> BTW:
> - When I click within VS.NET on the internalt browser tab it display's mine
> reports properly, I can browse through multiple pages, save my report to pdf.
> - I posted this already to the dotnet.general newsgroup, and they told me to
> post the question on this forum.
> Thanks,
> Charl
>|||Hello Charl,
This issue can occur if the virutal folders of IIS for reporting service
allow anonymouse.
Please check the following settings:
Right click Reports /ReportServer in IIS->Properties->Directory Security
Make sure "Intergrated Windows authentication" is checked and "enable
anonymouse access" is unchecked.
For SSL setting, please refer to
Using Secure Sockets Layer (SSL) for SQL Server 2000 Reporting Services
http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnsql2k/html
/sslsetup.asp
Hope this helps.
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: Problems during the deployment of a report
| thread-index: AcUD43GQazYXHSyvSkKGiJUt0NAIzw==| X-WBNR-Posting-Host: 144.141.194.3
| From: "=?Utf-8?B?UlMtR2lybA==?=" <RSGirl@.discussions.microsoft.com>
| References: <84A55AEC-F91F-49D2-BFED-5474968DD8D3@.microsoft.com>
| Subject: RE: Problems during the deployment of a report
| Date: Wed, 26 Jan 2005 12:13:04 -0800
| Lines: 43
| Message-ID: <ABFED987-6704-4F7E-BA22-A4CC5893B14B@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:40960
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| 1. I am getting the same error "The permissions granted to user
| 'MYDOMAIN\IUSR_MYDOMAIN' are insufficient for
| performing this operation." I thought it was because we installed a
| certifercate and applied SSL.
|
|
| 2. How do I use SSL in Interdev with Report Services?
|
|
| "Charl" wrote:
|
| > Hello,
| >
| > I just made a fresh install of Win2003 with VS.NET and SQL server 2000
with
| > reporting services. When I started to do some test projects to see if
| > everything was working again and to see what the reporting services
where I
| > ran into some problems:
| >
| > - first I started a new reporting project and after setting up a test
report
| > I tried to build the project what worked, but when it came to the stage
of
| > deploying it during the build process it came with the error: " The
| > permissions granted to user 'MYDOMAIN\IUSR_MYDOMAIN' are insufficient
for
| > performing this operation.". After searching the Internet I didn't
found a
| > sollution, so I tried the following:
| >
| > - I started a new web application (as allways) placed a button and
textbox
| > on it and ran it. It didn't work, it came with the following error
"Error:
| > Project Is Not Configured To Be Debugged". Looking in IIS admin I found
out
| > that there was only a virtual directory but no application made for it
| > (properties "create" application). After doing this the web app worked.
| > So it looks like VS.NET 2003 doesn't have enhough rights to work
properly
| > (because the reportingservices are still not working)? How can I fix
this?
| >
| > BTW:
| > - When I click within VS.NET on the internalt browser tab it display's
mine
| > reports properly, I can browse through multiple pages, save my report
to pdf.
| >
| > - I posted this already to the dotnet.general newsgroup, and they told
me to
| > post the question on this forum.
| >
| > Thanks,
| > Charl
| >
||||Thanks Peter,
This solved mine problem!
So what you are saying is that it isn't possible to use the reportingservice
with anonymouse access enabled? Because that is what I would like to do for
my reports?!?
Thanks,
Charl
"Peter Yang [MSFT]" wrote:
> Hello Charl,
> This issue can occur if the virutal folders of IIS for reporting service
> allow anonymouse.
> Please check the following settings:
> Right click Reports /ReportServer in IIS->Properties->Directory Security
> Make sure "Intergrated Windows authentication" is checked and "enable
> anonymouse access" is unchecked.
> For SSL setting, please refer to
> Using Secure Sockets Layer (SSL) for SQL Server 2000 Reporting Services
> http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnsql2k/html
> /sslsetup.asp
> Hope this helps.
> Thanks & Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> Business-Critical Phone Support (BCPS) provides you with technical phone
> support at no charge during critical LAN outages or "business down"
> situations. This benefit is available 24 hours a day, 7 days a week to all
> Microsoft technology partners in the United States and Canada.
> This and other support options are available here:
> BCPS:
> https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
> Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
> If you are outside the United States, please visit our International
> Support page:
> http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> --
> | Thread-Topic: Problems during the deployment of a report
> | thread-index: AcUD43GQazYXHSyvSkKGiJUt0NAIzw==> | X-WBNR-Posting-Host: 144.141.194.3
> | From: "=?Utf-8?B?UlMtR2lybA==?=" <RSGirl@.discussions.microsoft.com>
> | References: <84A55AEC-F91F-49D2-BFED-5474968DD8D3@.microsoft.com>
> | Subject: RE: Problems during the deployment of a report
> | Date: Wed, 26 Jan 2005 12:13:04 -0800
> | Lines: 43
> | Message-ID: <ABFED987-6704-4F7E-BA22-A4CC5893B14B@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:40960
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | 1. I am getting the same error "The permissions granted to user
> | 'MYDOMAIN\IUSR_MYDOMAIN' are insufficient for
> | performing this operation." I thought it was because we installed a
> | certifercate and applied SSL.
> |
> |
> | 2. How do I use SSL in Interdev with Report Services?
> |
> |
> | "Charl" wrote:
> |
> | > Hello,
> | >
> | > I just made a fresh install of Win2003 with VS.NET and SQL server 2000
> with
> | > reporting services. When I started to do some test projects to see if
> | > everything was working again and to see what the reporting services
> where I
> | > ran into some problems:
> | >
> | > - first I started a new reporting project and after setting up a test
> report
> | > I tried to build the project what worked, but when it came to the stage
> of
> | > deploying it during the build process it came with the error: " The
> | > permissions granted to user 'MYDOMAIN\IUSR_MYDOMAIN' are insufficient
> for
> | > performing this operation.". After searching the Internet I didn't
> found a
> | > sollution, so I tried the following:
> | >
> | > - I started a new web application (as allways) placed a button and
> textbox
> | > on it and ran it. It didn't work, it came with the following error
> "Error:
> | > Project Is Not Configured To Be Debugged". Looking in IIS admin I found
> out
> | > that there was only a virtual directory but no application made for it
> | > (properties "create" application). After doing this the web app worked.
> | > So it looks like VS.NET 2003 doesn't have enhough rights to work
> properly
> | > (because the reportingservices are still not working)? How can I fix
> this?
> | >
> | > BTW:
> | > - When I click within VS.NET on the internalt browser tab it display's
> mine
> | > reports properly, I can browse through multiple pages, save my report
> to pdf.
> | >
> | > - I posted this already to the dotnet.general newsgroup, and they told
> me to
> | > post the question on this forum.
> | >
> | > Thanks,
> | > Charl
> | >
> |
>|||HI...
We are usining both Annyonymous and Windows Integrations. This seems to
work. Are we doing something wrong?
:)
"Charl" wrote:
> Thanks Peter,
> This solved mine problem!
> So what you are saying is that it isn't possible to use the reportingservice
> with anonymouse access enabled? Because that is what I would like to do for
> my reports?!?
> Thanks,
> Charl
>
> "Peter Yang [MSFT]" wrote:
> > Hello Charl,
> >
> > This issue can occur if the virutal folders of IIS for reporting service
> > allow anonymouse.
> >
> > Please check the following settings:
> >
> > Right click Reports /ReportServer in IIS->Properties->Directory Security
> >
> > Make sure "Intergrated Windows authentication" is checked and "enable
> > anonymouse access" is unchecked.
> >
> > For SSL setting, please refer to
> >
> > Using Secure Sockets Layer (SSL) for SQL Server 2000 Reporting Services
> > http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnsql2k/html
> > /sslsetup.asp
> >
> > Hope this helps.
> >
> > Thanks & Regards,
> >
> > Peter Yang
> > MCSE2000/2003, MCSA, MCDBA
> > Microsoft Online Partner Support
> >
> > When responding to posts, please "Reply to Group" via your newsreader so
> > that others may learn and benefit from your issue.
> >
> > =====================================================> >
> > Business-Critical Phone Support (BCPS) provides you with technical phone
> > support at no charge during critical LAN outages or "business down"
> > situations. This benefit is available 24 hours a day, 7 days a week to all
> > Microsoft technology partners in the United States and Canada.
> >
> > This and other support options are available here:
> >
> > BCPS:
> > https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
> >
> > Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
> >
> > If you are outside the United States, please visit our International
> > Support page:
> > http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
> >
> > =====================================================> >
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > --
> > | Thread-Topic: Problems during the deployment of a report
> > | thread-index: AcUD43GQazYXHSyvSkKGiJUt0NAIzw==> > | X-WBNR-Posting-Host: 144.141.194.3
> > | From: "=?Utf-8?B?UlMtR2lybA==?=" <RSGirl@.discussions.microsoft.com>
> > | References: <84A55AEC-F91F-49D2-BFED-5474968DD8D3@.microsoft.com>
> > | Subject: RE: Problems during the deployment of a report
> > | Date: Wed, 26 Jan 2005 12:13:04 -0800
> > | Lines: 43
> > | Message-ID: <ABFED987-6704-4F7E-BA22-A4CC5893B14B@.microsoft.com>
> > | MIME-Version: 1.0
> > | Content-Type: text/plain;
> > | charset="Utf-8"
> > | Content-Transfer-Encoding: 7bit
> > | X-Newsreader: Microsoft CDO for Windows 2000
> > | Content-Class: urn:content-classes:message
> > | Importance: normal
> > | Priority: normal
> > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> > | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> > | Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:40960
> > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> > |
> > | 1. I am getting the same error "The permissions granted to user
> > | 'MYDOMAIN\IUSR_MYDOMAIN' are insufficient for
> > | performing this operation." I thought it was because we installed a
> > | certifercate and applied SSL.
> > |
> > |
> > | 2. How do I use SSL in Interdev with Report Services?
> > |
> > |
> > | "Charl" wrote:
> > |
> > | > Hello,
> > | >
> > | > I just made a fresh install of Win2003 with VS.NET and SQL server 2000
> > with
> > | > reporting services. When I started to do some test projects to see if
> > | > everything was working again and to see what the reporting services
> > where I
> > | > ran into some problems:
> > | >
> > | > - first I started a new reporting project and after setting up a test
> > report
> > | > I tried to build the project what worked, but when it came to the stage
> > of
> > | > deploying it during the build process it came with the error: " The
> > | > permissions granted to user 'MYDOMAIN\IUSR_MYDOMAIN' are insufficient
> > for
> > | > performing this operation.". After searching the Internet I didn't
> > found a
> > | > sollution, so I tried the following:
> > | >
> > | > - I started a new web application (as allways) placed a button and
> > textbox
> > | > on it and ran it. It didn't work, it came with the following error
> > "Error:
> > | > Project Is Not Configured To Be Debugged". Looking in IIS admin I found
> > out
> > | > that there was only a virtual directory but no application made for it
> > | > (properties "create" application). After doing this the web app worked.
> > | > So it looks like VS.NET 2003 doesn't have enhough rights to work
> > properly
> > | > (because the reportingservices are still not working)? How can I fix
> > this?
> > | >
> > | > BTW:
> > | > - When I click within VS.NET on the internalt browser tab it display's
> > mine
> > | > reports properly, I can browse through multiple pages, save my report
> > to pdf.
> > | >
> > | > - I posted this already to the dotnet.general newsgroup, and they told
> > me to
> > | > post the question on this forum.
> > | >
> > | > Thanks,
> > | > Charl
> > | >
> > |
> >
> >|||Hello Charl,
If you want to anonymouse to be able to run report properly, usually you
shall grant proper permission to ASP.net and USR_machinename accout.
- Chang the anonymous account to use IUSR_machinename
- Add aspnet/IUSR_machinename as a RM account and assigned browse, View
reports and View folder.
Usually you can check "enable anonymous access" in Reports virtual
directory but you shall not check it in ReportServer folder.
If the issue persists, try to add aspnet to the Admins group. Hope this
helps.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: Problems during the deployment of a report
| thread-index: AcUEbXeOmZUeArSJTFSbCQ/6IpLr7w==| X-WBNR-Posting-Host: 62.194.205.63
| From: "=?Utf-8?B?Q2hhcmw=?=" <Charl@.noemail.nospam>
| References: <84A55AEC-F91F-49D2-BFED-5474968DD8D3@.microsoft.com>
<ABFED987-6704-4F7E-BA22-A4CC5893B14B@.microsoft.com>
<5AaE0XCBFHA.2732@.cpmsftngxa10.phx.gbl>
| Subject: RE: Problems during the deployment of a report
| Date: Thu, 27 Jan 2005 04:41:05 -0800
| Lines: 151
| Message-ID: <D24DA289-3C1A-4C11-B6CE-847A313DE4BE@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:41027
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Thanks Peter,
|
| This solved mine problem!
| So what you are saying is that it isn't possible to use the
reportingservice
| with anonymouse access enabled? Because that is what I would like to do
for
| my reports?!?
|
| Thanks,
|
| Charl
|
|
| "Peter Yang [MSFT]" wrote:
|
| > Hello Charl,
| >
| > This issue can occur if the virutal folders of IIS for reporting
service
| > allow anonymouse.
| >
| > Please check the following settings:
| >
| > Right click Reports /ReportServer in IIS->Properties->Directory Security
| >
| > Make sure "Intergrated Windows authentication" is checked and "enable
| > anonymouse access" is unchecked.
| >
| > For SSL setting, please refer to
| >
| > Using Secure Sockets Layer (SSL) for SQL Server 2000 Reporting Services
| >
http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnsql2k/html
| > /sslsetup.asp
| >
| > Hope this helps.
| >
| > Thanks & Regards,
| >
| > Peter Yang
| > MCSE2000/2003, MCSA, MCDBA
| > Microsoft Online Partner Support
| >
| > When responding to posts, please "Reply to Group" via your newsreader
so
| > that others may learn and benefit from your issue.
| >
| > =====================================================| >
| > Business-Critical Phone Support (BCPS) provides you with technical
phone
| > support at no charge during critical LAN outages or "business down"
| > situations. This benefit is available 24 hours a day, 7 days a week to
all
| > Microsoft technology partners in the United States and Canada.
| >
| > This and other support options are available here:
| >
| > BCPS:
| >
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
| >
| > Others:
https://partner.microsoft.com/US/technicalsupport/supportoverview/
| >
| > If you are outside the United States, please visit our International
| > Support page:
| > http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
| >
| > =====================================================| >
| > This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| >
| > --
| > | Thread-Topic: Problems during the deployment of a report
| > | thread-index: AcUD43GQazYXHSyvSkKGiJUt0NAIzw==| > | X-WBNR-Posting-Host: 144.141.194.3
| > | From: "=?Utf-8?B?UlMtR2lybA==?=" <RSGirl@.discussions.microsoft.com>
| > | References: <84A55AEC-F91F-49D2-BFED-5474968DD8D3@.microsoft.com>
| > | Subject: RE: Problems during the deployment of a report
| > | Date: Wed, 26 Jan 2005 12:13:04 -0800
| > | Lines: 43
| > | Message-ID: <ABFED987-6704-4F7E-BA22-A4CC5893B14B@.microsoft.com>
| > | MIME-Version: 1.0
| > | Content-Type: text/plain;
| > | charset="Utf-8"
| > | Content-Transfer-Encoding: 7bit
| > | X-Newsreader: Microsoft CDO for Windows 2000
| > | Content-Class: urn:content-classes:message
| > | Importance: normal
| > | Priority: normal
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| > | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| > | Xref: cpmsftngxa10.phx.gbl
microsoft.public.sqlserver.reportingsvcs:40960
| > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > |
| > | 1. I am getting the same error "The permissions granted to user
| > | 'MYDOMAIN\IUSR_MYDOMAIN' are insufficient for
| > | performing this operation." I thought it was because we installed a
| > | certifercate and applied SSL.
| > |
| > |
| > | 2. How do I use SSL in Interdev with Report Services?
| > |
| > |
| > | "Charl" wrote:
| > |
| > | > Hello,
| > | >
| > | > I just made a fresh install of Win2003 with VS.NET and SQL server
2000
| > with
| > | > reporting services. When I started to do some test projects to see
if
| > | > everything was working again and to see what the reporting services
| > where I
| > | > ran into some problems:
| > | >
| > | > - first I started a new reporting project and after setting up a
test
| > report
| > | > I tried to build the project what worked, but when it came to the
stage
| > of
| > | > deploying it during the build process it came with the error: " The
| > | > permissions granted to user 'MYDOMAIN\IUSR_MYDOMAIN' are
insufficient
| > for
| > | > performing this operation.". After searching the Internet I didn't
| > found a
| > | > sollution, so I tried the following:
| > | >
| > | > - I started a new web application (as allways) placed a button and
| > textbox
| > | > on it and ran it. It didn't work, it came with the following error
| > "Error:
| > | > Project Is Not Configured To Be Debugged". Looking in IIS admin I
found
| > out
| > | > that there was only a virtual directory but no application made for
it
| > | > (properties "create" application). After doing this the web app
worked.
| > | > So it looks like VS.NET 2003 doesn't have enhough rights to work
| > properly
| > | > (because the reportingservices are still not working)? How can I
fix
| > this?
| > | >
| > | > BTW:
| > | > - When I click within VS.NET on the internalt browser tab it
display's
| > mine
| > | > reports properly, I can browse through multiple pages, save my
report
| > to pdf.
| > | >
| > | > - I posted this already to the dotnet.general newsgroup, and they
told
| > me to
| > | > post the question on this forum.
| > | >
| > | > Thanks,
| > | > Charl
| > | >
| > |
| >
| >
||||i've a similiar problem the error message is "The permissions granted to user
'DOMAIN\USER are insufficient for performing this operation. (rsAccessDenied)
"
I've changed premission of the fisical directory "ReportingServices" to
everyone full control
and put the aspnet user in the administrators group but it didn't work.
Is there any documentention on how to set a reporting server to anonyous use?
"Peter Yang [MSFT]" wrote:
> Hello Charl,
> If you want to anonymouse to be able to run report properly, usually you
> shall grant proper permission to ASP.net and USR_machinename accout.
> - Chang the anonymous account to use IUSR_machinename
> - Add aspnet/IUSR_machinename as a RM account and assigned browse, View
> reports and View folder.
> Usually you can check "enable anonymous access" in Reports virtual
> directory but you shall not check it in ReportServer folder.
> If the issue persists, try to add aspnet to the Admins group. Hope this
> helps.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> --
> | Thread-Topic: Problems during the deployment of a report
> | thread-index: AcUEbXeOmZUeArSJTFSbCQ/6IpLr7w==> | X-WBNR-Posting-Host: 62.194.205.63
> | From: "=?Utf-8?B?Q2hhcmw=?=" <Charl@.noemail.nospam>
> | References: <84A55AEC-F91F-49D2-BFED-5474968DD8D3@.microsoft.com>
> <ABFED987-6704-4F7E-BA22-A4CC5893B14B@.microsoft.com>
> <5AaE0XCBFHA.2732@.cpmsftngxa10.phx.gbl>
> | Subject: RE: Problems during the deployment of a report
> | Date: Thu, 27 Jan 2005 04:41:05 -0800
> | Lines: 151
> | Message-ID: <D24DA289-3C1A-4C11-B6CE-847A313DE4BE@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:41027
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | Thanks Peter,
> |
> | This solved mine problem!
> | So what you are saying is that it isn't possible to use the
> reportingservice
> | with anonymouse access enabled? Because that is what I would like to do
> for
> | my reports?!?
> |
> | Thanks,
> |
> | Charl
> |
> |
> | "Peter Yang [MSFT]" wrote:
> |
> | > Hello Charl,
> | >
> | > This issue can occur if the virutal folders of IIS for reporting
> service
> | > allow anonymouse.
> | >
> | > Please check the following settings:
> | >
> | > Right click Reports /ReportServer in IIS->Properties->Directory Security
> | >
> | > Make sure "Intergrated Windows authentication" is checked and "enable
> | > anonymouse access" is unchecked.
> | >
> | > For SSL setting, please refer to
> | >
> | > Using Secure Sockets Layer (SSL) for SQL Server 2000 Reporting Services
> | >
> http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnsql2k/html
> | > /sslsetup.asp
> | >
> | > Hope this helps.
> | >
> | > Thanks & Regards,
> | >
> | > Peter Yang
> | > MCSE2000/2003, MCSA, MCDBA
> | > Microsoft Online Partner Support
> | >
> | > When responding to posts, please "Reply to Group" via your newsreader
> so
> | > that others may learn and benefit from your issue.
> | >
> | > =====================================================> | >
> | > Business-Critical Phone Support (BCPS) provides you with technical
> phone
> | > support at no charge during critical LAN outages or "business down"
> | > situations. This benefit is available 24 hours a day, 7 days a week to
> all
> | > Microsoft technology partners in the United States and Canada.
> | >
> | > This and other support options are available here:
> | >
> | > BCPS:
> | >
> https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
> | >
> | > Others:
> https://partner.microsoft.com/US/technicalsupport/supportoverview/
> | >
> | > If you are outside the United States, please visit our International
> | > Support page:
> | > http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
> | >
> | > =====================================================> | >
> | > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> | >
> | >
> | > --
> | > | Thread-Topic: Problems during the deployment of a report
> | > | thread-index: AcUD43GQazYXHSyvSkKGiJUt0NAIzw==> | > | X-WBNR-Posting-Host: 144.141.194.3
> | > | From: "=?Utf-8?B?UlMtR2lybA==?=" <RSGirl@.discussions.microsoft.com>
> | > | References: <84A55AEC-F91F-49D2-BFED-5474968DD8D3@.microsoft.com>
> | > | Subject: RE: Problems during the deployment of a report
> | > | Date: Wed, 26 Jan 2005 12:13:04 -0800
> | > | Lines: 43
> | > | Message-ID: <ABFED987-6704-4F7E-BA22-A4CC5893B14B@.microsoft.com>
> | > | MIME-Version: 1.0
> | > | Content-Type: text/plain;
> | > | charset="Utf-8"
> | > | Content-Transfer-Encoding: 7bit
> | > | X-Newsreader: Microsoft CDO for Windows 2000
> | > | Content-Class: urn:content-classes:message
> | > | Importance: normal
> | > | Priority: normal
> | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | > | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | > | Xref: cpmsftngxa10.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:40960
> | > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> | > |
> | > | 1. I am getting the same error "The permissions granted to user
> | > | 'MYDOMAIN\IUSR_MYDOMAIN' are insufficient for
> | > | performing this operation." I thought it was because we installed a
> | > | certifercate and applied SSL.
> | > |
> | > |
> | > | 2. How do I use SSL in Interdev with Report Services?
> | > |
> | > |
> | > | "Charl" wrote:
> | > |
> | > | > Hello,
> | > | >
> | > | > I just made a fresh install of Win2003 with VS.NET and SQL server
> 2000
> | > with
> | > | > reporting services. When I started to do some test projects to see
> if
> | > | > everything was working again and to see what the reporting services
> | > where I
> | > | > ran into some problems:
> | > | >
> | > | > - first I started a new reporting project and after setting up a
> test
> | > report
> | > | > I tried to build the project what worked, but when it came to the
> stage
> | > of
> | > | > deploying it during the build process it came with the error: " The
> | > | > permissions granted to user 'MYDOMAIN\IUSR_MYDOMAIN' are
> insufficient
> | > for
> | > | > performing this operation.". After searching the Internet I didn't
> | > found a
> | > | > sollution, so I tried the following:
> | > | >
> | > | > - I started a new web application (as allways) placed a button and
> | > textbox
> | > | > on it and ran it. It didn't work, it came with the following error
> | > "Error:
> | > | > Project Is Not Configured To Be Debugged". Looking in IIS admin I
> found
> | > out
> | > | > that there was only a virtual directory but no application made for
> it
> | > | > (properties "create" application). After doing this the web app
> worked.
> | > | > So it looks like VS.NET 2003 doesn't have enhough rights to work
> | > properly
> | > | > (because the reportingservices are still not working)? How can I
> fix
> | > this?
> | > | >
> | > | > BTW:
> | > | > - When I click within VS.NET on the internalt browser tab it
> display's
> | > mine
> | > | > reports properly, I can browse through multiple pages, save my
> report
> | > to pdf.
> | > | >
> | > | > - I posted this already to the dotnet.general newsgroup, and they
> told
> | > me to
> | > | > post the question on this forum.
> | > | >
> | > | > Thanks,
> | > | > Charl
> | > | >
> | > |
> | >
> | >
> |
>sql
Problems displaying default value of first cascading parameters.
I have 5 cascading parameters. They all have default values. I would like the default value of each of these to be selected when the report opens.
It currently works correctly when I preview the report, however when I deploy the report to the server it does not. In the deployed report, the default value of the first parameter is not selected. However, when I select a value for this one, on postback the rest of these parameters get set to their default value. They're all configured the same. I'm confused as to why the first one doesn't default to its default value while the others do.
Got any ideas?
Here's how I have it configured:
Allow null value CHECKED
Allow blank value CHECKED
The rest are unchecked.
Available values: From query
Default Values: Non-queried with a value supplied that exists in the dataset.
This issue got resolved when I deleted all of my reports from the server and then redeployed them. Funny how that works...sqlProblems displaying default value of first cascading parameters.
I have 5 cascading parameters. They all have default values. I would like the default value of each of these to be selected when the report opens.
It currently works correctly when I preview the report, however when I deploy the report to the server it does not. In the deployed report, the default value of the first parameter is not selected. However, when I select a value for this one, on postback the rest of these parameters get set to their default value. They're all configured the same. I'm confused as to why the first one doesn't default to its default value while the others do.
Got any ideas?
Here's how I have it configured:
Allow null value CHECKED
Allow blank value CHECKED
The rest are unchecked.
Available values: From query
Default Values: Non-queried with a value supplied that exists in the dataset.
This issue got resolved when I deleted all of my reports from the server and then redeployed them. Funny how that works...Problems deploying to a remote Report Server(2005)
I developed a simple report using the AdventureWorks sample database on a XP
Pro with SQL Server 2005 BI tools only (Beta 2). The report runs fine in
preview mode. When I attempt to deploy it to a remote Report Server (June
2005 CTP) I get the following error:
"A connection could not be made to the report server
http://<servername>/reportserver.
Additional information: The version of the report server web service
definition (WSDL) is either not valid or unrecognized. The server is not a
compatible version (Microsoft.reportingServices.Designer)"
Any help/responses is greatly appreciated.
PS: The same report developed and deployed on the Report Server works fine!!
--
Thank you,
AshokThe version of RS with Beta2 is not the same as the June CTP. My guess is
that this version mismatch is causing the problem.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ashok G" <ashokg@.discussions.microsoft.com> wrote in message
news:B2A96F52-5CD0-4A83-A0B3-FFEB5EBF5D21@.microsoft.com...
>I developed a simple report using the AdventureWorks sample database on a
>XP
> Pro with SQL Server 2005 BI tools only (Beta 2). The report runs fine in
> preview mode. When I attempt to deploy it to a remote Report Server (June
> 2005 CTP) I get the following error:
> "A connection could not be made to the report server
> http://<servername>/reportserver.
> Additional information: The version of the report server web service
> definition (WSDL) is either not valid or unrecognized. The server is not
> a
> compatible version (Microsoft.reportingServices.Designer)"
> Any help/responses is greatly appreciated.
> PS: The same report developed and deployed on the Report Server works
> fine!!
> --
> Thank you,
> Ashok|||THanks Bruce. I appreciate your prompt reponse.
I suspected that it would be an incompatibility issue. Would you recommend
that I uninstall the Beta and install the june CTP on the client?
--
Thank you,
Ashok G
"Bruce L-C [MVP]" wrote:
> The version of RS with Beta2 is not the same as the June CTP. My guess is
> that this version mismatch is causing the problem.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Ashok G" <ashokg@.discussions.microsoft.com> wrote in message
> news:B2A96F52-5CD0-4A83-A0B3-FFEB5EBF5D21@.microsoft.com...
> >I developed a simple report using the AdventureWorks sample database on a
> >XP
> > Pro with SQL Server 2005 BI tools only (Beta 2). The report runs fine in
> > preview mode. When I attempt to deploy it to a remote Report Server (June
> > 2005 CTP) I get the following error:
> >
> > "A connection could not be made to the report server
> > http://<servername>/reportserver.
> >
> > Additional information: The version of the report server web service
> > definition (WSDL) is either not valid or unrecognized. The server is not
> > a
> > compatible version (Microsoft.reportingServices.Designer)"
> >
> > Any help/responses is greatly appreciated.
> >
> > PS: The same report developed and deployed on the Report Server works
> > fine!!
> > --
> > Thank you,
> > Ashok
>
>|||Yes. If you have the report available from RS 2000 then I suggest
uninstalling the beta and install the CTP and then bring over the reports
from RS 2000.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ashok G" <ashokg@.discussions.microsoft.com> wrote in message
news:72F122A5-2CD7-4EC1-A776-F8536B016EAB@.microsoft.com...
> THanks Bruce. I appreciate your prompt reponse.
> I suspected that it would be an incompatibility issue. Would you
> recommend
> that I uninstall the Beta and install the june CTP on the client?
> --
> Thank you,
> Ashok G
>
> "Bruce L-C [MVP]" wrote:
>> The version of RS with Beta2 is not the same as the June CTP. My guess is
>> that this version mismatch is causing the problem.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Ashok G" <ashokg@.discussions.microsoft.com> wrote in message
>> news:B2A96F52-5CD0-4A83-A0B3-FFEB5EBF5D21@.microsoft.com...
>> >I developed a simple report using the AdventureWorks sample database on
>> >a
>> >XP
>> > Pro with SQL Server 2005 BI tools only (Beta 2). The report runs fine
>> > in
>> > preview mode. When I attempt to deploy it to a remote Report Server
>> > (June
>> > 2005 CTP) I get the following error:
>> >
>> > "A connection could not be made to the report server
>> > http://<servername>/reportserver.
>> >
>> > Additional information: The version of the report server web service
>> > definition (WSDL) is either not valid or unrecognized. The server is
>> > not
>> > a
>> > compatible version (Microsoft.reportingServices.Designer)"
>> >
>> > Any help/responses is greatly appreciated.
>> >
>> > PS: The same report developed and deployed on the Report Server works
>> > fine!!
>> > --
>> > Thank you,
>> > Ashok
>>|||I moved to another RS 2005 server that has CTP June and it worked! I was
able to publish and execute the report.
Thanks once again.
--
Thank you,
Ashok G
"Bruce L-C [MVP]" wrote:
> Yes. If you have the report available from RS 2000 then I suggest
> uninstalling the beta and install the CTP and then bring over the reports
> from RS 2000.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Ashok G" <ashokg@.discussions.microsoft.com> wrote in message
> news:72F122A5-2CD7-4EC1-A776-F8536B016EAB@.microsoft.com...
> > THanks Bruce. I appreciate your prompt reponse.
> > I suspected that it would be an incompatibility issue. Would you
> > recommend
> > that I uninstall the Beta and install the june CTP on the client?
> >
> > --
> > Thank you,
> > Ashok G
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> The version of RS with Beta2 is not the same as the June CTP. My guess is
> >> that this version mismatch is causing the problem.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Ashok G" <ashokg@.discussions.microsoft.com> wrote in message
> >> news:B2A96F52-5CD0-4A83-A0B3-FFEB5EBF5D21@.microsoft.com...
> >> >I developed a simple report using the AdventureWorks sample database on
> >> >a
> >> >XP
> >> > Pro with SQL Server 2005 BI tools only (Beta 2). The report runs fine
> >> > in
> >> > preview mode. When I attempt to deploy it to a remote Report Server
> >> > (June
> >> > 2005 CTP) I get the following error:
> >> >
> >> > "A connection could not be made to the report server
> >> > http://<servername>/reportserver.
> >> >
> >> > Additional information: The version of the report server web service
> >> > definition (WSDL) is either not valid or unrecognized. The server is
> >> > not
> >> > a
> >> > compatible version (Microsoft.reportingServices.Designer)"
> >> >
> >> > Any help/responses is greatly appreciated.
> >> >
> >> > PS: The same report developed and deployed on the Report Server works
> >> > fine!!
> >> > --
> >> > Thank you,
> >> > Ashok
> >>
> >>
> >>
>
>
Pro with SQL Server 2005 BI tools only (Beta 2). The report runs fine in
preview mode. When I attempt to deploy it to a remote Report Server (June
2005 CTP) I get the following error:
"A connection could not be made to the report server
http://<servername>/reportserver.
Additional information: The version of the report server web service
definition (WSDL) is either not valid or unrecognized. The server is not a
compatible version (Microsoft.reportingServices.Designer)"
Any help/responses is greatly appreciated.
PS: The same report developed and deployed on the Report Server works fine!!
--
Thank you,
AshokThe version of RS with Beta2 is not the same as the June CTP. My guess is
that this version mismatch is causing the problem.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ashok G" <ashokg@.discussions.microsoft.com> wrote in message
news:B2A96F52-5CD0-4A83-A0B3-FFEB5EBF5D21@.microsoft.com...
>I developed a simple report using the AdventureWorks sample database on a
>XP
> Pro with SQL Server 2005 BI tools only (Beta 2). The report runs fine in
> preview mode. When I attempt to deploy it to a remote Report Server (June
> 2005 CTP) I get the following error:
> "A connection could not be made to the report server
> http://<servername>/reportserver.
> Additional information: The version of the report server web service
> definition (WSDL) is either not valid or unrecognized. The server is not
> a
> compatible version (Microsoft.reportingServices.Designer)"
> Any help/responses is greatly appreciated.
> PS: The same report developed and deployed on the Report Server works
> fine!!
> --
> Thank you,
> Ashok|||THanks Bruce. I appreciate your prompt reponse.
I suspected that it would be an incompatibility issue. Would you recommend
that I uninstall the Beta and install the june CTP on the client?
--
Thank you,
Ashok G
"Bruce L-C [MVP]" wrote:
> The version of RS with Beta2 is not the same as the June CTP. My guess is
> that this version mismatch is causing the problem.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Ashok G" <ashokg@.discussions.microsoft.com> wrote in message
> news:B2A96F52-5CD0-4A83-A0B3-FFEB5EBF5D21@.microsoft.com...
> >I developed a simple report using the AdventureWorks sample database on a
> >XP
> > Pro with SQL Server 2005 BI tools only (Beta 2). The report runs fine in
> > preview mode. When I attempt to deploy it to a remote Report Server (June
> > 2005 CTP) I get the following error:
> >
> > "A connection could not be made to the report server
> > http://<servername>/reportserver.
> >
> > Additional information: The version of the report server web service
> > definition (WSDL) is either not valid or unrecognized. The server is not
> > a
> > compatible version (Microsoft.reportingServices.Designer)"
> >
> > Any help/responses is greatly appreciated.
> >
> > PS: The same report developed and deployed on the Report Server works
> > fine!!
> > --
> > Thank you,
> > Ashok
>
>|||Yes. If you have the report available from RS 2000 then I suggest
uninstalling the beta and install the CTP and then bring over the reports
from RS 2000.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ashok G" <ashokg@.discussions.microsoft.com> wrote in message
news:72F122A5-2CD7-4EC1-A776-F8536B016EAB@.microsoft.com...
> THanks Bruce. I appreciate your prompt reponse.
> I suspected that it would be an incompatibility issue. Would you
> recommend
> that I uninstall the Beta and install the june CTP on the client?
> --
> Thank you,
> Ashok G
>
> "Bruce L-C [MVP]" wrote:
>> The version of RS with Beta2 is not the same as the June CTP. My guess is
>> that this version mismatch is causing the problem.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Ashok G" <ashokg@.discussions.microsoft.com> wrote in message
>> news:B2A96F52-5CD0-4A83-A0B3-FFEB5EBF5D21@.microsoft.com...
>> >I developed a simple report using the AdventureWorks sample database on
>> >a
>> >XP
>> > Pro with SQL Server 2005 BI tools only (Beta 2). The report runs fine
>> > in
>> > preview mode. When I attempt to deploy it to a remote Report Server
>> > (June
>> > 2005 CTP) I get the following error:
>> >
>> > "A connection could not be made to the report server
>> > http://<servername>/reportserver.
>> >
>> > Additional information: The version of the report server web service
>> > definition (WSDL) is either not valid or unrecognized. The server is
>> > not
>> > a
>> > compatible version (Microsoft.reportingServices.Designer)"
>> >
>> > Any help/responses is greatly appreciated.
>> >
>> > PS: The same report developed and deployed on the Report Server works
>> > fine!!
>> > --
>> > Thank you,
>> > Ashok
>>|||I moved to another RS 2005 server that has CTP June and it worked! I was
able to publish and execute the report.
Thanks once again.
--
Thank you,
Ashok G
"Bruce L-C [MVP]" wrote:
> Yes. If you have the report available from RS 2000 then I suggest
> uninstalling the beta and install the CTP and then bring over the reports
> from RS 2000.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Ashok G" <ashokg@.discussions.microsoft.com> wrote in message
> news:72F122A5-2CD7-4EC1-A776-F8536B016EAB@.microsoft.com...
> > THanks Bruce. I appreciate your prompt reponse.
> > I suspected that it would be an incompatibility issue. Would you
> > recommend
> > that I uninstall the Beta and install the june CTP on the client?
> >
> > --
> > Thank you,
> > Ashok G
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> The version of RS with Beta2 is not the same as the June CTP. My guess is
> >> that this version mismatch is causing the problem.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Ashok G" <ashokg@.discussions.microsoft.com> wrote in message
> >> news:B2A96F52-5CD0-4A83-A0B3-FFEB5EBF5D21@.microsoft.com...
> >> >I developed a simple report using the AdventureWorks sample database on
> >> >a
> >> >XP
> >> > Pro with SQL Server 2005 BI tools only (Beta 2). The report runs fine
> >> > in
> >> > preview mode. When I attempt to deploy it to a remote Report Server
> >> > (June
> >> > 2005 CTP) I get the following error:
> >> >
> >> > "A connection could not be made to the report server
> >> > http://<servername>/reportserver.
> >> >
> >> > Additional information: The version of the report server web service
> >> > definition (WSDL) is either not valid or unrecognized. The server is
> >> > not
> >> > a
> >> > compatible version (Microsoft.reportingServices.Designer)"
> >> >
> >> > Any help/responses is greatly appreciated.
> >> >
> >> > PS: The same report developed and deployed on the Report Server works
> >> > fine!!
> >> > --
> >> > Thank you,
> >> > Ashok
> >>
> >>
> >>
>
>
Friday, March 23, 2012
Problems Creating Report
Hi,
I have only recently started playing around with Reporting Services (2005), and I am having some problems creating a basic report.
What I want to display is a table which shows product names in the first column, sales for a specific period this year in the second column, and sales for the same period last year in the third column. The 'specific period' is determined by specifying a start week and an end week which I have set up as parameters.
I have managed to produce the first 2 column with no trouble. However, for the third column I need to subtract 52 weeks from the parameters and use them as new parameter in the third column.
Can anyone offer any suggestions?
Dave
Sounds like a T-SQL issue. Do you have a sample of the query?|||My apologies, I just realised I neglected to mention that the source data was in a cube. What I have in the cube is a product dimension, a time dimension (which goes down to week level), and a measure for sales amount.|||Anybody got any ideas?|||In MDX I would suggest using ParallelPeriod. The following is an AdventureWorks query showing an example. You just need to replace the expicit time members with parameters:
WITH
MEMBER [Measures].[Selection] as '
Sum(
[Date].[Calendar].[Month].&[2003]&[1]
:
[Date].[Calendar].[Month].&[2003]&[5]
, [Measures].[Sales Amount]
)'
MEMBER [Measures].[SamePeriodLastYear] as '
Sum(
ParallelPeriod([Date].[Calendar].[Calendar Year], 1, [Date].[Calendar].[Month].&[2003]&[1])
:
ParallelPeriod([Date].[Calendar].[Calendar Year], 1, [Date].[Calendar].[Month].&[2003]&[5])
, [Measures].[Sales Amount]
)'
SELECT
{ [Measures].[Selection]
, [Measures].[SamePeriodLastYear]
} ON 0,
NON EMPTY [Product].[Product Categories].Members ON 1
FROM [Adventure Works]
|||Thanks very much, that works a treat.|||Ok,
I managed to get the MDX query working in SQL Studio but when I try to parameterize it in Reporting Services, I don't get any rows returned.
I have created 2 parameters (StartWeek + EndWeek) which are both integers, and have used these in 2 calculated fields. The code for these is:
ThisYear
Sum(
[Dim Week No].[Week No].&[@.StartWeek]
:
[Dim Week No].[Week No].&[@.EndWeek]
, [Measures].[Rate]
)
LastYear
Sum(
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.StartWeek] )
:
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.EndWeek] )
, [Measures].[Rate]
)
I have then just added these 2 fields, and the product field to my report's dataset. Could somebody please tell me where I am going wrong as this is driving me crazy!!
Dave
|||Ok,
I managed to get the MDX query working in SQL Studio but when I try to parameterize it in Reporting Services, I don't get any rows returned.
I have created 2 parameters (StartWeek + EndWeek) which are both integers, and have used these in 2 calculated fields. The code for these is:
ThisYear
Sum(
[Dim Week No].[Week No].&[@.StartWeek]
:
[Dim Week No].[Week No].&[@.EndWeek]
, [Measures].[Rate]
)
LastYear
Sum(
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.StartWeek] )
:
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.EndWeek] )
, [Measures].[Rate]
)
I have then just added these 2 fields, and the product field to my report's dataset. Could somebody please tell me where I am going wrong as this is driving me crazy!!
Dave
|||Ok,
I managed to get the MDX query working in SQL Studio but when I try to parameterize it in Reporting Services, I don't get any rows returned.
I have created 2 parameters (StartWeek + EndWeek) which are both integers, and have used these in 2 calculated fields. The code for these is:
ThisYear
Sum(
[Dim Week No].[Week No].&[@.StartWeek]
:
[Dim Week No].[Week No].&[@.EndWeek]
, [Measures].[Rate]
)
LastYear
Sum(
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.StartWeek] )
:
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.EndWeek] )
, [Measures].[Rate]
)
I have then just added these 2 fields, and the product field to my report's dataset. Could somebody please tell me where I am going wrong as this is driving me crazy!!
Dave
|||Ok,
I managed to get the MDX query working in SQL Studio but when I try to parameterize it in Reporting Services, I don't get any rows returned.
I have created 2 parameters (StartWeek + EndWeek) which are both integers, and have used these in 2 calculated fields. The code for these is:
ThisYear
Sum(
[Dim Week No].[Week No].&[@.StartWeek]
:
[Dim Week No].[Week No].&[@.EndWeek]
, [Measures].[Rate]
)
LastYear
Sum(
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.StartWeek] )
:
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.EndWeek] )
, [Measures].[Rate]
)
I have then just added these 2 fields, and the product field to my report's dataset. Could somebody please tell me where I am going wrong as this is driving me crazy!!
Dave
|||Ok,
I managed to get the MDX query working in SQL Studio but when I try to parameterize it in Reporting Services, I don't get any rows returned.
I have created 2 parameters (StartWeek + EndWeek) which are both integers, and have used these in 2 calculated fields. The code for these is:
ThisYear
Sum(
[Dim Week No].[Week No].&[@.StartWeek]
:
[Dim Week No].[Week No].&[@.EndWeek]
, [Measures].[Rate]
)
LastYear
Sum(
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.StartWeek] )
:
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.EndWeek] )
, [Measures].[Rate]
)
I have then just added these 2 fields, and the product field to my report's dataset. Could somebody please tell me where I am going wrong as this is driving me crazy!!
Dave
|||Ok,
I managed to get the MDX query working in SQL Studio but when I try to parameterize it in Reporting Services, I don't get any rows returned.
I have created 2 parameters (StartWeek + EndWeek) which are both integers, and have used these in 2 calculated fields. The code for these is:
ThisYear
Sum(
[Dim Week No].[Week No].&[@.StartWeek]
:
[Dim Week No].[Week No].&[@.EndWeek]
, [Measures].[Rate]
)
LastYear
Sum(
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.StartWeek] )
:
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.EndWeek] )
, [Measures].[Rate]
)
I have then just added these 2 fields, and the product field to my report's dataset. Could somebody please tell me where I am going wrong as this is driving me crazy!!
Dave
|||Try constructing a MemberUniqueName string and passing that to the StrToMember functiuon
Sum(
StrToMember("[Dim Week No].[Week No].&[" + CStr(@.StartWeek) + "] ", CONSTRAINED)
:
StrToMember("[Dim Week No].[Week No].&[" + CStr(@.EndWeek) + "] ", CONSTRAINED)
, [Measures].[Rate]
)
Hi Adam,
Again, that works fine in SQL Studio with integer values instead of the parameters. However, when I try it in Reporting Services with my parameters I get the following error:
"The 'ThisYear' calculated member cannot be created because of the following error: Parser: The StartWeek parameter could not be resolved because it was referenced in ann inner subexpression"
My calculated member field is now:
"Sum(
StrToMember("[Dim Week No].[Week in Year].[Week No].&[" + CStr(@.StartWeek) + "] ", CONSTRAINED)
:
StrToMember("[Dim Week No].[Week in Year].[Week No].&[" + CStr(@.EndWeek) + "] ", CONSTRAINED)
, [Measures].[Rate]
)"
Some options:
try removing the CStr() call and see if that works
OR
Problems Creating Report
Hi,
I have only recently started playing around with Reporting Services (2005), and I am having some problems creating a basic report.
What I want to display is a table which shows product names in the first column, sales for a specific period this year in the second column, and sales for the same period last year in the third column. The 'specific period' is determined by specifying a start week and an end week which I have set up as parameters.
I have managed to produce the first 2 column with no trouble. However, for the third column I need to subtract 52 weeks from the parameters and use them as new parameter in the third column.
Can anyone offer any suggestions?
Dave
Sounds like a T-SQL issue. Do you have a sample of the query?|||My apologies, I just realised I neglected to mention that the source data was in a cube. What I have in the cube is a product dimension, a time dimension (which goes down to week level), and a measure for sales amount.|||Anybody got any ideas?|||In MDX I would suggest using ParallelPeriod. The following is an AdventureWorks query showing an example. You just need to replace the expicit time members with parameters:
WITH
MEMBER [Measures].[Selection] as '
Sum(
[Date].[Calendar].[Month].&[2003]&[1]
:
[Date].[Calendar].[Month].&[2003]&[5]
, [Measures].[Sales Amount]
)'
MEMBER [Measures].[SamePeriodLastYear] as '
Sum(
ParallelPeriod([Date].[Calendar].[Calendar Year], 1, [Date].[Calendar].[Month].&[2003]&[1])
:
ParallelPeriod([Date].[Calendar].[Calendar Year], 1, [Date].[Calendar].[Month].&[2003]&[5])
, [Measures].[Sales Amount]
)'
SELECT
{ [Measures].[Selection]
, [Measures].[SamePeriodLastYear]
} ON 0,
NON EMPTY [Product].[Product Categories].Members ON 1
FROM [Adventure Works]
|||Thanks very much, that works a treat.|||Ok,
I managed to get the MDX query working in SQL Studio but when I try to parameterize it in Reporting Services, I don't get any rows returned.
I have created 2 parameters (StartWeek + EndWeek) which are both integers, and have used these in 2 calculated fields. The code for these is:
ThisYear
Sum(
[Dim Week No].[Week No].&[@.StartWeek]
:
[Dim Week No].[Week No].&[@.EndWeek]
, [Measures].[Rate]
)
LastYear
Sum(
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.StartWeek] )
:
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.EndWeek] )
, [Measures].[Rate]
)
I have then just added these 2 fields, and the product field to my report's dataset. Could somebody please tell me where I am going wrong as this is driving me crazy!!
Dave
|||Ok,
I managed to get the MDX query working in SQL Studio but when I try to parameterize it in Reporting Services, I don't get any rows returned.
I have created 2 parameters (StartWeek + EndWeek) which are both integers, and have used these in 2 calculated fields. The code for these is:
ThisYear
Sum(
[Dim Week No].[Week No].&[@.StartWeek]
:
[Dim Week No].[Week No].&[@.EndWeek]
, [Measures].[Rate]
)
LastYear
Sum(
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.StartWeek] )
:
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.EndWeek] )
, [Measures].[Rate]
)
I have then just added these 2 fields, and the product field to my report's dataset. Could somebody please tell me where I am going wrong as this is driving me crazy!!
Dave
|||Ok,
I managed to get the MDX query working in SQL Studio but when I try to parameterize it in Reporting Services, I don't get any rows returned.
I have created 2 parameters (StartWeek + EndWeek) which are both integers, and have used these in 2 calculated fields. The code for these is:
ThisYear
Sum(
[Dim Week No].[Week No].&[@.StartWeek]
:
[Dim Week No].[Week No].&[@.EndWeek]
, [Measures].[Rate]
)
LastYear
Sum(
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.StartWeek] )
:
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.EndWeek] )
, [Measures].[Rate]
)
I have then just added these 2 fields, and the product field to my report's dataset. Could somebody please tell me where I am going wrong as this is driving me crazy!!
Dave
|||Ok,
I managed to get the MDX query working in SQL Studio but when I try to parameterize it in Reporting Services, I don't get any rows returned.
I have created 2 parameters (StartWeek + EndWeek) which are both integers, and have used these in 2 calculated fields. The code for these is:
ThisYear
Sum(
[Dim Week No].[Week No].&[@.StartWeek]
:
[Dim Week No].[Week No].&[@.EndWeek]
, [Measures].[Rate]
)
LastYear
Sum(
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.StartWeek] )
:
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.EndWeek] )
, [Measures].[Rate]
)
I have then just added these 2 fields, and the product field to my report's dataset. Could somebody please tell me where I am going wrong as this is driving me crazy!!
Dave
|||Ok,
I managed to get the MDX query working in SQL Studio but when I try to parameterize it in Reporting Services, I don't get any rows returned.
I have created 2 parameters (StartWeek + EndWeek) which are both integers, and have used these in 2 calculated fields. The code for these is:
ThisYear
Sum(
[Dim Week No].[Week No].&[@.StartWeek]
:
[Dim Week No].[Week No].&[@.EndWeek]
, [Measures].[Rate]
)
LastYear
Sum(
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.StartWeek] )
:
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.EndWeek] )
, [Measures].[Rate]
)
I have then just added these 2 fields, and the product field to my report's dataset. Could somebody please tell me where I am going wrong as this is driving me crazy!!
Dave
|||Ok,
I managed to get the MDX query working in SQL Studio but when I try to parameterize it in Reporting Services, I don't get any rows returned.
I have created 2 parameters (StartWeek + EndWeek) which are both integers, and have used these in 2 calculated fields. The code for these is:
ThisYear
Sum(
[Dim Week No].[Week No].&[@.StartWeek]
:
[Dim Week No].[Week No].&[@.EndWeek]
, [Measures].[Rate]
)
LastYear
Sum(
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.StartWeek] )
:
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.EndWeek] )
, [Measures].[Rate]
)
I have then just added these 2 fields, and the product field to my report's dataset. Could somebody please tell me where I am going wrong as this is driving me crazy!!
Dave
|||Try constructing a MemberUniqueName string and passing that to the StrToMember functiuon
Sum(
StrToMember("[Dim Week No].[Week No].&[" + CStr(@.StartWeek) + "] ", CONSTRAINED)
:
StrToMember("[Dim Week No].[Week No].&[" + CStr(@.EndWeek) + "] ", CONSTRAINED)
, [Measures].[Rate]
)
Hi Adam,
Again, that works fine in SQL Studio with integer values instead of the parameters. However, when I try it in Reporting Services with my parameters I get the following error:
"The 'ThisYear' calculated member cannot be created because of the following error: Parser: The StartWeek parameter could not be resolved because it was referenced in ann inner subexpression"
My calculated member field is now:
"Sum(
StrToMember("[Dim Week No].[Week in Year].[Week No].&[" + CStr(@.StartWeek) + "] ", CONSTRAINED)
:
StrToMember("[Dim Week No].[Week in Year].[Week No].&[" + CStr(@.EndWeek) + "] ", CONSTRAINED)
, [Measures].[Rate]
)"
Some options:
try removing the CStr() call and see if that works
OR
Problems Creating Report
Hi,
I have only recently started playing around with Reporting Services (2005), and I am having some problems creating a basic report.
What I want to display is a table which shows product names in the first column, sales for a specific period this year in the second column, and sales for the same period last year in the third column. The 'specific period' is determined by specifying a start week and an end week which I have set up as parameters.
I have managed to produce the first 2 column with no trouble. However, for the third column I need to subtract 52 weeks from the parameters and use them as new parameter in the third column.
Can anyone offer any suggestions?
Dave
Sounds like a T-SQL issue. Do you have a sample of the query?|||My apologies, I just realised I neglected to mention that the source data was in a cube. What I have in the cube is a product dimension, a time dimension (which goes down to week level), and a measure for sales amount.|||Anybody got any ideas?|||In MDX I would suggest using ParallelPeriod. The following is an AdventureWorks query showing an example. You just need to replace the expicit time members with parameters:
WITH
MEMBER [Measures].[Selection] as '
Sum(
[Date].[Calendar].[Month].&[2003]&[1]
:
[Date].[Calendar].[Month].&[2003]&[5]
, [Measures].[Sales Amount]
)'
MEMBER [Measures].[SamePeriodLastYear] as '
Sum(
ParallelPeriod([Date].[Calendar].[Calendar Year], 1, [Date].[Calendar].[Month].&[2003]&[1])
:
ParallelPeriod([Date].[Calendar].[Calendar Year], 1, [Date].[Calendar].[Month].&[2003]&[5])
, [Measures].[Sales Amount]
)'
SELECT
{ [Measures].[Selection]
, [Measures].[SamePeriodLastYear]
} ON 0,
NONEMPTY [Product].[Product Categories].MembersON 1
FROM [Adventure Works]
|||Thanks very much, that works a treat.|||Ok,
I managed to get the MDX query working in SQL Studio but when I try to parameterize it in Reporting Services, I don't get any rows returned.
I have created 2 parameters (StartWeek + EndWeek) which are both integers, and have used these in 2 calculated fields. The code for these is:
ThisYear
Sum(
[Dim Week No].[Week No].&[@.StartWeek]
:
[Dim Week No].[Week No].&[@.EndWeek]
, [Measures].[Rate]
)
LastYear
Sum(
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.StartWeek] )
:
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.EndWeek] )
, [Measures].[Rate]
)
I have then just added these 2 fields, and the product field to my report's dataset. Could somebody please tell me where I am going wrong as this is driving me crazy!!
Dave
|||Ok,
I managed to get the MDX query working in SQL Studio but when I try to parameterize it in Reporting Services, I don't get any rows returned.
I have created 2 parameters (StartWeek + EndWeek) which are both integers, and have used these in 2 calculated fields. The code for these is:
ThisYear
Sum(
[Dim Week No].[Week No].&[@.StartWeek]
:
[Dim Week No].[Week No].&[@.EndWeek]
, [Measures].[Rate]
)
LastYear
Sum(
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.StartWeek] )
:
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.EndWeek] )
, [Measures].[Rate]
)
I have then just added these 2 fields, and the product field to my report's dataset. Could somebody please tell me where I am going wrong as this is driving me crazy!!
Dave
|||Ok,
I managed to get the MDX query working in SQL Studio but when I try to parameterize it in Reporting Services, I don't get any rows returned.
I have created 2 parameters (StartWeek + EndWeek) which are both integers, and have used these in 2 calculated fields. The code for these is:
ThisYear
Sum(
[Dim Week No].[Week No].&[@.StartWeek]
:
[Dim Week No].[Week No].&[@.EndWeek]
, [Measures].[Rate]
)
LastYear
Sum(
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.StartWeek] )
:
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.EndWeek] )
, [Measures].[Rate]
)
I have then just added these 2 fields, and the product field to my report's dataset. Could somebody please tell me where I am going wrong as this is driving me crazy!!
Dave
|||Ok,
I managed to get the MDX query working in SQL Studio but when I try to parameterize it in Reporting Services, I don't get any rows returned.
I have created 2 parameters (StartWeek + EndWeek) which are both integers, and have used these in 2 calculated fields. The code for these is:
ThisYear
Sum(
[Dim Week No].[Week No].&[@.StartWeek]
:
[Dim Week No].[Week No].&[@.EndWeek]
, [Measures].[Rate]
)
LastYear
Sum(
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.StartWeek] )
:
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.EndWeek] )
, [Measures].[Rate]
)
I have then just added these 2 fields, and the product field to my report's dataset. Could somebody please tell me where I am going wrong as this is driving me crazy!!
Dave
|||Ok,
I managed to get the MDX query working in SQL Studio but when I try to parameterize it in Reporting Services, I don't get any rows returned.
I have created 2 parameters (StartWeek + EndWeek) which are both integers, and have used these in 2 calculated fields. The code for these is:
ThisYear
Sum(
[Dim Week No].[Week No].&[@.StartWeek]
:
[Dim Week No].[Week No].&[@.EndWeek]
, [Measures].[Rate]
)
LastYear
Sum(
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.StartWeek] )
:
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.EndWeek] )
, [Measures].[Rate]
)
I have then just added these 2 fields, and the product field to my report's dataset. Could somebody please tell me where I am going wrong as this is driving me crazy!!
Dave
|||Ok,
I managed to get the MDX query working in SQL Studio but when I try to parameterize it in Reporting Services, I don't get any rows returned.
I have created 2 parameters (StartWeek + EndWeek) which are both integers, and have used these in 2 calculated fields. The code for these is:
ThisYear
Sum(
[Dim Week No].[Week No].&[@.StartWeek]
:
[Dim Week No].[Week No].&[@.EndWeek]
, [Measures].[Rate]
)
LastYear
Sum(
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.StartWeek] )
:
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.EndWeek] )
, [Measures].[Rate]
)
I have then just added these 2 fields, and the product field to my report's dataset. Could somebody please tell me where I am going wrong as this is driving me crazy!!
Dave
|||Try constructing a MemberUniqueName string and passing that to the StrToMember functiuon
Sum(
StrToMember("[Dim Week No].[Week No].&[" + CStr(@.StartWeek) + "] ", CONSTRAINED)
:
StrToMember("[Dim Week No].[Week No].&[" + CStr(@.EndWeek) + "] ", CONSTRAINED)
, [Measures].[Rate]
)
Hi Adam,
Again, that works fine in SQL Studio with integer values instead of the parameters. However, when I try it in Reporting Services with my parameters I get the following error:
"The 'ThisYear' calculated member cannot be created because of the following error: Parser: The StartWeek parameter could not be resolved because it was referenced in ann inner subexpression"
My calculated member field is now:
"Sum(
StrToMember("[Dim Week No].[Week in Year].[Week No].&[" + CStr(@.StartWeek) + "] ", CONSTRAINED)
:
StrToMember("[Dim Week No].[Week in Year].[Week No].&[" + CStr(@.EndWeek) + "] ", CONSTRAINED)
, [Measures].[Rate]
)"
Some options:
try removing the CStr() call and see if that worksOR
Problems Creating Report
Hi,
I have only recently started playing around with Reporting Services (2005), and I am having some problems creating a basic report.
What I want to display is a table which shows product names in the first column, sales for a specific period this year in the second column, and sales for the same period last year in the third column. The 'specific period' is determined by specifying a start week and an end week which I have set up as parameters.
I have managed to produce the first 2 column with no trouble. However, for the third column I need to subtract 52 weeks from the parameters and use them as new parameter in the third column.
Can anyone offer any suggestions?
Dave
Sounds like a T-SQL issue. Do you have a sample of the query?|||My apologies, I just realised I neglected to mention that the source data was in a cube. What I have in the cube is a product dimension, a time dimension (which goes down to week level), and a measure for sales amount.|||Anybody got any ideas?|||In MDX I would suggest using ParallelPeriod. The following is an AdventureWorks query showing an example. You just need to replace the expicit time members with parameters:
WITH
MEMBER [Measures].[Selection] as '
Sum(
[Date].[Calendar].[Month].&[2003]&[1]
:
[Date].[Calendar].[Month].&[2003]&[5]
, [Measures].[Sales Amount]
)'
MEMBER [Measures].[SamePeriodLastYear] as '
Sum(
ParallelPeriod([Date].[Calendar].[Calendar Year], 1, [Date].[Calendar].[Month].&[2003]&[1])
:
ParallelPeriod([Date].[Calendar].[Calendar Year], 1, [Date].[Calendar].[Month].&[2003]&[5])
, [Measures].[Sales Amount]
)'
SELECT
{ [Measures].[Selection]
, [Measures].[SamePeriodLastYear]
} ON 0,
NON EMPTY [Product].[Product Categories].Members ON 1
FROM [Adventure Works]
|||Thanks very much, that works a treat.|||Ok,
I managed to get the MDX query working in SQL Studio but when I try to parameterize it in Reporting Services, I don't get any rows returned.
I have created 2 parameters (StartWeek + EndWeek) which are both integers, and have used these in 2 calculated fields. The code for these is:
ThisYear
Sum(
[Dim Week No].[Week No].&[@.StartWeek]
:
[Dim Week No].[Week No].&[@.EndWeek]
, [Measures].[Rate]
)
LastYear
Sum(
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.StartWeek] )
:
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.EndWeek] )
, [Measures].[Rate]
)
I have then just added these 2 fields, and the product field to my report's dataset. Could somebody please tell me where I am going wrong as this is driving me crazy!!
Dave
|||Ok,
I managed to get the MDX query working in SQL Studio but when I try to parameterize it in Reporting Services, I don't get any rows returned.
I have created 2 parameters (StartWeek + EndWeek) which are both integers, and have used these in 2 calculated fields. The code for these is:
ThisYear
Sum(
[Dim Week No].[Week No].&[@.StartWeek]
:
[Dim Week No].[Week No].&[@.EndWeek]
, [Measures].[Rate]
)
LastYear
Sum(
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.StartWeek] )
:
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.EndWeek] )
, [Measures].[Rate]
)
I have then just added these 2 fields, and the product field to my report's dataset. Could somebody please tell me where I am going wrong as this is driving me crazy!!
Dave
|||Ok,
I managed to get the MDX query working in SQL Studio but when I try to parameterize it in Reporting Services, I don't get any rows returned.
I have created 2 parameters (StartWeek + EndWeek) which are both integers, and have used these in 2 calculated fields. The code for these is:
ThisYear
Sum(
[Dim Week No].[Week No].&[@.StartWeek]
:
[Dim Week No].[Week No].&[@.EndWeek]
, [Measures].[Rate]
)
LastYear
Sum(
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.StartWeek] )
:
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.EndWeek] )
, [Measures].[Rate]
)
I have then just added these 2 fields, and the product field to my report's dataset. Could somebody please tell me where I am going wrong as this is driving me crazy!!
Dave
|||Ok,
I managed to get the MDX query working in SQL Studio but when I try to parameterize it in Reporting Services, I don't get any rows returned.
I have created 2 parameters (StartWeek + EndWeek) which are both integers, and have used these in 2 calculated fields. The code for these is:
ThisYear
Sum(
[Dim Week No].[Week No].&[@.StartWeek]
:
[Dim Week No].[Week No].&[@.EndWeek]
, [Measures].[Rate]
)
LastYear
Sum(
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.StartWeek] )
:
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.EndWeek] )
, [Measures].[Rate]
)
I have then just added these 2 fields, and the product field to my report's dataset. Could somebody please tell me where I am going wrong as this is driving me crazy!!
Dave
|||Ok,
I managed to get the MDX query working in SQL Studio but when I try to parameterize it in Reporting Services, I don't get any rows returned.
I have created 2 parameters (StartWeek + EndWeek) which are both integers, and have used these in 2 calculated fields. The code for these is:
ThisYear
Sum(
[Dim Week No].[Week No].&[@.StartWeek]
:
[Dim Week No].[Week No].&[@.EndWeek]
, [Measures].[Rate]
)
LastYear
Sum(
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.StartWeek] )
:
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.EndWeek] )
, [Measures].[Rate]
)
I have then just added these 2 fields, and the product field to my report's dataset. Could somebody please tell me where I am going wrong as this is driving me crazy!!
Dave
|||Ok,
I managed to get the MDX query working in SQL Studio but when I try to parameterize it in Reporting Services, I don't get any rows returned.
I have created 2 parameters (StartWeek + EndWeek) which are both integers, and have used these in 2 calculated fields. The code for these is:
ThisYear
Sum(
[Dim Week No].[Week No].&[@.StartWeek]
:
[Dim Week No].[Week No].&[@.EndWeek]
, [Measures].[Rate]
)
LastYear
Sum(
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.StartWeek] )
:
ParallelPeriod([Dim Week No].[Week in Year].[Year Name], 1,[Dim Week No].[Week in Year].[Week No].&[@.EndWeek] )
, [Measures].[Rate]
)
I have then just added these 2 fields, and the product field to my report's dataset. Could somebody please tell me where I am going wrong as this is driving me crazy!!
Dave
|||Try constructing a MemberUniqueName string and passing that to the StrToMember functiuon
Sum(
StrToMember("[Dim Week No].[Week No].&[" + CStr(@.StartWeek) + "] ", CONSTRAINED)
:
StrToMember("[Dim Week No].[Week No].&[" + CStr(@.EndWeek) + "] ", CONSTRAINED)
, [Measures].[Rate]
)
Hi Adam,
Again, that works fine in SQL Studio with integer values instead of the parameters. However, when I try it in Reporting Services with my parameters I get the following error:
"The 'ThisYear' calculated member cannot be created because of the following error: Parser: The StartWeek parameter could not be resolved because it was referenced in ann inner subexpression"
My calculated member field is now:
"Sum(
StrToMember("[Dim Week No].[Week in Year].[Week No].&[" + CStr(@.StartWeek) + "] ", CONSTRAINED)
:
StrToMember("[Dim Week No].[Week in Year].[Week No].&[" + CStr(@.EndWeek) + "] ", CONSTRAINED)
, [Measures].[Rate]
)"
Some options:
try removing the CStr() call and see if that worksORsql
Subscribe to:
Posts (Atom)