Bind SQL reporting services (Reports) to ASP.NET (Urgent)

Hi all,

Currently I have a project that require me to use reporting services (Reports) together with ASP.net web application.

However, I have the following problem.

I have an asp.net web application. From there, I have a textbox whereby user can type a specific date. The specific date should then be incorporate with the sql reporting services. The report that is being generated will contain data that is on the specific date.

How can I do that?

I try to search through the internet but to no result. Can anyone help out?

Thank you so much.Read a book on Reporting Services ... you can pass everything to Reporting Services through the webservices it exposes ...
Microsoft has some good books about Reporting Services ... Search for William Vaugh ... He's very good

Bind my own DataSet that I get in my WebApp and show in the Reporting Services - is it pos

All,
Does anybody know if I can bind my own DataSet dynamically getting it in my
WebApp and show it in the Reporting Services using the services as a
formatter/viewer of this DataSet - is it possible?
Or all I can do with the RS 2000 is just a new VD for each new report and I
have to use this URL to show anything from my app? I didn't see anything
helpful allowing us to integrate the Reporting Services into WebApp yet on
the fly. What's the difference if the RS generates the DataSet or it's
generated by my application? The second way is much more flexible and
practical. Is it already implemented in the RS 2005? I saw the controls, but
didn't test them yet since my solution is not convertible to the VS2005 with
the new Reporting Services.
Just D.VS 2005 have two new controls. Webform and winform. You can use them in
local mode and give them the dataset. In local mode you do have more you
have to do (subforms etc).
In 2000 you would have to create a data processing extension (which would
work for either 2000 or 2005).
RS is designed as a service oriented application. You request a service and
RS implements it. You can call stored procedures easily or use SQL
statement. Pass in the parameters from your app and let RS create the
dataset.
Any particular reason you want to be passing a dataset. If you let RS handle
it then it will automatically do a lot for you. For instance, take the issue
of subreports. If you are handling the dataset then for each subreport you
need to respond to an event and generate the datasets for the subreport as
well.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Just D." <no@.spam.please> wrote in message
news:Kk5If.13830$eR.455@.fed1read03...
> All,
> Does anybody know if I can bind my own DataSet dynamically getting it in
> my WebApp and show it in the Reporting Services using the services as a
> formatter/viewer of this DataSet - is it possible?
> Or all I can do with the RS 2000 is just a new VD for each new report and
> I have to use this URL to show anything from my app? I didn't see anything
> helpful allowing us to integrate the Reporting Services into WebApp yet on
> the fly. What's the difference if the RS generates the DataSet or it's
> generated by my application? The second way is much more flexible and
> practical. Is it already implemented in the RS 2005? I saw the controls,
> but didn't test them yet since my solution is not convertible to the
> VS2005 with the new Reporting Services.
> Just D.
>|||I've got a case where I need to bind to a dataset that I fetch. In my
case, I need to get a stored definition of a user-customized query, and
generate RDL from that definition. I then need to fill a weakly-typed
dataset to be used as the data source for the generated report.
Any reference on how to use pre-filled datasets in SRSS? I've been
searching Google and MSDN, and have so far come up short.
Thanks in advance.
Bruce L-C [MVP] wrote:
> VS 2005 have two new controls. Webform and winform. You can use them in
> local mode and give them the dataset. In local mode you do have more you
> have to do (subforms etc).
> In 2000 you would have to create a data processing extension (which would
> work for either 2000 or 2005).
> RS is designed as a service oriented application. You request a service and
> RS implements it. You can call stored procedures easily or use SQL
> statement. Pass in the parameters from your app and let RS create the
> dataset.
> Any particular reason you want to be passing a dataset. If you let RS handle
> it then it will automatically do a lot for you. For instance, take the issue
> of subreports. If you are handling the dataset then for each subreport you
> need to respond to an event and generate the datasets for the subreport as
> well.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Just D." <no@.spam.please> wrote in message
> news:Kk5If.13830$eR.455@.fed1read03...
> > All,
> >
> > Does anybody know if I can bind my own DataSet dynamically getting it in
> > my WebApp and show it in the Reporting Services using the services as a
> > formatter/viewer of this DataSet - is it possible?
> >
> > Or all I can do with the RS 2000 is just a new VD for each new report and
> > I have to use this URL to show anything from my app? I didn't see anything
> > helpful allowing us to integrate the Reporting Services into WebApp yet on
> > the fly. What's the difference if the RS generates the DataSet or it's
> > generated by my application? The second way is much more flexible and
> > practical. Is it already implemented in the RS 2005? I saw the controls,
> > but didn't test them yet since my solution is not convertible to the
> > VS2005 with the new Reporting Services.
> >
> > Just D.
> >
> >|||If you are creating your own RDL then the way to go is to definitely get the
new controls with VS 2005. In local mode you don't need any server. You can
give the report the rdlc and the dataset.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Kevin L." <kevin.lowe0@.gmail.com> wrote in message
news:1139862643.634896.4400@.o13g2000cwo.googlegroups.com...
> I've got a case where I need to bind to a dataset that I fetch. In my
> case, I need to get a stored definition of a user-customized query, and
> generate RDL from that definition. I then need to fill a weakly-typed
> dataset to be used as the data source for the generated report.
> Any reference on how to use pre-filled datasets in SRSS? I've been
> searching Google and MSDN, and have so far come up short.
> Thanks in advance.
>
> Bruce L-C [MVP] wrote:
>> VS 2005 have two new controls. Webform and winform. You can use them in
>> local mode and give them the dataset. In local mode you do have more you
>> have to do (subforms etc).
>> In 2000 you would have to create a data processing extension (which would
>> work for either 2000 or 2005).
>> RS is designed as a service oriented application. You request a service
>> and
>> RS implements it. You can call stored procedures easily or use SQL
>> statement. Pass in the parameters from your app and let RS create the
>> dataset.
>> Any particular reason you want to be passing a dataset. If you let RS
>> handle
>> it then it will automatically do a lot for you. For instance, take the
>> issue
>> of subreports. If you are handling the dataset then for each subreport
>> you
>> need to respond to an event and generate the datasets for the subreport
>> as
>> well.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Just D." <no@.spam.please> wrote in message
>> news:Kk5If.13830$eR.455@.fed1read03...
>> > All,
>> >
>> > Does anybody know if I can bind my own DataSet dynamically getting it
>> > in
>> > my WebApp and show it in the Reporting Services using the services as a
>> > formatter/viewer of this DataSet - is it possible?
>> >
>> > Or all I can do with the RS 2000 is just a new VD for each new report
>> > and
>> > I have to use this URL to show anything from my app? I didn't see
>> > anything
>> > helpful allowing us to integrate the Reporting Services into WebApp yet
>> > on
>> > the fly. What's the difference if the RS generates the DataSet or it's
>> > generated by my application? The second way is much more flexible and
>> > practical. Is it already implemented in the RS 2005? I saw the
>> > controls,
>> > but didn't test them yet since my solution is not convertible to the
>> > VS2005 with the new Reporting Services.
>> >
>> > Just D.
>> >
>> >
>

