Need help building a cube

hi,

i am a newbie to Analysis Services. Could someone help me build a cube. I read somewhere that a cube must contain some sort of measure or aggregate, however, i am working with data that has no need for a measure, it doesn't have columns that could be used as a measure(i.e. units or currency)...how can i build a cube without a measure and is this possible?

thanks

yadgor2000

Yadgor - without a measure there's nothing to cube up. What kind of data are you trying to analyze via a cube? I'd also highly recommend Harinath & Quinn's SSAS book if you're trying to get up to speed in Analysis Services...it's incredibly useful for me.|||

May be Ur not getting the actual facts in your data base...first prepare your dimensional modeling....then think again. Or U should take advice from Sr. Database guys in Ur organisation regarding...

Thanks

|||As per the other replies: If you have no measures, you have nothing to analyse... so the question to be answered is why are you trying to build a cube? Maybe some other technology would be more appropriate.sql

Need Help Authentication loses HttpContext?

We have both a custom data extension and a custom authentication extension for Reporting Services 2000.

Reports with one dataset work great, but reports with more than one dataset fail because the Authentication extension call GetUserInfo no longer has an HttpContext when the second dataset calls into it.

I've seen several people post this same problem on other forums but no answers. Documentation of an msdn article states "the security extension will always be loaded in the Report Server app domain" so I don't understand how we could lose the context.

Additionally, ALL samples of an authentication extension I've looked at have GetUserInfo coded the same way:

Code Snippet

Public Sub GetUserInfo(ByRef userIdentity As System.Security.Principal.IIdentity, ByRef userId As System.IntPtr) Implements Microsoft.ReportingServices.Interfaces.IAuthenticationExtension.GetUserInfo

If Not System.Web.HttpContext.Current Is Nothing _

AndAlso Not System.Web.HttpContext.Current.User Is Nothing Then

userIdentity = System.Web.HttpContext.Current.User.Identity

Else

userIdentity = Nothing

End If

userId = IntPtr.Zero

End Sub

Any help or insights would be GREATLY appreciated - thanks, Ken.

OK, Wanted to share what I have found after opening a ticket with MS.

What we wanted to accomplish:
To dynamically change our connection string per userID so we could hit multiple instances of the same database structure. We did this by using the UserID stored in the HTTPContext. However, multiple datasets in a report caused Reportings Services to spawn new threads to access the data and RS did not persist the HTTPContext to these threads.

The GetUserInfo problem was a red herring- this did indeed always have access to the HTTPContext which was part of our Authentication extension. The Data extension was the real problem as we didn't have the HTTPContext during creation of our Connection object. What we found out from MS is that Reporting Services doesn't guarantee calls to be made on the asp.net worker thread and indeed in some instances even reports with one dataset failed.

Workaround:

Reports build with RS have access to a global variable UserID - this is actually retrieved from either WindowsIndentity or FormsIdentity based on authentication. Thus I added a report parameter UserID with a non-queried default value of =User!UserID to each report, and then created a parameter @.UserID for every dataset with the value of =Parameters!UserID.Value.

In the connection object if I don't have my HTTPContext, I default to a known database so the code doesn't fail. Then in the Command object's execute reader, I loop through the parameters until I find @.UserID. I now can recreate my connection object based on the UserID and set this connection as my Command's connection and return the datareader from the correct database. I make sure the connection is closed by always specifying the CloseConnection behavior during the datareader creation.

Whew!!! A bit cheesy, but it is allowing us to do what we need. Hopefully this will help anyone else that needs it.

Need Help Authentication loses HttpContext?

We have both a custom data extension and a custom authentication extension for Reporting Services 2000.

Reports with one dataset work great, but reports with more than one dataset fail because the Authentication extension call GetUserInfo no longer has an HttpContext when the second dataset calls into it.

I've seen several people post this same problem on other forums but no answers. Documentation of an msdn article states "the security extension will always be loaded in the Report Server app domain" so I don't understand how we could lose the context.

Additionally, ALL samples of an authentication extension I've looked at have GetUserInfo coded the same way:

Code Snippet

Public Sub GetUserInfo(ByRef userIdentity As System.Security.Principal.IIdentity, ByRef userId As System.IntPtr) Implements Microsoft.ReportingServices.Interfaces.IAuthenticationExtension.GetUserInfo

If Not System.Web.HttpContext.Current Is Nothing _

