Im going to throw this out and maybe someone has some resources to
point me at.
Map based reporting within the US based on Zip supported by census data
? Has anyone done this ? Are there any Zip Maps out there to use as
templates ?
Say I have a database of customers and addresses and I want to show
state and then zip based drill down of approximate percentages of
cutomer saturation / return for a given area.
Any ideas anyone ?
ChrisWertmanTheMad wrote:
> Any ideas anyone ?
We developed an ASP.Net-Solution with mappoint
(http://www.microsoft.com/mappoint/default.mspx)
By clicking on a zip-based-area in the map the suggested report opened.
regards
Frank|||We used Spatially Aware's Map Suite Product, you can build up web pages with
interactive maps or you can retrieve custom maps via an exteral URL in SQL
Reporting Services.
www.spatiallyaware.com
"WertmanTheMad" wrote:
> Im going to throw this out and maybe someone has some resources to
> point me at.
> Map based reporting within the US based on Zip supported by census data
> ? Has anyone done this ? Are there any Zip Maps out there to use as
> templates ?
> Say I have a database of customers and addresses and I want to show
> state and then zip based drill down of approximate percentages of
> cutomer saturation / return for a given area.
> Any ideas anyone ?
> Chris
>sql
Showing posts with label reporting. Show all posts
Showing posts with label reporting. Show all posts
Monday, March 26, 2012
Friday, March 23, 2012
many to many relationship in OLAP
Hi, this is a question about many to many relationship in Analysis services cube.
We have an Analysis services OLAP cube for reporting the amount of sold goods. One of the dimensions is customers another dimension is sales person. One sale person takes care of more than one customer and one costumer can be hold by more than one sales person. (many to many relationship, for connecting table customers and sales person I used intermediate table)
The problem is when one customer has, for example, two sales persons (A and B). If I chose just sale person A from sales person dimension everything is O.K. (Row area - customers, Column area - time dimension, Excel XP) but if I want to see how much was sold by both A and B, the data (amount of sold goods) is multiplied twice. (e.g. on 01.01.03 was sold to customer XX just 100 items and not 200 even though two sales person sold them) I am looking for something like distinct sum.
Can you suggest any solution to this problem?
Thanks in advance,
Daviddont summarize based on this data
you can:
a). not summarize based on this data
b). create a percentage of sales-- so that if 9 sales people are assigned to an account, then they each get 11% of the sales.|||So you think there is no other way how to solve my problem. We have more of these cases.|||uh there are a hundred ways to solve this
i would try to solve it on the database side, and not the OLAP side-- it is going to be a lot eaiser.
i deal with this all the time, and i have a cube for employee sales and then a cube for total sales.
let me look into this a little bit better..
im an olap developer and just generally avoid many to many.. but maybe there is a logical way to do this
(to be truthful, when i have a many to many, i shape the data using DTS in order to flatten it into a snowflake)--
isnt this just a snowflake schema?
maybe you could create a table that would assign a bunch of salespeople and then you assign the group to the record..
and allow drilldown to see what people are in a group--
but this seems oversimplified..
cant you just make a list of all of the sales people for each customer, and list it in text?
like you would push into a database field all of the sales reps for a particular order-- IE, 'John Smith, April Johnson, Mark Kay Latorneau' etc
this really wouldnt be that difficult to accomplish...|||thanks for advice
We have an Analysis services OLAP cube for reporting the amount of sold goods. One of the dimensions is customers another dimension is sales person. One sale person takes care of more than one customer and one costumer can be hold by more than one sales person. (many to many relationship, for connecting table customers and sales person I used intermediate table)
The problem is when one customer has, for example, two sales persons (A and B). If I chose just sale person A from sales person dimension everything is O.K. (Row area - customers, Column area - time dimension, Excel XP) but if I want to see how much was sold by both A and B, the data (amount of sold goods) is multiplied twice. (e.g. on 01.01.03 was sold to customer XX just 100 items and not 200 even though two sales person sold them) I am looking for something like distinct sum.
Can you suggest any solution to this problem?
Thanks in advance,
Daviddont summarize based on this data
you can:
a). not summarize based on this data
b). create a percentage of sales-- so that if 9 sales people are assigned to an account, then they each get 11% of the sales.|||So you think there is no other way how to solve my problem. We have more of these cases.|||uh there are a hundred ways to solve this
i would try to solve it on the database side, and not the OLAP side-- it is going to be a lot eaiser.
i deal with this all the time, and i have a cube for employee sales and then a cube for total sales.
let me look into this a little bit better..
im an olap developer and just generally avoid many to many.. but maybe there is a logical way to do this
(to be truthful, when i have a many to many, i shape the data using DTS in order to flatten it into a snowflake)--
isnt this just a snowflake schema?
maybe you could create a table that would assign a bunch of salespeople and then you assign the group to the record..
and allow drilldown to see what people are in a group--
but this seems oversimplified..
cant you just make a list of all of the sales people for each customer, and list it in text?
like you would push into a database field all of the sales reps for a particular order-- IE, 'John Smith, April Johnson, Mark Kay Latorneau' etc
this really wouldnt be that difficult to accomplish...|||thanks for advice
Monday, March 19, 2012
manually removing encryption keys
Hi,
I am trying to recover a reporting services installation to a different
server with a different name. At the moment I am battling a "this
edition of reporting services does not support web farms". I think now
I have remove all the encryption keys and then install just one key,
with the associated installation ID in the config file.
Anyway, I can't remove the encryption keys, I keep getting unexpected
database error (-2147159548) ox80040e21 when I run rskeymgmt -r
<installation id>
Can remove the keys manually?
ChandraWas wondering if you had found a fix for this problem? I've had the same
problem, and have found no solution.
Thanks
Marvin
"chandra@.cbmi.org.au" wrote:
> Hi,
> I am trying to recover a reporting services installation to a different
> server with a different name. At the moment I am battling a "this
> edition of reporting services does not support web farms". I think now
> I have remove all the encryption keys and then install just one key,
> with the associated installation ID in the config file.
> Anyway, I can't remove the encryption keys, I keep getting unexpected
> database error (-2147159548) ox80040e21 when I run rskeymgmt -r
> <installation id>
>
> Can remove the keys manually?
>
> Chandra
>|||Sorry, still don't have an answer :-)
very frustrating
Chandra
Marvin wrote:
> Was wondering if you had found a fix for this problem? I've had the same
> problem, and have found no solution.
> Thanks
> Marvin
> "chandra@.cbmi.org.au" wrote:
> > Hi,
> >
> > I am trying to recover a reporting services installation to a different
> > server with a different name. At the moment I am battling a "this
> > edition of reporting services does not support web farms". I think now
> > I have remove all the encryption keys and then install just one key,
> > with the associated installation ID in the config file.
> >
> > Anyway, I can't remove the encryption keys, I keep getting unexpected
> > database error (-2147159548) ox80040e21 when I run rskeymgmt -r
> > <installation id>
> >
> >
> > Can remove the keys manually?
> >
> >
> > Chandra
> >
> >
I am trying to recover a reporting services installation to a different
server with a different name. At the moment I am battling a "this
edition of reporting services does not support web farms". I think now
I have remove all the encryption keys and then install just one key,
with the associated installation ID in the config file.
Anyway, I can't remove the encryption keys, I keep getting unexpected
database error (-2147159548) ox80040e21 when I run rskeymgmt -r
<installation id>
Can remove the keys manually?
ChandraWas wondering if you had found a fix for this problem? I've had the same
problem, and have found no solution.
Thanks
Marvin
"chandra@.cbmi.org.au" wrote:
> Hi,
> I am trying to recover a reporting services installation to a different
> server with a different name. At the moment I am battling a "this
> edition of reporting services does not support web farms". I think now
> I have remove all the encryption keys and then install just one key,
> with the associated installation ID in the config file.
> Anyway, I can't remove the encryption keys, I keep getting unexpected
> database error (-2147159548) ox80040e21 when I run rskeymgmt -r
> <installation id>
>
> Can remove the keys manually?
>
> Chandra
>|||Sorry, still don't have an answer :-)
very frustrating
Chandra
Marvin wrote:
> Was wondering if you had found a fix for this problem? I've had the same
> problem, and have found no solution.
> Thanks
> Marvin
> "chandra@.cbmi.org.au" wrote:
> > Hi,
> >
> > I am trying to recover a reporting services installation to a different
> > server with a different name. At the moment I am battling a "this
> > edition of reporting services does not support web farms". I think now
> > I have remove all the encryption keys and then install just one key,
> > with the associated installation ID in the config file.
> >
> > Anyway, I can't remove the encryption keys, I keep getting unexpected
> > database error (-2147159548) ox80040e21 when I run rskeymgmt -r
> > <installation id>
> >
> >
> > Can remove the keys manually?
> >
> >
> > Chandra
> >
> >
Manually change report
Hello,
I use Reporting Services in my solution. The data i have as source is very uncertain. Sometimes i manually have to delete a record from the report (not the database itself). I woluld like to have a checkbox or something simular to delete from report and totals, grafs would be updated. At the same time I would like the report to make a comment that a record was taken away, alternative let the user make a comment. Is this possible? DO i have to make a own application for that?
Thank you for your help!
Best regards,
Luskan
If you want my personal opinion, I don't think RS would be the best application for this.
Personally I would return the data from SQL to something like Excel using ADO/VBA or even MSQuery
and base your report / charts on the data then in Excel.
Deleting/changing the data will then have no effect on the data in your SQL database and if
constructed correcly, your charts/reports in excel will be updated automatically...
|||Well, thank you for your opinion!
But i think I got a Solution. Besides exporting to Excel you can use cascading report parameters in order to to achive the same thing. The only problem i have know is that "Value field" and "label field" does not work as it is inteded to do.
Best regards,
Luskan
Monday, March 12, 2012
Manual Configuration - Installation
I have installed Reporting Services on a computer running Windows Server 2000
with SP4. At the end of the installation it told me it could not
automatically configure/start reporting services and that it needed to be
done. The only thing I can find in the readme file is in regards to
permissions dor IWAM on a domain controller, however this server is not a
domain controller. When I go to the page for ReportManager I get an access
denied and the ReportingServices page has a page cannot be displayed error.
Any help is greatly appreciated.
Thanks,
IanI have made it past that error but now I am getting: The Report Server Web
service has not generated a public key. The service may have not have
started successfully. Check the log files for more information.
I have done everything here:
http://www.sqlreportingservices.net/Ask/354.aspx with no luck thus far.
Please help.
Ian
"Ian T. Jones" wrote:
> I have installed Reporting Services on a computer running Windows Server 2000
> with SP4. At the end of the installation it told me it could not
> automatically configure/start reporting services and that it needed to be
> done. The only thing I can find in the readme file is in regards to
> permissions dor IWAM on a domain controller, however this server is not a
> domain controller. When I go to the page for ReportManager I get an access
> denied and the ReportingServices page has a page cannot be displayed error.
> Any help is greatly appreciated.
> Thanks,
> Ian
with SP4. At the end of the installation it told me it could not
automatically configure/start reporting services and that it needed to be
done. The only thing I can find in the readme file is in regards to
permissions dor IWAM on a domain controller, however this server is not a
domain controller. When I go to the page for ReportManager I get an access
denied and the ReportingServices page has a page cannot be displayed error.
Any help is greatly appreciated.
Thanks,
IanI have made it past that error but now I am getting: The Report Server Web
service has not generated a public key. The service may have not have
started successfully. Check the log files for more information.
I have done everything here:
http://www.sqlreportingservices.net/Ask/354.aspx with no luck thus far.
Please help.
Ian
"Ian T. Jones" wrote:
> I have installed Reporting Services on a computer running Windows Server 2000
> with SP4. At the end of the installation it told me it could not
> automatically configure/start reporting services and that it needed to be
> done. The only thing I can find in the readme file is in regards to
> permissions dor IWAM on a domain controller, however this server is not a
> domain controller. When I go to the page for ReportManager I get an access
> denied and the ReportingServices page has a page cannot be displayed error.
> Any help is greatly appreciated.
> Thanks,
> Ian
manual activation of RS
Hi
I'm having problems manually activating the report server after installation
on Windows 2000 server sp4 , SQL Server 2000 sp3 and Reporting Services sp1.
I have followed other fixes I have seen but still get the same error "The
Report Server Web service has not generated a public key"
I have done the following:
rskeymgmt -d
rsactivate -c"C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\RSReportServer.config" -t
but still get the same error. Can anyone help?
Thanks,
JezHi jez,
From your descriptions, I understood that you encounter error message "The
Report Server Web service has not generated a public key" during your
Reporting Services installation. Have I understood you? Correct me if I was
wrong.
Based on my experience, RSActivate is only used for setting up web farms.
As the error states, the problem is most likely an unrelated failure when
the web service starts. You can get a more detailed description of the
underlying problem by navigating to http://localhost/reportserver.
Please give full permissions to IUSR, IWAM, and ASPNET users on the
following key using regedt32 and reinstalled SQL Server Reporting Services
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application
Let me know whether it works or you need more detailed steps about how to
perform these steps.
Sincerely yours,
Michael Cheng
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.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Cheng,
Yes you have understood this correctly.
In the past I have successfully install RS on XP but now I'm trying to
install it on Windows 2000 Server and I run into this error. I have tried
to follow your advice but have observed the following:
1) When I try and access the page reportserver I get "HTTP 500 - Internal
Server error". I then checked that the configuration pointed to version
1.1.4322 of the .NET Framework which it did.
Then I looked at the Event Viewer and the only messages in there relating to
Reporting Services where entries every 12 hours by the "Schedule and
Delivery" source recording "The ReportServer service has been activated"
2) regedit - On Windows 2000 Server I do not get a "permissions" option when
I right click the registry key as you would on XP. I have checked under the
"Local User and Groups" heading in the Computer Management console and noted
that these users belonging to the following groups:
IUSR - Guest
IWAM - Guest
ASPNET - Administrators; Guest; VS Developers; Web Applications
I then added IUSR and IWAM to the administrators group and reinstalled RS
but still get the same error.
Can you suggest what I should do next?
Thanks,
Jez
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:uzEVYw0CFHA.2768@.cpmsftngxa10.phx.gbl...
> Hi jez,
> From your descriptions, I understood that you encounter error message "The
> Report Server Web service has not generated a public key" during your
> Reporting Services installation. Have I understood you? Correct me if I
> was
> wrong.
> Based on my experience, RSActivate is only used for setting up web farms.
> As the error states, the problem is most likely an unrelated failure when
> the web service starts. You can get a more detailed description of the
> underlying problem by navigating to http://localhost/reportserver.
> Please give full permissions to IUSR, IWAM, and ASPNET users on the
> following key using regedt32 and reinstalled SQL Server Reporting Services
> HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application
> Let me know whether it works or you need more detailed steps about how to
> perform these steps.
>
> Sincerely yours,
> Michael Cheng
> 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.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
>
>|||Hi jez,
Expand the Registery Key to
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application
Right click "Application" in the Left Panel,
Click "Permissions..."
Add IUSR, IWAM and ASPNET full permissions explicitly
Let me know whether it works.
Sincerely yours,
Michael Cheng
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.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Cheng,
To administer the server I'm using NetMeeting or Terminal Services and
logging on as the local Administrator but when I right click "Application" I
do not see a Permissions option. The only choices I have are:
Collapse
New
Find
Delete
Rename
Copy Key Name
Are you sure that this option is avaible under Windows 2000 Server?
If it is then it must be the properties of NetMeeting or Terminal Services
but I just don't understand that?
Thanks,
Jez
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:Iwt07ORDFHA.644@.cpmsftngxa10.phx.gbl...
> Hi jez,
> Expand the Registery Key to
> HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application
> Right click "Application" in the Left Panel,
> Click "Permissions..."
> Add IUSR, IWAM and ASPNET full permissions explicitly
> Let me know whether it works.
>
> Sincerely yours,
> Michael Cheng
> 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.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hi Jez,
Oops, I didn't realize that you are using Windows 2000
So, please follow the steps below to open Regstry Editor
- Start -> Run -> "regedt32"
- Go to
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application
- Click Menu "Security" -> "Permissions"
Let me know whether it works this time.
Sincerely yours,
Michael Cheng
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.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Cheng,
User error on my behalf as I was using regedit and not regedt32!!! Have set
the permissions and reinstalled RS but still get the same error on
installation that reporting services requires manual activation.
Any ideas where to look next?
Many thanks for your help,
Jez
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:j6wYYTaDFHA.3152@.cpmsftngxa10.phx.gbl...
> Hi Jez,
> Oops, I didn't realize that you are using Windows 2000
> So, please follow the steps below to open Regstry Editor
> - Start -> Run -> "regedt32"
> - Go to
> HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application
> - Click Menu "Security" -> "Permissions"
> Let me know whether it works this time.
>
> Sincerely yours,
> Michael Cheng
> 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.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Cheng,
In the end I reinstalled the .Net 1.1 framework and then reinstalled RS and
it now all works!
Thanks for you help,
Jez
"jez" <jnel@.nospam.nospam> wrote in message
news:eSM45JcDFHA.3928@.TK2MSFTNGP15.phx.gbl...
> Cheng,
> User error on my behalf as I was using regedit and not regedt32!!! Have
> set the permissions and reinstalled RS but still get the same error on
> installation that reporting services requires manual activation.
> Any ideas where to look next?
> Many thanks for your help,
> Jez
> "Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
> news:j6wYYTaDFHA.3152@.cpmsftngxa10.phx.gbl...
>> Hi Jez,
>> Oops, I didn't realize that you are using Windows 2000
>> So, please follow the steps below to open Regstry Editor
>> - Start -> Run -> "regedt32"
>> - Go to
>> HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application
>> - Click Menu "Security" -> "Permissions"
>> Let me know whether it works this time.
>>
>> Sincerely yours,
>> Michael Cheng
>> 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.
>> =====================================================>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>|||Hi Jze,
Thanks for your kindly letting me know about this, it's great to hear that
it!
Based on my experience, setting the permission will do resolve this issue,
anyway, it's great to hear that it works now. If you have any questions or
concerns next time, don't hesitate to let me know. We are always here to be
of assistance!
Sincerely yours,
Michael Cheng
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.
I'm having problems manually activating the report server after installation
on Windows 2000 server sp4 , SQL Server 2000 sp3 and Reporting Services sp1.
I have followed other fixes I have seen but still get the same error "The
Report Server Web service has not generated a public key"
I have done the following:
rskeymgmt -d
rsactivate -c"C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\RSReportServer.config" -t
but still get the same error. Can anyone help?
Thanks,
JezHi jez,
From your descriptions, I understood that you encounter error message "The
Report Server Web service has not generated a public key" during your
Reporting Services installation. Have I understood you? Correct me if I was
wrong.
Based on my experience, RSActivate is only used for setting up web farms.
As the error states, the problem is most likely an unrelated failure when
the web service starts. You can get a more detailed description of the
underlying problem by navigating to http://localhost/reportserver.
Please give full permissions to IUSR, IWAM, and ASPNET users on the
following key using regedt32 and reinstalled SQL Server Reporting Services
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application
Let me know whether it works or you need more detailed steps about how to
perform these steps.
Sincerely yours,
Michael Cheng
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.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Cheng,
Yes you have understood this correctly.
In the past I have successfully install RS on XP but now I'm trying to
install it on Windows 2000 Server and I run into this error. I have tried
to follow your advice but have observed the following:
1) When I try and access the page reportserver I get "HTTP 500 - Internal
Server error". I then checked that the configuration pointed to version
1.1.4322 of the .NET Framework which it did.
Then I looked at the Event Viewer and the only messages in there relating to
Reporting Services where entries every 12 hours by the "Schedule and
Delivery" source recording "The ReportServer service has been activated"
2) regedit - On Windows 2000 Server I do not get a "permissions" option when
I right click the registry key as you would on XP. I have checked under the
"Local User and Groups" heading in the Computer Management console and noted
that these users belonging to the following groups:
IUSR - Guest
IWAM - Guest
ASPNET - Administrators; Guest; VS Developers; Web Applications
I then added IUSR and IWAM to the administrators group and reinstalled RS
but still get the same error.
Can you suggest what I should do next?
Thanks,
Jez
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:uzEVYw0CFHA.2768@.cpmsftngxa10.phx.gbl...
> Hi jez,
> From your descriptions, I understood that you encounter error message "The
> Report Server Web service has not generated a public key" during your
> Reporting Services installation. Have I understood you? Correct me if I
> was
> wrong.
> Based on my experience, RSActivate is only used for setting up web farms.
> As the error states, the problem is most likely an unrelated failure when
> the web service starts. You can get a more detailed description of the
> underlying problem by navigating to http://localhost/reportserver.
> Please give full permissions to IUSR, IWAM, and ASPNET users on the
> following key using regedt32 and reinstalled SQL Server Reporting Services
> HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application
> Let me know whether it works or you need more detailed steps about how to
> perform these steps.
>
> Sincerely yours,
> Michael Cheng
> 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.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
>
>|||Hi jez,
Expand the Registery Key to
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application
Right click "Application" in the Left Panel,
Click "Permissions..."
Add IUSR, IWAM and ASPNET full permissions explicitly
Let me know whether it works.
Sincerely yours,
Michael Cheng
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.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Cheng,
To administer the server I'm using NetMeeting or Terminal Services and
logging on as the local Administrator but when I right click "Application" I
do not see a Permissions option. The only choices I have are:
Collapse
New
Find
Delete
Rename
Copy Key Name
Are you sure that this option is avaible under Windows 2000 Server?
If it is then it must be the properties of NetMeeting or Terminal Services
but I just don't understand that?
Thanks,
Jez
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:Iwt07ORDFHA.644@.cpmsftngxa10.phx.gbl...
> Hi jez,
> Expand the Registery Key to
> HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application
> Right click "Application" in the Left Panel,
> Click "Permissions..."
> Add IUSR, IWAM and ASPNET full permissions explicitly
> Let me know whether it works.
>
> Sincerely yours,
> Michael Cheng
> 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.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hi Jez,
Oops, I didn't realize that you are using Windows 2000
So, please follow the steps below to open Regstry Editor
- Start -> Run -> "regedt32"
- Go to
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application
- Click Menu "Security" -> "Permissions"
Let me know whether it works this time.
Sincerely yours,
Michael Cheng
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.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Cheng,
User error on my behalf as I was using regedit and not regedt32!!! Have set
the permissions and reinstalled RS but still get the same error on
installation that reporting services requires manual activation.
Any ideas where to look next?
Many thanks for your help,
Jez
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:j6wYYTaDFHA.3152@.cpmsftngxa10.phx.gbl...
> Hi Jez,
> Oops, I didn't realize that you are using Windows 2000
> So, please follow the steps below to open Regstry Editor
> - Start -> Run -> "regedt32"
> - Go to
> HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application
> - Click Menu "Security" -> "Permissions"
> Let me know whether it works this time.
>
> Sincerely yours,
> Michael Cheng
> 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.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Cheng,
In the end I reinstalled the .Net 1.1 framework and then reinstalled RS and
it now all works!
Thanks for you help,
Jez
"jez" <jnel@.nospam.nospam> wrote in message
news:eSM45JcDFHA.3928@.TK2MSFTNGP15.phx.gbl...
> Cheng,
> User error on my behalf as I was using regedit and not regedt32!!! Have
> set the permissions and reinstalled RS but still get the same error on
> installation that reporting services requires manual activation.
> Any ideas where to look next?
> Many thanks for your help,
> Jez
> "Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
> news:j6wYYTaDFHA.3152@.cpmsftngxa10.phx.gbl...
>> Hi Jez,
>> Oops, I didn't realize that you are using Windows 2000
>> So, please follow the steps below to open Regstry Editor
>> - Start -> Run -> "regedt32"
>> - Go to
>> HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application
>> - Click Menu "Security" -> "Permissions"
>> Let me know whether it works this time.
>>
>> Sincerely yours,
>> Michael Cheng
>> 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.
>> =====================================================>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>|||Hi Jze,
Thanks for your kindly letting me know about this, it's great to hear that
it!
Based on my experience, setting the permission will do resolve this issue,
anyway, it's great to hear that it works now. If you have any questions or
concerns next time, don't hesitate to let me know. We are always here to be
of assistance!
Sincerely yours,
Michael Cheng
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.
Manipulating a reports visual appearance
Hi,
we are changing at the moment our reporting system from crystal report to MS
Reporting services. Our reports are highly customizable during display. In
Crystal Reports we were using scripts into the reports to set the text align
and the column back- and foreground color by user decisions. It was also
possible to choose whether the report should be displayed in landscape or
portrait format. Now I need to give the reports with MS Reporting Services
the same abilities but I didn't find any possiblity to that yet. Because our
main application in which the reports are shown is written in good old MFC
we are using URL access to render and display the reports.
Does anyone here knows how to solve one or all of my issues described above?
Thanks in Advance
Markus
P.S. I'm a really newbie in MS Reporting Services.Style properties (like text alignment and color) can be expressions. These
expressions can depend on parameters to the report.
For example:
<TextAlign>=Parameters!TextAlign.Value</TextAlign>
Or:
<Color>=iif(Parameters!ColorScheme.Value="Rainbow","HotPink","LightBrown")</
Color>
For page orientation, you can set the page height and width via parameters
in the URL (something like rc:PageHeight=8.5... Check the documentation for
details)
My employer's lawyers require me to say:
"This posting is provided 'AS IS' with no warranties, and confers no
rights."
"Markus Heid" <markus.heid@.logasys.com> wrote in message
news:efgHn3$YEHA.1448@.TK2MSFTNGP12.phx.gbl...
> Hi,
> we are changing at the moment our reporting system from crystal report to
MS
> Reporting services. Our reports are highly customizable during display. In
> Crystal Reports we were using scripts into the reports to set the text
align
> and the column back- and foreground color by user decisions. It was also
> possible to choose whether the report should be displayed in landscape or
> portrait format. Now I need to give the reports with MS Reporting Services
> the same abilities but I didn't find any possiblity to that yet. Because
our
> main application in which the reports are shown is written in good old MFC
> we are using URL access to render and display the reports.
> Does anyone here knows how to solve one or all of my issues described
above?
> Thanks in Advance
> Markus
> P.S. I'm a really newbie in MS Reporting Services.
>|||TextAlign, BackgroundColor, and ForegroundColor can be expressions, so you
can make them user-driven using user-entered parameters. Check
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_expressions_v1_3983.asp
for details.
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Markus Heid" <markus.heid@.logasys.com> wrote in message
news:efgHn3$YEHA.1448@.TK2MSFTNGP12.phx.gbl...
> Hi,
> we are changing at the moment our reporting system from crystal report to
MS
> Reporting services. Our reports are highly customizable during display. In
> Crystal Reports we were using scripts into the reports to set the text
align
> and the column back- and foreground color by user decisions. It was also
> possible to choose whether the report should be displayed in landscape or
> portrait format. Now I need to give the reports with MS Reporting Services
> the same abilities but I didn't find any possiblity to that yet. Because
our
> main application in which the reports are shown is written in good old MFC
> we are using URL access to render and display the reports.
> Does anyone here knows how to solve one or all of my issues described
above?
> Thanks in Advance
> Markus
> P.S. I'm a really newbie in MS Reporting Services.
>|||Thank you very much. It is much easier than I though!
"Chris Hays [MSFT]" <chays@.online.microsoft.com> wrote in message
news:uetiBzFZEHA.2972@.tk2msftngp13.phx.gbl...
> Style properties (like text alignment and color) can be expressions.
These
> expressions can depend on parameters to the report.
> For example:
> <TextAlign>=Parameters!TextAlign.Value</TextAlign>
> Or:
>
<Color>=iif(Parameters!ColorScheme.Value="Rainbow","HotPink","LightBrown")</
> Color>
> For page orientation, you can set the page height and width via parameters
> in the URL (something like rc:PageHeight=8.5... Check the documentation
for
> details)
>
> --
> My employer's lawyers require me to say:
> "This posting is provided 'AS IS' with no warranties, and confers no
> rights."
> "Markus Heid" <markus.heid@.logasys.com> wrote in message
> news:efgHn3$YEHA.1448@.TK2MSFTNGP12.phx.gbl...
> > Hi,
> > we are changing at the moment our reporting system from crystal report
to
> MS
> > Reporting services. Our reports are highly customizable during display.
In
> > Crystal Reports we were using scripts into the reports to set the text
> align
> > and the column back- and foreground color by user decisions. It was also
> > possible to choose whether the report should be displayed in landscape
or
> > portrait format. Now I need to give the reports with MS Reporting
Services
> > the same abilities but I didn't find any possiblity to that yet. Because
> our
> > main application in which the reports are shown is written in good old
MFC
> > we are using URL access to render and display the reports.
> > Does anyone here knows how to solve one or all of my issues described
> above?
> >
> > Thanks in Advance
> >
> > Markus
> >
> > P.S. I'm a really newbie in MS Reporting Services.
> >
> >
>
we are changing at the moment our reporting system from crystal report to MS
Reporting services. Our reports are highly customizable during display. In
Crystal Reports we were using scripts into the reports to set the text align
and the column back- and foreground color by user decisions. It was also
possible to choose whether the report should be displayed in landscape or
portrait format. Now I need to give the reports with MS Reporting Services
the same abilities but I didn't find any possiblity to that yet. Because our
main application in which the reports are shown is written in good old MFC
we are using URL access to render and display the reports.
Does anyone here knows how to solve one or all of my issues described above?
Thanks in Advance
Markus
P.S. I'm a really newbie in MS Reporting Services.Style properties (like text alignment and color) can be expressions. These
expressions can depend on parameters to the report.
For example:
<TextAlign>=Parameters!TextAlign.Value</TextAlign>
Or:
<Color>=iif(Parameters!ColorScheme.Value="Rainbow","HotPink","LightBrown")</
Color>
For page orientation, you can set the page height and width via parameters
in the URL (something like rc:PageHeight=8.5... Check the documentation for
details)
My employer's lawyers require me to say:
"This posting is provided 'AS IS' with no warranties, and confers no
rights."
"Markus Heid" <markus.heid@.logasys.com> wrote in message
news:efgHn3$YEHA.1448@.TK2MSFTNGP12.phx.gbl...
> Hi,
> we are changing at the moment our reporting system from crystal report to
MS
> Reporting services. Our reports are highly customizable during display. In
> Crystal Reports we were using scripts into the reports to set the text
align
> and the column back- and foreground color by user decisions. It was also
> possible to choose whether the report should be displayed in landscape or
> portrait format. Now I need to give the reports with MS Reporting Services
> the same abilities but I didn't find any possiblity to that yet. Because
our
> main application in which the reports are shown is written in good old MFC
> we are using URL access to render and display the reports.
> Does anyone here knows how to solve one or all of my issues described
above?
> Thanks in Advance
> Markus
> P.S. I'm a really newbie in MS Reporting Services.
>|||TextAlign, BackgroundColor, and ForegroundColor can be expressions, so you
can make them user-driven using user-entered parameters. Check
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_expressions_v1_3983.asp
for details.
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Markus Heid" <markus.heid@.logasys.com> wrote in message
news:efgHn3$YEHA.1448@.TK2MSFTNGP12.phx.gbl...
> Hi,
> we are changing at the moment our reporting system from crystal report to
MS
> Reporting services. Our reports are highly customizable during display. In
> Crystal Reports we were using scripts into the reports to set the text
align
> and the column back- and foreground color by user decisions. It was also
> possible to choose whether the report should be displayed in landscape or
> portrait format. Now I need to give the reports with MS Reporting Services
> the same abilities but I didn't find any possiblity to that yet. Because
our
> main application in which the reports are shown is written in good old MFC
> we are using URL access to render and display the reports.
> Does anyone here knows how to solve one or all of my issues described
above?
> Thanks in Advance
> Markus
> P.S. I'm a really newbie in MS Reporting Services.
>|||Thank you very much. It is much easier than I though!
"Chris Hays [MSFT]" <chays@.online.microsoft.com> wrote in message
news:uetiBzFZEHA.2972@.tk2msftngp13.phx.gbl...
> Style properties (like text alignment and color) can be expressions.
These
> expressions can depend on parameters to the report.
> For example:
> <TextAlign>=Parameters!TextAlign.Value</TextAlign>
> Or:
>
<Color>=iif(Parameters!ColorScheme.Value="Rainbow","HotPink","LightBrown")</
> Color>
> For page orientation, you can set the page height and width via parameters
> in the URL (something like rc:PageHeight=8.5... Check the documentation
for
> details)
>
> --
> My employer's lawyers require me to say:
> "This posting is provided 'AS IS' with no warranties, and confers no
> rights."
> "Markus Heid" <markus.heid@.logasys.com> wrote in message
> news:efgHn3$YEHA.1448@.TK2MSFTNGP12.phx.gbl...
> > Hi,
> > we are changing at the moment our reporting system from crystal report
to
> MS
> > Reporting services. Our reports are highly customizable during display.
In
> > Crystal Reports we were using scripts into the reports to set the text
> align
> > and the column back- and foreground color by user decisions. It was also
> > possible to choose whether the report should be displayed in landscape
or
> > portrait format. Now I need to give the reports with MS Reporting
Services
> > the same abilities but I didn't find any possiblity to that yet. Because
> our
> > main application in which the reports are shown is written in good old
MFC
> > we are using URL access to render and display the reports.
> > Does anyone here knows how to solve one or all of my issues described
> above?
> >
> > Thanks in Advance
> >
> > Markus
> >
> > P.S. I'm a really newbie in MS Reporting Services.
> >
> >
>
Wednesday, March 7, 2012
Managing Reporting Services Users
Good afternoon,
I've just started using SQL Server 2005 Reporting Services and after managing to deploy it, on the dev server, I've found myself unable to manage the users that can access it. After searching on the web I've noticed that only windows users can access Reporting Services (unless you develop your custom authentication system using the extentions). That's ok for now, the problem is that I can't seem to find where to assign permissions to the windows users.
The bottom line is that I would like configure reporting services in a way that some users can add reports while others can only view them, as well as making their own using ad-hoc reports. Could someone help me out with this? :)
I started to answer a similar question here:http://forums.asp.net/thread/1573629.aspx
Within the security area you will see the different type of access that are available:
Browser Role : Run reports and navigate through the folder structure.
Content Manager Role : Define a folder structure for storing reports and other items, set security at the item level, and view and manage the items stored by the server.
Report Builder Role: Build and edit reports in Report Builder.
Publisher Role: Publish content to a report server.
My Reports Role : Build reports for personal use or store reports in a user-owned folder.
System Administrator Role: Enable features and set defaults, set site-wide security, create role definitions, and manage jobs.
System User Role : View basic information about the report server such as the schedule information in a shared schedule.
'Roles Copied straight outta the help'
I've found it's easier to set up Global groups within the Active Dir and add them to RS2005, it's a lot easier to manage the users.
Managing reporting services models
Hi everybody,
I have the following scenario: I have web application which is creting new SQL Server database each time when new customer is created in the application.
I would like to give users the possibility of creating ad hoc reports and thus I need to create new connection and report model (and deploy them to my reoport server) each time when the new database is created (report models can not use multiple databases). Does anybody knows how can I do that?
Maybe there is another approach to this kind of problem?
Thank you in advance,
Marek
You can create datasources and autogenerate models from these datasources using the SSRS SOAP API. Check out this article in BOL for information on how to get started using the SOAP API:
http://msdn2.microsoft.com/en-us/library/ms159162.aspx
Saturday, February 25, 2012
Managing an axis in a SQL 2005 Reporting Services Chart
Hi,
I'm getting my feet wet with SQL 2005's reporting services charting features and I can't seem to find a way to have my Y-Axis stay constant. I've created a Line Chart and have set the Minimum and Maximum scale to 10 for my Y-Axis. The report seems to ignore this and sets each chart in the report relevant to the data for the series. This means that my charts, which are performance indicators for individuals, are not consistent in their layout. Is this a bug, or am I doing something wrong?
thanks
-James
james@.4divine.com
The minimum value of the y-axis describes the minimum axis value that should be shown in the chart. It sounds like you have set the minimum and the maximum value of the y-axis to have identical values. In that case your setting is ignored and the axis will autoscale based on the actual data point y-values.
I think you should set the minimum to be 0 and the maximum to be 10.
-- Robert
|||hi,
i also have a problem with the numbers in charts, esp bar chart. currently, the y-axis is on auto-mode.
however, some of the numbers are hidden in the bar chart.
is there a way to set the maximum value of the y-axis to be max(globalvariable) + 10.
i believe this will force the chart to be bigger, thus the nos will not be hidden in the bar chart.
any idea how this can be done?
-
HY
|||RS 2005 allows the usage of expressions for the axis settings, such as min, max, and so on.
E.g. =Max(Fields!A.Value, "Dataset1")
-- Robert
Managing an axis in a SQL 2005 Reporting Services Chart
Hi,
I'm getting my feet wet with SQL 2005's reporting services charting features and I can't seem to find a way to have my Y-Axis stay constant. I've created a Line Chart and have set the Minimum and Maximum scale to 10 for my Y-Axis. The report seems to ignore this and sets each chart in the report relevant to the data for the series. This means that my charts, which are performance indicators for individuals, are not consistent in their layout. Is this a bug, or am I doing something wrong?
thanks
-James
james@.4divine.com
The minimum value of the y-axis describes the minimum axis value that should be shown in the chart. It sounds like you have set the minimum and the maximum value of the y-axis to have identical values. In that case your setting is ignored and the axis will autoscale based on the actual data point y-values.
I think you should set the minimum to be 0 and the maximum to be 10.
-- Robert
|||hi,
i also have a problem with the numbers in charts, esp bar chart. currently, the y-axis is on auto-mode.
however, some of the numbers are hidden in the bar chart.
is there a way to set the maximum value of the y-axis to be max(globalvariable) + 10.
i believe this will force the chart to be bigger, thus the nos will not be hidden in the bar chart.
any idea how this can be done?
-
HY
|||RS 2005 allows the usage of expressions for the axis settings, such as min, max, and so on.
E.g. =Max(Fields!A.Value, "Dataset1")
-- Robert
Subscribe to:
Posts (Atom)