Extra columns in Excel with SP2

I would like to upgrade to Reporting Services service pack 2 so that I can
specify report colours and specify to move the header into Excel's header.
However when we upgrade to Service Pack 2 it causes extra totals columns to
appear at the end of the months in the generated reports. These columns
could possibly acceptable if they were titled as Total however they are not.
Can anybody make any suggestions in how to generate the report in excel
without the additional columns appearing in the excel output? Many thanks.Does anybody have any ideas about how to do this - any guesses even would be
appreciated. Thanks
"Nicola Jones" wrote:
> I would like to upgrade to Reporting Services service pack 2 so that I can
> specify report colours and specify to move the header into Excel's header.
> However when we upgrade to Service Pack 2 it causes extra totals columns to
> appear at the end of the months in the generated reports. These columns
> could possibly acceptable if they were titled as Total however they are not.
> Can anybody make any suggestions in how to generate the report in excel
> without the additional columns appearing in the excel output? Many thanks.

External web service as datasource for Reporting Service report

Hello,
I would like to make some Reporting Services reports from a datasource
that is a web service. Is this possible? I am using SSRS 2005. Any
suggestions or directions would be greatly appreciated.
photogulliverIt is possible but I haven't done it. Read up in Books On Line on XML.
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/d23408e5-e65b-4f49-a98f-234454d5d267.htm
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<ehausig@.yahoo.com> wrote in message
news:1141931933.379723.119120@.e56g2000cwe.googlegroups.com...
> Hello,
> I would like to make some Reporting Services reports from a datasource
> that is a web service. Is this possible? I am using SSRS 2005. Any
> suggestions or directions would be greatly appreciated.
> photogulliver
>|||Yes. it is possible.
however, there are serious limitations on this approach. see other
postings in this group by me and Teo's responses to my postings.
1. the XML returned by the web service may not be readily consumable by
SSRS.
2. the query syntax to consume the XML is xpath like, but it is neither
xpath not xquery
3. security is a big concern. webservices consumption is non-secure
however, you can write your own custom data processing extension which
can overcome the above limitations.
thanks
- jasthi|||Ok, thanks for the feedback!
Eric

External image problem when sorting in table

Reporting Services I am using external image png as my header for reports When i am clicking on sort row of the report the header image is dissapeared.Though it is working well in Visual Studio 2005 the problem is occuring after deploying it in reportserver.

What the reason and how can i remove this error.It was working well when i had embeded the image..But i need to have external image only..