AndAlso Not System.Web.HttpContext.Current.User Is Nothing Then

userIdentity = System.Web.HttpContext.Current.User.Identity

Else

userIdentity = Nothing

End If

userId = IntPtr.Zero

End Sub

Any help or insights would be GREATLY appreciated - thanks, Ken.

OK, Wanted to share what I have found after opening a ticket with MS.

What we wanted to accomplish:
To dynamically change our connection string per userID so we could hit multiple instances of the same database structure. We did this by using the UserID stored in the HTTPContext. However, multiple datasets in a report caused Reportings Services to spawn new threads to access the data and RS did not persist the HTTPContext to these threads.

The GetUserInfo problem was a red herring- this did indeed always have access to the HTTPContext which was part of our Authentication extension. The Data extension was the real problem as we didn't have the HTTPContext during creation of our Connection object. What we found out from MS is that Reporting Services doesn't guarantee calls to be made on the asp.net worker thread and indeed in some instances even reports with one dataset failed.

Workaround:

Reports build with RS have access to a global variable UserID - this is actually retrieved from either WindowsIndentity or FormsIdentity based on authentication. Thus I added a report parameter UserID with a non-queried default value of =User!UserID to each report, and then created a parameter @.UserID for every dataset with the value of =Parameters!UserID.Value.

In the connection object if I don't have my HTTPContext, I default to a known database so the code doesn't fail. Then in the Command object's execute reader, I loop through the parameters until I find @.UserID. I now can recreate my connection object based on the UserID and set this connection as my Command's connection and return the datareader from the correct database. I make sure the connection is closed by always specifying the CloseConnection behavior during the datareader creation.

Whew!!! A bit cheesy, but it is allowing us to do what we need. Hopefully this will help anyone else that needs it.

need help

I have installed SQL 2005 reporting services and I configured it using
Reporting Services Configuration. Now I tried to access to report manager
using http://servername/Reports with login I used to start reporting
services. It doesn't work and keep prompting me for login and password. But
no use and I am sure this login is correct and password correct and it
started the reportings services successfully. Can anyone please help how to
solve this problem. Thanks.On Nov 4, 9:56 pm, " Miley Cyrus" <a...@.b.com> wrote:
> I have installed SQL 2005 reporting services and I configured it using
> Reporting Services Configuration. Now I tried to access to report manager
> using http://servername/Reports with login I used to start reporting
> services. It doesn't work and keep prompting me for login and password. But
> no use and I am sure this login is correct and password correct and it
> started the reportings services successfully. Can anyone please help how to
> solve this problem. Thanks.
You might want to check the Virtual Directories and see if the
permissions are set to anonymous. To do this, right-click My Computer
>> select Manage >> select Services and Applications >> Internet
Information Services >> Web Sites >> Default Web Site >> right-click
the Reports/ReportServer virtual directories >> select Properties >
select the Directory Security tab >> select the top Edit... button >>
select Anonymous access, Allow IIS to control password and Integrated
Windows authentication. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Enrique,
In fact, it is checked already. Integrade window
authentication, digest authentication ... and basic authenitcation are
checked as well. Only .net passport atuthentication and default domain and
realm are empty. Is this this all right?
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1194239797.654239.246180@.19g2000hsx.googlegroups.com...
> On Nov 4, 9:56 pm, " Miley Cyrus" <a...@.b.com> wrote:
>> I have installed SQL 2005 reporting services and I configured it using
>> Reporting Services Configuration. Now I tried to access to report manager
>> using http://servername/Reports with login I used to start reporting
>> services. It doesn't work and keep prompting me for login and password.
>> But
>> no use and I am sure this login is correct and password correct and it
>> started the reportings services successfully. Can anyone please help how
>> to
>> solve this problem. Thanks.
>
> You might want to check the Virtual Directories and see if the
> permissions are set to anonymous. To do this, right-click My Computer
>> select Manage >> select Services and Applications >> Internet
> Information Services >> Web Sites >> Default Web Site >> right-click
> the Reports/ReportServer virtual directories >> select Properties >
> select the Directory Security tab >> select the top Edit... button >>
> select Anonymous access, Allow IIS to control password and Integrated
> Windows authentication. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||If you have Window Vista, is need run Internet Explorer with Administrator
privileges.
" Miley Cyrus" <a@.b.com> pí¹e v diskusním pøíspìvku
news:eK30U02HIHA.4808@.TK2MSFTNGP05.phx.gbl...
> Enrique,
> In fact, it is checked already. Integrade window
> authentication, digest authentication ... and basic authenitcation are
> checked as well. Only .net passport atuthentication and default domain and
> realm are empty. Is this this all right?
>
> "EMartinez" <emartinez.pr1@.gmail.com> wrote in message
> news:1194239797.654239.246180@.19g2000hsx.googlegroups.com...
>> On Nov 4, 9:56 pm, " Miley Cyrus" <a...@.b.com> wrote:
>> I have installed SQL 2005 reporting services and I configured it using
>> Reporting Services Configuration. Now I tried to access to report
>> manager
>> using http://servername/Reports with login I used to start reporting
>> services. It doesn't work and keep prompting me for login and password.
>> But
>> no use and I am sure this login is correct and password correct and it
>> started the reportings services successfully. Can anyone please help how
>> to
>> solve this problem. Thanks.
>>
>> You might want to check the Virtual Directories and see if the
>> permissions are set to anonymous. To do this, right-click My Computer
>> select Manage >> select Services and Applications >> Internet
>> Information Services >> Web Sites >> Default Web Site >> right-click
>> the Reports/ReportServer virtual directories >> select Properties >
>> select the Directory Security tab >> select the top Edit... button >>
>> select Anonymous access, Allow IIS to control password and Integrated
>> Windows authentication. Hope this helps.
>> Regards,
>> Enrique Martinez
>> Sr. Software Consultant
>

