Named set is not working in excel

Hi All,

I have created the named set to get the top 4 referers for my products.

But it is not working as expected.I am using Ecel 2007 as reporting UI using Pivot tables.

The referers are in rows and product is in filter.

Say I want the top referers (google.com,altavista.com...etc) for VB (or) VC++ or SQL 2005 ....etc

Please suggest me how I can do this i.e arrange in order and vary with change of product.

I have three tables Dim_Product, Dim_Referer, Fact table

The content of this new named set would be:

{([Dim Referer].[name category].Members,4,[Measures].[value])}

Rgds

Sai

Named sets created in the MDX Script are static - they are evaluated only once. Therefore changing the current product won't affect the content of the named set.sql

n00b question - permissions from website

Hi everyone,

I've inherited a website based on the dotnetnuke frameowork.

this website also uses the reporting services from sqlserver.

When the report button is clicked in the website, the user is prompted

with a login and password (standard windows dialog)

Entering the username/password for the web site fails,

entering username/password for the machine works.

The user - of course - doesn't want to enter enything, let alone see the darn dialog box,

just wants to see the report on the screen.

Does anyone have any ideas on where to start looking for a solution to this problem?

thanks

tony

The settings for the permissions of the report service are in the service's properties in IIS settings in control panel -> administrative tools. You might be able to set it to use the same password as the rest of the website there.

N UP style reports

Is there a way to create N UP style reports in Reporting Services. N UP
style reports have a newspaper column style of appearance where the same
database column with different data is displayed in multiple columns across
the same page of a report.See if the multi-column functionality meets your need. A fuller discussion
about multi-column reports can be found at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_layout_v1_4uwj.asp
NOTE: Use must render multi_column reports to PDF, TIFF, or Print Preview to
see them a multi-column. Multi-column reports are rendered as a single
column if you use HTML, Excel, or Preview.
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Reporting Services Developer - Atlanta" <Reporting Services Developer -
Atlanta@.discussions.microsoft.com> wrote in message
news:D216D411-55A0-4014-A787-ACFA5A165C15@.microsoft.com...
> Is there a way to create N UP style reports in Reporting Services. N UP
> style reports have a newspaper column style of appearance where the same
> database column with different data is displayed in multiple columns
> across
> the same page of a report.|||Bruce, thanks for the reply. These reports are typically not printed or
exported. The data is highly dynamic and is viewed/used by our support staff
online (in HTML).
I'll read the information on the link but I'm still interested in knowing if
there is some way to detect the context of a drilldown/row group.
Thanks,
Glenn
"Bruce Johnson [MSFT]" wrote:
> See if the multi-column functionality meets your need. A fuller discussion
> about multi-column reports can be found at
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_layout_v1_4uwj.asp
> NOTE: Use must render multi_column reports to PDF, TIFF, or Print Preview to
> see them a multi-column. Multi-column reports are rendered as a single
> column if you use HTML, Excel, or Preview.
>
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Reporting Services Developer - Atlanta" <Reporting Services Developer -
> Atlanta@.discussions.microsoft.com> wrote in message
> news:D216D411-55A0-4014-A787-ACFA5A165C15@.microsoft.com...
> > Is there a way to create N UP style reports in Reporting Services. N UP
> > style reports have a newspaper column style of appearance where the same
> > database column with different data is displayed in multiple columns
> > across
> > the same page of a report.
>
>|||The link below provides good information -
but is there a way to overide the "snaking" behavior that is discussed ?
Crystal allows you to specify whether data for these types of reports is
displayed down the page or across the page.
When converting reports from Cyrstal to SRS, it is important to make them
look exactly the same to improve my organization's confidence in SRS. Most
people will see this as a limitation of SRS.
"Bruce Johnson [MSFT]" wrote:
> See if the multi-column functionality meets your need. A fuller discussion
> about multi-column reports can be found at
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_layout_v1_4uwj.asp
> NOTE: Use must render multi_column reports to PDF, TIFF, or Print Preview to
> see them a multi-column. Multi-column reports are rendered as a single
> column if you use HTML, Excel, or Preview.
>
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Reporting Services Developer - Atlanta" <Reporting Services Developer -
> Atlanta@.discussions.microsoft.com> wrote in message
> news:D216D411-55A0-4014-A787-ACFA5A165C15@.microsoft.com...
> > Is there a way to create N UP style reports in Reporting Services. N UP
> > style reports have a newspaper column style of appearance where the same
> > database column with different data is displayed in multiple columns
> > across
> > the same page of a report.
>
>

MYSQL and Reporting Server

Hi All,
Not sure if this is the best place to ask this, but how can I use
parameters in a report connecting to a MYSQL database.
Thanks
Michael
Use ? as the parameter marker e.g.
select * from mysqlcode.categories where ID = ?
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Michael van der Veeke" <michaelvanderveeke@.borderexpress.com.au> wrote in
message news:41e36ad1$0$96867$c30e37c6@.ken-reader.news.telstra.net...
> Hi All,
> Not sure if this is the best place to ask this, but how can I use
> parameters in a report connecting to a MYSQL database.
> Thanks
> Michael
|||Thank you very much.
Jasper Smith wrote:
> Use ? as the parameter marker e.g.
> select * from mysqlcode.categories where ID = ?
>

My Very Own SOAP / Web Service Report Viewer

