Report with x items per page. Can't get this to work.

I have a very simple design that is causing a very large headache, and
I was hoping you could point me in the right direction.
All I need is for my report to have some information at the top, a
list of 5 items, and then some information at the bottom. But there
maybe more then 5 items, say 10. So I would need to generate 2 pages
with all the same information at the top and the bottom but the first
page would contain the first 5 lines and the second the next 5 lines.
The number of items would vary anywhere from 1 to 100, so it needs to
start a new page every 5 items.
I'm actually not using a database connection instead I'm using .net
object that contains all the information I need, including the list of
items. Now when I use a table or list and grouping so I can group the
items into chunks of 5, and then use a page break on group end I can
generate the next page, but the next set of items start at the top of
the page not where the list is on layout, and none of my other
information repeats. Now I've also tried using headers and footers
but for some reason it says I can't use "Fields" in the header and
footer sections so the additional information I need to display cant
be put in the header and foot.
This seems like a very very simple report yet I can't get the report
to do what I need.
Any help would be appreciated, Thanx.On Mar 30, 10:31 am, Edgey.Er...@.gmail.com wrote:
> I have a very simple design that is causing a very large headache, and
> I was hoping you could point me in the right direction.
> All I need is for my report to have some information at the top, a
> list of 5 items, and then some information at the bottom. But there
> maybe more then 5 items, say 10. So I would need to generate 2 pages
> with all the same information at the top and the bottom but the first
> page would contain the first 5 lines and the second the next 5 lines.
> The number of items would vary anywhere from 1 to 100, so it needs to
> start a new page every 5 items.
> I'm actually not using a database connection instead I'm using .net
> object that contains all the information I need, including the list of
> items. Now when I use a table or list and grouping so I can group the
> items into chunks of 5, and then use a page break on group end I can
> generate the next page, but the next set of items start at the top of
> the page not where the list is on layout, and none of my other
> information repeats. Now I've also tried using headers and footers
> but for some reason it says I can't use "Fields" in the header and
> footer sections so the additional information I need to display cant
> be put in the header and foot.
> This seems like a very very simple report yet I can't get the report
> to do what I need.
> Any help would be appreciated, Thanx.
Have you tried adding the header and footer information in the
grouping rows (top and bottom rows of the table control (if you're
using any))?
Enrique Martinez
Sr. Software Consultant

Report Services Configuration Error

Hello,

I am a complete Newbie with SQL Server 2005. Can someone help with this problem or at least point me in the right directio for diagnosing it correctly.

I'm learning the Standard SQL product on Windows XP Pro, and everything on my computer has the latest updates (from Windows Updates). I had previously installed SQL Express, but removed all products associated with that according to steps listed at Microsoft's site (pre-installation steps for SQL Server 2005 Standard, as they relate to the removal of SQLExpress).

My problem is I can't run "Reporting Services Configuration". When I try to run it, the main window opens with "Report Server Installation Instance Selection" window, and immediately I get an error box that says, "An unknown error has occurred in the WMI Provider. Error Code 80040219". When I click Ok, I'm back at the instance selection window, where my computer name is by default the machine name, but the instance name is greyed out. After the error, Event Viewer/Application gives the info below. I noticed that it refers to MSSQL.2\Reporting Services\ - but that was the directory for SQL Express Reporting Services, according to the mapping in my registry. It shows mssql.4 as the Standard SQL Reporting Services directory

Event Type: Error
Event Source: Report Server
Event Category: (5)
Event ID: 133
Date: 1/3/2007
Time: 11:08:23 AM
User: N/A
Computer: BSDELL
Description:
The description for Event ID ( 133 ) in Source ( Report Server ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: c:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\RSReportServer.config.

When I try to connect to Report Services through SQL Server Management Studio, I get the following error: Cannot connect to BsDell - with the following technical details...

Program Location:

at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at System.Management.ManagementObjectCollection.ManagementObjectEnumerator.MoveNext()
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.ParseServerName(String serverName)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.CreateSqlOlapConnectionInfoBase(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.RSType.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

Thanks so much Albert!! It was the Namespace in the config file.

Removed, saved, and immediately connected in management studio.

:)

Brian

|||

The error means that the config tool can't open the config file for the instance "MSSQL.2". Not surprising, since you uninstalled it. However, the instance name is apparently still in the registry. I'm not sure why the config tool is unable to continue after the error, but you may be able to work around it by cleaning the registry. Using Regedit, look for a key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\RS". Under that key, is there a value whose data is "MSSQL.2"? If so, delete the value.

-Albert

|||

Thanks Albert, that was it.

After deleting that key, I was able to run the RS Config. But I'm still not able to pull up the web at http://localhost/Reports or http://localhost/ReportServer and I can't connect to Reporting Services in MS SQL Server Management Studio.

Should I delete the old mssql.2 folder (inside c:\program files\Microsoft SQL Server) that used to be for the SQLEXPRESS instance? And, along those lines, should I delete any other branches or keys in the registry that mention MSSQL.2? I have a branch at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.2 which is almost an exact duplicate of HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.4 (mssql.2 for SQLEXPRESS and mssql.4 for MSSQLSERVER standard)

I appreciate your help immensly.

Here's the last part of the SQLDUMPER_ERROR.log from "MSSQL.4\Reporting Services\LogFiles".

It's got about 10 dumps in it, and they are all exactly like what I've pasted in below.

01/04/07 16:39:48, ACTION, aspnet_wp.exe, Watson Invoke: No

01/04/07 16:40:18, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)