need help

I have installed SQL 2005 reporting services and I configured it using
Reporting Services Configuration. Now I tried to access to report manager
using http://servername/Reports with login I used to start reporting
services. It doesn't work and keep prompting me for login and password. But
no use and I am sure this login is correct and password correct and it
started the reportings services successfully. Can anyone please help how to
solve this problem. Thanks.On Nov 4, 9:56 pm, " Miley Cyrus" <a...@.b.com> wrote:
> I have installed SQL 2005 reporting services and I configured it using
> Reporting Services Configuration. Now I tried to access to report manager
> using http://servername/Reports with login I used to start reporting
> services. It doesn't work and keep prompting me for login and password. But
> no use and I am sure this login is correct and password correct and it
> started the reportings services successfully. Can anyone please help how to
> solve this problem. Thanks.
You might want to check the Virtual Directories and see if the
permissions are set to anonymous. To do this, right-click My Computer
>> select Manage >> select Services and Applications >> Internet
Information Services >> Web Sites >> Default Web Site >> right-click
the Reports/ReportServer virtual directories >> select Properties >
select the Directory Security tab >> select the top Edit... button >>
select Anonymous access, Allow IIS to control password and Integrated
Windows authentication. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Enrique,
In fact, it is checked already. Integrade window
authentication, digest authentication ... and basic authenitcation are
checked as well. Only .net passport atuthentication and default domain and
realm are empty. Is this this all right?
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1194239797.654239.246180@.19g2000hsx.googlegroups.com...
> On Nov 4, 9:56 pm, " Miley Cyrus" <a...@.b.com> wrote:
>> I have installed SQL 2005 reporting services and I configured it using
>> Reporting Services Configuration. Now I tried to access to report manager
>> using http://servername/Reports with login I used to start reporting
>> services. It doesn't work and keep prompting me for login and password.
>> But
>> no use and I am sure this login is correct and password correct and it
>> started the reportings services successfully. Can anyone please help how
>> to
>> solve this problem. Thanks.
>
> You might want to check the Virtual Directories and see if the
> permissions are set to anonymous. To do this, right-click My Computer
>> select Manage >> select Services and Applications >> Internet
> Information Services >> Web Sites >> Default Web Site >> right-click
> the Reports/ReportServer virtual directories >> select Properties >
> select the Directory Security tab >> select the top Edit... button >>
> select Anonymous access, Allow IIS to control password and Integrated
> Windows authentication. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||If you have Window Vista, is need run Internet Explorer with Administrator
privileges.
" Miley Cyrus" <a@.b.com> pí¹e v diskusním pøíspìvku
news:eK30U02HIHA.4808@.TK2MSFTNGP05.phx.gbl...
> Enrique,
> In fact, it is checked already. Integrade window
> authentication, digest authentication ... and basic authenitcation are
> checked as well. Only .net passport atuthentication and default domain and
> realm are empty. Is this this all right?
>
> "EMartinez" <emartinez.pr1@.gmail.com> wrote in message
> news:1194239797.654239.246180@.19g2000hsx.googlegroups.com...
>> On Nov 4, 9:56 pm, " Miley Cyrus" <a...@.b.com> wrote:
>> I have installed SQL 2005 reporting services and I configured it using
>> Reporting Services Configuration. Now I tried to access to report
>> manager
>> using http://servername/Reports with login I used to start reporting
>> services. It doesn't work and keep prompting me for login and password.
>> But
>> no use and I am sure this login is correct and password correct and it
>> started the reportings services successfully. Can anyone please help how
>> to
>> solve this problem. Thanks.
>>
>> You might want to check the Virtual Directories and see if the
>> permissions are set to anonymous. To do this, right-click My Computer
>> select Manage >> select Services and Applications >> Internet
>> Information Services >> Web Sites >> Default Web Site >> right-click
>> the Reports/ReportServer virtual directories >> select Properties >
>> select the Directory Security tab >> select the top Edit... button >>
>> select Anonymous access, Allow IIS to control password and Integrated
>> Windows authentication. Hope this helps.
>> Regards,
>> Enrique Martinez
>> Sr. Software Consultant
>sql

