Ad-hoc reporting

We have a web application using SQL Server 2000, and we'd like to add ad-hoc
reporting. Here are the options we thought of so far:
1. Use SQL Server 2000 Reporting Services - but we're not sure how "ad-hoc"
we can get using SSRS. Has anyone tried?
2. Use a 3rd party reporting software package. Does anyone know of any?
3. Build a custom .NET ad-hoc app that is fine tuned for this application.
This is likely the most costly.
The goal is to have the users build and save report templates, and the be
able to select any combination of fields in the relational schema to include
in the reports, and select on any fields as well.
Does anyone have any other suggestions?
Thank you!!My suggestion is to investigate Report Builder which comes with RS 2005. It
is an ad hoc reporting solution that came out with RS 2005. This is
non-trivial to create on your own and from a cost perspective you will be
better off paying for the upgrade. Plus RS 2005 is much faster for Excel and
PDF output, has multi-select parameters, end user sorting and date picker.
Note that as long as you pay the license you can upgrade just RS and leave
your database at 2000.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dean J Garrett" <info@.amuletc.com> wrote in message
news:uUTBa8qrHHA.5028@.TK2MSFTNGP05.phx.gbl...
> We have a web application using SQL Server 2000, and we'd like to add
> ad-hoc
> reporting. Here are the options we thought of so far:
> 1. Use SQL Server 2000 Reporting Services - but we're not sure how
> "ad-hoc"
> we can get using SSRS. Has anyone tried?
> 2. Use a 3rd party reporting software package. Does anyone know of any?
> 3. Build a custom .NET ad-hoc app that is fine tuned for this application.
> This is likely the most costly.
> The goal is to have the users build and save report templates, and the be
> able to select any combination of fields in the relational schema to
> include
> in the reports, and select on any fields as well.
> Does anyone have any other suggestions?
> Thank you!!
>

Ad-hoc reporting

Is the ad-hoc reporting available for SQL Server 2005 reporting
services a web based environment or is it an application that has to be
installed?
Thanks
Robertits a clickonce application.
this required that the user have the .Net Framework 2.0 installed locally.
then the reportbuilder application is downloaded automatically without any
install process.
but its not a webbased application. its a client/server application which
use webservices calls to the server to execute andrender queries.
"rhoenig" <rhoenig@.charter.net> wrote in message
news:1158956048.392781.78140@.m7g2000cwm.googlegroups.com...
> Is the ad-hoc reporting available for SQL Server 2005 reporting
> services a web based environment or is it an application that has to be
> installed?
> Thanks
> Robert
>

Adding Viewer Controls to WinForms or Web project

With the release of the feature pack for SQL 2005 and the included Datamining Viewer Controls I was wondering three things. 1) How do you add these controls to your toolbox and 2) Are these controls installed with VS 2005 or SQL 2005 and these are just the redistributable versions for systems where VS 2005 and SQL 2005 are not installed? 3) Is there a description of the controls and what each one does?1) How do you add these controls to your toolbox

In the Winform designer, right click on the Toolbox and select 'Choose Items...' menu item. Hit the Brows button and select file 'Microsoft.AnalysisServices.Viewers.dll'. Hit the OK button to add all the viewer controls to your toolbox.

2) Are these controls installed with VS 2005 or SQL 2005 and these are just the redistributable versions for systems where VS 2005 and SQL 2005 are not installed?

The view controls are shipped with SQL 2005 as well as in its separate redistributable available for download.

3) Is there a description of the controls and what each one does?
You can find description of each individual viewer control in SQL Books online.

Adding new web.config custom section

Hello All,
I want to add custom cofiguration section to the report server web.config
and use this configuration from the RDL, can it be done? and if the answer is
yes, how it can be done.
Thank youOn Oct 7, 1:21 pm, Shlomi <Shl...@.discussions.microsoft.com> wrote:
> Hello All,
> I want to add custom cofiguration section to the report server web.config
> and use this configuration from the RDL, can it be done? and if the answer is
> yes, how it can be done.
> Thank you
You might be able to reference the Web config file from custom code in
the report (via: Layout view >> Report drop-down >> Report
Properties... >> Code tab). You might be able to reference it via a
call to Configurations.AppSettings(...). Of course this is a long
shot. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||thank you,
i will be thankful if you can give me an example f custom configuration
section for the web.config
"EMartinez" wrote:
> On Oct 7, 1:21 pm, Shlomi <Shl...@.discussions.microsoft.com> wrote:
> > Hello All,
> >
> > I want to add custom cofiguration section to the report server web.config
> > and use this configuration from the RDL, can it be done? and if the answer is
> > yes, how it can be done.
> >
> > Thank you
>
> You might be able to reference the Web config file from custom code in
> the report (via: Layout view >> Report drop-down >> Report
> Properties... >> Code tab). You might be able to reference it via a
> call to Configurations.AppSettings(...). Of course this is a long
> shot. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>