Big-IP and SSL

Hi! I am working on some issues related to Reporting Services and SSL, I
wanted to know:
- If I install a NLB cluster and I add "n" servers, how many SSL
Certificates will I need? 1 or "n"?
- does anyone know if there are any issue related to MRS, SSL and the
Big-IP Load Balancer?
Thank you very much in advance :-)
Jose
--
------
Jose Ignacio Rodas, A+, CCEA, MCSEI use BigIP's in production, LVS' in test and development. If I understand
your first question about NLB clusters, you will need one certificate per
domain name. If your NLB cluster, comprised of "n" servers, answers up to
www.mydomain.com then you will need a certificate on www.mydomain.com. I
worked with NLB in 2000 and do not remember certificate management as being a
part of it, I could be wrong, not sure about 2003. As far as the BigIP and
SQL RS, good luck. It will work, if configured properly. Supposedly SP2 of
SQL RS added a feature to support SSL termination prior to the web server if
the proper HTTP headers are passed. I was able to get Reports working, but
not ReportServer. The information is available in the SP2 update
documentation. Hope this helps.
"Jose Ignacio Rodas" wrote:
> Hi! I am working on some issues related to Reporting Services and SSL, I
> wanted to know:
> - If I install a NLB cluster and I add "n" servers, how many SSL
> Certificates will I need? 1 or "n"?
> - does anyone know if there are any issue related to MRS, SSL and the
> Big-IP Load Balancer?
> Thank you very much in advance :-)
> Jose
> --
>
> ------
> Jose Ignacio Rodas, A+, CCEA, MCSE|||http://download.microsoft.com/download/5/1/3/513534ae-a0e7-44e6-9a04-ba3c549a5f5f/sp2Readme_EN.htm#_http_headers
That is the SP2 readme that talks about SSL termination
"Brian" wrote:
> I use BigIP's in production, LVS' in test and development. If I understand
> your first question about NLB clusters, you will need one certificate per
> domain name. If your NLB cluster, comprised of "n" servers, answers up to
> www.mydomain.com then you will need a certificate on www.mydomain.com. I
> worked with NLB in 2000 and do not remember certificate management as being a
> part of it, I could be wrong, not sure about 2003. As far as the BigIP and
> SQL RS, good luck. It will work, if configured properly. Supposedly SP2 of
> SQL RS added a feature to support SSL termination prior to the web server if
> the proper HTTP headers are passed. I was able to get Reports working, but
> not ReportServer. The information is available in the SP2 update
> documentation. Hope this helps.
> "Jose Ignacio Rodas" wrote:
> > Hi! I am working on some issues related to Reporting Services and SSL, I
> > wanted to know:
> >
> > - If I install a NLB cluster and I add "n" servers, how many SSL
> > Certificates will I need? 1 or "n"?
> >
> > - does anyone know if there are any issue related to MRS, SSL and the
> > Big-IP Load Balancer?
> >
> > Thank you very much in advance :-)
> >
> > Jose
> > --
> >
> >
> >
> > ------
> > Jose Ignacio Rodas, A+, CCEA, MCSE