Need basic help with deployment

Hello

I feel like an idiot here, but I cannot figure out how to get Reporting Services to work outside of Visual Studio. I have everything installed (using SQL Server 2005 Express), I have a report, it deploys but when I go to view it, I'm asked for a username and password. I found out how to allow annymous login, but when I do that it says I do not have permissions to access the report on the localhost server.

I can view the report through Visual Studio just fine, but not outside of it.

How can I get it to just allow me to view the report without logging in?

Any help would be greatly appreciated.

Thanks
-JimWell it turns out the problem was that my default browser is firefox, and so it would deploy and try to open it that way and it wouldnt work. If I open it in IE its just fine, go figure :-\sql

need all visual studio for use Reporting Services?

need all visual studio for use Reporting Services'
I thing, need only visual basicyes u wright...it's enough only VB
"TIago" wrote:
> need all visual studio for use Reporting Services'
> I thing, need only visual basic

Need Advise on SQL Express with Advanced Services

Hi Guys,

Need some advice on the free SQL Express with Advanced Services provided.

I plan to develop a small departmental multi-user applications with 5 to 6 simultaneous users using the free SQL Express with Advanced Services with VB.net and stored procedures on a local area network.

Is it a good choice to use this free SQL Express with Advanced Services or is it more advisable to purchase a standard version ?

Appreciate if someone could help me to address this issue?

One more thing, can i install the free SQL Express with Advanced Services on a normal desktop with Windows XP SP 2 and utilize it as a server or do i need a proper server with Windows 2003?

Thanks and Regards,

Jansen

If you have a small app and you're sure you'll only have 5 or 6 people generating a small load, then you should be OK with the Express version. I'd still recommend that it go on a server OS, primarilly because of the way security and networking are handled.

You also have some other limitations on Express such as database size and so forth, but you certainly could start your app there and grow into a larger server. All you have to do is backup and restore the database to the Standard Edition, and change your connection strings in your app.

Buck

|||

You should be fine with that, but you need to consider the space limitations as well. You can always grow the app into a Standard Edition. I'd also recommend that you always use a Server OS.

Buck

Need Advise on SQL Express with Advanced Services

Hi Guys,

Need some advice on the free SQL Express with Advanced Services provided.

I plan to develop a small departmental multi-user applications with 5 to 6 simultaneous users using the free SQL Express with Advanced Services with VB.net and stored procedures on a local area network.

Is it a good choice to use this free SQL Express with Advanced Services or is it more advisable to purchase a standard version ?

Appreciate if someone could help me to address this issue?

One more thing, can i install the free SQL Express with Advanced Services on a normal desktop with Windows XP SP 2 and utilize it as a server or do i need a proper server with Windows 2003.

Thanks and Regards,

Jansen

Express is well suited to the task you are discussing and yes it should install on a std windows desktop.

Need a way to use Windows NT intgrated security between two servers