Well, I've finally done it! The first fully functional prototype of the
report viewer control for Reporting Services 2000 is complete. I am
working on a project that cannot wait until RS 2005, so we bit the
bullet and wrote our own component (URL access will not work for a
number of reasons).
Alon with report selection, I have implemented:
1) Parameter selection (including linked params)
2) Page navigation
3) Zooming
4) Refresh
5) Export to: PDF, Excel, CSV, TIFF, XML, MHTML
6) Printing
I have received a lot of help from the RS community, so may thanks to
those of you who frequent this group!
Kulgan.Congratulations!
I have been struggling to build one too. Would you mind sharing your
code/ideas on how to go on about it?
TIA.
Marlon
"Kulgan" <nickamckenna@.gmail.com> wrote in message
news:1121180309.308222.314710@.g43g2000cwa.googlegroups.com...
> Well, I've finally done it! The first fully functional prototype of the
> report viewer control for Reporting Services 2000 is complete. I am
> working on a project that cannot wait until RS 2005, so we bit the
> bullet and wrote our own component (URL access will not work for a
> number of reasons).
> Alon with report selection, I have implemented:
> 1) Parameter selection (including linked params)
> 2) Page navigation
> 3) Zooming
> 4) Refresh
> 5) Export to: PDF, Excel, CSV, TIFF, XML, MHTML
> 6) Printing
> I have received a lot of help from the RS community, so may thanks to
> those of you who frequent this group!
> Kulgan.
>|||Unfortunately the code belongs to the client I have done the work for,
but I will be doing an open source version shortly (when I return from
holiday in a couple of weeks).
I will keep you posted!
In the meantime, if you get stuck, email me and I'll help wherever I
can.
Cheers,
Kulgan.|||Yes, thats great! I have the exact same issue that I need to resolve, i.e.
using the viewer through SOAP. I would love to see how you did this!
"TechnoSpyke" wrote:
> Congratulations!
> I have been struggling to build one too. Would you mind sharing your
> code/ideas on how to go on about it?
> TIA.
> Marlon
> "Kulgan" <nickamckenna@.gmail.com> wrote in message
> news:1121180309.308222.314710@.g43g2000cwa.googlegroups.com...
> > Well, I've finally done it! The first fully functional prototype of the
> > report viewer control for Reporting Services 2000 is complete. I am
> > working on a project that cannot wait until RS 2005, so we bit the
> > bullet and wrote our own component (URL access will not work for a
> > number of reasons).
> >
> > Alon with report selection, I have implemented:
> >
> > 1) Parameter selection (including linked params)
> > 2) Page navigation
> > 3) Zooming
> > 4) Refresh
> > 5) Export to: PDF, Excel, CSV, TIFF, XML, MHTML
> > 6) Printing
> >
> > I have received a lot of help from the RS community, so may thanks to
> > those of you who frequent this group!
> >
> > Kulgan.
> >
>
>|||Me too.
tnx.
Tom.

My Reports folder

Hi everyone,
I reinsralled my reporting services (on sql 2000) and i have a problem:
i added users and if one user create folder everyone else can see his
folder. also the my reports folder is not created auto like it was.
cant i create a folder that only i can see?
thanksThe folder that all of the My Reports are in is Users... If everyone can
see this, then either everyone is an administrator, or you need to reduce the
permissions on the Users folder.
To have the My Reports folders created automatically you must
Check the Enable My Reports box from the SIte Settings menu item on the top
left of Report Manager. There you can also setup the permissions that
individuals have on their My Reports folder.
Hope this helps
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Ruby Nadler" wrote:
> Hi everyone,
> I reinsralled my reporting services (on sql 2000) and i have a problem:
> i added users and if one user create folder everyone else can see his
> folder. also the my reports folder is not created auto like it was.
> cant i create a folder that only i can see?
> thanks
>

My Report feature

Currently - our Reporting Services site is setup so that all Domain Users can access it. We are starting to use Report Builder now. I have enabled the My Reports folder feature that that creates a user folder for anyone that logs onto the site. Is there a way to just create the user folders for certain people?

Yes. You do not have to use the "My Reports" function at all. Just create a folder for each user under the Home folder and then assign them at least browser rights to that folder. Also, be sure they have browser rights to the Home folder or they will not be able to see their own folder as this follows a hierachial structure.

My primitive questions

I want to cerate printable reports and they must be in certain format , I don't have any experience in neither "Crystal reports" and "Reporting services" I wanted to make them by "Crystal reports" but it is very confusing ! so some one advice me to use "Reporting services" and I want to make sure that"Reporting services" can give me what I need befor I start to learn it seriously .

My first question is can I use "Reporting services" with a sql server data base on an ordinary web hosting?

Then I need extremely formatted prints of those reports rather in a web based application. Can "Reporting services" give me web based print like something we have in crystal reports ?

And last question is : where to start learning"Reporting services" fast ?

Thank you in advance .

Have a look at the following:

http://msdn2.microsoft.com/en-gb/sql/aa336316.aspx (SQL Server 2005 Reporting Services has many tutorials)|||

Thank you for links despite I saw them before but Dude give me some basic information before make me to read every thingJ

Please somebody answer my question with yes or no

Thank you .

|||

>My first question is can I use "Reporting services" with a sql server data base on an ordinary web hosting?

If you have SQL Server with the reporting services component plus the web viewer control.

>Then I need extremely formatted prints of those reports rather in a web based application. Can "Reporting services" give me web based print like something we have in crystal reports ?
SSRS can output a number of formats including PDF.