Big picture question about Reporting Services

I am an beginner who has completed one report under RS. I'm wondering if my
memory is playing tricks on me. This report has been rather easy to do.
I've hardly had to look at the documentation. (I should point out that I'm
temporarily using the SQL Express version because Someone misplaced the disks
for the full version.)
My question is this: I was under the impression that Reporting Services
involved actual Dot Net programming. At least that was the impression I got
from the early demos I saw, but it has been a while. Is there more to RS
than just dragging fields on a designer?On May 15, 8:51 am, B. Chernick <BChern...@.discussions.microsoft.com>
wrote:
> I am an beginner who has completed one report under RS. I'm wondering if my
> memory is playing tricks on me. This report has been rather easy to do.
> I've hardly had to look at the documentation. (I should point out that I'm
> temporarily using the SQL Express version because Someone misplaced the disks
> for the full version.)
> My question is this: I was under the impression that Reporting Services
> involved actual Dot Net programming. At least that was the impression I got
> from the early demos I saw, but it has been a while. Is there more to RS
> than just dragging fields on a designer?
There does not have to be any actual programming, even though you are
in Visual Studio. Demos or classes may have examples where you could
code an assembly and then call it from the report.|||You can write expressions in reporting services using visual basic.
No .net programming is required to create reports.
However, because the report definiton files (RDL) are basically xml files
then the system is wide open for customisation.
For example, I have a SQL stored procedure that generates hundreds of
reports automatically for me.
Now that is real power.sql

Big performance problem with reports

Hello everyone!
I have major performance problems with reports that I have deployed in
Reporting Services.
I have an Sql database with millions of rows, and I have created a cube in
Analysis Services that is run against a view in the database.
My reports get data from the cube and the dataset is created with Sql syntax.
I need to filter the report and needed to create parameters, but only
prameters that give the option of choosing "all", i.e. being optional
parameters. The only way I can do that, as far as I know, is by creating the
filter parameter datasets in Sql Syntax. That is to be able to use union as
in
"select 'All'
union
select the real dataset
group by value" syntax. And it seems that I can't use union when running the
sql statement on a cube, so I have to run the statement on the original
database view.
Now the problem I have is that it takes about half an hour or more to view
the report, after choosing values in some filter parameters!
As far as I can see, the group by, is the statement that takes such a long
time. But that can't be the only problem.
So... does anyone know what I can do to reduce the time it takes to process
a report and what performance enhancements I can do?
I also have a problem with a specific report that gets a
System.OutOfMemoryException when I try to view it in the preview pane. But
when I run the dataset generating the report data, there are no problems.
Does anybody know what the problem might be?
I'm in a tight place and would appreciate any fast responses.
Thanks a lot,
TaraDo you have a stored procedure or is the sql code inside the RDL?
If you put as much as possible on the SQL Server, you can run it
through Query Analyzer and look at query plans etc. It does sound like
you are passing a lot more data around than you need, so get all the
SQL code out of the RDL and see where that gets you.

BI Web Intelligence