Reporting Services is on its own Win2k3 server , running a report that
does a query against our Production database using Windows NT
Integrated Security.
The query never returns any data, yet when I run the query in Query
Analyzer it works fine...I have another report that uses "Credentials
stored securely in the report server" and that Query woks fine in RS
and in Query Analyzer...Has anybody found a way to use Windows NT
intgrated security between two servers accessed by IIS.RS is on one
server and the database is another..I don't have a direct answer for you but I have a suggestion. I think that
using the credentials of the calling user to hit the database is a bad idea.
The reason is that you will lose all the benefits of connection pooling. I
suggest having a readonly account that is used for the credentials of the
report. Then you use the role based security (with integrated security) to
only allow access to the reports the user should have. If you have sensitive
data that the user should only be able to see certain data then use the
global variable user!userid either as a query parameter or as a filter
parameter. The end result will be the same but your performance under load
will be much much better.
Bruce L-C
"Tom" <tom_barnard@.aotx.uscourts.gov> wrote in message
news:1096405401.694519.113440@.k17g2000odb.googlegroups.com...
> Reporting Services is on its own Win2k3 server , running a report that
> does a query against our Production database using Windows NT
> Integrated Security.
> The query never returns any data, yet when I run the query in Query
> Analyzer it works fine...I have another report that uses "Credentials
> stored securely in the report server" and that Query woks fine in RS
> and in Query Analyzer...Has anybody found a way to use Windows NT
> intgrated security between two servers accessed by IIS.RS is on one
> server and the database is another..
>

Need a quick answer about Reporting Services in SQL Server 2005?

Hi all,

I apologize in advance for the lack of homework before posting, but I am just looking for a quick answer, or a quick point in the right direction to figure this out.

I have a developer from an adjacent team that wants to use Reporting Services in a SQL Server 2005 installation.

From what I found online during what I thought was a definitive search yesterday, I gave him the MSDN SQL Server 2005 DVD and told him that Reporting Services is now part of the standard installation. Which is what my brief search yesterday indicated to me.

He did the installation (full, according to him) and said he could not find Reporting Services.

So, the quick question is...

Where is Reporting Services in SQL Server 2005? I don't have a separate MSDN DVD that contains it as was the case on SQL Server 2000. This further supports my (wavering) position that it is part of the standard installation.

Thoughts? Direction? Collective kicks in the posterior?

Thanks!Check services for "SQL Server Reporting Services (instancename)" to see if it is installed AND running. One thing is you can defer the configuration of Reporting Services until after the install. The default is to have the installation do it for you, which your neighbor may have done. If so, check http://hiscomputer/reports to see if anything is there. Oh, and he DID have IIS installed on his machine beforehand, right? It is sort of a requirement.|||Thanks very much for the info, Mr. C!!! I do appreciate it. I assume he has IIS set up, but I will check with him and pass on your other suggestions!

I am just glad to know that I didn't mis-interpret the stuff I found online yesterday, and that I am not then required to go tell him "oh, sorry, I was wrong about it being a part of the standard installation".

I have not yet graduated in my department to the use and care of 2005, but since I am the keeper of the MSDN disks, of course the minions that have actually been allowed to move on to 2005 assume I know all, and see all.

Thanks again very much! I hate asking questions like that when google would probably tell me the answer (feels too much like asking a homework problem), but today is a crazy day on the farm and I just don't have the time today.|||...the minions that have actually been allowed to move on to 2005 assume I know all, and see all.
You have access to this site, and SQLTeam. That makes you better than omniscient ;-).|||Yes, true dat.

And that's why when I forwarded your suggestions to Dude, I simply said "this was posted on a database board in response to my query". Purposely keeping the name of the board hidden safely away in my toolkit.

Knowledge is power, you know.

I would be in good shape if belly fat was also power.|||If he brings up Management Studio (gosh how I hate that thing) and selects Reporting Services instead of Database Engine, he will find it.|||Thanks Tom...info forwarded on to him. Hopefully that will do it for him and I can get back to the fires at hand.

Need a book for reporting services.

