How to Create Reports?

Hi --
We have SQL Server 2000 and I just found out that it comes with Reporting
Services. How do I create reports?
Thanks
RichRead the SQL Server Help File to get started, there are a lot of good
tutorials.
"Rich Morey" <rwmorey71@.hotmail.com> wrote in message
news:uV%23a1doCIHA.1208@.TK2MSFTNGP05.phx.gbl...
> Hi --
> We have SQL Server 2000 and I just found out that it comes with Reporting
> Services. How do I create reports?
> Thanks
> Rich
>

How to create new alias for Analysis Services 2005

Hello All,

Pl guide me for creating new instance for analysis services 2005.

Deepti

Run SQL Server setup to install additional named instances on your machine.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

How to create large report?

Hi,

I have been tasked with trying to re-create out in-house reporting solution, based-on powerpoint and SQL Server, using Reporting Services 2005.

However when trying to create a demo report I find a number of problems:

1) I cannot make the page layout long enough or insert extra pages in order to caointain all of the test, charts and tables that we have in our reports (typically around 100 powerpoint slides)

2) I cannot find a way to set any global report styles for text or charts

3) I cannot find a way to have a flow layout instead of a grid layout - which does not allow me to insert items into the middle of a report

Any help/advice would be greatly appreciated,

Thanks,

Denham

1) Click on the Body band and set the Size property accordingly.

2) Currently, SSRS doesn't support styles or templates.

3) The List region allows you to create freeflowing reports.

|||

Hi Denham,

please forgive me if I have not understood you correctly...

1) I cannot make the page layout long enough or insert extra pages in order to caointain all of the test, charts and tables that we have in our reports (typically around 100 powerpoint slides)

This sounds like you are trying to create a 100 page report (?). If so, I would question the business value of such a report. May be better to suggest an alternative, such as using exception reports in a web page (BI style, which you can do in report designer), or cutting up the report into smaller chunks. Personally, I haven't had the need to create a report more than 30-odd pages long - which I thought was rather extravagant.

2) I cannot find a way to set any global report styles for text or charts

I don't know of any either. I tend to copy a graph/table/matrix and then change the dataset & values.

3) I cannot find a way to have a flow layout instead of a grid layout - which does not allow me to insert items into the middle of a report.

The only way I know of is to move everything on the page downwards to insert something in between. The layout can take quite a bit of getting used to, especially if you are familiar with banded report designers, such as Crystal. However, once you have been using it for a while, it becomes reasonably easy.

Hope that has been of some help to you.

NinetyNine

|||

Thanks for your reply.

1) Unfortunately our business needs to create these large reports in order to support the many different types of analyses that are used. However it may be possible to break them up into sub-reports in order for us to use Reporting Services

2) Shame about the lack of styles. Our current reporting solution is based on Powerpoint for which we can use templates.

3) Again, shame!

How to create large report?

Hi,

I have been tasked with trying to re-create out in-house reporting solution, based-on powerpoint and SQL Server, using Reporting Services 2005.

However when trying to create a demo report I find a number of problems:

1) I cannot make the page layout long enough or insert extra pages in order to caointain all of the test, charts and tables that we have in our reports (typically around 100 powerpoint slides)

2) I cannot find a way to set any global report styles for text or charts

3) I cannot find a way to have a flow layout instead of a grid layout - which does not allow me to insert items into the middle of a report

Any help/advice would be greatly appreciated,

Thanks,

Denham

1) Click on the Body band and set the Size property accordingly.

2) Currently, SSRS doesn't support styles or templates.

3) The List region allows you to create freeflowing reports.

|||

Hi Denham,

please forgive me if I have not understood you correctly...

1) I cannot make the page layout long enough or insert extra pages in order to caointain all of the test, charts and tables that we have in our reports (typically around 100 powerpoint slides)

This sounds like you are trying to create a 100 page report (?). If so, I would question the business value of such a report. May be better to suggest an alternative, such as using exception reports in a web page (BI style, which you can do in report designer), or cutting up the report into smaller chunks. Personally, I haven't had the need to create a report more than 30-odd pages long - which I thought was rather extravagant.