01/04/07 16:40:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied

01/04/07 16:40:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 1180

01/04/07 16:40:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0

01/04/07 16:40:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0

01/04/07 16:40:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0

01/04/07 16:40:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x11EB40D4

01/04/07 16:40:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>

01/04/07 16:40:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000

01/04/07 16:40:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000

01/04/07 16:40:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>

01/04/07 16:40:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>

01/04/07 16:40:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>

01/04/07 16:40:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used

01/04/07 16:40:19, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used

01/04/07 16:40:19, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\LogFiles\SQLDmpr0010.mdmp

01/04/07 16:40:19, ACTION, aspnet_wp.exe, Watson Invoke: No

|||

It would not hurt to delete the registry key and files for the MSSQL.2 instance. I don't know if it's causing your problem, though. Can you scan the other log files in MSSQL.4\Reporting Services\LogFiles for error messages?

-Albert

|||

Albert,

I have several logs that appeared in the mssql.4 log folder after trying to connect to report server in MS SQL Management Studio, and I have two "system" event log entries which both say the same thing, recorded with the same time stamp. I'll paste one of the report server error logs, the sql dumper and the system event item below, but first I will just paraphrase the errors from each log.

The system event error log puzzles me. I've looked up the referenced CLSID key in the registry (see below), starting in HKCR\CLSID\ and the clsid has 18 entries. The entries have various names, like Netork Connection Manager, Lan Connection, etc But I don't see any of the named items in the Component Services tool. Apparently the item or items need Local Activation permission. By the way, the Event Log mentions ASPNET as the user.

The ReportServer log makes reference to "Object reference not set to an instance of an object", just before the system event DCOM error, and then the same error again immediately following the system event DCOM error.

Thanks again for your help.

Brian

--System Event DCOM errors- (2 Items, both exactly the same, pasting only one item)

Event Type: Error
Event Source: DCOM
Event Category: None
Event ID: 10016
Date: 1/5/2007
Time: 10:54:29 AM
User: BSDELL\ASPNET
Computer: BSDELL
Description:
The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID
{BA126AD1-2166-11D1-B1D0-00805FC1270E}
to the user BSDELL\ASPNET SID (S-1-5-21-1417001333-813497703-725345543-1008). This security permission can be modified using the Component Services administrative tool.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

--ReportServer__01_05_2007_10_54_20.log--

<Header>

<Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product>

<Locale>en-US</Locale>

<TimeZone>Eastern Standard Time</TimeZone>

<Path>C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\LogFiles\ReportServer__01_05_2007_10_54_20.log</Path>

<SystemName>BSDELL</SystemName>

<OSName>Microsoft Windows NT 5.1.2600 Service Pack 2</OSName>

<OSVersion>5.1.2600.131072</OSVersion>

</Header>

aspnet_wp!webserver!1!1/5/2007-10:54:22:: i INFO: Reporting Web Server started

aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.

aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.

aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.

aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.

aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.

aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.

aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.

aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.

aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.

aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.

aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.

aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.

aspnet_wp!configmanager!1!1/5/2007-10:54:22:: w WARN: WebServiceAccount is not specified in the config file. Using default: BSDELL\ASPNET

aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.

aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.

aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.

aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.

aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.

aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.

aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.

aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.

aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.

aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.

aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.

aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.

aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.

aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.

aspnet_wp!library!1!1/5/2007-10:54:22:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.

aspnet_wp!resourceutilities!1!1/5/2007-10:54:22:: i INFO: Reporting Services starting SKU: Standard

aspnet_wp!resourceutilities!1!1/5/2007-10:54:22:: i INFO: Evaluation copy: 0 days left

aspnet_wp!resourceutilities!1!1/5/2007-10:54:22:: i INFO: Running on 1 physical processors, 2 logical processors

aspnet_wp!runningjobs!1!1/5/2007-10:54:22:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds

aspnet_wp!runningjobs!1!1/5/2007-10:54:22:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds

aspnet_wp!runningjobs!1!1/5/2007-10:54:22:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds

aspnet_wp!runningjobs!1!1/5/2007-10:54:22:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds

aspnet_wp!library!1!01/05/2007-10:54:22:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;

Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.

at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetWebConfigAuthenticationAttribute(String attrName)

at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetAuthenticationType()

at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.get_UsingWindowsAuth()

at Microsoft.ReportingServices.WebServer.Global.EnableAntiDos()

at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()

at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)

End of inner exception stack trace

aspnet_wp!library!1!01/05/2007-10:54:28:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson

aspnet_wp!library!1!01/05/2007-10:54:31:: i INFO: Catalog SQL Server Edition = Standard

aspnet_wp!library!1!01/05/2007-10:54:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;

Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.

at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetWebConfigAuthenticationAttribute(String attrName)

at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetAuthenticationType()

at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.get_UsingWindowsAuth()

at Microsoft.ReportingServices.WebServer.Global.EnableAntiDos()

at Microsoft.ReportingServices.WebServer.Global.Application_EndRequest(Object sender, EventArgs e)

End of inner exception stack trace

aspnet_wp!library!1!01/05/2007-10:54:32:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson

--SQLDUMPER_ERRORLOG.log--

01/05/07 10:54:27, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)

01/05/07 10:54:27, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied

01/05/07 10:54:27, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 3976

01/05/07 10:54:27, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0

01/05/07 10:54:27, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0

01/05/07 10:54:27, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0

01/05/07 10:54:27, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x47405860

01/05/07 10:54:27, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>

01/05/07 10:54:27, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000

01/05/07 10:54:27, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000

01/05/07 10:54:27, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>

01/05/07 10:54:27, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>

01/05/07 10:54:27, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>

01/05/07 10:54:27, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used

01/05/07 10:54:28, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used

01/05/07 10:54:28, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\LogFiles\SQLDmpr0017.mdmp

01/05/07 10:54:28, ACTION, aspnet_wp.exe, Watson Invoke: No

01/05/07 10:54:31, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)

01/05/07 10:54:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied

01/05/07 10:54:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 3976

01/05/07 10:54:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0

01/05/07 10:54:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0

01/05/07 10:54:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0

01/05/07 10:54:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x47405860

01/05/07 10:54:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>

01/05/07 10:54:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000

01/05/07 10:54:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000

01/05/07 10:54:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>

01/05/07 10:54:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>

01/05/07 10:54:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>

01/05/07 10:54:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used

01/05/07 10:54:32, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used

01/05/07 10:54:32, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\LogFiles\SQLDmpr0018.mdmp

01/05/07 10:54:32, ACTION, aspnet_wp.exe, Watson Invoke: No

|||

Check that the MSSQL.4\Reporting Services\ReportServer\web.config file has a configuration/system.web/authentication element. (See this thread). Also, if you have edited the ReportServer web site with VS2005, it may have altered the web.config by adding a namespace attribute to the configuration element. This would cause the exception you saw.

-Albert

Report Services and Web Services?

