Anyone producing a large number of reports per day?

I'm evaluting Reporting Services for my client. They need to produce 5000+
reports per day, mainly output in PDF format. The PDF's are 6-8 pages long.
Does anyone have any experience of getting this kind of performance out of
SQL-RS?
They have an 8-processor 2.8Ghz server running SQL Server that will be the
Reporting Services server. It has 4gig of memory. Will it be up to the job?
Thanks,
Andy.I am able to render about 70reports (PDF format) in less than 10mins. Each
report has about 200 pages.
"Andy Smith" wrote:
> I'm evaluting Reporting Services for my client. They need to produce 5000+
> reports per day, mainly output in PDF format. The PDF's are 6-8 pages long.
> Does anyone have any experience of getting this kind of performance out of
> SQL-RS?
> They have an 8-processor 2.8Ghz server running SQL Server that will be the
> Reporting Services server. It has 4gig of memory. Will it be up to the job?
> Thanks,
> Andy.|||Don't forget to set boot.ini to use /3GB switch in order to take advantage
of the memory.
To verify RS can handle this load, consider using a test tool like
Application Center Test (ACT), part of Visual Studio, to run a Proof Of
Concept. Below is sample ACT script you might use to run such a test:
' --
CONSTANTS --
const ENABLE_DELAYS = True
const REQUESTBUFFERSIZE = 15000
const REPORTSERVERNAME = "localhost"
' --
' -- Think time variables - examples shows between 2-3 seconds
' --
const MIN_SLEEP_MSEC = 2000
const MAX_SLEEP_MSEC = 3000
' --
' -- Think time logic if desired
' --
Function RandomSleep()
if (NOT ENABLE_DELAYS) then
RandomSleep = 0
return
end if
Dim lMinSleep, lMaxSleep, lSleep
lMaxSleep = MAX_SLEEP_MSEC
lMinSleep = MIN_SLEEP_MSEC
' create a random int within our range
Call Randomize()
lSleep = Int((lMaxSleep - lMinSleep + 1) * Rnd(1) + lMinSleep)
' Test.Trace "Sleeping: " + Cstr(lSleep)
Call Test.Sleep(lSleep)
' return the delay time
RandomSleep = lSleep
End Function
Function SendGetRequest(reportServerUrl)
Dim oConnection, oRequest, oResponse, oHeaders, statusCode
Set oConnection = Test.CreateConnection(REPORTSERVERNAME, 80, false)
If (oConnection is Nothing) Then
Test.Trace "Error: Unable to create connection to server"
Else
' TODO: uncomment this after debugging
' Test.Trace(reportServerUrl)
Set oRequest = Test.CreateRequest
oRequest.ResponseBufferSize = REQUESTBUFFERSIZE
oRequest.Path = reportServerUrl
oRequest.Verb = "GET"
oRequest.HTTPVersion = "HTTP/1.1"
set oHeaders = oRequest.Headers
oHeaders.RemoveAll
oHeaders.Add "Accept", "image/gif, image/x-xbitmap, image/jpeg,
image/pjpeg, application/vnd.ms-excel, application/vnd.ms-powerpoint,
application/msword, */*"
oHeaders.Add "Accept-Language", "en-us"
oHeaders.Add "User-Agent", "Mozilla/4.0 (compatible; MSIE 6.0;
Windows NT 5.1; .NET CLR 1.0.3512; .NET CLR 1.1.4322)"
oHeaders.Add "Host", "(automatic)"
oHeaders.Add "Cookie", "(automatic)"
Set oResponse = oConnection.Send(oRequest)
If (oResponse is Nothing) Then
Test.Trace "Error: Failed to receive response for URL to " +
reportServerUrl
Else
statusCode = oResponse.ResultCode
'DEBUG
Test.Trace "Received: " + CStr(statusCode) + " for: " + REPORTSERVERNAME
+ reportServerUrl
' delay in case of errors - to avoid the snowball effect
' Test.Trace "Response code of: " + CStr(statusCode) + "
recieved for " + reportServerUrl
if (statusCode = 503) Then
Test.Trace "Server too busy error: " + CStr(statusCode) + "
recieved for " + reportServerUrl + " - Process Put To Sleep"
End If
End If
oConnection.Close
End If
End Function
Sub Main()
Dim Url
'--
'-- URL of report to call for test. This one calls report named "Simple"
located in dir /Benchmark
'-- passing in a parm of &RowNumber '--
Url ="/ReportServer?/Benchmark/Simple&RowNumber=20&rs:Command=Render&rc:Toolbar=false&rs:Format=PDF"
SendGetRequest(Url)
RandomSleep()
End Sub
Main
--
-- "This posting is provided 'AS IS' with no warranties, and confers no
rights."
jhmiller@.online.microsoft.com
"Raj Chandra" <RajChandra@.discussions.microsoft.com> wrote in message
news:C23DE604-F4E0-4F3E-BD7B-1C4516C1987C@.microsoft.com...
>I am able to render about 70reports (PDF format) in less than 10mins. Each
> report has about 200 pages.
> "Andy Smith" wrote:
>> I'm evaluting Reporting Services for my client. They need to produce
>> 5000+
>> reports per day, mainly output in PDF format. The PDF's are 6-8 pages
>> long.
>> Does anyone have any experience of getting this kind of performance out
>> of
>> SQL-RS?
>> They have an 8-processor 2.8Ghz server running SQL Server that will be
>> the
>> Reporting Services server. It has 4gig of memory. Will it be up to the
>> job?
>> Thanks,
>> Andy.sql

anyone good with Integration services

Hi I have a simple package I am putting together. The package runs a query
on an SQL database (database1) and the results are then copied over to
another SLQ database (database2). I have this set up and it works. I am
trying to add another element that will update a table in database1 as long
as the transfer is successful. I also have a script in the control flow that
writes out a message, success! and this seems to work.
Anyhow not quite sure how what to add to update database1 if the transfer is
successful--
thanks.
Paul G
Software engineer.On Oct 31, 11:44 am, Paul <P...@.discussions.microsoft.com> wrote:
> Hi I have a simple package I am putting together. The package runs a query
> on an SQL database (database1) and the results are then copied over to
> another SLQ database (database2). I have this set up and it works. I am
> trying to add another element that will update a table in database1 as long
> as the transfer is successful. I also have a script in the control flow that
> writes out a message, success! and this seems to work.
> Anyhow not quite sure how what to add to update database1 if the transfer is
> successful--
> thanks.
> Paul G
> Software engineer.
Try Adding a Execute SQL Task as control flow and define your update
Query in the task. change the precedence to success beoe this task.|||Hi thanks that seemed to do the trick. I currently a script task on success
and on failure well that writes out a corresponding message. I was wondering
if you know if there is a way to include the number of records updated from
one of the tasks in the message? It would have to be retreived in the
script? Also are the event handlers for any event in a control flow?
--
Paul G
Software engineer.
"Maninder" wrote:
> On Oct 31, 11:44 am, Paul <P...@.discussions.microsoft.com> wrote:
> > Hi I have a simple package I am putting together. The package runs a query
> > on an SQL database (database1) and the results are then copied over to
> > another SLQ database (database2). I have this set up and it works. I am
> > trying to add another element that will update a table in database1 as long
> > as the transfer is successful. I also have a script in the control flow that
> > writes out a message, success! and this seems to work.
> > Anyhow not quite sure how what to add to update database1 if the transfer is
> > successful--
> > thanks.
> > Paul G
> > Software engineer.
> Try Adding a Execute SQL Task as control flow and define your update
> Query in the task. change the precedence to success beoe this task.
>

Anyone else had this error situation?

So, for the past two weeks or so every morning Reporting services has come up
with the report error "Sorting cannot be performed on table1". For some odd
reason though it does the error on all reports with any sorting whatsoever.
I've checked and double checked my sorting expressions
(=iif(Parameters!Direction.Value = "Ascending",
Fields(Parameters!SortBy.Value).Value, 0) and =iif(Parameters!Direction.Value
= "Descending", Fields(Parameters!SortBy.Value).Value, 0)...
Direction is a drop down param which is either Ascending or Descending and
SortBy is a drop down param that contains all table columns) and have had
others look at it as well and the logic is good for it. What ultimately
remedies it is a restart of IIS on the server we run the reports on.
So has anyone else experienced this problem? If so I could use any
information as to the possible cause or fix to this.Please try this - note the CInt() function call:
=iif(Parameters!Direction.Value = "Ascending",
CInt(Fields(Parameters!SortBy.Value).Value), 0)
=iif(Parameters!Direction.Value = "Descending",
CInt(Fields(Parameters!SortBy.Value).Value), 0)
etc.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Timm" <Timm@.discussions.microsoft.com> wrote in message
news:2DD5CE58-A3DF-41EF-BD47-010A0770E2AE@.microsoft.com...
> So, for the past two weeks or so every morning Reporting services has come
> up
> with the report error "Sorting cannot be performed on table1". For some
> odd
> reason though it does the error on all reports with any sorting
> whatsoever.
> I've checked and double checked my sorting expressions
> (=iif(Parameters!Direction.Value = "Ascending",
> Fields(Parameters!SortBy.Value).Value, 0) and
> =iif(Parameters!Direction.Value
> = "Descending", Fields(Parameters!SortBy.Value).Value, 0)...
> Direction is a drop down param which is either Ascending or Descending and
> SortBy is a drop down param that contains all table columns) and have had
> others look at it as well and the logic is good for it. What ultimately
> remedies it is a restart of IIS on the server we run the reports on.
> So has anyone else experienced this problem? If so I could use any
> information as to the possible cause or fix to this.|||The column names in use are string values (non-numeric) so using CInt throws
back a
different error that will cause the report to not work 100% of the time. I'm
toying with
an idea that this is something to do with the reporting services and not the
reports
themselves since restarting IIS resolves the issue for a day (and the next
day the error
occurs again).
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:OOY8V1sZFHA.3280@.TK2MSFTNGP09.phx.gbl...
> Please try this - note the CInt() function call:
> =iif(Parameters!Direction.Value = "Ascending",
> CInt(Fields(Parameters!SortBy.Value).Value), 0)
> =iif(Parameters!Direction.Value = "Descending",
> CInt(Fields(Parameters!SortBy.Value).Value), 0)
> etc.
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Timm" <Timm@.discussions.microsoft.com> wrote in message
> news:2DD5CE58-A3DF-41EF-BD47-010A0770E2AE@.microsoft.com...
>> So, for the past two weeks or so every morning Reporting services has
>> come up
>> with the report error "Sorting cannot be performed on table1". For some
>> odd
>> reason though it does the error on all reports with any sorting
>> whatsoever.
>> I've checked and double checked my sorting expressions
>> (=iif(Parameters!Direction.Value = "Ascending",
>> Fields(Parameters!SortBy.Value).Value, 0) and
>> =iif(Parameters!Direction.Value
>> = "Descending", Fields(Parameters!SortBy.Value).Value, 0)...
>> Direction is a drop down param which is either Ascending or Descending
>> and
>> SortBy is a drop down param that contains all table columns) and have had
>> others look at it as well and the logic is good for it. What ultimately
>> remedies it is a restart of IIS on the server we run the reports on.
>> So has anyone else experienced this problem? If so I could use any
>> information as to the possible cause or fix to this.
>|||If they are strings, then this explains why it does not work. Use the
following expression then - note that 0 is replaced with an empty string:
=iif(Parameters!Direction.Value = "Ascending",
Fields(Parameters!SortBy.Value).Value, "")
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Timm" <tim@.gumdropbooks.com> wrote in message
news:%23F1YsdtZFHA.720@.TK2MSFTNGP15.phx.gbl...
> The column names in use are string values (non-numeric) so using CInt
> throws back a
> different error that will cause the report to not work 100% of the time.
> I'm toying with
> an idea that this is something to do with the reporting services and not
> the reports
> themselves since restarting IIS resolves the issue for a day (and the next
> day the error
> occurs again).
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:OOY8V1sZFHA.3280@.TK2MSFTNGP09.phx.gbl...
>> Please try this - note the CInt() function call:
>> =iif(Parameters!Direction.Value = "Ascending",
>> CInt(Fields(Parameters!SortBy.Value).Value), 0)
>> =iif(Parameters!Direction.Value = "Descending",
>> CInt(Fields(Parameters!SortBy.Value).Value), 0)
>> etc.
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Timm" <Timm@.discussions.microsoft.com> wrote in message
>> news:2DD5CE58-A3DF-41EF-BD47-010A0770E2AE@.microsoft.com...
>> So, for the past two weeks or so every morning Reporting services has
>> come up
>> with the report error "Sorting cannot be performed on table1". For some
>> odd
>> reason though it does the error on all reports with any sorting
>> whatsoever.
>> I've checked and double checked my sorting expressions
>> (=iif(Parameters!Direction.Value = "Ascending",
>> Fields(Parameters!SortBy.Value).Value, 0) and
>> =iif(Parameters!Direction.Value
>> = "Descending", Fields(Parameters!SortBy.Value).Value, 0)...
>> Direction is a drop down param which is either Ascending or Descending
>> and
>> SortBy is a drop down param that contains all table columns) and have
>> had
>> others look at it as well and the logic is good for it. What ultimately
>> remedies it is a restart of IIS on the server we run the reports on.
>> So has anyone else experienced this problem? If so I could use any
>> information as to the possible cause or fix to this.
>>
>|||I did that change and this morning we got that error still. After restarting
IIS it now works again.
Is this a known issue or is this something that may be unique to our system?
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:%23ggV6FvZFHA.3280@.TK2MSFTNGP09.phx.gbl...
> If they are strings, then this explains why it does not work. Use the
> following expression then - note that 0 is replaced with an empty string:
> =iif(Parameters!Direction.Value = "Ascending",
> Fields(Parameters!SortBy.Value).Value, "")
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Timm" <tim@.gumdropbooks.com> wrote in message
> news:%23F1YsdtZFHA.720@.TK2MSFTNGP15.phx.gbl...
>> The column names in use are string values (non-numeric) so using CInt
>> throws back a
>> different error that will cause the report to not work 100% of the time.
>> I'm toying with
>> an idea that this is something to do with the reporting services and not
>> the reports
>> themselves since restarting IIS resolves the issue for a day (and the
>> next day the error
>> occurs again).
>> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
>> news:OOY8V1sZFHA.3280@.TK2MSFTNGP09.phx.gbl...
>> Please try this - note the CInt() function call:
>> =iif(Parameters!Direction.Value = "Ascending",
>> CInt(Fields(Parameters!SortBy.Value).Value), 0)
>> =iif(Parameters!Direction.Value = "Descending",
>> CInt(Fields(Parameters!SortBy.Value).Value), 0)
>> etc.
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Timm" <Timm@.discussions.microsoft.com> wrote in message
>> news:2DD5CE58-A3DF-41EF-BD47-010A0770E2AE@.microsoft.com...
>> So, for the past two weeks or so every morning Reporting services has
>> come up
>> with the report error "Sorting cannot be performed on table1". For some
>> odd
>> reason though it does the error on all reports with any sorting
>> whatsoever.
>> I've checked and double checked my sorting expressions
>> (=iif(Parameters!Direction.Value = "Ascending",
>> Fields(Parameters!SortBy.Value).Value, 0) and
>> =iif(Parameters!Direction.Value
>> = "Descending", Fields(Parameters!SortBy.Value).Value, 0)...
>> Direction is a drop down param which is either Ascending or Descending
>> and
>> SortBy is a drop down param that contains all table columns) and have
>> had
>> others look at it as well and the logic is good for it. What ultimately
>> remedies it is a restart of IIS on the server we run the reports on.
>> So has anyone else experienced this problem? If so I could use any
>> information as to the possible cause or fix to this.
>>
>>
>|||I haven't seen this before. Are you sure you don't have any report execution
caching set up?
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Timm" <tim@.gumdropbooks.com> wrote in message
news:eHjfzC3ZFHA.1040@.TK2MSFTNGP10.phx.gbl...
>I did that change and this morning we got that error still. After
>restarting IIS it now works again.
> Is this a known issue or is this something that may be unique to our
> system?
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:%23ggV6FvZFHA.3280@.TK2MSFTNGP09.phx.gbl...
>> If they are strings, then this explains why it does not work. Use the
>> following expression then - note that 0 is replaced with an empty string:
>> =iif(Parameters!Direction.Value = "Ascending",
>> Fields(Parameters!SortBy.Value).Value, "")
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Timm" <tim@.gumdropbooks.com> wrote in message
>> news:%23F1YsdtZFHA.720@.TK2MSFTNGP15.phx.gbl...
>> The column names in use are string values (non-numeric) so using CInt
>> throws back a
>> different error that will cause the report to not work 100% of the time.
>> I'm toying with
>> an idea that this is something to do with the reporting services and not
>> the reports
>> themselves since restarting IIS resolves the issue for a day (and the
>> next day the error
>> occurs again).
>> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
>> news:OOY8V1sZFHA.3280@.TK2MSFTNGP09.phx.gbl...
>> Please try this - note the CInt() function call:
>> =iif(Parameters!Direction.Value = "Ascending",
>> CInt(Fields(Parameters!SortBy.Value).Value), 0)
>> =iif(Parameters!Direction.Value = "Descending",
>> CInt(Fields(Parameters!SortBy.Value).Value), 0)
>> etc.
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Timm" <Timm@.discussions.microsoft.com> wrote in message
>> news:2DD5CE58-A3DF-41EF-BD47-010A0770E2AE@.microsoft.com...
>> So, for the past two weeks or so every morning Reporting services has
>> come up
>> with the report error "Sorting cannot be performed on table1". For
>> some odd
>> reason though it does the error on all reports with any sorting
>> whatsoever.
>> I've checked and double checked my sorting expressions
>> (=iif(Parameters!Direction.Value = "Ascending",
>> Fields(Parameters!SortBy.Value).Value, 0) and
>> =iif(Parameters!Direction.Value
>> = "Descending", Fields(Parameters!SortBy.Value).Value, 0)...
>> Direction is a drop down param which is either Ascending or Descending
>> and
>> SortBy is a drop down param that contains all table columns) and have
>> had
>> others look at it as well and the logic is good for it. What
>> ultimately
>> remedies it is a restart of IIS on the server we run the reports on.
>> So has anyone else experienced this problem? If so I could use any
>> information as to the possible cause or fix to this.
>>
>>
>>
>|||I am new to reporting services, so my answer may not be correct.
I had same error, when 2nd parameter was changed to cint, error went
away.
Something like this -
=iif(Parameters!Direction.Value = "Ascending",
CInt(Fields(Parameters!SortBy.Value).Value), cint(0))
=iif(Parameters!Direction.Value = "Descending",
CInt(Fields(Parameters!SortBy.Value).Value), cint(0))

Anybody looked at LGX Report?

This is at freereporting.com.
It seems to be very similar to Reporting Services.
Has anybody here made a comparison?
JCLooks good, I noticed you have to pay for PDF outputs, which you don't
on RS.
Also one of the biggest advantages of RS is that it is seamless
connection to Visual Studio .Net

Any tutorials (confused!)

Hi,
I'm new to this reporting services technology, but done a far bit of C#
and web services. In the current system I work on we have a complex
typed dataset which I want to use as the source for a reporting
services report.
using c#, can you let me know if the following is possible and point me
in a direction;
Populate the typed dataset in the main c# application.
Call reporting services, passing in this dataset (or XML) as a
parameter
All I've done with reporting services so far is to create a static
report and render this as a PDF and output the result to a physical
file on the local hard drive.
Many thanks
MatMat, have a look at www.gotreportviewer.com
HTH,
Ed
<matpublic@.ntlworld.com> wrote in message
news:1140550512.461086.100440@.g44g2000cwa.googlegroups.com...
> Hi,
> I'm new to this reporting services technology, but done a far bit of C#
> and web services. In the current system I work on we have a complex
> typed dataset which I want to use as the source for a reporting
> services report.
> using c#, can you let me know if the following is possible and point me
> in a direction;
> Populate the typed dataset in the main c# application.
> Call reporting services, passing in this dataset (or XML) as a
> parameter
> All I've done with reporting services so far is to create a static
> report and render this as a PDF and output the result to a physical
> file on the local hard drive.
> Many thanks
> Mat
>

Any samples or Demos of Microsoft Office 2007 workng with SQL Server 2005 Analysis Services?

Hi, all experts here,

As we know, SQL Server 2005 Analysis Services has actually got its add-on (like data mining, and OLAP browsing)for Microsoft Office 2007. Could any experts here give me any idea if there is any available demo built on it for us to have a look?

Thanks a lot and I am looking forward to hearing from you shortly.

With best regards,

Yours sincerely,

There are some virtual labs here:

http://msdn2.microsoft.com/en-us/virtuallabs/aa740409.aspx

Is that the kind of thing you're looking for?

Chris

|||

Hi, Chris,

Thanks a lot for the link. It's been very helpful.

I am looking for demos which demonstrating Microsoft integrated BI leveraging SQL Server 2005, Office 2007 and ProClarity. As they perfectly have the integration among each other. It will be very helpful if we could have a look at any demos with these integrations among these products together.

Thanks again.

With best regards,

Yours sincerely,

|||

Hello Helen. You will see more of that integration in Performancepoint analytics.

The last version of ProClarity as an analytical platform is 6.3, recently released. In this release they have dropped the Business Reporter so the integration is weaker than before.

But wait for Performancepoint or sign up for the beta and you will see more about ProClarity's future.

HTH

Thomas Ivarsson

|||

Hi, Thomas,

Thanks a lot. But does PerformancePoint Beta version have the full features of its future release?

With best regards,

Yours sincerely,

|||

Hi Helen. You would have to ask the development team about that.

Full features are normally presented about 1-2 month's before the release.

Kind regards

Thomas

|||

Hi, Thomas,

Thanks a lot for your helo.

With best regards,

Yours sincerely,

Any Reporting Service Log experts out there?

We are working on developing some statistical reports to help us to better
undertand how our users are (or are not) leveraging our Reporting Services
implementation. We have been writing execution log data to a database based
on the Msft provided SSIS package that pulls data from the Report Server
database and I've discovered a hole in the information that I'm hoping
someone can help me fix.
We use data drive subscriptions pretty heavily which of course require
cached data credentials. In the "ExecutionLogs" table, these entries appear
as being requested by "System" and the user shows our proxy account. If you
review the "ReportServerService_..." log on the report server, you can see
the actual detail surrounding the processing of the subscription, but I can't
find a way to correlate these entries back to the ExecutionLog table. The
"ExecutionLogId" in the ExecutionLog table doesn't reference any of the
uniqueidentifiers that you see in the text ReportServerService log.
My end goal is to be able to update the User column in the ExecutionLog
table with the user who was the actual recipient of the report as identified
in the ReportServerService log file.
Anyone tackle this yet or have any ideas as to how it might be accomplished?I'll give you a big hint.. :)
Remember, you are not limited to just select statements in your datasets for
your reports.
I have a dataset that does INSERTS for my data driven reports... (since it
is data driven, you KNOW who the users are that are going to get the
reports)
cheers!
=-Chris
"KS" <ks@.community.nospam> wrote in message
news:C44736CF-304A-4478-98E9-01BDA5A7C0B2@.microsoft.com...
> We are working on developing some statistical reports to help us to better
> undertand how our users are (or are not) leveraging our Reporting Services
> implementation. We have been writing execution log data to a database
> based
> on the Msft provided SSIS package that pulls data from the Report Server
> database and I've discovered a hole in the information that I'm hoping
> someone can help me fix.
> We use data drive subscriptions pretty heavily which of course require
> cached data credentials. In the "ExecutionLogs" table, these entries
> appear
> as being requested by "System" and the user shows our proxy account. If
> you
> review the "ReportServerService_..." log on the report server, you can
> see
> the actual detail surrounding the processing of the subscription, but I
> can't
> find a way to correlate these entries back to the ExecutionLog table. The
> "ExecutionLogId" in the ExecutionLog table doesn't reference any of the
> uniqueidentifiers that you see in the text ReportServerService log.
> My end goal is to be able to update the User column in the ExecutionLog
> table with the user who was the actual recipient of the report as
> identified
> in the ReportServerService log file.
> Anyone tackle this yet or have any ideas as to how it might be
> accomplished?|||Thanks for the hint, Chris.
Unless I'm missing something, however, that still doesn't provide you with
the ability to cross reference the actual report delivery with the
ExecutionLog record to be able to access the other metrics that are being
captured (TimeDataRetrieval, TimeProcessing, TimeRendering, ByteCount,
RowCount...)
Need to find a way to accurately identify a specific data driven
subscription execution with the corresponding ExecutionLog entry.
Any other ideas? Like I said, all the necessary info is in
ReportServerServices_xxx.log, but I don't see how I can accurately tie that
back to the appropriate ExecutionLogId in the ExecutionLog table. The text
file inlcudes a number of uniqueidentifiers, but none of which match up to
the ExecutionLog. Can't go by exact time either as the text file is not
precise enough in the event of batch data driven subscription processing.
"Chris Conner" wrote:
> I'll give you a big hint.. :)
> Remember, you are not limited to just select statements in your datasets for
> your reports.
> I have a dataset that does INSERTS for my data driven reports... (since it
> is data driven, you KNOW who the users are that are going to get the
> reports)
> cheers!
> =-Chris
>
> "KS" <ks@.community.nospam> wrote in message
> news:C44736CF-304A-4478-98E9-01BDA5A7C0B2@.microsoft.com...
> > We are working on developing some statistical reports to help us to better
> > undertand how our users are (or are not) leveraging our Reporting Services
> > implementation. We have been writing execution log data to a database
> > based
> > on the Msft provided SSIS package that pulls data from the Report Server
> > database and I've discovered a hole in the information that I'm hoping
> > someone can help me fix.
> >
> > We use data drive subscriptions pretty heavily which of course require
> > cached data credentials. In the "ExecutionLogs" table, these entries
> > appear
> > as being requested by "System" and the user shows our proxy account. If
> > you
> > review the "ReportServerService_..." log on the report server, you can
> > see
> > the actual detail surrounding the processing of the subscription, but I
> > can't
> > find a way to correlate these entries back to the ExecutionLog table. The
> > "ExecutionLogId" in the ExecutionLog table doesn't reference any of the
> > uniqueidentifiers that you see in the text ReportServerService log.
> >
> > My end goal is to be able to update the User column in the ExecutionLog
> > table with the user who was the actual recipient of the report as
> > identified
> > in the ReportServerService log file.
> >
> > Anyone tackle this yet or have any ideas as to how it might be
> > accomplished?
>
>|||Hmm... this is a nice challenge.
Let's try this - forget the log for the moment - I know I could look this
up - but I'm not at a report server at the moment - does the report
Globals!ExecutionTime match the time stored in the ExectionLog? I mean, you
know the report name ...
Here is what I was thinking:
select name, b.executiontime
from reportserver.dbo.catalog c
inner join reportserver.dbo.executionlog ex
ON (c.ItemID = ex.ReportID)
inner join BobTable b on (c.name = b.ReportName)
where name = b.ReportName and b.executiontime between c.TimeStart and
c.TimeEnd
Where "BobTable" is your table that you store the report name and report
execution time when the report runs.
=-Chris
"KS" <ks@.community.nospam> wrote in message
news:2E0EE652-8A08-4D89-9DB3-50EB8B367FF6@.microsoft.com...
> Thanks for the hint, Chris.
> Unless I'm missing something, however, that still doesn't provide you with
> the ability to cross reference the actual report delivery with the
> ExecutionLog record to be able to access the other metrics that are being
> captured (TimeDataRetrieval, TimeProcessing, TimeRendering, ByteCount,
> RowCount...)
> Need to find a way to accurately identify a specific data driven
> subscription execution with the corresponding ExecutionLog entry.
> Any other ideas? Like I said, all the necessary info is in
> ReportServerServices_xxx.log, but I don't see how I can accurately tie
> that
> back to the appropriate ExecutionLogId in the ExecutionLog table. The
> text
> file inlcudes a number of uniqueidentifiers, but none of which match up to
> the ExecutionLog. Can't go by exact time either as the text file is not
> precise enough in the event of batch data driven subscription processing.
> "Chris Conner" wrote:
>> I'll give you a big hint.. :)
>> Remember, you are not limited to just select statements in your datasets
>> for
>> your reports.
>> I have a dataset that does INSERTS for my data driven reports... (since
>> it
>> is data driven, you KNOW who the users are that are going to get the
>> reports)
>> cheers!
>> =-Chris
>>
>> "KS" <ks@.community.nospam> wrote in message
>> news:C44736CF-304A-4478-98E9-01BDA5A7C0B2@.microsoft.com...
>> > We are working on developing some statistical reports to help us to
>> > better
>> > undertand how our users are (or are not) leveraging our Reporting
>> > Services
>> > implementation. We have been writing execution log data to a database
>> > based
>> > on the Msft provided SSIS package that pulls data from the Report
>> > Server
>> > database and I've discovered a hole in the information that I'm hoping
>> > someone can help me fix.
>> >
>> > We use data drive subscriptions pretty heavily which of course require
>> > cached data credentials. In the "ExecutionLogs" table, these entries
>> > appear
>> > as being requested by "System" and the user shows our proxy account.
>> > If
>> > you
>> > review the "ReportServerService_..." log on the report server, you can
>> > see
>> > the actual detail surrounding the processing of the subscription, but I
>> > can't
>> > find a way to correlate these entries back to the ExecutionLog table.
>> > The
>> > "ExecutionLogId" in the ExecutionLog table doesn't reference any of the
>> > uniqueidentifiers that you see in the text ReportServerService log.
>> >
>> > My end goal is to be able to update the User column in the ExecutionLog
>> > table with the user who was the actual recipient of the report as
>> > identified
>> > in the ReportServerService log file.
>> >
>> > Anyone tackle this yet or have any ideas as to how it might be
>> > accomplished?
>>

Any load testing tool to test queries

Guys,

Is there any tool that can test the scalability of Analysis Services?

Basically we want to fire multiple queries to the Analysis Services and check if there is any performance degradation.

Is there any utility or tool that I can use?

Rgds

Hari

SQL Performance monitor works with SSAS too.|||

The Community samples site has an ASLoadSim tool listed which might be worth a look http://www.codeplex.com/SQLSrvAnalysisSrvcs

Any ideas ?

Unable to encrypt or decrypt data managed by the Report Server instance.
Please refer to the Reporting Services online help for guidance in enabling
this functionality.
...In help there is no help...If I understand you corrrectly, one way to do it would be to use a custom
assembly to encrtpy and decrypt data.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michael Vardinghus" <michaelvardinghus@.notexisting.com> wrote in message
news:O3XEwo9oEHA.4004@.TK2MSFTNGP10.phx.gbl...
> Unable to encrypt or decrypt data managed by the Report Server instance.
> Please refer to the Reporting Services online help for guidance in
enabling
> this functionality.
> ...In help there is no help...
>

Any hosting for Report Services

Does anyone know of a commercial hosting service that is supporting the new Reporting Services? The hosters I have talked to don't even know what it is.In case anyone is interested, MaximumASP is now offering Reporting Services along with their SQL 2000. Haven't actually tried it yet, but getting ready to.|||ASPWired also has Reporting Services...

JK|||anyone know a host supporting RS in the United Kingdom ?! not after a dedicated server setup - too expensive ... thanks|||

Don't have the answer that you need, but if you find that you're only option is to use a host in the States, I use RS at both MaximumASP and DiscountASP on shared accounts (not dedicated servers). Works absolutely great. We produce thousands of reports a month.

|||yes thanks - i actually opened an account with DiscountASP.NET last week to test it all and it IS great but the trans-atlantic time lag is a little annoying ... yep, it still exists even today! i am very close to going with them for my client but i may have to bite the bullet and take out a dedicated server instead

Any Help regarding SQL Reporting Services

Hi,
I checked with msdn for help in sql Reporting Services.
Where can i find help for the same.
--
SushiLIf I understand you correctly you are asking where the documentation is?
When you install RS it installs Books OnLine. That is where all the
documentation is located.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Sushil" <Sushil@.discussions.microsoft.com> wrote in message
news:D3072889-4C65-4EAC-A4C5-9AF7FF37A58A@.microsoft.com...
> Hi,
> I checked with msdn for help in sql Reporting Services.
> Where can i find help for the same.
> --
> SushiL|||Thanks a lot Bruce but i'm not able to find it. Is there any other way if i
can find the documentation. It would be a great help if you tell b'coz i have
already installed Reporting Services. i checked it in MSDN.Net as well as
book online of SQL Server but im not able to find it.
--
SushiL
"Bruce L-C [MVP]" wrote:
> If I understand you correctly you are asking where the documentation is?
> When you install RS it installs Books OnLine. That is where all the
> documentation is located.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Sushil" <Sushil@.discussions.microsoft.com> wrote in message
> news:D3072889-4C65-4EAC-A4C5-9AF7FF37A58A@.microsoft.com...
> > Hi,
> >
> > I checked with msdn for help in sql Reporting Services.
> > Where can i find help for the same.
> > --
> > SushiL
>
>|||Reporting Services BOL is found by going to program manager -> sql server ->
reporting services (note the exact naming might be different, I am on a
computer without RS installed). So, you should have the reporting services
showing up, what happens when you go there. If you don't then you need to
reinstall. Did you install the client tools? I have BOL regardless. Both on
my servers and on my development machine.
You could also try this (installing an updated version of BOL).
http://www.microsoft.com/downloads/details.aspx?FamilyID=5e550d73-8f35-435e-bb71-c8573a1cdbdb&DisplayLang=en
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Sushil" <Sushil@.discussions.microsoft.com> wrote in message
news:B2A50B72-652C-40A5-9B05-FAB98E53BE52@.microsoft.com...
> Thanks a lot Bruce but i'm not able to find it. Is there any other way if
> i
> can find the documentation. It would be a great help if you tell b'coz i
> have
> already installed Reporting Services. i checked it in MSDN.Net as well as
> book online of SQL Server but im not able to find it.
> --
> SushiL
>
> "Bruce L-C [MVP]" wrote:
>> If I understand you correctly you are asking where the documentation is?
>> When you install RS it installs Books OnLine. That is where all the
>> documentation is located.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Sushil" <Sushil@.discussions.microsoft.com> wrote in message
>> news:D3072889-4C65-4EAC-A4C5-9AF7FF37A58A@.microsoft.com...
>> > Hi,
>> >
>> > I checked with msdn for help in sql Reporting Services.
>> > Where can i find help for the same.
>> > --
>> > SushiL
>>

Any good webcasts for sql server 2005 reporting services {Developer perspective}

Can any body please point me to Any good webcasts for sql server 2005 reporting services {Developer perspective}

Also Please recommend me any good book for using and creating SSRS.

Thanks

Hello Kamii,

Here is a link to some of the webcasts on Microsoft's site, there is a section for Reporting Services.

http://www.microsoft.com/events/series/sqlserverbi.mspx

And here is a book on Reporting Services, it got pretty good reviews.

http://www.amazon.com/Microsoft-Server-2005-Reporting-Services/dp/0072262397/ref=pd_bbs_sr_2/103-3827006-9073459?ie=UTF8&s=books&qid=1174049936&sr=8-2

Hope this helps.

Jarret

Any good webcast for Data cleansing

I have sql server 2005 developer edition and vs2005 team system.
I want's to use data cleansing feature.i.e.
Integration Services Advanced Transforms Includes data mining, text mining, and data cleansing

Can please some body points me to any good webcast about using this feature

I just know about this document:

http://forums.microsoft.com/MSDN/Search/Search.aspx?words=data+reader&searchKey=&lcid=1033&searchscope=forumscope&siteid=1&ForumID=80&ForumGroupID=-1

Any good books on Microsoft Reporting Services for a Visual Studio developer?

I'm starting to useMicrosoft Reporting Services and coming from a Crystal background. I'm wondering if anyone is aware of a good book that addresses development of Microsoft reports within the Visual Studio context.

Thanks!

BCB

I just ordered Microsoft SQL Server 2005 Reporting Services 2005 by Brian Larson through amazon this morning. It is supposed to be here tomorrow sometime. I can let you know if it is any good. It did get good reviews on the amazon site and I also found amazon to be the cheapest.

I am having problems with my reporting deployment to the server. It keeps telling me that the ASPNET account does not have sufficient privileges to perform the operation.

|||I have been using Brian Larson's book (SQL Server 2005 Reporting Services) for several months and it is wonderful. It reminds me of a good Wrox book in the sense that it uses cumulative examples where a report that was developed earlier may be used as the basis for demonstrating a new feature. (Don't get me wrong - there are a bunch of report types in the book including Web Services.) You can work through the examples yourself or there is downloadable source code. The book covers both the design and administration side of Reporting Services. The book is less than 600 pages (not counting the appendices) and it has many screen shots that make explicit what the author has just described in words. I like that. The examples really work and files that he references are present in the folders where he states they will be found. I like that even more. Larson isn't just a technical guy who knows a lot about this product; he's an accomplished writer as well. I found that the book was a fairly quick read that managed to leave a lot of knowledge behind after I put it down for the final time. Did I mention that I recommend it?|||Hey guyin kalamazoo,

I just recently went through this learning curve. You have to add permissions for ASPNET to the database that the datasource is trying to access. Unless you store the credentials in the datasource, then it will use those credentials to access the database.

Anyway, look into the permissions for ASPNET on the machine with the database, and make sure you have the proper roles setup on the reporting server.

I hope this helps, as I am still relatively new to SSRS2005.

Anthony

Any easy way to create SQL on the fly with RS?

I am very new to reporting services. I am using reporting services
with Visual Web Developer and my database is Oracle 10g.
I have successfully created reports using the MS reporting services.
Data were pulled out from Oracle 10g through pre-defined SQL.
I would like to display on the web a list of fields that my end users
can select, and then my web application creates the SQL command on the
fly according to end users' selection criteria. Any easy way to do
this with the reporting services?
I hope that I have made clear what effect I would like to achieve. If
not, please ask. Thanks.If you are using SSRS 2005 then you got the answer. Just have a look at what
is called "Report Model" where in you can create a view where you can give
the readable column names and the users can drag and drop to get the reports.
Amarnath
"antonyliu2002@.yahoo.com" wrote:
> I am very new to reporting services. I am using reporting services
> with Visual Web Developer and my database is Oracle 10g.
> I have successfully created reports using the MS reporting services.
> Data were pulled out from Oracle 10g through pre-defined SQL.
> I would like to display on the web a list of fields that my end users
> can select, and then my web application creates the SQL command on the
> fly according to end users' selection criteria. Any easy way to do
> this with the reporting services?
> I hope that I have made clear what effect I would like to achieve. If
> not, please ask. Thanks.
>|||Amarnath wrote:
> If you are using SSRS 2005 then you got the answer. Just have a look at what
> is called "Report Model" where in you can create a view where you can give
> the readable column names and the users can drag and drop to get the reports.
> Amarnath
> "antonyliu2002@.yahoo.com" wrote:
> > I am very new to reporting services. I am using reporting services
> > with Visual Web Developer and my database is Oracle 10g.
> >
> > I have successfully created reports using the MS reporting services.
> > Data were pulled out from Oracle 10g through pre-defined SQL.
> >
> > I would like to display on the web a list of fields that my end users
> > can select, and then my web application creates the SQL command on the
> > fly according to end users' selection criteria. Any easy way to do
> > this with the reporting services?
> >
> > I hope that I have made clear what effect I would like to achieve. If
> > not, please ask. Thanks.
> >
That sounds great. I am not sure which version I am using, but I just
downloaded it a few weeks ago from Microsoft as a plug-in for Visual
Web Developer. I'll check it out.|||> Amarnath wrote:
> If you are using SSRS 2005 then you got the answer. Just have a look at what
> is called "Report Model" where in you can create a view where you can give
> the readable column names and the users can drag and drop to get the reports.
> Amarnath
>
Hi, I am using the Reporting Add-in for Visual Web Developer (VWD)
2005. I was not able to see anything called "Report Model" in VWD.
As I mentioned before, I've successfully created reports using this
Add-in. But the reports I created were predefined. I would like to
let my web users select what data they would like to get from the
database, and then create the SQL on the fly. I hope that I can do
this with this Reporting Add-in.
Any idea about how I can do this? Thanks.|||antonyliu2002@.yahoo.com wrote:
> > Amarnath wrote:
> > If you are using SSRS 2005 then you got the answer. Just have a look at what
> > is called "Report Model" where in you can create a view where you can give
> > the readable column names and the users can drag and drop to get the reports.
> >
> > Amarnath
> >
> Hi, I am using the Reporting Add-in for Visual Web Developer (VWD)
> 2005. I was not able to see anything called "Report Model" in VWD.
> As I mentioned before, I've successfully created reports using this
> Add-in. But the reports I created were predefined. I would like to
> let my web users select what data they would like to get from the
> database, and then create the SQL on the fly. I hope that I can do
> this with this Reporting Add-in.
> Any idea about how I can do this? Thanks.
I've googled a little bit, and the tutorials I found on creating
reporting models all use BI Development Studio. Does this mean that I
cannot possibly create a reporting model with the Add-in in Visual Web
Developer 2005?|||The BI tools come with their own version of VS. If you have it, it
integrates with it. If not, then it installs it. This means that VS 2005
does not need to be purchased.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<antonyliu2002@.yahoo.com> wrote in message
news:1161640436.894263.5660@.i3g2000cwc.googlegroups.com...
> antonyliu2002@.yahoo.com wrote:
>> > Amarnath wrote:
>> > If you are using SSRS 2005 then you got the answer. Just have a look at
>> > what
>> > is called "Report Model" where in you can create a view where you can
>> > give
>> > the readable column names and the users can drag and drop to get the
>> > reports.
>> >
>> > Amarnath
>> >
>> Hi, I am using the Reporting Add-in for Visual Web Developer (VWD)
>> 2005. I was not able to see anything called "Report Model" in VWD.
>> As I mentioned before, I've successfully created reports using this
>> Add-in. But the reports I created were predefined. I would like to
>> let my web users select what data they would like to get from the
>> database, and then create the SQL on the fly. I hope that I can do
>> this with this Reporting Add-in.
>> Any idea about how I can do this? Thanks.
> I've googled a little bit, and the tutorials I found on creating
> reporting models all use BI Development Studio. Does this mean that I
> cannot possibly create a reporting model with the Add-in in Visual Web
> Developer 2005?
>|||> Bruce L-C [MVP] wrote:
> The BI tools come with their own version of VS. If you have it, it
> integrates with it. If not, then it installs it. This means that VS 2005
> does not need to be purchased.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
Thanks, Bruce, are you suggesting that the BI Development Studio is
free? Where can I get it?
I have no Visual Studio 2005, what I have is the free Visual Web
Developer 2005.|||It is free. It comes on the SQL Server media.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<antonyliu2002@.yahoo.com> wrote in message
news:1161658217.724868.128170@.b28g2000cwb.googlegroups.com...
>> Bruce L-C [MVP] wrote:
>> The BI tools come with their own version of VS. If you have it, it
>> integrates with it. If not, then it installs it. This means that VS 2005
>> does not need to be purchased.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
> Thanks, Bruce, are you suggesting that the BI Development Studio is
> free? Where can I get it?
> I have no Visual Studio 2005, what I have is the free Visual Web
> Developer 2005.
>|||> Bruce L-C [MVP] wrote:
> It is free. It comes on the SQL Server media.
>
Thanks, Bruce.
Before I proceed, I have a question. We don't use MS SQL Server as our
database behind our web application. Instead, we use Oracle 10g. Will
I be able to create a web-based application that allows users to create
ad-hoc reports using the SQL Server reporting services and Oracle 10g?
Thanks.|||Developers yes, end users no.
Report Designer is for developers and that works against Oracle. For end
users there is a another tool where first a developer/dba creates a model
and that model is used by the end users to create their own reports. Models
can not be created against Oracle data.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<antonyliu2002@.yahoo.com> wrote in message
news:1161703326.930679.107880@.i3g2000cwc.googlegroups.com...
>> Bruce L-C [MVP] wrote:
>> It is free. It comes on the SQL Server media.
> Thanks, Bruce.
> Before I proceed, I have a question. We don't use MS SQL Server as our
> database behind our web application. Instead, we use Oracle 10g. Will
> I be able to create a web-based application that allows users to create
> ad-hoc reports using the SQL Server reporting services and Oracle 10g?
> Thanks.
>|||> Bruce L-C [MVP] wrote:
> Developers yes, end users no.
> Report Designer is for developers and that works against Oracle. For end
> users there is a another tool where first a developer/dba creates a model
> and that model is used by the end users to create their own reports. Models
> can not be created against Oracle data.
>
Thanks, Bruce.
I am new to Reporting Services. The kind of reports I've managed to
create with the Reporting Services Add-in in Visual Web Developer are
from predefined SQL queries.
Just for the purpose of simplicity, suppose that in my web application,
I present the names of 10 students in a dropdown list. I would like to
let my web users select one of these students and then I construct the
sql query on the fly, and create a report about this selected student
only.
Is this do-able with the Reporting Services Add-in in Visual Web
Developer 2005 Express Edition?
Thanks.

Any documentation anywhere on vs.net 2005 + report services

Well, it finally arrived, my eval version of vs.net 2005...I was so
excited, I think I really must 'get a life'...
Anyway, I recall on here mention that in vs.net 2005 you get more
control over the parameter area....can anyone point me to any
documentation on how vs.net allows more control of reports than 2003?
Did anyone write something about it somewhere?
Thanks
Peter Nolan
www.peternolan.comYou are saying vs.net 2005. vs.net is not Reporting Service. VS 2005 comes
with 2 controls. A winform control and a webform control. If you have your
own application that is integrating with RS then these controls are great.
The controls work in local mode (render without a server) and server mode.
In server mode the server must be running RS 2005, it does not work with RS
2000.
It sounds like you are using Report Manager for your portal to the reports
(versus creating your own app that interacts with the user). If so, then VS
2005 does not provide anything of use to you. You need to upgrade to RS 2005
to see any improvement. As far as more control over the parameter area. RS
2005 has a calendar date picker and it support multi-selection parameters.
Two major improvements.
RS 2005 is faster and also has support for end user sorting.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Peter Nolan" <peter@.peternolan.com> wrote in message
news:1141230819.293974.223770@.u72g2000cwu.googlegroups.com...
> Well, it finally arrived, my eval version of vs.net 2005...I was so
> excited, I think I really must 'get a life'...
> Anyway, I recall on here mention that in vs.net 2005 you get more
> control over the parameter area....can anyone point me to any
> documentation on how vs.net allows more control of reports than 2003?
> Did anyone write something about it somewhere?
> Thanks
> Peter Nolan
> www.peternolan.com
>|||Hi Bruce,
yes, I mean vs.net 2005...I also have sql server 2005.....I have been
going through the 'upgrade' process from sql server 2000 + RS and
vs.net 2003. We are playing around with all the 2005 stuff and
integrating dundas chart controls.
We are building a product based on all the MSFT technology stack (music
to your eyes I am sure)...and we are trying to make it the very best we
can on all 2005 stuff.
We want to integrate it into dotnetnuke in the future but it looks like
it is a bit of work to do and we decided for version 1.0 we would go
with the out of the box report manager.
So currently, we want the 'best result' we can get with vs.net 2005 and
sql server 2005...sounds to me like we can't do any more with the
webform and we might just have wait until version 1.1 and we get it
into the dot net nuke portal...
This sound correct to you?
Best Regards
Peter
www.peternolan.com|||If you want your own frontend then look at the new webform controls that
come with VS 2005, they work with RS 2005.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Peter Nolan" <peter@.peternolan.com> wrote in message
news:1141333522.027909.311300@.j33g2000cwa.googlegroups.com...
> Hi Bruce,
> yes, I mean vs.net 2005...I also have sql server 2005.....I have been
> going through the 'upgrade' process from sql server 2000 + RS and
> vs.net 2003. We are playing around with all the 2005 stuff and
> integrating dundas chart controls.
> We are building a product based on all the MSFT technology stack (music
> to your eyes I am sure)...and we are trying to make it the very best we
> can on all 2005 stuff.
> We want to integrate it into dotnetnuke in the future but it looks like
> it is a bit of work to do and we decided for version 1.0 we would go
> with the out of the box report manager.
> So currently, we want the 'best result' we can get with vs.net 2005 and
> sql server 2005...sounds to me like we can't do any more with the
> webform and we might just have wait until version 1.1 and we get it
> into the dot net nuke portal...
> This sound correct to you?
> Best Regards
> Peter
> www.peternolan.com
>|||Hi Bruce,
we'd like out own but we see it is a lot of work to do....I bought the
hitch-hikers book and I agree with their opinion...too hard...
I also think someone else is going to do it and charge a reasonable fee
for it...failing that, we will put it into dotnetnuke....we don't
want to have to write an application just to present our
reports...there's too much to write...we like DNN as it now has
windows authentication, lots of modules, a developer ecosystem
happening, the source code is availble, and it's the right price.. LOL!
Personally, I'd love to see MSFT and DNN core team work together to
develop a really, really good suite of modules for Report Services.
There is one out there already and I am using it...but I think someone
actually spending a good amount of time and effort on it might be
useful...perhaps I should do that myself!!! Maybe we can use the new
webform inside DNN.....sounds like Version 1.1 to me...and we are
still working on getting V 1.0 out the door...
Best Regards
Peter
www.peternolan.com

Any Book on MetaData Services ?

Looking for a good book on SQL Server metadata services user guide. Any
idea ?
Thanks
Mac
I don't know of any commercial books but there is a fair amount of
information right in BooksOnLine under "Meta data".
Andrew J. Kelly SQL MVP
"Mac Vazehgoo" <mahmood.vazehgoo@.unisys.com> wrote in message
news:cpdnnt$1i6m$1@.si05.rsvl.unisys.com...
> Looking for a good book on SQL Server metadata services user guide. Any
> idea ?
> Thanks
> Mac
>
|||Good Day,
Our organization would like to make use of sql server repository meta data
for use in our CIM system (following DMTF standards).
I have created a repository database, imported an information model into it,
and am now trying to program using the Meta Data SDK API.
In my view the API is not well documented at all. The documentation
describes the API but offers very very little in the way of examples. Am i
missing something or is there very little in the way of examples to use this
technology.
I also have found virtually no books on the subject matter that can help us.
Any help in this area is greatly appreciatted as there are virtually no
examples on the net either. I wonder if we are on the right track or if this
is so new that nobody has put out information on how to use it.
Thanks in advance,
Mike
"Andrew J. Kelly" wrote:

> I don't know of any commercial books but there is a fair amount of
> information right in BooksOnLine under "Meta data".
> --
> Andrew J. Kelly SQL MVP
>
> "Mac Vazehgoo" <mahmood.vazehgoo@.unisys.com> wrote in message
> news:cpdnnt$1i6m$1@.si05.rsvl.unisys.com...
>
>
|||I can see why there is little docs. In all the years I have worked with SQL
Server I didn't even know it had a Meta Data SDK. I would have to assume
you are one of the few who chose to use it. That does not mean it is not
useful, just not popular. If you do a search on Google as this:
site:support.microsoft.com meta data sdk
you should see a number of related hits. The first that I see looks the most
promising:
http://support.microsoft.com/?kbid=238912
Andrew J. Kelly SQL MVP
"WestyManBC" <WestyManBC@.discussions.microsoft.com> wrote in message
news:A65BD6AC-D351-4A76-9235-623F94008FA6@.microsoft.com...[vbcol=seagreen]
> Good Day,
> Our organization would like to make use of sql server repository meta data
> for use in our CIM system (following DMTF standards).
> I have created a repository database, imported an information model into
> it,
> and am now trying to program using the Meta Data SDK API.
> In my view the API is not well documented at all. The documentation
> describes the API but offers very very little in the way of examples. Am i
> missing something or is there very little in the way of examples to use
> this
> technology.
> I also have found virtually no books on the subject matter that can help
> us.
> Any help in this area is greatly appreciatted as there are virtually no
> examples on the net either. I wonder if we are on the right track or if
> this
> is so new that nobody has put out information on how to use it.
> Thanks in advance,
> Mike
> "Andrew J. Kelly" wrote:

Any Book on MetaData Services ?

Looking for a good book on SQL Server metadata services user guide. Any
idea ?
Thanks
MacI don't know of any commercial books but there is a fair amount of
information right in BooksOnLine under "Meta data".
--
Andrew J. Kelly SQL MVP
"Mac Vazehgoo" <mahmood.vazehgoo@.unisys.com> wrote in message
news:cpdnnt$1i6m$1@.si05.rsvl.unisys.com...
> Looking for a good book on SQL Server metadata services user guide. Any
> idea ?
> Thanks
> Mac
>|||Good Day,
Our organization would like to make use of sql server repository meta data
for use in our CIM system (following DMTF standards).
I have created a repository database, imported an information model into it,
and am now trying to program using the Meta Data SDK API.
In my view the API is not well documented at all. The documentation
describes the API but offers very very little in the way of examples. Am i
missing something or is there very little in the way of examples to use this
technology.
I also have found virtually no books on the subject matter that can help us.
Any help in this area is greatly appreciatted as there are virtually no
examples on the net either. I wonder if we are on the right track or if this
is so new that nobody has put out information on how to use it.
Thanks in advance,
Mike
"Andrew J. Kelly" wrote:
> I don't know of any commercial books but there is a fair amount of
> information right in BooksOnLine under "Meta data".
> --
> Andrew J. Kelly SQL MVP
>
> "Mac Vazehgoo" <mahmood.vazehgoo@.unisys.com> wrote in message
> news:cpdnnt$1i6m$1@.si05.rsvl.unisys.com...
> > Looking for a good book on SQL Server metadata services user guide. Any
> > idea ?
> >
> > Thanks
> > Mac
> >
> >
>
>|||I can see why there is little docs. In all the years I have worked with SQL
Server I didn't even know it had a Meta Data SDK. I would have to assume
you are one of the few who chose to use it. That does not mean it is not
useful, just not popular. If you do a search on Google as this:
site:support.microsoft.com meta data sdk
you should see a number of related hits. The first that I see looks the most
promising:
http://support.microsoft.com/?kbid=238912
--
Andrew J. Kelly SQL MVP
"WestyManBC" <WestyManBC@.discussions.microsoft.com> wrote in message
news:A65BD6AC-D351-4A76-9235-623F94008FA6@.microsoft.com...
> Good Day,
> Our organization would like to make use of sql server repository meta data
> for use in our CIM system (following DMTF standards).
> I have created a repository database, imported an information model into
> it,
> and am now trying to program using the Meta Data SDK API.
> In my view the API is not well documented at all. The documentation
> describes the API but offers very very little in the way of examples. Am i
> missing something or is there very little in the way of examples to use
> this
> technology.
> I also have found virtually no books on the subject matter that can help
> us.
> Any help in this area is greatly appreciatted as there are virtually no
> examples on the net either. I wonder if we are on the right track or if
> this
> is so new that nobody has put out information on how to use it.
> Thanks in advance,
> Mike
> "Andrew J. Kelly" wrote:
>> I don't know of any commercial books but there is a fair amount of
>> information right in BooksOnLine under "Meta data".
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Mac Vazehgoo" <mahmood.vazehgoo@.unisys.com> wrote in message
>> news:cpdnnt$1i6m$1@.si05.rsvl.unisys.com...
>> > Looking for a good book on SQL Server metadata services user guide.
>> > Any
>> > idea ?
>> >
>> > Thanks
>> > Mac
>> >
>> >
>>

Antivirus software on SQL Server 2000

I am preparing to install SQL Server 2000 on a Windows 2003 server. There will be no file or print sharing services or in general no other processes running on this server except those required by SQL Server. The SQL Server is behind a filewall and will only be accessed internally. Should I install McAfee or Norton antivirus software on this machine? If so, are there any special configuration options that I should consider?Check out this KB article.
INF: Consideration for a Virus Scanner on a Computer That Is Running SQL
Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;309422&Product=sql2k
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Lane Lesperance" <LLesperance@.cooperpower.com> wrote in message
news:ekCZHsCwDHA.1764@.TK2MSFTNGP10.phx.gbl...
> I am preparing to install SQL Server 2000 on a Windows 2003 server. There
will be no file or print sharing services or in general no other processes
running on this server except those required by SQL Server. The SQL Server
is behind a filewall and will only be accessed internally. Should I install
McAfee or Norton antivirus software on this machine? If so, are there any
special configuration options that I should consider?
>|||See http://support.microsoft.com/default.aspx?scid=kb;en-
us;309422
In general, it is not recommended to do so if you don't
have to on a SQL box due to the things you mention (i.e.
not a file server, etc.). If you do, filter the SQL
DB/log files (not the executables), and if it's a cluster,
filter the \MSCS and if it exists, \MSDtc folders on the
quorum.
>--Original Message--
>I am preparing to install SQL Server 2000 on a Windows
2003 server. There will be no file or print sharing
services or in general no other processes running on this
server except those required by SQL Server. The SQL Server
is behind a filewall and will only be accessed internally.
Should I install McAfee or Norton antivirus software on
this machine? If so, are there any special configuration
options that I should consider?
>
>.
>