I am currently looking for a reporting solution for my company. I am tore
between RS and Crystal. We are primarily a MS shop with enterprise
licensing.
Business Objects (BO) has presented me with a really nice set of tools aside
from their reporting solution. Aside from reporting I would like to get
more involved with BI (dataming and cube analysis). At some point I would
like to have the end users browse the cube/universe data for quick adhoc
analysis.
BO presented me with really nice web intelligence software which is all
integrated with the BO product line. The products were: BO Web
Intelligence, BO Predictive Analysis, BO Set Analysis. These products seem
easy to use and the data can all be analyzed through the web once the
developer creates the middle layer.
I know MS has SSAS which contains the cube technology and data mining.
Do they offer a packaged product ready for enduser use similiar to BO?
Do you need to program your needs in the BI environment to develop what your
looking for?
Is there a way to get the SSAS cubes designed for end users to access
through the web/intranet?
Thanks.Basically you need to see what exactly you require. Both offer same things
but MS is cost effective solution and one stop solution. You also get
everything packged and moreover the SSRS comes free with Enterprise version
of SQL SERVER. So if you are planning for a small / mid size then this will
be ideal for you.
Amarnath
"Brian Shannon" wrote:
> I am currently looking for a reporting solution for my company. I am tore
> between RS and Crystal. We are primarily a MS shop with enterprise
> licensing.
> Business Objects (BO) has presented me with a really nice set of tools aside
> from their reporting solution. Aside from reporting I would like to get
> more involved with BI (dataming and cube analysis). At some point I would
> like to have the end users browse the cube/universe data for quick adhoc
> analysis.
> BO presented me with really nice web intelligence software which is all
> integrated with the BO product line. The products were: BO Web
> Intelligence, BO Predictive Analysis, BO Set Analysis. These products seem
> easy to use and the data can all be analyzed through the web once the
> developer creates the middle layer.
> I know MS has SSAS which contains the cube technology and data mining.
> Do they offer a packaged product ready for enduser use similiar to BO?
> Do you need to program your needs in the BI environment to develop what your
> looking for?
> Is there a way to get the SSAS cubes designed for end users to access
> through the web/intranet?
> Thanks.
>
>|||"Brian Shannon" <brian.shannon@.diamondjo.com> wrote in message
news:O2$FcrnDHHA.1220@.TK2MSFTNGP04.phx.gbl...
> BO presented me with really nice web intelligence software which is all
> integrated with the BO product line. The products were: BO Web
> Intelligence, BO Predictive Analysis, BO Set Analysis. These products
> seem easy to use and the data can all be analyzed through the web once the
> developer creates the middle layer.
> I know MS has SSAS which contains the cube technology and data mining.
> Do they offer a packaged product ready for enduser use similiar to BO?
> Do you need to program your needs in the BI environment to develop what
> your looking for?
Take a look at Microsoft Performance Point 2007, as it will help you do much
of what you're looking for.
http://office.microsoft.com/en-us/performancepoint/FX101680481033.aspx
Hope this helps.
Ted|||Hey, Brian
One of Microsoft's biggest ambitions is to be leading the Business
Intelligence (BI) arena. In 2007, they have announced the release of
several new products and integration with the Office suite (especially
Excel). I would really consider the Microsoft suite of BI offerings
that will be coming up in the next year. Like Ted said,
PerformancePoint will be a key product to get into BIPM, and will allow
users to view scorecard technology, data mining, cube analysis, etc.
They will be leveraging a lot of their BI offerings with Office and
SharePoint, in order to provide the end users access to data w/ tools
like Excel and their web browser (IE) which they're already familiar
with and comfortable using.
Since your company is a MS shop, and they already run SQL Server, the
license for Reporting Services is included, so you can have a pretty
good reporting engine up and running fairly quickly. Reporting
Services can connect to several data sources including OLTP and OLAP,
such as SQL Server DB, Analysis Services cubes, Oracle, XML web
services (RS 2005), and in the SP2 of SQL 2005, they will be adding
support for Hyperion. If you already have cubes setup in an Analysis
Services database, you can simply write the MDX (or use the MDX query
generator in RS 2005) for the report query, then design your report
layout, and the learning curve for Reporting Services is fairly
minimal.
I have seen a lot of companies that used Crystal reports as their main
reporting tool, move away from that and migrate all their reports to
Reporting Services because the licensing is much more cost effective --
it's included w/ their SQL Server license!
I would definitely recommend spending some time in the MS BI web site
to learn about their future offerings in that area.
(http://www.microsoft.com/bi)
Regards,
Thiago Silva, MCAD.NET
On Nov 22, 10:09 pm, "Ted Malone" <ted.nospam.mal...@.gmail.com> wrote:
> "Brian Shannon" <brian.shan...@.diamondjo.com> wrote in messagenews:O2$FcrnDHHA.1220@.TK2MSFTNGP04.phx.gbl...
> > BO presented me with really nice web intelligence software which is all
> > integrated with the BO product line. The products were: BO Web
> > Intelligence, BO Predictive Analysis, BO Set Analysis. These products
> > seem easy to use and the data can all be analyzed through the web once the
> > developer creates the middle layer.
> > I know MS has SSAS which contains the cube technology and data mining.
> > Do they offer a packaged product ready for enduser use similiar to BO?
> > Do you need to program your needs in the BI environment to develop what
> > your looking for?Take a look at Microsoft Performance Point 2007, as it will help you do much
> of what you're looking for.
> http://office.microsoft.com/en-us/performancepoint/FX101680481033.aspx
> Hope this helps.
> Ted

BI Development Studio not showing "create new project" on file menu

I just installed Reporting Services 2005 but when I start up SQL
Server Business Intelligence Development Studio I'm stuck. I don't
even have "create new project" as an option on my file menu, instead I
have "create team project" or "create file".
I previously had Visual Studio with Team Foundation Server on my
machine, but I only used it to log bugs. When I installed SS2005 and
reporting services I actually uninstalled the copy of Visual Studio I
had on my machine but that hasn't helped.
I don't want to create a teams project (and I don't haver permissions
anyway), I just want to use reporting services but it seems stuck in
some TFS mode. I'd take out the TFS part if I could figure out how
to.
Any ideas? Thanks in advance.Try to uninstall the TFS and reinstall visual studio 2005
Amarnath
"doug.andersen@.gmail.com" wrote:
> I just installed Reporting Services 2005 but when I start up SQL
> Server Business Intelligence Development Studio I'm stuck. I don't
> even have "create new project" as an option on my file menu, instead I
> have "create team project" or "create file".
> I previously had Visual Studio with Team Foundation Server on my
> machine, but I only used it to log bugs. When I installed SS2005 and
> reporting services I actually uninstalled the copy of Visual Studio I
> had on my machine but that hasn't helped.
> I don't want to create a teams project (and I don't haver permissions
> anyway), I just want to use reporting services but it seems stuck in
> some TFS mode. I'd take out the TFS part if I could figure out how
> to.
> Any ideas? Thanks in advance.
>