Did you install SP1 on the report server (http://www.microsoft.com/sql/sp1.mspx)?

-- Robert

External Activation and Receive Timeout

I have a set of service broker services setup that rely on external activation to process messages. I'm using the GotDotNet ExternalActivator, and it launches console applications that do the actual retrieval from the queues. The console applications are written to run continuously to avoid the cost of starting up .NET based console apps over and over again.

I am observing very odd timing behavior. With the receive queues empty and the external activator configured to run a minimum and maximum of 5 instances, I observe in SQL Profiler that most of the receive operations finish in about the same amount of time as my WAITFOR command in my receive stored procedure. However, there is usually one receive command that consistently takes upwards of 30 seconds and often causes sql timeout exceptions to be thrown. I know that I could code around this, but I wasn't really expecting this behavior.

Does anyone have any thoughts on why it might be occurring? I would have expected to routinely see my receive operations taking 15 seconds, give or take, especially when the queue is empty. Also, I have observed this behaviour on both SQL 2k5 Express and Dev Editions, so I don't think it's a version thing.

The stored procedure I am using to do the receive is:

Create PROCEDURE [dbo].[P_RTD_MessageBase_Receive]

@.receiving_queue_name varchar(255),

@.receiving_time_out int

AS

Declare @.receiveQuery nvarchar(300)

Set @.receiveQuery = 'WAITFOR(RECEIVE * FROM [dbo].['+ @.receiving_queue_name +']),

TIMEOUT ' + cast (@.receiving_time_out as varchar)

Execute sp_executeSql @.receiveQuery

Using SQL profiler can you find out if the actual command being executed has the correct timeout?

Some questions to help me understand why you made some design decisions:

1. Why do the apps run forever instead of shutting down after a long period of inactivity? Sure I understand you don't want yout .NET programs being launched and torn down over and over but you could use a longer timeout to avoid this. (Also, you should probably ngen your assemblies to improve startup time).

2. Why are you setting minimum instances to 5? Most people want minimum to be 0 so that there are no instances running when the queue is empty. Do all instances execute the same code path or are you doing something special here?

|||

I have confirmed that the actual command that seems to take much longer than the timeout has the correct timeout. IOW, I issue a receive with a 15000 ms timeout, and it takes about 28000 ms even though the queue is completely empty. The other four receives seems to finish and around 15000 ms consistently.

I don't have a great reason for the apps to run forever, except to avoid startup time. I could implement a longer timeout, but I am seeking to minimize the amount of time it takes to process a single message. The nature of the system is that messages drip in during some periods of the day, and I don't really want those messages to have to wait any longer than when messages are regularly coming in. nGen could help, but I still think my approach is the fastest.

I was setting the minimum instances to 5 in order to test the apps to make sure they weren't leaking any memory and that they did indeed run indefinitely.

How might these three issues affect the timeout?

|||

Is it possible for you to capture the trace using SQL Profiler with all Broker events as well as the following events enabled?

- RPC:Starting
- RPC:Completed
- SP:StmtStarting
- SP:StmtCompleted
- SP:Starting
- SP:Completed
- SQL:StmtStarting
- SQL:StmtCompleted
- SQL:BatchStarting
- SQL:BatchCompleted

You could e-mail that to rushi (dot) desai (at) microsoft (dot) com.

My questions were unrelated to the problem you are facing. I was intrigued by the atypical setup and so I was curious why you were using this setup.

Thanks,

Rushi

|||Hey Rushi - I just sent the trace file to you...|||

Rushi has come back to me and said that this is a bug. I have posted a bug report at:

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=234866

External Activation and Notification Services

I have been going over the samples from PDC 2005 and trying to run the External Activator program in section 2 'CLR Services'. After sending a message to the Inventory Queue, I see that 'dm_broker_queue_monitors' table has a row in the table, with the state column shown as 'NOTIFIED', but the ExternalActivator program never gets notified of the event and therefore never launches the 'InventoryServer' program.

Querying the [ExternalActivatorQueue] shows no rows.

Querying the [Inventory Queue] shows messages are waiting to be received.

Executing the 'activator' command in the ExternalActviator program shows

Notification service 'ExternalActivator' on SQL Server 'DBSERVER\' and Database 'In
ventory' is connected to the database and working.

Any Ideas?

Thanks,

-KuoAfter some browsing through code in the samples, I figured out the problem. The queue thats suppose to contain all the notification messages for the ExternalActivator program was checking the correct queue for messages, however no messages were being created in the [ExternalActivatorQueue] whenever a new message was sent to the [Inventory Queue].
So I, dDropped the event, 'en', and reran the create event notifcation:

drop event notification en on queue [Inventory Queue]

create event notification en
on queue [Inventory Queue]
for queue_activation
to service 'ExternalActivator', 'current database';

sent a few more messages and the ExternalActivatorQueue started getting messages in the queue whenever a new message was sent to the [Inventory Queue].

This is really strange. I know I must of ran the create event notification command a few times. Oh well, it works now.

-Mr.Kuo

Extending the number of rows returned per page in RS

Is there a way to extend the number of rows that will be returned so that Reporting services doesn't display such a large number of pages for the users to page through? It would be easier for them to "wheel mouse" through a long page on the screen.

Anyone out there have any thoughts on how this might be accomplished?

Thanks!

Travis

Here are a couple of options:

- set PageBreakAtEnd and PageBreakAtStart to false on your tables/matrices/grouping panels

- make your row heights smaller, use a smaller font

- filter your data better, or group it into smaller groups and have each group rendered into its own table, turn off paging on those tables

But turning off paging looks okay when viewing the report in the browser, but can make the report look like *** when exported to PDF.

Extending Delievery Extensions in SQL Reporting Services

Hi All

We have requirement in Reports. When ever report is sent to file share using Reporting Services File Share extension than details of that file should be saved in database.

How can we achieve this functionality? What is the best possible way of achieving this?

Please let me know the solution.

Thanks in advance

Rehan Mustafa Khan
HCL Technologies
Noida,IndiaYou can to implement a windows service application.
This application will use the FileSystemWatcher class
present in the .NET Framework.

The application can be written to keep watch over the
directory into which the Reports will be saved. As soon
as a notification is received by the application it will query
the file attributes and save these attributes into the database
by using ADO.NET

Subrahmanya Raju
ProgressiveXperts Infolabs I (Pvt) Ltd
Hyderabadsql

Extended Stored Procedure Problem

I am using the Open Data Services to program an extended stored procedure.
The extended stored procedure is called from a table trigger. The problem I
am having is the call to srv_paramlen(...) returns 30 for a varchar(255)
variable even when the data is longer than 30. Therefore when I retrieve the
data as follows,
memcpy(pszColumnValue, srv_paramdata(srvproc, iIndex), len);
the data is truncated to 30 when the actual data stored in the DB is longer
than 30. Thanks very much for any help in solving this problem.
Charles...See SQL Server Books Online and you will find that srv_paramlen should no
longer be used and you should use srv_paraminfo instead
http://msdn.microsoft.com/library/d.../>
06_2rhq.asp
Important This Open Data Services function or macro is only supported in
Microsoft SQL ServerT 2000 for backward compatibility. It has been
superseded by the srv_paraminfo function.
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright SQLDev.Net 1991-2005 All rights reserved.
"Charles Parker" <charles.parker@.whamtect.com> wrote in message
news:e01GoHtCFHA.1432@.tk2msftngp13.phx.gbl...
>I am using the Open Data Services to program an extended stored procedure.
> The extended stored procedure is called from a table trigger. The problem
> I
> am having is the call to srv_paramlen(...) returns 30 for a varchar(255)
> variable even when the data is longer than 30. Therefore when I retrieve
> the
> data as follows,
> memcpy(pszColumnValue, srv_paramdata(srvproc, iIndex), len);
> the data is truncated to 30 when the actual data stored in the DB is
> longer
> than 30. Thanks very much for any help in solving this problem.
> Charles...
>

Extended Stored Procedure API not in new Platform SDK

Does anyone know why the Extended Stored Procedure API (formerly Open Data Services) headers and libraries (e.g. srv.h, srvdbtyp.h, opends60.lib) are not in the new Platform SDK?
Older versions of the Platform SDK had these tools included, but I installed the new Platform SDK and they're not included. Is there another SDK that I need to download and install now?Those headers don't work with Visual C++ .NET, they only work with 6.0 (some versions also work with 5.0). I can't see any point in even trying to compile that code in the same context as the newer API stuff.

-PatP|||We're still using the 6.0 compiler, not .NET (i.e. 7.x). What is the newer API stuff your referring to? Has the Extended Stored Procedure API been replaced by something else?

Expressions in RS

How do I add comments to expressions I create in Reporting Services?

Hello,

To add comments, prefix the line with a single quote (').

For example:

=Iif(Fields!Amount.Value < "1", "Red", "Black")

'Change color to red if below 1.

Hope this helps.

Jarret

|||Thanks, Jarret. I had forgotten that the expression must always be first. I had been trying to add the comment above the expression. I'm too silly

Expressions and other code?

Is there any way to write C# code in SQL Server Reporting Services?

yes, more details could be found here:

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

Expression switch facility

Hello, I would ask about the possibility of implementing a switch algorithm via expressions in Reporting services to . For example, Can I test on the dataset field a

if a= null -->display none

if a= 1 -->display "string1"

if a= 2 -->display "string2"

some help about this topic

thanks in advance

= Switch(Fields!a.Value = 1, "string1", Fields!a.Value = 2, "string2", Not(Fields!a.Value), "", true, "else string here")

Expression for calculating the different between two dates

i am currently doing a system where user can submit their suggestions to us
and part of my system is using Reporting Services and i need some guide on my
problem.
When user submit their suggestions, the date of submission will be auto
input into SQL Server database and if the suggestions is being evaluated by a
evaluator, the date of evaluation will also be input into the SQL Server
database and all this part i had done it all in aspx.
So now when user want to view their suggestions, they will go to a page
which i had generate using Reporting Services. In this page, there is a
column call Turnaround Time(the datediff from the day of submission to now
till the suggestions is being evaluated). That means In this column i wan to
display the datediff from the date of submission till the date today if it
still had not been evaluated(that means the SQL Server database that contains
the field "Date of Evaluation" is still null). And if the suggestions had
been evaluated(that means the SQL Server database that contains the field
"Date of Evaluation" contains a date value now), it will display the datediff
from the date of submission to the date of evaluation.
For now i can only display the datediff from the date of submission to now
using the following expression : =DateDiff(DateInterval.Day,
Fields!DateSubmitted.Value, Now()) and thus i need help on how to display the
datediff from the date of submission to now if the suggestions had not been
evaluated and display the datediff from the date of submission to the date of
evaluation if the suggestions had been evaluated.
I appreciate for the help and guide. ThanksYou can try this :
IIF(Fields!EvaluationDate.Value Is Nothing , Now()-Fields!
SubmissionDate.Value,Fields!EvaluationDate.Value-Fields!
SubmissionDate.Value)
>--Original Message--
>i am currently doing a system where user can submit their
suggestions to us
>and part of my system is using Reporting Services and i
need some guide on my
>problem.
>When user submit their suggestions, the date of
submission will be auto
>input into SQL Server database and if the suggestions is
being evaluated by a
>evaluator, the date of evaluation will also be input into
the SQL Server
>database and all this part i had done it all in aspx.
>So now when user want to view their suggestions, they
will go to a page
>which i had generate using Reporting Services. In this
page, there is a
>column call Turnaround Time(the datediff from the day of
submission to now
>till the suggestions is being evaluated). That means In
this column i wan to
>display the datediff from the date of submission till the
date today if it
>still had not been evaluated(that means the SQL Server
database that contains
>the field "Date of Evaluation" is still null). And if the
suggestions had
>been evaluated(that means the SQL Server database that
contains the field
>"Date of Evaluation" contains a date value now), it will
display the datediff
>from the date of submission to the date of evaluation.
>For now i can only display the datediff from the date of
submission to now
>using the following expression : =DateDiff
(DateInterval.Day,
>Fields!DateSubmitted.Value, Now()) and thus i need help
on how to display the
>datediff from the date of submission to now if the
suggestions had not been
>evaluated and display the datediff from the date of
submission to the date of
>evaluation if the suggestions had been evaluated.
>I appreciate for the help and guide. Thanks
>.
>|||you can directly get the Turnaround Time from database.
In your query get this column...
DateDiff(Day,Table.DateSubmitted,IsNull(Table.DateEvaluated,GetDate())) as
TurnaroundTime
and use Fields!TurnaroundTime.Value in your report.
hth
"JiaN" <JiaN@.discussions.microsoft.com> wrote in message
news:37BA72F4-FCF1-4659-ACA3-9366AE53A518@.microsoft.com...
>i am currently doing a system where user can submit their suggestions to us
> and part of my system is using Reporting Services and i need some guide on
> my
> problem.
> When user submit their suggestions, the date of submission will be auto
> input into SQL Server database and if the suggestions is being evaluated
> by a
> evaluator, the date of evaluation will also be input into the SQL Server
> database and all this part i had done it all in aspx.
> So now when user want to view their suggestions, they will go to a page
> which i had generate using Reporting Services. In this page, there is a
> column call Turnaround Time(the datediff from the day of submission to now
> till the suggestions is being evaluated). That means In this column i wan
> to
> display the datediff from the date of submission till the date today if it
> still had not been evaluated(that means the SQL Server database that
> contains
> the field "Date of Evaluation" is still null). And if the suggestions had
> been evaluated(that means the SQL Server database that contains the field
> "Date of Evaluation" contains a date value now), it will display the
> datediff
> from the date of submission to the date of evaluation.
> For now i can only display the datediff from the date of submission to now
> using the following expression : =DateDiff(DateInterval.Day,
> Fields!DateSubmitted.Value, Now()) and thus i need help on how to display
> the
> datediff from the date of submission to now if the suggestions had not
> been
> evaluated and display the datediff from the date of submission to the date
> of
> evaluation if the suggestions had been evaluated.
> I appreciate for the help and guide. Thanks|||ok thanks for your help ravi but my datatype for EvaluationDate and
SubmissionDate is Date/Time and it shows a error when i preview using the
expression you had given me.
The error is : "The value expression for the textbox 'Turnaround Time'
contains and error: [BC30452] Operator '-' is not defined for types 'Date'
and Microsoft.ReportingServices.ReportProcessing.ReportObjectModel.Fields"
"Ravi" wrote:
> You can try this :
> IIF(Fields!EvaluationDate.Value Is Nothing , Now()-Fields!
> SubmissionDate.Value,Fields!EvaluationDate.Value-Fields!
> SubmissionDate.Value)
>
> >--Original Message--
> >i am currently doing a system where user can submit their
> suggestions to us
> >and part of my system is using Reporting Services and i
> need some guide on my
> >problem.
> >
> >When user submit their suggestions, the date of
> submission will be auto
> >input into SQL Server database and if the suggestions is
> being evaluated by a
> >evaluator, the date of evaluation will also be input into
> the SQL Server
> >database and all this part i had done it all in aspx.
> >So now when user want to view their suggestions, they
> will go to a page
> >which i had generate using Reporting Services. In this
> page, there is a
> >column call Turnaround Time(the datediff from the day of
> submission to now
> >till the suggestions is being evaluated). That means In
> this column i wan to
> >display the datediff from the date of submission till the
> date today if it
> >still had not been evaluated(that means the SQL Server
> database that contains
> >the field "Date of Evaluation" is still null). And if the
> suggestions had
> >been evaluated(that means the SQL Server database that
> contains the field
> >"Date of Evaluation" contains a date value now), it will
> display the datediff
> >from the date of submission to the date of evaluation.
> >
> >For now i can only display the datediff from the date of
> submission to now
> >using the following expression : =DateDiff
> (DateInterval.Day,
> >Fields!DateSubmitted.Value, Now()) and thus i need help
> on how to display the
> >datediff from the date of submission to now if the
> suggestions had not been
> >evaluated and display the datediff from the date of
> submission to the date of
> >evaluation if the suggestions had been evaluated.
> >
> >I appreciate for the help and guide. Thanks
> >.
> >
>|||Its working!! Thanks avnrao!!
Ravi, thanks too! for spending the time in helping me. =)
"avnrao" wrote:
> you can directly get the Turnaround Time from database.
> In your query get this column...
> DateDiff(Day,Table.DateSubmitted,IsNull(Table.DateEvaluated,GetDate())) as
> TurnaroundTime
> and use Fields!TurnaroundTime.Value in your report.
> hth
> "JiaN" <JiaN@.discussions.microsoft.com> wrote in message
> news:37BA72F4-FCF1-4659-ACA3-9366AE53A518@.microsoft.com...
> >i am currently doing a system where user can submit their suggestions to us
> > and part of my system is using Reporting Services and i need some guide on
> > my
> > problem.
> >
> > When user submit their suggestions, the date of submission will be auto
> > input into SQL Server database and if the suggestions is being evaluated
> > by a
> > evaluator, the date of evaluation will also be input into the SQL Server
> > database and all this part i had done it all in aspx.
> > So now when user want to view their suggestions, they will go to a page
> > which i had generate using Reporting Services. In this page, there is a
> > column call Turnaround Time(the datediff from the day of submission to now
> > till the suggestions is being evaluated). That means In this column i wan
> > to
> > display the datediff from the date of submission till the date today if it
> > still had not been evaluated(that means the SQL Server database that
> > contains
> > the field "Date of Evaluation" is still null). And if the suggestions had
> > been evaluated(that means the SQL Server database that contains the field
> > "Date of Evaluation" contains a date value now), it will display the
> > datediff
> > from the date of submission to the date of evaluation.
> >
> > For now i can only display the datediff from the date of submission to now
> > using the following expression : =DateDiff(DateInterval.Day,
> > Fields!DateSubmitted.Value, Now()) and thus i need help on how to display
> > the
> > datediff from the date of submission to now if the suggestions had not
> > been
> > evaluated and display the datediff from the date of submission to the date
> > of
> > evaluation if the suggestions had been evaluated.
> >
> > I appreciate for the help and guide. Thanks
>
>

Express reporting services

I'd like to graduate from using access as my back-end db to using sql express however i'm concerned that I won't be able to create reports with express. Is this true? And if it is, is there some third party tool (preferable free) that will allow me to create a reports....Or can I link access to the sql server tables just for reports?

Thanks,.

Hi,

SQL Reporting Services will be added to the Express product later this year when we release Service Pack 1. You can use Reporting Services in Express to create reports against your SQL Express databases.

You can also create linked tables to your SQL database in Access and use the reporting functionality built into Access to create your reports.

Regards,

Mike Wachal
SQL Express Team

|||Hi,

Can we create reports using SQL SERVER EXPRESS, if we install crystal reports 10 (or later editions) separately ?

Express reporting services

I'd like to graduate from using access as my back-end db to using sql express however i'm concerned that I won't be able to create reports with express. Is this true? And if it is, is there some third party tool (preferable free) that will allow me to create a reports....Or can I link access to the sql server tables just for reports?

Thanks,.

Hi,

SQL Reporting Services will be added to the Express product later this year when we release Service Pack 1. You can use Reporting Services in Express to create reports against your SQL Express databases.

You can also create linked tables to your SQL database in Access and use the reporting functionality built into Access to create your reports.

Regards,

Mike Wachal
SQL Express Team

|||Hi,

Can we create reports using SQL SERVER EXPRESS, if we install crystal reports 10 (or later editions) separately ?

Express reporting services

I'd like to graduate from using access as my back-end db to using sql express however i'm concerned that I won't be able to create reports with express. Is this true? And if it is, is there some third party tool (preferable free) that will allow me to create a reports....Or can I link access to the sql server tables just for reports?

Thanks,.

Hi,

SQL Reporting Services will be added to the Express product later this year when we release Service Pack 1. You can use Reporting Services in Express to create reports against your SQL Express databases.

You can also create linked tables to your SQL database in Access and use the reporting functionality built into Access to create your reports.

Regards,

Mike Wachal
SQL Express Team

|||Hi,

Can we create reports using SQL SERVER EXPRESS, if we install crystal reports 10 (or later editions) separately ?

Express Reporting Services

I've installed SQLEXPR_ADV.EXE and SQLEXPR_TOOLKIT.EXE. Was able to reattached my own DB's and everything seems to be working fine, but....

I used reporting services extensively in SQL 2000 and would love to play with the express version. My problem is, I don't know how to access. I tried opening ReportBuilder.exe but get an error indicating "Report Builder and Report Models are not supported in this version of Reporting Services"...

I have XP Pro and there is a Reports and ReportServer under the default web sites. Do you have to have Visual Studio to utilize?

Any help would be appreciated...

Thank you...

Danno

You need to use the Business Intellegence Developer's Studio, which is installed with the SQL Express Toolkit to design your reports. It should be listed on the Start menu with the other SQL tools.

Mike

|||

Thanks Mike, there is a line item called "SQL Server Business Intelligence Development Studio". When I try to access (double-click) I get the message "Windows is searching for devenv.ext. To locate the file yourself, click browse". I did a search on my entire hard drive for devenv.exe, but it is no where to be found. I tried reinstalling the Toolkit, but get a message that I didn't change anything so nothing was installed. I made sure the BI option was chosen.

I'm assuming that the BI Deve Studio is part of SQLEXPR_TOOLKIT.EXE, is this correct. Any ideas on what I can do to get the BI Dev Studio installed?

Thank you,

Dan

|||

We are facing exactly same problem as Dan has mensioned above. We have tried installing SQLexpress with advanced feature and the tool kit on three different machines and behaviour is same. We are not been able to use Reporting services with SQL2005express. Please help.

Prashant

Express Edition, Reporting Services, and Licensing

Hello,

From reading the licensing considerations page [1], my understanding is that if my environment is 2 servers - an IIS Server and a separate SQL Server Std - I will need a 2nd license of SQL Server to run Reporting Services on my IIS Server? Is this correct? If so, would a license of SQL Server Express Edition w/Advanced Services satisfy the second license requirement, or would I need a license to match the database server?

Essentially, what is the recommended guidance for Reporting Services and Web Applications? It's a known best practice that, for performance, run SQL Server on a dedicated machine separate from IIS. Is it recommended that the database server also serve the reports?

[1] http://www.microsoft.com/sql/howtobuy/howtolicensers.mspx

Thanks,

The definitive answer for licensing issues is to call the licensing folks at:

Licensing –VL Contact
(800) 426-9400

|||

Hi,

"Is it recommended that the database server also serve the reports?"

there is no no yes or no for this, cause this depends on your workload and the amount of licences you want to spend on.

For the first qestions you ask, the scenario mentioned is not possible as you are only allowed to query and report data from the local SQL Server database.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Jens K. Suessmeyer wrote:

"Is it recommended that the database server also serve the reports?"

there is no no yes or no for this, cause this depends on your workload and the amount of licences you want to spend on.

Jens,

Thanks for your reply. I take it by workload, you are referring to combined/overall workload, not just Reporting Services vs. Transactional/Operational, correct? Obviously, that would needed to be weighed into the decision.

Thanks,|||Exactly.

Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Just a point from your initial question...

You can not use Express Advanced to bypass the licensing for SQL Standard Edition. Every person or service connecting to Standard Edition must be properly licensed either by CAL or Proc License. Using Reporting Services from Express Advanced doesn't change the licensing requirements for Standard.

Mike

|||

Mike Wachal - MSFT wrote:

Just a point from your initial question...

You can not use Express Advanced to bypass the licensing for SQL Standard Edition. Every person or service connecting to Standard Edition must be properly licensed either by CAL or Proc License. Using Reporting Services from Express Advanced doesn't change the licensing requirements for Standard.

Mike

Mike,

Thanks for your reply. I'm going to contact licensing just to be safe, but that makes sense.

Thanks,

Express and Reporting Services

Hi,

This thread http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=179557&SiteID=1 says that Express will have Reporting Services enabled such that reports can be created in Express edition. I have just downloaded Express Edition with Advanced Services but i dont appear to have any of the tools neccessary to create a report using reporting services. ( I do have VS 2005)

Also this URL http://msdn.microsoft.com/vstudio/express/ promotes Express as having Reporting Services and yet this table http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx says just the server is installed.

Can anyone please clarify if I just haven't installed or activated the required functionality to build reports using Express edition or whether there is no such capability with Express edition.

If the latter is the case does this mean that I can still run applications and reporting services reports with Express edition? In other words if I buy standard edition to develop reports, can my customers run my application (i.e reports) with Express edition or do they have to purchase standard edition as well?

Richard

Hi S-Bob

You can dowload the report designer and management studio express with the express edition toolkit:

http://www.microsoft.com/downloads/details.aspx?FamilyID=3c856b93-369f-4c6f-9357-c35384179543&DisplayLang=en

You can create reports using standard edition or the toolkit and consumers using express advanced can view them. Note that express has some limitations such as supporting local data sources only.

-JonHP

Exporting Tools

Hi,

I'm looking how export a Cube of my MS Analyzer Services.
I made a cube from the Foodmart DB, and i nedd to share the cube with some mates.
We don't want to build the cube every time that we change the notebook where we work :)

thanks a lotYou can use backup/restore to do this.