2) I cannot find a way to set any global report styles for text or charts

I don't know of any either. I tend to copy a graph/table/matrix and then change the dataset & values.

3) I cannot find a way to have a flow layout instead of a grid layout - which does not allow me to insert items into the middle of a report.

The only way I know of is to move everything on the page downwards to insert something in between. The layout can take quite a bit of getting used to, especially if you are familiar with banded report designers, such as Crystal. However, once you have been using it for a while, it becomes reasonably easy.

Hope that has been of some help to you.

NinetyNine

|||

Thanks for your reply.

1) Unfortunately our business needs to create these large reports in order to support the many different types of analyses that are used. However it may be possible to break them up into sub-reports in order for us to use Reporting Services

2) Shame about the lack of styles. Our current reporting solution is based on Powerpoint for which we can use templates.

3) Again, shame!

How to Create Dynamic Report Using Reporting Services

Hi all,
I was wondering is Reporting Services can be used to create dynamic
report as Crystal Report Advanced Edition do? So, we can add new object
based on user requirement through coding.
For example the scenario is (with VB6):
There's 5 checkbox that's reflect 5 database field of a table that will
be choosed by user and appear at the report.
My consideration is, even though Reporting Services can be used at
Windows environment using IE control, the report must be compiled &
built, so if we... we can say... create report runtime is it possible
to do it at Reporting Services?Hi Resant,
YOu have to deploy (publish) the report on the server in order to run it.
You can create an interface that allows the user to create on the fly base on
metadata. But the preview has to come afte a publish.
see this ASP.NET demo, it may has ideas
http://www.rdlcomponents.com/ASPExamples/default.aspx
Thanks
Jerry
"Resant" wrote:
> Hi all,
> I was wondering is Reporting Services can be used to create dynamic
> report as Crystal Report Advanced Edition do? So, we can add new object
> based on user requirement through coding.
> For example the scenario is (with VB6):
> There's 5 checkbox that's reflect 5 database field of a table that will
> be choosed by user and appear at the report.
> My consideration is, even though Reporting Services can be used at
> Windows environment using IE control, the report must be compiled &
> built, so if we... we can say... create report runtime is it possible
> to do it at Reporting Services?
>|||Actually my conception exactly the same as the interface that's shown
by ASP.NET demo, I don't mind if I must learn RDL code, but could you
share how to publish the report on the server automatically (through
coding or the others) ?
I'm interested with RDL Component, how is the component work? Is it
read RDL code and change it into ASP code?
waiting for your reply...|||If you are interested in this I strongly suggest that you look at the new
report controls in the newest beta for Widbey (Visual Studio). There are two
controls: web and winform. They can work with server or work in local mode.
The best thing to understand how RS works is to go read this very good
article here:
http://www.microsoft.com/sql/reporting/techinfo/techoverview.asp
RDL stands for Report Definition Language. It is an XML document that
defines the report in a output independent manner. HTML output is just one
of the rendering outputs (RS also does PDF, Excel, etc). The spec is here:
http://www.microsoft.com/sql/reporting/techinfo/rdlspec.asp
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Resant" <resant_v@.yahoo.com> wrote in message
news:1114566998.702015.164760@.g14g2000cwa.googlegroups.com...
> Actually my conception exactly the same as the interface that's shown
> by ASP.NET demo, I don't mind if I must learn RDL code, but could you
> share how to publish the report on the server automatically (through
> coding or the others) ?
> I'm interested with RDL Component, how is the component work? Is it
> read RDL code and change it into ASP code?
> waiting for your reply...
>|||Hi Resant,
The full source code for Publish the report is there.
And the component basically convert (read/write) the XML representation
in objects/collections, in the case the programmer does not want to deal with
the RDL specification and writting raw
XML(http://www.microsoft.com/sql/reporting/techinfo/rdlspec.asp).
The ASP.NET interface helps you to select the items to be included in the
report, but its not reading or using any metadata at all.
Hopefully it help you to start.
Thanks
Jerry
--
The first RDL reader/writer of the market.
http://www.rdlcomponents.com
"Resant" wrote:
> Actually my conception exactly the same as the interface that's shown
> by ASP.NET demo, I don't mind if I must learn RDL code, but could you
> share how to publish the report on the server automatically (through
> coding or the others) ?
> I'm interested with RDL Component, how is the component work? Is it
> read RDL code and change it into ASP code?
> waiting for your reply...
>|||Hi Bruce,
Where we can find information abou the web and winform controls?
Thanks
Jerry
"Bruce L-C [MVP]" wrote:
> If you are interested in this I strongly suggest that you look at the new
> report controls in the newest beta for Widbey (Visual Studio). There are two
> controls: web and winform. They can work with server or work in local mode.
> The best thing to understand how RS works is to go read this very good
> article here:
> http://www.microsoft.com/sql/reporting/techinfo/techoverview.asp
> RDL stands for Report Definition Language. It is an XML document that
> defines the report in a output independent manner. HTML output is just one
> of the rendering outputs (RS also does PDF, Excel, etc). The spec is here:
> http://www.microsoft.com/sql/reporting/techinfo/rdlspec.asp
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Resant" <resant_v@.yahoo.com> wrote in message
> news:1114566998.702015.164760@.g14g2000cwa.googlegroups.com...
> > Actually my conception exactly the same as the interface that's shown
> > by ASP.NET demo, I don't mind if I must learn RDL code, but could you
> > share how to publish the report on the server automatically (through
> > coding or the others) ?
> >
> > I'm interested with RDL Component, how is the component work? Is it
> > read RDL code and change it into ASP code?
> >
> > waiting for your reply...
> >
>
>|||Check this related thread:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=8a565186-663e-48aa-b4e2-8bad3056c40f&sloc=en-us
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jerry" <Jerry@.discussions.microsoft.com> wrote in message
news:1555FEF1-AB9A-4BA1-BA38-B83C5DA7658D@.microsoft.com...
> Hi Bruce,
> Where we can find information abou the web and winform controls?
> Thanks
> Jerry
> "Bruce L-C [MVP]" wrote:
>> If you are interested in this I strongly suggest that you look at the new
>> report controls in the newest beta for Widbey (Visual Studio). There are
>> two
>> controls: web and winform. They can work with server or work in local
>> mode.
>> The best thing to understand how RS works is to go read this very good
>> article here:
>> http://www.microsoft.com/sql/reporting/techinfo/techoverview.asp
>> RDL stands for Report Definition Language. It is an XML document that
>> defines the report in a output independent manner. HTML output is just
>> one
>> of the rendering outputs (RS also does PDF, Excel, etc). The spec is
>> here:
>> http://www.microsoft.com/sql/reporting/techinfo/rdlspec.asp
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Resant" <resant_v@.yahoo.com> wrote in message
>> news:1114566998.702015.164760@.g14g2000cwa.googlegroups.com...
>> > Actually my conception exactly the same as the interface that's shown
>> > by ASP.NET demo, I don't mind if I must learn RDL code, but could you
>> > share how to publish the report on the server automatically (through
>> > coding or the others) ?
>> >
>> > I'm interested with RDL Component, how is the component work? Is it
>> > read RDL code and change it into ASP code?
>> >
>> > waiting for your reply...
>> >
>>|||I've answer of my question with :
http://weblogs.sqlteam.com/tarad/archive/2005/01/05/3944.aspx
So by struggling with RDL writing & reading + publish automatically you
can build your dynamic report.sql

How to create charts and graphs on reports?

Hi to all,

I am newbie to Reporting Services technology

I am trying to develop some reports in Reporting Services using Visual Studio Management Express.

Is there a way to create some charts and graphs inside a report?

Have I to use Report Builder?

Thanks a lot

Bye

Sure, it's quite simple actually. The trick is to get the right SQL query.

Personally, I wouldn't use report builder.

Here are the steps:

1. Create a Report Server Project from Business Intelligence Studio

2. Add a new report to the project. This can be done by opening solution explorer (View -> solution explorer). Next, right click the name of your project then Add -> New Item. Click on Report then click OK.

3. On the Data tab, you want to create a new dataset and form your SQL statement there. This can be a stored procedure or textual.

4. From the toolbox (view -> toolbox), drag and drop a chart to the grid area of the layout tab.

5. Now, you can select the type of chart and play with whatever kind of formatting you want the chart or graph to have.

6. The important thing to do next is click view -> datasets. You want to drag and drop the field(s) to the Y or X-axis as appropriate.

If you have any more questions, let us know but that should get you started.

|||

Thanks for the reply.

I will try and I will post here news about develop

thanks a lot

bye

How to create a Virtual Directory that uses instance name

Hi,
I installed Reporting Services 2005 as an instance MYMACHINE\RS2005. If I do
this, the regular setup creates a Virtual Directory called
http://MYMACHINE/ReportServer$RS2005/
But if I wanted to create a similar virtual directory (say
http://MYMACHINE/TestServer$RS2005) using Reporting Services Configuration
tool, it errors out saying the virtual directory name is invalid (I just type
in TestServer$RS2005 in the virtual directory name)
How can I accomplish this?
Any help is greatly appreciated.
Thanks.Also,
I just found documentation on MSDN that said that the tool will
automatically add the instance name, but when I use the tool, it just creates
a Virtual Directory called TestServer.
"Raghu" wrote:
> Hi,
> I installed Reporting Services 2005 as an instance MYMACHINE\RS2005. If I do
> this, the regular setup creates a Virtual Directory called
> http://MYMACHINE/ReportServer$RS2005/
> But if I wanted to create a similar virtual directory (say
> http://MYMACHINE/TestServer$RS2005) using Reporting Services Configuration
> tool, it errors out saying the virtual directory name is invalid (I just type
> in TestServer$RS2005 in the virtual directory name)
> How can I accomplish this?
> Any help is greatly appreciated.
> Thanks.

How to create a scheduler report by report services

May i know the way how to create a scheduler report thus the client user will receive a weekly report and email (html version)Naviagte to the Report > Subscriptions > Add new subscription > Select Report Server EMail Delivery (Note: If this is not selectable, you might have not setup the mail server properly) here you can set the mail settings for sending the report with selecting the values for the parameters (if any)

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

How to Create a Mailing Label Report

Hi,

I want to create a mailing label report, with Avery formats. Please guide me how can create this using sql server 2005 reporting services?

Regards,

Prashant Mulay

Did you sort this out?

I also want to produce a label style report where I have 3 labels across and 8 labels down..

|||

This might help:

http://blogs.msdn.com/chrishays/archive/2004/07/23/HorizontalTables.aspx

How to create a dimesnion for a range of values

I am new to OLAP and I was wondering if it is possible to create a dimension
in Analysis Services 2005 based on a range of values for a given field in a
Fact table.
Example:
Field Name: Quantity
Dimension Name: Quantity Range
Dimension Values: 0-100
101-200
201-1000
> 1000
The only solution I see now is to denormalize Quantity into a new field
QuantityRange that is computed based on the value of the quantity
1: 0-100
2: 101-200
3: 201-1000
4: > 1000
The values 1 to 4 would be my dimension.
Thanks al lot
I gave you some ideas on the microsoft.public.sqlserver.olap newsgroup.
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"carlos" <carlos@.discussions.microsoft.com> wrote in message
news:6043ABBE-7ADA-4E9D-8AA7-D252F075DAEB@.microsoft.com...
>I am new to OLAP and I was wondering if it is possible to create a
>dimension
> in Analysis Services 2005 based on a range of values for a given field in
> a
> Fact table.
> Example:
> Field Name: Quantity
> Dimension Name: Quantity Range
> Dimension Values: 0-100
> 101-200
> 201-1000
> The only solution I see now is to denormalize Quantity into a new field
> QuantityRange that is computed based on the value of the quantity
> 1: 0-100
> 2: 101-200
> 3: 201-1000
> 4: > 1000
> The values 1 to 4 would be my dimension.
> Thanks al lot
|||You could drive this denormalisation using the data in the dimension
table.
1) Create a dimension table with max and min columns
ID MinValue MaxValue
1 0 100
2 101 200
3 201 1000
4 1000 2147483648 <-- max integer value
2) Create a view on the fact table like the following
Select
...
<list fact columns here>
...
,dim.ID
from fact f
inner join dimQuantityRange dim
on f.Quantity between dim.MinValue and dim.MaxValue
3) Alter you cube to use the newly created view as the fact "table".
then you can join the dimension back onto the id in the view.
The advantage of doing things this way is that everything is data
driven. If you need to add more ranges or change the ranges you just
update the max/min columns in the dim table and re-process.
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