BI and Reporting Tools used with Reporting Services

What tools (companies) have you found to work well with your Data Warehouse,
easy to use by non-developers and also interface with MS Reporting Services?
JBH1
> What tools (companies) have you found to work well with your Data
> Warehouse,
> easy to use by non-developers and also interface with MS Reporting
> Services?
*sigh* i have a thread wondering this same thing. i can't find anything. And
getting information from the actual companies is like pulling teeth.
|||> What tools (companies) have you found to work well with your Data
> Warehouse,
> easy to use by non-developers and also interface with MS Reporting
> Services?
Oh, and btw, a guy sent me a link to a site where: if you're willing to pay,
he'll let you read his reviews of various data warehouse access tools.
That's how much of a secret this stuff is.
|||I have some links related to reporting services and 3rd party companies on
Reporting Services.
You might want to have a look at the SQL 2005 Report Builder as well.
Cizer.net has some nice tools too.
Links are provided on my website .
www.dandyman.net/sql
Dandy Weyn
[MCSE-MCSA-MCDBA-MCDST-MCT]
http://www.dandyman.net
Check my SQL Server Resource Pages at http://www.dandyman.net/sql
"Jeff H." <JeffH@.discussions.microsoft.com> wrote in message
news:E5BFF01A-13CF-494A-9D90-AED28D7EC64B@.microsoft.com...
> What tools (companies) have you found to work well with your Data
> Warehouse,
> easy to use by non-developers and also interface with MS Reporting
> Services?
> --
> JBH1
|||This is sort of a broad question.
How isl the data being accessed by the end users stored?
"Jeff H." <JeffH@.discussions.microsoft.com> wrote in message
news:E5BFF01A-13CF-494A-9D90-AED28D7EC64B@.microsoft.com...
> What tools (companies) have you found to work well with your Data
> Warehouse,
> easy to use by non-developers and also interface with MS Reporting
> Services?
> --
> JBH1
|||Ian,
I am not sure many of the major BI vendors are keen to work closely
with RS...after all MSFT has now announced it's intention of 'eating
their lunch'....remember how low key the first release of RS was? And
no MSFT is 'talking it up' as a real alternative to Crystal Reports now
owned by Business Objects.
I am certainly aware that Business Objects is training up staff to
compete with RS2005.
When an 800 pound gorilla like MSFT steps into the BI marketplace all
vendors are going to do whatever they can to maintain their
clients....
All those vendors (BO, COGN, MSTR etc) will all work with SQL Server
and position their tools as somehow 'better' than Report Services....
For the last 7-8 years people have talked about integration of the
development environment between vendors, usually via some form of
metadata hub (for example Ascentials MetaStage and the MetaData
Coalition etc.). However, this has been a pretty fruitless exercise.
The BI vendors are not interested in making it easier to share their
metadata with other BI vendors. Whoever owns 'what is presented on the
screen' owns the client and all of them are trying to protect their
position from MSFTs RS efforts.
Ufortunately IT shops and business users have remained subbornly
ignorant of the fact that 80% of the work is in database design and ETL
and 20% in the presentation layer...and people buy the presentation
layer and not the infrastructure/architecture. This make 'what is on
the screen' even more important to protect.
Best Regards
Peter Nolan
www.peternolan.com
|||What do you mean by interfacing with Reporting Services? Microsoft itself
provides some good BI front tend tools for 2005.
"Jeff H." <JeffH@.discussions.microsoft.com> wrote in message
news:E5BFF01A-13CF-494A-9D90-AED28D7EC64B@.microsoft.com...
> What tools (companies) have you found to work well with your Data
> Warehouse,
> easy to use by non-developers and also interface with MS Reporting
> Services?
> --
> JBH1
|||In a data warehouse. In fact tables, surrounded by dimension tables.
"Jesse O" <jesperzz@.hotmail.com> wrote in message
news:ee5Z7SYuFHA.596@.TK2MSFTNGP12.phx.gbl...
> This is sort of a broad question.
> How isl the data being accessed by the end users stored?
>
>
> "Jeff H." <JeffH@.discussions.microsoft.com> wrote in message
> news:E5BFF01A-13CF-494A-9D90-AED28D7EC64B@.microsoft.com...
>
|||Hi JT,
which ones? I have read zip about any good tools that integrate RS into
them...we are doing this work for ourselves...
We have been surprised there is no good browser front end for RS and
that the answer we have gotten back so far is that we must build one
for ourselves...?
Thanks
Peter Nolan
www.peternolan.com
|||Depending on what you are looking for. Cizer has an interesting
web-based report builder environment. My favorite though is
SoftArtisans OfficeWriter -
http://officewriter.softartisans.com...riter-250.aspx
Because RS has a pretty complete array of rendering mechanisms, there
hasn't been a real need (at least ont he dozen or so projects I have
worked on) for a 3rd party add-on.
If you want to be a bit more specific about what problems you are
having, that you are looking for a solution too, I'll see if I can find
something.
Steve Muise
neudesic LLC

