Moving CRM and Reporting Services Backend to another Server

We are running SQL Server 2000 Standard Edition sp3a on a WIN2003 Server with 
CRM and Reporting Services installed all on the same box.  

I now need to move the CRM and Report Server SQL Server Backends to another 
Database Server (We want a Two Server deployment Model) 

What I have done so far is backup the two CRM Databases and the two 
Reporting Services Databases (and all associated User IDs) on the the Server 
containing the CRM and Reporting Services APPS AND the SQL Server Backend and 
Restored them to a new SQL Server Backend Server.   After doing this we 
successfully pointed the CRM app to the New Databases on the 2nd Server.

Now I'm not sure what to do with the Reporting Services peice of it !!!!

I found an article on how to move a Reporting Services Database 
http://support.microsoft.com/?kbid=842425

but it seems like some things are missing????

It say move a SQL Server 2000 Reporting Services Database to another 
computer and make Reporting Services point to that Database to do the 
following: 

Backup the ReportServer and ReportServerTempDB databases on the Source Server

Restore the Databases to a SQL Server Instance running on another Computer
(I did both of these steps and I also recreated all logins associated with 
CRM and Reporting Services on the new SQL Server

Next the Article says to make Reporting Services repoint to the database on 
the new sql server, run the  RSCONFIG command line Utility. Did this.

Now, I'm not sure what else I need to do.  There are a bunch of scheduled 
jobs on the original SQL Server that did not move  ie: MSCRM Identity 
Reseeding, MSCRM Index Reseeding, MSCRM Stored Procedure Priming

Do I need to move these Jobs? I'd like to uninstall the SQL Server on the 
CRM/Reporting Services Box at some point .... 

Should I backup MSDB on the Original Instance and restore it to the new SQL 
Server Backend...............

Also, how can I verify that moving the Reporting Services Backend peice of 
it worked?

Can anyone offer any suggestions?????

0
Utf
8/29/2006 6:23:02 PM
crm 35858 articles. 1 followers. Follow

4 Replies
640 Views

Similar Articles

[PageSpeed] 20

Are you able to open access Reporting Services directly?

If so, do you see the CRM reports?  

Once this is done, verify that Microsoft CRM is pointing to the correct URL 
for reporting services.    This can be done through the deployment manager on 
the application server.  

"itsonlyme4" wrote:

> We are running SQL Server 2000 Standard Edition sp3a on a WIN2003 Server with 
> CRM and Reporting Services installed all on the same box.  
> 
> I now need to move the CRM and Report Server SQL Server Backends to another 
> Database Server (We want a Two Server deployment Model) 
> 
> What I have done so far is backup the two CRM Databases and the two 
> Reporting Services Databases (and all associated User IDs) on the the Server 
> containing the CRM and Reporting Services APPS AND the SQL Server Backend and 
> Restored them to a new SQL Server Backend Server.   After doing this we 
> successfully pointed the CRM app to the New Databases on the 2nd Server.
> 
> Now I'm not sure what to do with the Reporting Services peice of it !!!!
> 
> I found an article on how to move a Reporting Services Database 
> http://support.microsoft.com/?kbid=842425
> 
> but it seems like some things are missing????
> 
> It say move a SQL Server 2000 Reporting Services Database to another 
> computer and make Reporting Services point to that Database to do the 
> following: 
> 
> Backup the ReportServer and ReportServerTempDB databases on the Source Server
> 
> Restore the Databases to a SQL Server Instance running on another Computer
> (I did both of these steps and I also recreated all logins associated with 
> CRM and Reporting Services on the new SQL Server
> 
> Next the Article says to make Reporting Services repoint to the database on 
> the new sql server, run the  RSCONFIG command line Utility. Did this.
> 
> Now, I'm not sure what else I need to do.  There are a bunch of scheduled 
> jobs on the original SQL Server that did not move  ie: MSCRM Identity 
> Reseeding, MSCRM Index Reseeding, MSCRM Stored Procedure Priming
> 
> Do I need to move these Jobs? I'd like to uninstall the SQL Server on the 
> CRM/Reporting Services Box at some point .... 
> 
> Should I backup MSDB on the Original Instance and restore it to the new SQL 
> Server Backend...............
> 
> Also, how can I verify that moving the Reporting Services Backend peice of 
> it worked?
> 
> Can anyone offer any suggestions?????
> 
0
Utf
8/29/2006 6:29:03 PM
I CANNOT see how to open Reporting Services Directly on my CRM Frontend 
Server?????  It is not on my START/PROGRAMS menu????

"dtu11" wrote:

> Are you able to open access Reporting Services directly?
> 
> If so, do you see the CRM reports?  
> 
> Once this is done, verify that Microsoft CRM is pointing to the correct URL 
> for reporting services.    This can be done through the deployment manager on 
> the application server.  
> 
> "itsonlyme4" wrote:
> 
> > We are running SQL Server 2000 Standard Edition sp3a on a WIN2003 Server with 
> > CRM and Reporting Services installed all on the same box.  
> > 
> > I now need to move the CRM and Report Server SQL Server Backends to another 
> > Database Server (We want a Two Server deployment Model) 
> > 
> > What I have done so far is backup the two CRM Databases and the two 
> > Reporting Services Databases (and all associated User IDs) on the the Server 
> > containing the CRM and Reporting Services APPS AND the SQL Server Backend and 
> > Restored them to a new SQL Server Backend Server.   After doing this we 
> > successfully pointed the CRM app to the New Databases on the 2nd Server.
> > 
> > Now I'm not sure what to do with the Reporting Services peice of it !!!!
> > 
> > I found an article on how to move a Reporting Services Database 
> > http://support.microsoft.com/?kbid=842425
> > 
> > but it seems like some things are missing????
> > 
> > It say move a SQL Server 2000 Reporting Services Database to another 
> > computer and make Reporting Services point to that Database to do the 
> > following: 
> > 
> > Backup the ReportServer and ReportServerTempDB databases on the Source Server
> > 
> > Restore the Databases to a SQL Server Instance running on another Computer
> > (I did both of these steps and I also recreated all logins associated with 
> > CRM and Reporting Services on the new SQL Server
> > 
> > Next the Article says to make Reporting Services repoint to the database on 
> > the new sql server, run the  RSCONFIG command line Utility. Did this.
> > 
> > Now, I'm not sure what else I need to do.  There are a bunch of scheduled 
> > jobs on the original SQL Server that did not move  ie: MSCRM Identity 
> > Reseeding, MSCRM Index Reseeding, MSCRM Stored Procedure Priming
> > 
> > Do I need to move these Jobs? I'd like to uninstall the SQL Server on the 
> > CRM/Reporting Services Box at some point .... 
> > 
> > Should I backup MSDB on the Original Instance and restore it to the new SQL 
> > Server Backend...............
> > 
> > Also, how can I verify that moving the Reporting Services Backend peice of 
> > it worked?
> > 
> > Can anyone offer any suggestions?????
> > 
0
Utf
8/30/2006 12:32:02 PM
try http://server/Reports/



itsonlyme4 wrote:
> I CANNOT see how to open Reporting Services Directly on my CRM Frontend
> Server?????  It is not on my START/PROGRAMS menu????
>
> "dtu11" wrote:
>
> > Are you able to open access Reporting Services directly?
> >
> > If so, do you see the CRM reports?
> >
> > Once this is done, verify that Microsoft CRM is pointing to the correct URL
> > for reporting services.    This can be done through the deployment manager on
> > the application server.
> >
> > "itsonlyme4" wrote:
> >
> > > We are running SQL Server 2000 Standard Edition sp3a on a WIN2003 Server with
> > > CRM and Reporting Services installed all on the same box.
> > >
> > > I now need to move the CRM and Report Server SQL Server Backends to another
> > > Database Server (We want a Two Server deployment Model)
> > >
> > > What I have done so far is backup the two CRM Databases and the two
> > > Reporting Services Databases (and all associated User IDs) on the the Server
> > > containing the CRM and Reporting Services APPS AND the SQL Server Backend and
> > > Restored them to a new SQL Server Backend Server.   After doing this we
> > > successfully pointed the CRM app to the New Databases on the 2nd Server.
> > >
> > > Now I'm not sure what to do with the Reporting Services peice of it !!!!
> > >
> > > I found an article on how to move a Reporting Services Database
> > > http://support.microsoft.com/?kbid=842425
> > >
> > > but it seems like some things are missing????
> > >
> > > It say move a SQL Server 2000 Reporting Services Database to another
> > > computer and make Reporting Services point to that Database to do the
> > > following:
> > >
> > > Backup the ReportServer and ReportServerTempDB databases on the Source Server
> > >
> > > Restore the Databases to a SQL Server Instance running on another Computer
> > > (I did both of these steps and I also recreated all logins associated with
> > > CRM and Reporting Services on the new SQL Server
> > >
> > > Next the Article says to make Reporting Services repoint to the database on
> > > the new sql server, run the  RSCONFIG command line Utility. Did this.
> > >
> > > Now, I'm not sure what else I need to do.  There are a bunch of scheduled
> > > jobs on the original SQL Server that did not move  ie: MSCRM Identity
> > > Reseeding, MSCRM Index Reseeding, MSCRM Stored Procedure Priming
> > >
> > > Do I need to move these Jobs? I'd like to uninstall the SQL Server on the
> > > CRM/Reporting Services Box at some point ....
> > >
> > > Should I backup MSDB on the Original Instance and restore it to the new SQL
> > > Server Backend...............
> > >
> > > Also, how can I verify that moving the Reporting Services Backend peice of
> > > it worked?
> > > 
> > > Can anyone offer any suggestions?????
> > >

0
DerekH
8/31/2006 7:50:05 AM
Thanks so much ! But I need some more help!!!!!

http://server/reports Gives me a page Titled SQL Server Reporting Services 
and it has a ton of titles in the body of the page: Account Activity, Account 
Distribution, Account Overview..  Am I right in thinking that these are the 
'canned reports' that come with Reporting Services? Well..... when I click on 
ANY of them, I get the following error: 

"The property ‘nullable’ of report parameter ‘CRM_Locale’ is set to false. 
However, the corresponding parameter (default) value is null or contains an 
empty string. (rsProcessingError)"



"DerekH" wrote:

> try http://server/Reports/
> 
> 
> 
> itsonlyme4 wrote:
> > I CANNOT see how to open Reporting Services Directly on my CRM Frontend
> > Server?????  It is not on my START/PROGRAMS menu????
> >
> > "dtu11" wrote:
> >
> > > Are you able to open access Reporting Services directly?
> > >
> > > If so, do you see the CRM reports?
> > >
> > > Once this is done, verify that Microsoft CRM is pointing to the correct URL
> > > for reporting services.    This can be done through the deployment manager on
> > > the application server.
> > >
> > > "itsonlyme4" wrote:
> > >
> > > > We are running SQL Server 2000 Standard Edition sp3a on a WIN2003 Server with
> > > > CRM and Reporting Services installed all on the same box.
> > > >
> > > > I now need to move the CRM and Report Server SQL Server Backends to another
> > > > Database Server (We want a Two Server deployment Model)
> > > >
> > > > What I have done so far is backup the two CRM Databases and the two
> > > > Reporting Services Databases (and all associated User IDs) on the the Server
> > > > containing the CRM and Reporting Services APPS AND the SQL Server Backend and
> > > > Restored them to a new SQL Server Backend Server.   After doing this we
> > > > successfully pointed the CRM app to the New Databases on the 2nd Server.
> > > >
> > > > Now I'm not sure what to do with the Reporting Services peice of it !!!!
> > > >
> > > > I found an article on how to move a Reporting Services Database
> > > > http://support.microsoft.com/?kbid=842425
> > > >
> > > > but it seems like some things are missing????
> > > >
> > > > It say move a SQL Server 2000 Reporting Services Database to another
> > > > computer and make Reporting Services point to that Database to do the
> > > > following:
> > > >
> > > > Backup the ReportServer and ReportServerTempDB databases on the Source Server
> > > >
> > > > Restore the Databases to a SQL Server Instance running on another Computer
> > > > (I did both of these steps and I also recreated all logins associated with
> > > > CRM and Reporting Services on the new SQL Server
> > > >
> > > > Next the Article says to make Reporting Services repoint to the database on
> > > > the new sql server, run the  RSCONFIG command line Utility. Did this.
> > > >
> > > > Now, I'm not sure what else I need to do.  There are a bunch of scheduled
> > > > jobs on the original SQL Server that did not move  ie: MSCRM Identity
> > > > Reseeding, MSCRM Index Reseeding, MSCRM Stored Procedure Priming
> > > >
> > > > Do I need to move these Jobs? I'd like to uninstall the SQL Server on the
> > > > CRM/Reporting Services Box at some point ....
> > > >
> > > > Should I backup MSDB on the Original Instance and restore it to the new SQL
> > > > Server Backend...............
> > > >
> > > > Also, how can I verify that moving the Reporting Services Backend peice of
> > > > it worked?
> > > > 
> > > > Can anyone offer any suggestions?????
> > > >
> 
> 
0
Utf
9/5/2006 4:34:02 PM
Reply:

Similar Artilces:

report writer #3
I have installed project management and fixed asset modules along with the default modules of Great Plains version 8. The report writer option does not seem to be working after this I resinstalled the whole application today and found report writer working after creating a sample company. On installing project management, the problem continues to persist I am using windows 2000 server. I have also installed service pack 2 of version 8 GP Anybody else facing the same problem Dear Krishna, Can you Specify more details about what do you mean by report writer options does not seem to workin...

Rename GP 9.0 Server and Domain Name Change
I plan on re-naming the server name hosting my GP 9.0 server. I am also going to change server domain names. Can you offer me any insight to changes I will need to make? What problems will I run into? Any articles out there that can help me out on this? Jeff, Renaming the server will cause problems with SQL. You will want to check SQL documentation on how to change the server name......if it is possible. You may be looking at reinstalling SQL ? "Jeff" wrote: > I plan on re-naming the server name hosting my GP 9.0 server. I am also > going to change server domai...

Hosted Project Server 2007 / 2010
Hi- Anyone currently using a hosted instance of Project Server 2007? I would be interested in your experiences regarding how well the solution is working for you has it been cheaper than hosting internally your experiences re service packs, CUs, server patch levels etc. vendor resopnse to issues connectivity issues customizability (can you do your own or does vendor need to do them) security backup / restore surprises (hidden costs, inability to do expected functions) We are seriously looking at the costs of moving to 2010 (Sharepoint Enterprise CALS, etc.) and hosting may b...

GP 8.0 + SQL Server 2000 SP4 (installing SP 4)
Hello there, We have running the GP 8.0 on a SQL Server 2000 database with no service pack. I've just downloaded the SQL Server 2000 SP 4 and I'm planning to upgrade the database. I'm concerning as to whether or not there might be side effects on the GP functionality if I install the SQL Server SP 4. Is it safe to make this upgrade ? or Are there some technical issues ? Thanks in advance. Kind regards Cesar I've been running sp4 for months with GP 8, sp2, and I've had no problems. ...

CRM SBS install and uninstall error
The install (reinstall) or uninstall MS CRM 3.0 on SBS2003 Premium does not work. During "Executing Install (or Uninstall) action" I receive Warning: "Failed to remove the Microsoft CRM-Fax Router Service" and then Error: "System.Exception: Action Microsoft.Crm.Setup.Server.RegisterFaxService failed." "The configuration registry key is invalid". How can I uninstall CRM completely or install it properly? Help me please. Any suggestion will be appreciated. Regards Renio ...

I can't get Outlook to connect to an IMAP4 server
I'm trying to connect Outlook 2000 SP3 (Windows XP Pro, all patches installed, 700 MHz Pentium III, 320 Mb RAM) to Mercury/32 v. 4.01 (Windows 2000 Pro, all patches installed, 350 MHz, 416 Mb RAM). The machines are on a small network running Ethernet (100Base-T full duplex) using a Linksys router/switch. The IMAP server PC has a static IP (192.168.1.222) - the Outlook machine does not. I know that the static IP is correct - can connect to Mercury's HTTP server by pointing Internet Explorer 6 at the IP. I have two problems: 1. When I create an IMAP account, I do not get an...

Looking for detailed information on MS CRM
hello, where can i get _detailed_ information on the current and the expected new version of ms crm? topics of interest would be - work on-/offline (data replication from server to client pc) - user privileges (who sees what field of a customer, user roles) - sync conflicts the ms site provides only very basic information. thanks a lot, michael Hi Michael! "Michael Fuchs" wrote: > where can i get _detailed_ information on the current and the expected > new version of ms crm? > topics of interest would be > > - work on-/offline (data replication from server to c...

Multi-Server jobs do not run on master server MSX
Hello I defined one of my server as master server (MSX) for multi-server jobs. 3 other servers (in fact: instances) are defined as target. My problem is that some jobs are defined as Multi-Server jobs, but I cannot make them run on the MSX, except if I also create the same job for local use, which I think is a bit stupid. Of course, I cannot enlist a target as master. So how to make jobs that run locally AND on targets ? Pierrot ...

server error 03-01-10
i keep getting this error and i dont know how to fix it The host 'pop3' could not be found. Please verify that you have entered the server name correctly. Account: 'Windowa Mail', Server: 'pop3', Protocol: POP3, Port: 995, Secure(SSL): Yes, Socket Error: 11001, Error Number: 0x800CCC0D "d" <d@discussions.microsoft.com> wrote in message news:906AB3BC-7B68-42EB-8A09-45A341BECD31@microsoft.com... >i keep getting this error and i dont know how to fix it > > The host 'pop3' could not be found. Please verify that you have en...

Installing Service Packs on Exchange Server 2003
Have one Exchange 2003 front End server and two Exchange 2003 back end servers. Have not installed any service packs on these systems yet. Just got OK from change control board to install these. Just wanted to know what would be the best process to install these ? Do I need to go to SP1 first then SP2 or does SP2 contain SP1 updates as well? Do I do the front end server first? Thanks! On Wed, 31 May 2006 12:58:02 -0700, D303M <D303M@discussions.microsoft.com> wrote: >Have one Exchange 2003 front End server and two Exchange 2003 back end >servers. Have not installed any s...

police reports
wednesday oct. 27 voreis was registered as a___offender 10:32 am 12/14/09 "jeramie francis" wrote: > > wednesday oct. 27 > > voreis was registered as a___offender 10:32 am > > 12/14/09 ...

when sedning email msg in pub
Please help. We no longer have our old email account. When publisher is directed to send publication as message it automatically pulls up our old address and won't send the message through windows live mail. IT will send as attachment but not as message. I just need to know hwo to direct publisher to use my current email address as the sender. Publihser 2007 Have you looked at the Live Mail Help? There is a pictoral tutorial here http://www.huskeraccess.com/index.php?option=com_content&view=article&id=51 "Robin1only" wrote: > Please help. We no longer have ou...

RE: Limit records shown per report
Information per Karl Dewey's request Query for report is named Bart S1 report: SELECT [Customer Information].Customer_ID, [Customer Information].Customer, [Bart S1].Service_Address, [Bart S1].Employee, [Service Address].Manager, ServiceRequirements2.Type_of_System, ServiceRequirements2.Raw_Water, ServiceRequirements2.Treated_Water, ServiceRequirements2.Cycles, ServiceRequirements2.Inhibitor_Level, ServiceRequirements2.Range_1, ServiceRequirements2.Range_2, ServiceRequirements2.Range_3, ServiceRequirements2.Range_4, ServiceRequirements2.Range_5, 1 AS ZZZ FROM ServiceRequi...

Use of Discovery service in IFD scenario
We have problem using the discovery service "/2007/SPLA/CrmDiscoveryService.asmx". What we've done is to change the anonymous IIS account. With the original setup we receive a 401.1 http error (not authorize). We tried to check "integrated security" in IIS and the behavior change : IIS ask for a login but whatever the account used IIS does not give access. We suspect our problem is that our anonymous account doesn't have sufficient right. We use "filemon" to check the NTFS security but everything look right with our anonymous account. Is there...

PDF not an option in file type in reports
I have installed the full version of Acrobat 5. Even installed Acrobat PDFWriter Files. However, still the dropdown on file types in reports does not contain pdf. Please let me know what steps am I missing. ...

SMTP VIRTUAL Server
Hello all, I have a brand new Exchange 2003 Enterprise server that works fine. The problem is that whenever I restart the server or cold boot, the Default SMTP virtual Server in Exchange System Manager (under protocols) has to be stopped and started manually. I have the service pack and hotfix loaded. Any suggestions? Thank you I would check your Event Viewer Application log for any errors after your reboot. -- John Oliver, Jr. MCSE, MCT, CCNA, Exchange MVP Microsoft Certified Partner "Tpoole" <tpoole89@hotmail.com> wrote in message news:OZlVjASaEHA.1488@TK2MSFTNGP09.ph...

kernel mode cryptographic services on Windows 7
Could someone please point me to a link decribing kernel mode cryptographic services on Windows 7? Basically all I need to do is create a sha1 hash of some data. I am aware of this link discussing fips.sys on earlier versions of Windows: http://technet.microsoft.com/en-us/library/cc750356.aspx. But I thought that wasn't supported. I also see the BCrypt* functions. But that seems to be encryption. Thanks in advance if anyone can help. Regards, George. Oh. Maybe I can use BCrypt: http://msdn.microsoft.com/en-us/library/aa375534(v=VS.85).aspx. Thanks anyw...

/r/n (13-10) (carriage return
Hi, A few days go I fiund iut that the xmlserializer strips away /r/n out during deserialization (and just leave /n) ... I found out that you can resolve this problem using the deserialize overlaod that takes an xmltextreader instead of a stream .. However when it's time to Web Services you have no such a control over the deserialization phase AND I found out that WS strips out /r/n (an leave /n) ... I understand there are some XMl specs related to this .. however . what one should do to have a /r/n sequence into a string property of his own custom object ? I saw that writing /r/n...

DPM 2007 SP1: Windows Server 2008 R2: Could not connect to SQL Server Reporting Server because of IIS Connectivity issues
Hi, I'm experiencing "Could not connect to SQL Server Reporting Server because of IIS Connectivity issues" and checked the wildcard script mappong permission for ISAPI Extentions in IIS 7: http://technet.microsoft.com/en-us/library/bb795696.aspx Actually in my Windows Server 2008 R2 this was already ok But still it does not work. Did anybody get this to run? Thanks, Adrian Adrian Miller ...

ftp server
hi everybody I need to create a ftp server on a pc. The pc will: wait for a ftp connection from a remote computer accept or refuse that client do ftp stuff like get put delete files, for example I look into msdn and find nothing for now. Any clue will be appreciated. Thanks! -- Normand Bilodeau There are a HUGE number of really good FTP servers available free; why write one? joe On Wed, 7 Feb 2007 20:35:58 -0500, "Normand" <n_bilodeau@videotron.ca> wrote: >hi everybody >I need to create a ftp server on a pc. >The pc will: > wait for a ft...

Share point installation on windows server 2008 R2
I have registered for MS partnership programs and gat the setup CD for Windows Server 2008 R2 and installed it. I have even the sharepoint Installation cd 64-bit. When I tried to install the sharepoint server I got the exception as there are compatibility issues. I have also searched for a solution on microsoft site and I was told that I should install WSS3.0. I have downloaded it and installed. After installation, the sharepoint server also got installed and when I try to add any new document under shared Documents section, I am getting an exception. Would any one help me in ...

moving hotmail messages to main folder
I am using outlook and hotmail. I have outlook set up to retrieve my hotmail, but it is in a seperate folder listed "hotmail" not the main inbox one. I would like to find a way to automatically copy/move the emails from the hotmail inbox to the main inbox.......is this posible? thanks ...

Update from CRM 3.0 to new CRM 4.0
At the moment we are runnig CRM 3.0. Because of the new multi-language feature of CRM 4.0 we want tu upgrate/update to the new version. Does anybody has further information about the necessary steps? I suggest that you wait for the officially released version which will contain upgrade and installation guides. -- ----------------- Please note that the contents of my posts are my personal opinions and views and I am not a Microsoft staff member. ----------------- Feridun Kadir MCSE, MCT "Frank_Munich" wrote: > At the moment we are runnig CRM 3.0. Because of the new multi-...

MS CRM 3.0 on SQL Cluster 2000 Environment...
Has anyone installed MSCRM 3.0 on SQL 2000 Cluster and it is up and running with Reports, Outlook Client etc etc? CRM 3.0 supports only default instance on SQL Server. How about SQL Cluster? Is there any good document to implement CRM 3 in SQL Server 2000 cluster environment? I appreciate your help. Onkar http://www.microsoft.com/dynamics/crm/using/deploy/clusteringsqlservers.mspx "Onkar" <budc57@yahoo.com> wrote in message news:1160873095.913396.268610@b28g2000cwb.googlegroups.com... > Has anyone installed MSCRM 3.0 on SQL 2000 Cluster and it is up and > running wi...

Merging two reports
Hi, I have two reports based from the same query. In the first report, I filter a field called PING for fail. In the second report, I filter a field called UP for fail. What I would like to do is combine these reports so that in the fist section, the filter is set for the PING field. And in the second section, the filter is set for the UP field. Can these reports have independent sections based on one query, but different filters in each section? How do I achieve this? Any assistance is always greatly appreciated. Cheers, GLT. GLT, What do you mean by "...