http://www.amazon.ca/s/ref=nb_ss_gw/701-8175374-6201155?url=search-alias%3Daps&field-keywords=reporting+services
I need a book to do the following:
Create a format of a report.
Define parameters of a format of a report, name, description.
Choose options of period of report
Modify the format of a report.
Create a chart by name, description, grouping by.
Modify the chart.
Delete the chart.
Create a time period (Range)
Define the range of parameters of the name
description formula
Modify time period
Delete time period.
Associate a format of the report. PDF, Excel, HMTL
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.comThis Hitchhikers Guide to Reporting Services is your best bet IMHO.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<matt cupryk> wrote in message news:20061010104027macupryk@.videotron.ca...
> http://www.amazon.ca/s/ref=nb_ss_gw/701-8175374-6201155?url=search-alias%3Daps&field-keywords=reporting+services
> I need a book to do the following:
> Create a format of a report.
> Define parameters of a format of a report, name, description.
> Choose options of period of report
> Modify the format of a report.
> Create a chart by name, description, grouping by.
> Modify the chart.
> Delete the chart.
> Create a time period (Range)
> Define the range of parameters of the name
> description formula
> Modify time period
> Delete time period.
> Associate a format of the report. PDF, Excel, HMTL
> EggHeadCafe.com - .NET Developer Portal of Choice
> http://www.eggheadcafe.com|||Hi,
I own both hitch hikers and the Wrox Professional book...both are good
but if you only have money for one I'd go for the hitchhikers one...
Peter
Hilary Cotter wrote:
> This Hitchhikers Guide to Reporting Services is your best bet IMHO.
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> <matt cupryk> wrote in message news:20061010104027macupryk@.videotron.ca...
> > http://www.amazon.ca/s/ref=nb_ss_gw/701-8175374-6201155?url=search-alias%3Daps&field-keywords=reporting+services
> >
> > I need a book to do the following:
> >
> > Create a format of a report.
> >
> > Define parameters of a format of a report, name, description.
> >
> > Choose options of period of report
> >
> > Modify the format of a report.
> >
> > Create a chart by name, description, grouping by.
> >
> > Modify the chart.
> >
> > Delete the chart.
> >
> > Create a time period (Range)
> >
> > Define the range of parameters of the name
> > description formula
> >
> > Modify time period
> >
> > Delete time period.
> >
> > Associate a format of the report. PDF, Excel, HMTL
> >
> > EggHeadCafe.com - .NET Developer Portal of Choice
> > http://www.eggheadcafe.com

Nearly blank report manager/home page

Hi,
I have just installed Reporting Services for SQL Server 2005. I went through
the configuration tool and everything went smoothly. However... when I
navigate to the report manager (http://MyReportServer/reports) I see the page
OK and the header is all there (i.e. Labels like "SQL Server Reporting
Services" and "Home" and the links for Home, My Subscriptions & Help in the
top RH side) however, there are none of the usual tabs on this main page. I
expect to see "Contents" and other tabs/folders, but they are just not there.
Any ideas?
Thanks in advance,
Andrew StanfordI'm also having this issue
"Andrew Stanford" wrote:|||Woops, figured it out - just the permission settings.
It worked fine when I was logged in on the server as admin (someone from
BUILTIN\Administrators )
Opened http://localhost/reports -> Properties tab -> Noted that only the
BUILTIN\Administrators group roles -> Added users with proper roles
Hope this helps,
gummih
"Andrew Stanford" wrote:
> Hi,
>
> I have just installed Reporting Services for SQL Server 2005. I went through
> the configuration tool and everything went smoothly. However... when I
> navigate to the report manager (http://MyReportServer/reports) I see the page
> OK and the header is all there (i.e. Labels like "SQL Server Reporting
> Services" and "Home" and the links for Home, My Subscriptions & Help in the
> top RH side) however, there are none of the usual tabs on this main page. I
> expect to see "Contents" and other tabs/folders, but they are just not there.
> Any ideas?
> Thanks in advance,
> Andrew Stanford

Navigation in a Graph

In SQL Reporting Services, i am having a problem with
passing the label value(eg. on x-axis) as a parameter to another report.
So for example, lets say i have the days of the week as my x-axis values in
the graph. Is there any way to allow the user to click on this label
value(eg. monday) which will then pass this as a parameter to another
report?
ThanksNot from labels themselves, but you can do this with data points. Pull up
Chart Properties dialog in report designer -> Values -> Edit -> Action tab.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kershni Chetty" <support@.sqrsoftware.com> wrote in message
news:O1FqKospEHA.1988@.TK2MSFTNGP09.phx.gbl...
> In SQL Reporting Services, i am having a problem with
> passing the label value(eg. on x-axis) as a parameter to another report.
> So for example, lets say i have the days of the week as my x-axis values
in
> the graph. Is there any way to allow the user to click on this label
> value(eg. monday) which will then pass this as a parameter to another
> report?
> Thanks
>