adding data entered in to web textbox to rdlc report

I have a report services report that I created in local mode that takes data from a dataset and creates a report off of it. I need to add a field into the report that shows some of the data that the user enters in to the textboxes on the web page. Can someone explain to me how to do this or point me to a resource that will show me. Thanks!!

Pass the textbox data as parameters to your report. This entails simply loading the textbox(es) data into a parameter array & passing it to your report. Cheers!

adding an enddate to a subscription

Hi,
I use web services to register a datadriven subscription. When i use this
piece for my scheduledefinition, it works like a charm :
<ScheduleDefinition><StartDateTime>2005-10-14T15:15:00</StartDateTime>" &
"<MonthlyRecurrence><Days>14</Days><MonthsOfYear>" &
"<January>False</January><February>False</February><March>False</March>" &
"<April>False</April><May>False</May><June>False</June><July>False</July>" &
"<August>False</August><September>False</September><October>True</October>" &
"<November>False</November><December>False</December></MonthsOfYear></MonthlyRecurrence></ScheduleDefinition>
BUT,
when I add an <EndDate> element (right after the StartDateTime-element), the
subscription is still created, but my begin AND endtime are unknown.. anyone
an idea why this happens (and only when i add the enddate element) ?
Thx!Make sure you have SP2 installed and also there should be an EndDateSpecified
element that should be set to True when using the EndDate element.
HTH
Dave
"Koen" wrote:
> Hi,
> I use web services to register a datadriven subscription. When i use this
> piece for my scheduledefinition, it works like a charm :
> <ScheduleDefinition><StartDateTime>2005-10-14T15:15:00</StartDateTime>" &
> "<MonthlyRecurrence><Days>14</Days><MonthsOfYear>" &
> "<January>False</January><February>False</February><March>False</March>" &
> "<April>False</April><May>False</May><June>False</June><July>False</July>" &
> "<August>False</August><September>False</September><October>True</October>" &
> "<November>False</November><December>False</December></MonthsOfYear></MonthlyRecurrence></ScheduleDefinition>
> BUT,
> when I add an <EndDate> element (right after the StartDateTime-element), the
> subscription is still created, but my begin AND endtime are unknown.. anyone
> an idea why this happens (and only when i add the enddate element) ?
> Thx!|||hi Dave,
thx for your reply. Where in the xml statement should i place the
EndDateSpecified ? Case when i add the element
<EndDateSpecified>True</EndDateSpecified> it says that it's not correct
accoring the xml syntax ?
Thanks
"Dave" wrote:
> Make sure you have SP2 installed and also there should be an EndDateSpecified
> element that should be set to True when using the EndDate element.
> HTH
> Dave
> "Koen" wrote:
> > Hi,
> >
> > I use web services to register a datadriven subscription. When i use this
> > piece for my scheduledefinition, it works like a charm :
> >
> > <ScheduleDefinition><StartDateTime>2005-10-14T15:15:00</StartDateTime>" &
> > "<MonthlyRecurrence><Days>14</Days><MonthsOfYear>" &
> > "<January>False</January><February>False</February><March>False</March>" &
> > "<April>False</April><May>False</May><June>False</June><July>False</July>" &
> > "<August>False</August><September>False</September><October>True</October>" &
> > "<November>False</November><December>False</December></MonthsOfYear></MonthlyRecurrence></ScheduleDefinition>
> >
> > BUT,
> >
> > when I add an <EndDate> element (right after the StartDateTime-element), the
> > subscription is still created, but my begin AND endtime are unknown.. anyone
> > an idea why this happens (and only when i add the enddate element) ?
> >
> > Thx!|||The EnddateSpecified is a property of the ScheduleDefinition so I would try:
<ScheduleDefinition>
<StartDateTime>2005-10-14T15:15:00</StartDateTime>
<MonthlyRecurrence> ... </MonthlyRecurrence>
<EndDate>2005-10-15</EndDate>
<EndDateSpecified>True</EndDateSpecified>
</ScheduleDefinition>
Note I have never tried using the EndDate so this *should* work but ... If
it doesn't work you could
create the ScheduleDefinition in code and then try using the XML serializer
to serialize the ScheduleDefinition object. Again
I have never done this but did come across this tip in one of the help files.
I have also heard that there are problems with EndDates esp. if you include
a time. You may want to search MS and other places for any topics on using
EndDates.
Regards
Dave
"Koen" wrote:
> hi Dave,
> thx for your reply. Where in the xml statement should i place the
> EndDateSpecified ? Case when i add the element
> <EndDateSpecified>True</EndDateSpecified> it says that it's not correct
> accoring the xml syntax ?
> Thanks
> "Dave" wrote:
> > Make sure you have SP2 installed and also there should be an EndDateSpecified
> > element that should be set to True when using the EndDate element.
> >
> > HTH
> >
> > Dave
> >
> > "Koen" wrote:
> >
> > > Hi,
> > >
> > > I use web services to register a datadriven subscription. When i use this
> > > piece for my scheduledefinition, it works like a charm :
> > >
> > > <ScheduleDefinition><StartDateTime>2005-10-14T15:15:00</StartDateTime>" &
> > > "<MonthlyRecurrence><Days>14</Days><MonthsOfYear>" &
> > > "<January>False</January><February>False</February><March>False</March>" &
> > > "<April>False</April><May>False</May><June>False</June><July>False</July>" &
> > > "<August>False</August><September>False</September><October>True</October>" &
> > > "<November>False</November><December>False</December></MonthsOfYear></MonthlyRecurrence></ScheduleDefinition>
> > >
> > > BUT,
> > >
> > > when I add an <EndDate> element (right after the StartDateTime-element), the
> > > subscription is still created, but my begin AND endtime are unknown.. anyone
> > > an idea why this happens (and only when i add the enddate element) ?
> > >
> > > Thx!