Hi All,
I have spent the last few weeks working with SQL Server 2000 Reporting
Services and have gotten to the point of successfully creating EMail
Subscriptions. I now want to extend this so this process is performed
automatically, ie by clicking an 'Add me to this Reports Subscription list'
from within ur web application along side the link to run the report.
I'm aware of the RS.EXE utility but I'm not sure this is the answer, I'm
thinking this might lie within Web Services, as I hear Reporting Services is
basically a collection of such WSs which the localhost reporting services
interface plugs into.
So I'm wondering if this is correct and if so how I go about plugging into
the WSs to script the creation of a Report Subscription. I'm guessing it
might be possible to create the required subscriptions and then just use the
script/WSs to add a users email to the email list for the subscription,
although I'm wondering if it'll be that simple!
Thanks in advance,
Stephen
.ive done this using the reporting services soap api (although i am
using 2005, it was available in 2000)
heres a starting point ..
http://msdn2.microsoft.com/en-US/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.createsubscription.aspx
its not too difficult, especially if your contriving much of the
schedule type values in your app rather than having to recreate a
scheduling interface for the user.
db
http://www.osix.net
the open source institute
home of the geek programming challenges
StephenMcC wrote:
> Hi All,
> I have spent the last few weeks working with SQL Server 2000 Reporting
> Services and have gotten to the point of successfully creating EMail
> Subscriptions. I now want to extend this so this process is performed
> automatically, ie by clicking an 'Add me to this Reports Subscription list'
> from within ur web application along side the link to run the report.
> I'm aware of the RS.EXE utility but I'm not sure this is the answer, I'm
> thinking this might lie within Web Services, as I hear Reporting Services is
> basically a collection of such WSs which the localhost reporting services
> interface plugs into.
> So I'm wondering if this is correct and if so how I go about plugging into
> the WSs to script the creation of a Report Subscription. I'm guessing it
> might be possible to create the required subscriptions and then just use the
> script/WSs to add a users email to the email list for the subscription,
> although I'm wondering if it'll be that simple!
> Thanks in advance,
> Stephen
> .|||Thanks for the reply bb, but is this .Net, migth it be poss to plug into this
from VB6 or Classic ASP, as the app is in old school VS?!
Thanks,
Sephen
"bb" wrote:
> ive done this using the reporting services soap api (although i am
> using 2005, it was available in 2000)
> heres a starting point ..
> http://msdn2.microsoft.com/en-US/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.createsubscription.aspx
> its not too difficult, especially if your contriving much of the
> schedule type values in your app rather than having to recreate a
> scheduling interface for the user.
> db
>
> http://www.osix.net
> the open source institute
> home of the geek programming challenges
>
>
> StephenMcC wrote:
> > Hi All,
> >
> > I have spent the last few weeks working with SQL Server 2000 Reporting
> > Services and have gotten to the point of successfully creating EMail
> > Subscriptions. I now want to extend this so this process is performed
> > automatically, ie by clicking an 'Add me to this Reports Subscription list'
> > from within ur web application along side the link to run the report.
> >
> > I'm aware of the RS.EXE utility but I'm not sure this is the answer, I'm
> > thinking this might lie within Web Services, as I hear Reporting Services is
> > basically a collection of such WSs which the localhost reporting services
> > interface plugs into.
> >
> > So I'm wondering if this is correct and if so how I go about plugging into
> > the WSs to script the creation of a Report Subscription. I'm guessing it
> > might be possible to create the required subscriptions and then just use the
> > script/WSs to add a users email to the email list for the subscription,
> > although I'm wondering if it'll be that simple!
> >
> > Thanks in advance,
> >
> > Stephen
> >
> > .
>

Report Service not showing up in WSS 3.0 Central Admin

I installed the Reporting Service for Share Point just fine but when I go to central admin I do not see the reporting service section. Any Ideas?Can you check under site settings -> Site collection features and see if the feature is activated?|||

Install SharePoint.exe and Install SharePointRS.msi with same user ?

|||I had installed the reporting service and share point as different users on the server. I reinstalled RS using the same login as was used to install WSS and I now have the Report Service in Central Admin. THanks for all of the help.

Report Server Windows Service (MSSQLSERVER)

This error is being displayed in the eventlog every minute. Any ideas on what it is referring too? I reviewed some posts but most point to specific problems of report server not running, or receiving this error during a run. We are receiving no errors at all. However this is jamming up the event viewer to make troubleshooting other issues very diffucult.

Event Type: Error
Event Source: Report Server Windows Service (MSSQLSERVER)
Event Category: Management
Event ID: 107
Date: 3/23/2007
Time: 8:20:16 AM
User: N/A
Computer: SPECTRUM_DB2B
Description:
Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

It is stating that RS can not connect to it's database. A possible reason is the way you are connecting to the RS database. In the config tool if on the Database tab it says "Service Account" then it is using whatever account the windows service is running as. It is possible someone changed this account via another tool and this account does not have rights to read the DB.

The easiest way to fix this is to go to the Database tab in the configuration tool and select "Script...". Then select "Grant Rights Script", enter the username and hit OK. After this, run the script on the SQL server. The windows service user should now be able to connect to the SQL server, making the error go away.

Report Server Setup when query against terabytes of data

Hi all,

Can anyone point me to a resource on the best way to setup and use SSRS 2005 when reporting on tables that could have 1 billion rows. The database in question will have mulitple schema's each being at least 1 terabyte in size.

Thanks

-JW

The size of the database matters much less than the size of the data you want in the report. My advice is to push as much filtering and sorting logic as you can into the back end database and return only the result set you want to display into SSRS 2005. Assuming you filter the data down to 20-100 page reports, going against billions of rows and terabytes of data is not difficult.

Thanks.

Donovan Smith

|||

Thanks Donovan

Report server cannot open a connection to the report server database

I am getting the following error, when trying to deploy. the report should point to a server which is in my network, but the report is on my machine. where i am trying to deploy locally but point to a different machine.

******************************************************

The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing.

***********************************

Thank you very much for the information.

Within Business Intelligence Development Studio, open your report project and select '-ProjectName- Properties' from the Project menu (should be at the bottom of the menu). Does the TargetServerURL show http://NetworkServerName/ReportServer or does it show http://localhost/ReportServer?

Jarret

|||

Jarret,

That was my mistake i recently changed my systems password, that did'nt get updated for the services.

so the services are not running, i had to go to each service and update the new password, and started all of them and then the sql sderver with reporting services all are up.

Thanks.