BI and Reporting Tools used with Reporting Services

What tools (companies) have you found to work well with your Data Warehouse,
easy to use by non-developers and also interface with MS Reporting Services?
--
JBH1> What tools (companies) have you found to work well with your Data
> Warehouse,
> easy to use by non-developers and also interface with MS Reporting
> Services?
*sigh* i have a thread wondering this same thing. i can't find anything. And
getting information from the actual companies is like pulling teeth.|||> What tools (companies) have you found to work well with your Data
> Warehouse,
> easy to use by non-developers and also interface with MS Reporting
> Services?
Oh, and btw, a guy sent me a link to a site where: if you're willing to pay,
he'll let you read his reviews of various data warehouse access tools.
That's how much of a secret this stuff is.|||I have some links related to reporting services and 3rd party companies on
Reporting Services.
You might want to have a look at the SQL 2005 Report Builder as well.
Cizer.net has some nice tools too.
Links are provided on my website .
www.dandyman.net/sql
Dandy Weyn
[MCSE-MCSA-MCDBA-MCDST-MCT]
http://www.dandyman.net
Check my SQL Server Resource Pages at http://www.dandyman.net/sql
"Jeff H." <JeffH@.discussions.microsoft.com> wrote in message
news:E5BFF01A-13CF-494A-9D90-AED28D7EC64B@.microsoft.com...
> What tools (companies) have you found to work well with your Data
> Warehouse,
> easy to use by non-developers and also interface with MS Reporting
> Services?
> --
> JBH1|||This is sort of a broad question.
How isl the data being accessed by the end users stored?
"Jeff H." <JeffH@.discussions.microsoft.com> wrote in message
news:E5BFF01A-13CF-494A-9D90-AED28D7EC64B@.microsoft.com...
> What tools (companies) have you found to work well with your Data
> Warehouse,
> easy to use by non-developers and also interface with MS Reporting
> Services?
> --
> JBH1|||Ian,
I am not sure many of the major BI vendors are keen to work closely
with RS...after all MSFT has now announced it's intention of 'eating
their lunch'....remember how low key the first release of RS was? And
no MSFT is 'talking it up' as a real alternative to Crystal Reports now
owned by Business Objects.
I am certainly aware that Business Objects is training up staff to
compete with RS2005.
When an 800 pound gorilla like MSFT steps into the BI marketplace all
vendors are going to do whatever they can to maintain their
clients....
All those vendors (BO, COGN, MSTR etc) will all work with SQL Server
and position their tools as somehow 'better' than Report Services....
For the last 7-8 years people have talked about integration of the
development environment between vendors, usually via some form of
metadata hub (for example Ascentials MetaStage and the MetaData
Coalition etc.). However, this has been a pretty fruitless exercise.
The BI vendors are not interested in making it easier to share their
metadata with other BI vendors. Whoever owns 'what is presented on the
screen' owns the client and all of them are trying to protect their
position from MSFTs RS efforts.
Ufortunately IT shops and business users have remained subbornly
ignorant of the fact that 80% of the work is in database design and ETL
and 20% in the presentation layer...and people buy the presentation
layer and not the infrastructure/architecture. This make 'what is on
the screen' even more important to protect.
Best Regards
Peter Nolan
www.peternolan.com|||What do you mean by interfacing with Reporting Services? Microsoft itself
provides some good BI front tend tools for 2005.
"Jeff H." <JeffH@.discussions.microsoft.com> wrote in message
news:E5BFF01A-13CF-494A-9D90-AED28D7EC64B@.microsoft.com...
> What tools (companies) have you found to work well with your Data
> Warehouse,
> easy to use by non-developers and also interface with MS Reporting
> Services?
> --
> JBH1|||In a data warehouse. In fact tables, surrounded by dimension tables.
"Jesse O" <jesperzz@.hotmail.com> wrote in message
news:ee5Z7SYuFHA.596@.TK2MSFTNGP12.phx.gbl...
> This is sort of a broad question.
> How isl the data being accessed by the end users stored?
>
>
> "Jeff H." <JeffH@.discussions.microsoft.com> wrote in message
> news:E5BFF01A-13CF-494A-9D90-AED28D7EC64B@.microsoft.com...
>|||Hi JT,
which ones? I have read zip about any good tools that integrate RS into
them...we are doing this work for ourselves...
We have been surprised there is no good browser front end for RS and
that the answer we have gotten back so far is that we must build one
for ourselves...'
Thanks
Peter Nolan
www.peternolan.com|||Depending on what you are looking for. Cizer has an interesting
web-based report builder environment. My favorite though is
SoftArtisans OfficeWriter -
http://officewriter.softartisans.co...writer-250.aspx
Because RS has a pretty complete array of rendering mechanisms, there
hasn't been a real need (at least ont he dozen or so projects I have
worked on) for a 3rd party add-on.
If you want to be a bit more specific about what problems you are
having, that you are looking for a solution too, I'll see if I can find
something.
Steve Muise
neudesic LLC