Adding a Web Server to RS 2000

I currently have my report server and my reporting services database on two
different machines. My company is now wanting to add another machine on the
web server/service side. Can anyone refer me to a good article on how
exactly to do this without killing my first machine and database?
Thanks
ScottHello Scott,
This scenario is called Enterprise Deployment Model in Reporting Services
2000.
You could add the addtional server to the existing server farm.
Please follow this article:
Installing a Report Server Web Farm
http://msdn2.microsoft.com/en-us/library/aa179321(SQL.80).aspx
Hope this will be helpful!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Looks like it was what I needed. I'll let you know if I need anything else.
Thanks
Scott
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:GXiC0$CGHHA.2204@.TK2MSFTNGHUB02.phx.gbl...
> Hello Scott,
> This scenario is called Enterprise Deployment Model in Reporting Services
> 2000.
> You could add the addtional server to the existing server farm.
> Please follow this article:
> Installing a Report Server Web Farm
> http://msdn2.microsoft.com/en-us/library/aa179321(SQL.80).aspx
> Hope this will be helpful!
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>

Adding a web reference to a Report Server project

Hi there,

My company has a centralised user profile repository that all new applications worldwide use for authorization and user details; we access it from the various apps via a web service.

What I'd like to do in a report is to pass a user's ID to the web service and return their name and contact details to display in the header. I imagine I'd need to do this in a custom function and I can see where I can add a reference to use in this function but not where to add a web reference. Is this possible?

Regards,

Uzum4k1i.

One possible solution to the issue is to add custom code to the report: custom code (e.g., a C# library project in which a web reference could be added) calls the web service and exposes the web service call result for the report to reference. the assembly containing custom code needs to be deployed on the report server. More details are available here:

http://msdn2.microsoft.com/en-us/library/ms252130.aspx

Another possible option is to configure the web service as an XML data source in which the web service URL is the connection string. Details here:

http://msdn2.microsoft.com/en-us/library/ms159741.aspx

http://msdn2.microsoft.com/en-us/library/ms345338.aspx

|||Cheers Tau Liang, both of those answers sound like they'll fit the bill nicely

Adding a web reference to a Report Server project

Hi there,

My company has a centralised user profile repository that all new applications worldwide use for authorization and user details; we access it from the various apps via a web service.

What I'd like to do in a report is to pass a user's ID to the web service and return their name and contact details to display in the header. I imagine I'd need to do this in a custom function and I can see where I can add a reference to use in this function but not where to add a web reference. Is this possible?

Regards,

Uzum4k1i.

One possible solution to the issue is to add custom code to the report: custom code (e.g., a C# library project in which a web reference could be added) calls the web service and exposes the web service call result for the report to reference. the assembly containing custom code needs to be deployed on the report server. More details are available here:

http://msdn2.microsoft.com/en-us/library/ms252130.aspx

Another possible option is to configure the web service as an XML data source in which the web service URL is the connection string. Details here:

http://msdn2.microsoft.com/en-us/library/ms159741.aspx

http://msdn2.microsoft.com/en-us/library/ms345338.aspx

|||Cheers Tau Liang, both of those answers sound like they'll fit the bill nicely

Adding a web reference (web service) to an SSIS script task?

Is it possible to do this under SSIS 2005? How? I see I can add a reference to system.web.services.dll.. but then what?

The web service was developed in vb.net/vs.net 2005 and I have no problem adding and consuming it from a web page developed using vs.net 2005 - asp.net/vb.net.

Thanks for any help or information.

VSA won't allow you set a web reference. You can compile the proxy created by Visual Studio and reference that.
|||

Jay is absolutely correct. Script Task uses VSA as its dotnet editor and that does not support web references.

Although it doesn't help you much now...the functionality you are after will be in katmai. In the meantime, do what Jay suggested.

-Jamie