How to create a dimesnion for a range of values

I am new to OLAP and I was wondering if it is possible to create a dimension
in Analysis Services 2005 based on a range of values for a given field in a
Fact table.
Example:
Field Name: Quantity
Dimension Name: Quantity Range
Dimension Values: 0-100
101-200
201-1000
> 1000
The only solution I see now is to denormalize Quantity into a new field
QuantityRange that is computed based on the value of the quantity
1: 0-100
2: 101-200
3: 201-1000
4: > 1000
The values 1 to 4 would be my dimension.
Thanks al lotI gave you some ideas on the microsoft.public.sqlserver.olap newsgroup.
--
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"carlos" <carlos@.discussions.microsoft.com> wrote in message
news:6043ABBE-7ADA-4E9D-8AA7-D252F075DAEB@.microsoft.com...
>I am new to OLAP and I was wondering if it is possible to create a
>dimension
> in Analysis Services 2005 based on a range of values for a given field in
> a
> Fact table.
> Example:
> Field Name: Quantity
> Dimension Name: Quantity Range
> Dimension Values: 0-100
> 101-200
> 201-1000
> The only solution I see now is to denormalize Quantity into a new field
> QuantityRange that is computed based on the value of the quantity
> 1: 0-100
> 2: 101-200
> 3: 201-1000
> 4: > 1000
> The values 1 to 4 would be my dimension.
> Thanks al lot|||You could drive this denormalisation using the data in the dimension
table.
1) Create a dimension table with max and min columns
ID MinValue MaxValue
1 0 100
2 101 200
3 201 1000
4 1000 2147483648 <-- max integer value
2) Create a view on the fact table like the following
Select
..
<list fact columns here>
..
,dim.ID
from fact f
inner join dimQuantityRange dim
on f.Quantity between dim.MinValue and dim.MaxValue
3) Alter you cube to use the newly created view as the fact "table".
then you can join the dimension back onto the id in the view.
The advantage of doing things this way is that everything is data
driven. If you need to add more ranges or change the ranges you just
update the max/min columns in the dim table and re-process.
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

How to create a custom tier above msmdpump.dll or create custom msmdpump.dll?

I want to hit Analysis Services over HTTP but with custom authentication. Is it possible to intercept the request before it gets to msmdpump and authenticate the user credentials coming from the client app? Or is it even possible to implement some interface or inherit from a base class and create my custom msmdpump.dll?It is possible using standard ISAPI filter interfaces. msmdpump.dll is ISAPI extenstion, and by putting your ISAPI filter before it, you can intercept the HTTP request, extract all the fields you want and set token thread according to your custome authentication. In fact, there are commercial products which do just that.|||I would like to do this in .NET but ISAPI filter can only be written in C or C++. Since all msmdpump does is send the request XMLA to Analysis Server, can I create a simple webpage that does the same thing?|||You are somewhat oversimplifying what msmdpump.dll does. The HTTP to TCP/IP transition involves translation of headers (some of them are custom), which is non-trivial piece, managing the pooling under different security settings etc. It is possible, of course, to replicate its functionality, but I am afraid "simple webpage" won't be enough to do it.