Better MDX Query in 2005?

I've worked on several analysis services and reporting services solutions but this has me stumped. I have an X,Y scatter chart in RS that needs to hit a cube. So I need an MDX query that returns something like this:

DiseaseAbrev Pathway Feasibility
ADD 2.7 1.9
XS 4.0 1.0
YYY 1.4 2.0

The goal is to have two columns, Pathway and Feasibility, that contain a weighted measure that is calculated by summing a set of other measures times a weighting factor. The Disease Score Type dimension has a parent-child hierarchy set up so that Pathway and Feasibility are two members who roll up the weighted leaf members. When applied to the Score measure (see query below) this gives me what I want.

SELECT {[Disease Score Type].[Parent Id].&[2],[Disease Score Type].[Parent Id].&[1]} ON COLUMNS,
[Disease].[Disease Abbrev].[Disease Abbrev] ON ROWS
FROM [IVDB]
WHERE ([Measures].[Score], [Disease Selection].[Short List].&[Short List])

But, and this is a big problem, Reporting Services requires measures and ONLY measures in the first axis. So this does not work, which is really frustrating since this is really the most elegant way of modelling the problem domain. How can I write a better query that returns a Pathway and a Feasibility column containing weighted sums of the Score measure for just those two dimension members?

Can someone please help me?

There is nothing really wrong with your MDX, it is an unreasonable limitation of Reporting Services which has been raised by a few people, including fellow MVP Chris Webb here: http://cwebbbi.spaces.live.com/Blog/cns!1pi7ETChsJ1un_2s41jm9Iyg!163.entry

A work around is to create a an OLE DB datasource in RS2005 then choose the "Microsoft OLE DB Provider for Analysis Services 9.0" provider, you don't get the fancy designer and have to enter your MDX by hand, but you can structure your query any way you like.

|||

Thank you! The work around is fine for this report (and the dozen or so left to do...). I don't need the Query Builder in Reporting Services since I usually wind up writing the MDX directly to get what I want. And if I want a fancy designer the one in SQL Management Studio works very well. The only thing you really give up this way is direct support for parameters etc - but I can use the same tricks as the 'bad-old-days' of Analysis Services 2000 where you could fake parameters by using string functions to build the MDX!

It's just too bad that 2005 has a set of restrictions that make it's new features useless for anything but the most trivial MDX.

Thank you again!

Micah

|||

One way of working around the Analysis Services Provider limitation in this case is to use calculated measures, like:

With

Member [Measures].[PathwayScore] as

([Measures].[Score], [Disease Score Type].[Parent Id].&[2])

Member [Measures].[FeasibilityScore] as

([Measures].[Score], [Disease Score Type].[Parent Id].&[1])

SELECT {[Measures].[PathwayScore], [Measures].[FeasibilityScore]} ON COLUMNS,
[Disease].[Disease Abbrev].[Disease Abbrev] ON ROWS
FROM [IVDB]
WHERE ([Disease Selection].[Short List].&[Short List])

Better Charting capability

Has anyone heard as to whether Microsoft plans on updating the charting engine for Reporting Services? Right now I find the charting capability rather limited and would like to see richer charting capability. Is this a case where it is better to not wait for this feature as it will be way off into the future before this happens, or better charting features just are not in the scope of Microsoft's plans for Reporting Services. If either case is true then the best solution would be to purchase the full capabilities of Dundas Chart for Reporting Services.

if you can wait for the next releas(es) - microsoft acquired the data visualization products of dundas

read this article

http://blogs.msdn.com/bwelcker/archive/2007/06/04/dreamy-reporting-services-at-teched.aspx

regards

andreas

Best way to replicate large DB

I would like to replicate a large database to a reporting server on the same
network. I have very good bandwidth between the two servers
The DB in questio is ~200GB and has a transaction rate of ~3000 per minute.
There are 10 tables that are > 10 GB's.
Does anyone have any advice for me? or a document to review?
Thanks in advance!
Mark,
there are no articles specific to large volume replication that I am aware
of. There is an article on performance tuning and optimization
(http://www.microsoft.com/technet/pro.../tranrepl.mspx)
that should be of some help in your situation. Pull subscribers and a
separate distributor would probably be the first step. Teckie issues like
Raid 0+1, #procs, RAM and high bandwidth are not specific to replication,
but in your case the setup will probably prove crucial. These are also
partially covered in the article.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Best way to format a letter so that text can break across a page

I'm currently using SQL reporting services to produce letters. Most of the
formatting can be achieved however I'm having problems with page breaks.
I've currently set up the report using Text Boxes in the following format:
Name
Address
Salutation
Main Content
From
I need to ensure that the Main Content follows on directly from the
Salutation field. This works fine if the letter is 1 or 3 pages long.
However, in the case where the Main Content requires a few lines on page 2 it
places all the main content onto Page 2.
How can I ensure that the Main Content always follows directly on from the
Salutation? Is it possible to do this using a table instead of text boxes?
Any help would be greatly appreciated!I should have mentioned that the report is being produced in PDF format.
I read in a newsgroup article that PDF won't split a single row between 2
pages unless the row itself is longer than one page. Is this still the case
or is there a workaround? If this it true, then one solution might be to
bring back the main content text in sections although this isn't too
appealing!
"SV" wrote:
> I'm currently using SQL reporting services to produce letters. Most of the
> formatting can be achieved however I'm having problems with page breaks.
> I've currently set up the report using Text Boxes in the following format:
> Name
> Address
> Salutation
> Main Content
> From
> I need to ensure that the Main Content follows on directly from the
> Salutation field. This works fine if the letter is 1 or 3 pages long.
> However, in the case where the Main Content requires a few lines on page 2 it
> places all the main content onto Page 2.
> How can I ensure that the Main Content always follows directly on from the
> Salutation? Is it possible to do this using a table instead of text boxes?
> Any help would be greatly appreciated!

Best way to do this

Hi Group,

I need to incoporate reporting services into my ASP.NET application.

Should I:

1. Use the ReportViewer control to map to my Server or

2. Add a reference to the web service?

Which is the 'best' option?

What are advantages, disadvantages, drawbacks of either one?

Thanks!!

Hi,

Check this link out to help you decide which one better to use.

http://www.devx.com/dotnet/Article/30424/1763.

Hth,

Michael Castillones

best way to delete the reporting services jobs in sqlserver

I have six thousand reporting services jobs in sqlserver, which were
scheduled to run only once and their execution date is older than a month.
how do I know which of the jobs are useful out of these 6000.
Can I write a job, to purge the reporting services jobs older than a month
and schedule it to run every week, basically how do I manage these ever
growing jobs ?
Thanks in advance..GAis it okay to delete the subscriptions like below '
delete from reportserver..subscriptions
WHERE ModifiedDate < dateadd(day, -7, getdate()) AND Description LIKE 'SRS%'
TIA
"DallasBlue" wrote:
> I have six thousand reporting services jobs in sqlserver, which were
> scheduled to run only once and their execution date is older than a month.
> how do I know which of the jobs are useful out of these 6000.
> Can I write a job, to purge the reporting services jobs older than a month
> and schedule it to run every week, basically how do I manage these ever
> growing jobs ?
>
> Thanks in advance..GA
>|||I have deleted subscriptions using this method. There are cascading deletes
when to remove the related records in ReportSchedule and Schedule tables.
Though, bulk deleting a lot of subscriptions at the same time might not work
with that statement. I know for me I've gotten timeouts when trying a direct
delete. So instead, I create a memory table (DECLARE @.x TABLE...) and put in
all the SubscriptionID for the ones I want to delete. Then I delete from the
Subscription table using a join to the memory table. I know it might seem
strange to do it that way, but because of the way the tables are indexed, it
works.
Once you the records are deleted from the tables, the Reporting Service will
automatically delete the actual SQL Agent jobs when it does its maintenance,
I'm not sure of the frequency that it does that, but at minimum its once a
day.
Carmine
"DallasBlue" wrote:
> is it okay to delete the subscriptions like below '
> delete from reportserver..subscriptions
> WHERE ModifiedDate < dateadd(day, -7, getdate()) AND Description LIKE 'SRS%'
> TIA
> "DallasBlue" wrote:
> > I have six thousand reporting services jobs in sqlserver, which were
> > scheduled to run only once and their execution date is older than a month.
> > how do I know which of the jobs are useful out of these 6000.
> > Can I write a job, to purge the reporting services jobs older than a month
> > and schedule it to run every week, basically how do I manage these ever
> > growing jobs ?
> >
> >
> > Thanks in advance..GA
> >
> >