Exchange Server or NS filtering email addresses?

My Notification Services (NS 2.0 SP1) application works fine, except one big problem:

I am using a built-in SMTP provider, and notifications are delivered ONLY to those subscribers who have email addresses within our company's domain.

That is, all subscribers with addresses like someone@.ourcompany.com always get their notifications, whereas any other email addresses do not work. I tried my gmail.com, aim.com, and optonline.net email addresses, and none of them ever received a notification, not even once.

As soon as I change a particular subscriber's email address from whatever to anybody@.ourcompany.com (whether I do it via SMI or directly in the NS subscribers table, does not matter), it works again.

So, something is filtering emails based on the recipients' addresses.
I do not know for sure whether it's done by NS or by the SMTP server, but the situation is the same regardless of whether I use my local machine's SMTP server or our company's MS Exchange Server 5.5 (I specify it only in the InstanceConfiguration.xml file).

Could someone point me in the right direction as to where to look for what's causing this kind of filtering, please?

Thank you very much!Answering my own question...
Here's what the Exchange Server 5.5 returns in an exception message:
The server rejected one or more recipient addresses. The server response was: 550 Relaying is prohibited.
It's a spam-filtering -related feature.

Exchange Report Pack

We have a Two Server Deployment: CRM, Reporting Services and IIS on
one Server and our SQL Server 2000 Backend on another Server - which
happends to be a Named Instance.
Because we have a Named Instance as our SQL Server backend......In
order to get Reporting Services to work correctly, we had temporarily
disable the EDW (Environmental Diagnostics Wizard) in CRM using a
registry key change in order for the the 'canned' CRM Reports to work
against our SQL Named Instance (see this link for more info on this
http://blogs.msdn.com/ukcrm/archive/2006/08/17/704229.aspx)
Well... now I am attempting to get the reports in the Exchange Report
Pack for Reporting Servives to work. What I did so far was: Turned off
EDW in the registry on the CRM Server, installed the Exchange Report
Pack, attached the Sample Databases to my CRM named Instance, created
an ODBC connection to the sample Exchange database, and uiploaded the
Reports from the Report Pack and configured them to use the ODBC
connection to the Sample database. Now when I try and run any of the
Exchange Reports, I get this error:
An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
Cannot create a connection to data source 'SSW Exchange Reporter'.
(rsErrorOpeningConnection) Get Online Help
Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection.
Has anyone gotten this to work or can anyone help'?Are you sure that this isn't a simple double-hop problem?
We should ask our Active Directory Wizards what they know about
double-hop and then run this by them if they look at us with a blank
stare
http://blogs.msdn.com/sql_protocols/archive/2006/08/10/694657.aspx
(4) The user's domain account must NOT select "Account is
sensitive and cannot be delegated" in its Active Directory properties
of domain D. Please refer to [1] on how to configure this on Active
Directory machine.
(5) The service account under which the SQL instance is running must
be "trusted for delegation", configured in Active Directory. If the
service is running as "NT AUTHORITY\SYSTEM" or "NT
AUTHORITY\NETWORK SERVICE", the computer must be "trusted for
delegation". Please refer to [1] on how to configure this on Active
Directory Machine. You need to have domain admin privilege to do/verify
so.
Also; I think that we may need to run 'setspn' with the service account
for the sql box in order to allow it to participate in a double-hop
authentication..
Janice wrote:
> We have a Two Server Deployment: CRM, Reporting Services and IIS on
> one Server and our SQL Server 2000 Backend on another Server - which
> happends to be a Named Instance.
> Because we have a Named Instance as our SQL Server backend......In
> order to get Reporting Services to work correctly, we had temporarily
> disable the EDW (Environmental Diagnostics Wizard) in CRM using a
> registry key change in order for the the 'canned' CRM Reports to work
> against our SQL Named Instance (see this link for more info on this
> http://blogs.msdn.com/ukcrm/archive/2006/08/17/704229.aspx)
> Well... now I am attempting to get the reports in the Exchange Report
> Pack for Reporting Servives to work. What I did so far was: Turned off
> EDW in the registry on the CRM Server, installed the Exchange Report
> Pack, attached the Sample Databases to my CRM named Instance, created
> an ODBC connection to the sample Exchange database, and uiploaded the
> Reports from the Report Pack and configured them to use the ODBC
> connection to the Sample database. Now when I try and run any of the
> Exchange Reports, I get this error:
> An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> Cannot create a connection to data source 'SSW Exchange Reporter'.
> (rsErrorOpeningConnection) Get Online Help
> Login failed for user '(null)'. Reason: Not associated with a trusted
> SQL Server connection.
> Has anyone gotten this to work or can anyone help'?

Exchange Pack for Reporting Services

Has anyone successfully installed the Exchange Pack for Reporting Services?
I've attempted a couple of times and continue to get "Object Reference not
set to an instance of object", which causes the install to rollback.
Does anyone know how to correct this problem?
Thanks.Several others are having the same problem. I haven't found a fix yet.
It seems the version available on SSW's site is different and
time-limited.|||Any updates on this that you know of? I am seeing the same issue.
"bret@.fishbrains.com" wrote:
> Several others are having the same problem. I haven't found a fix yet.
> It seems the version available on SSW's site is different and
> time-limited.
>

Exchange Pack for Reporting Services

Is there any way to get data from a real install of Exchange into the
database for the Exchange Pack for Reporting Services, or is it just to look
at pretty reports that mean nothing to us?
Am I missing something here?
MichaelThe goal of the report packs is to show reports one might write using
reporting services. It is not necessarily to ship solutions that monitor
the specified application. This particular report pack contains a reference
to a tool from SSW for a product they support for extracting data about
exchange. This could be a start. Alternatively, you can use an ETL tool
such as DTS to do so, though I'm sure tools such as SSW Exchange Extraction
Service provide additional analytics.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
<michael@.civis.com> wrote in message
news:OUTh16MBFHA.1392@.tk2msftngp13.phx.gbl...
> Is there any way to get data from a real install of Exchange into the
> database for the Exchange Pack for Reporting Services, or is it just to
> look
> at pretty reports that mean nothing to us?
> Am I missing something here?
> Michael
>

Excessively long string

On my form I have a web control that shows my report services report. When I
click on the printer button I get the error "An error has occurred trying to
get the current window.", then the next error, "A Runtime Error has occurred.
Do you wish to Debug? Line: 25 Error: Marshaler restriction: Excessively long
string."Hello Mike,
Before we go further on this issue, I'd like to know which web control you
use to show reports? Is it Web browser control? Does the issue occurs on
different reports? If you use a simple report with some textboxes, can you
reproduce the issue? Do you have RS 2005 sp1 installed?
Based on my research, you may have encountered the following known issue
913771 FIX: You may receive an error message when you try to print a SQL
Server
2005 Reporting Services report from a WebBrowser control
<http://support.microsoft.com/default.aspx?scid=kb;EN-US;913771>
This issue is fixed in SRS 2005 sp1. If you did not have applied sp1,
please go to the following link to get it
http://www.microsoft.com/downloads/details.aspx?FamilyId=CB6C71EA-D649-47FF-
9176-E7CAC58FD4BC
If you need any further help, please feel free to let's know. Thank you!
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||SP fixed it. Thanks.
"Peter Yang [MSFT]" wrote:
> Hello Mike,
> Before we go further on this issue, I'd like to know which web control you
> use to show reports? Is it Web browser control? Does the issue occurs on
> different reports? If you use a simple report with some textboxes, can you
> reproduce the issue? Do you have RS 2005 sp1 installed?
> Based on my research, you may have encountered the following known issue
>
> 913771 FIX: You may receive an error message when you try to print a SQL
> Server
> 2005 Reporting Services report from a WebBrowser control
> <http://support.microsoft.com/default.aspx?scid=kb;EN-US;913771>
> This issue is fixed in SRS 2005 sp1. If you did not have applied sp1,
> please go to the following link to get it
> http://www.microsoft.com/downloads/details.aspx?FamilyId=CB6C71EA-D649-47FF-
> 9176-E7CAC58FD4BC
> If you need any further help, please feel free to let's know. Thank you!
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications
> <http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscriptions/support/default.aspx>.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>

excessive sending package from the sqlserver

The users reported excessive sending package from the sqlserver, we intented down the services but we can't
The server administrator rebooted the server and the network was stable
What do you think about it?
Sounds suspiciously like a Slammer infection. I'd suggest you take a
look here http://www.microsoft.com/security/incident/slammer.mspx and
make sure your servers are patched correctly.
g.
http://www.sqlskunkworks.com
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

excessive sending package from the sqlserver

The users reported excessive sending package from the sqlserver, we intented
down the services but we can't
The server administrator rebooted the server and the network was stable
What do you think about it?Sounds suspiciously like a Slammer infection. I'd suggest you take a
look here http://www.microsoft.com/security/incident/slammer.mspx and
make sure your servers are patched correctly.
g.
http://www.sqlskunkworks.com
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

EXCEPTION_ACCESS_VIOLATION when installing June CTP

Hi - I'm trying to install June CTP on Win2k3 SP1.
Setup failed when trying to start services for configuration.
In log files I found the following
Computer type is AT/AT COMPATIBLE.
Bios Version is INSYDE - 1
Insyde Software MobilePRO BIOS Version 4.00.01
Current time is 11:26:54 08/30/05.
1 Intel x86 level 15, 3 Mhz processor (s).
Windows NT 5.2 Build 3790 CSD Service Pack 1.

Memory
MemoryLoad = 57%
Total Physical = 959 MB
Available Physical = 408 MB
Total Page File = 2329 MB
Available Page File = 1812 MB
Total Virtual = 2047 MB
Available Virtual = 1014 MB
***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\log\SQLDump0001.txt
SqlDumpExceptionHandler: Process 5180 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server i
s terminating this process.
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 08/30/05 11:26:54 spid 0
*
*
* Exception Address = 77BD8944 (strncmp + 00000014)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00330072
*
* MODULE BASE END SIZE
* sqlservr 00400000 01DDEFFF 019df000
* Invalid Address 7C800000 7C8BFFFF 000c0000
* kernel32 77E40000 77F41FFF 00102000
* ADVAPI32 77F50000 77FEBFFF 0009c000
* RPCRT4 77C50000 77CEEFFF 0009f000
* CRYPT32 761B0000 76242FFF 00093000
* MSASN1 76190000 761A1FFF 00012000
* msvcrt 77BA0000 77BF9FFF 0005a000
* USER32 77380000 77411FFF 00092000
* GDI32 77C00000 77C47FFF 00048000
* MSVCP80 7C420000 7C4A4FFF 00085000
* MSVCR80 7C370000 7C408FFF 00099000
* MSWSOCK 71B20000 71B60FFF 00041000
* WS2_32 71C00000 71C16FFF 00017000
* WS2HELP 71BF0000 71BF7FFF 00008000
* NETAPI32 71C40000 71C97FFF 00058000
* opends60 41060000 41065FFF 00006000
* Secur32 76F50000 76F62FFF 00013000
* SHLWAPI 77DA0000 77DF1FFF 00052000
* USERENV 76920000 769E3FFF 000c4000
* psapi 76B70000 76B7AFFF 0000b000
* instapi 02310000 02318FFF 00009000
* sqlevn70 41070000 411ECFFF 0017d000
* SQLOS 02350000 02354FFF 00005000
* rsaenh 68000000 6802EFFF 0002f000
* AUTHZ 76C40000 76C53FFF 00014000
* MSCOREE 78800000 7883FFFF 00040000
* ole32 77670000 777A3FFF 00134000
* msv1_0 76C90000 76CB6FFF 00027000
* iphlpapi 76CF0000 76D09FFF 0001a000
* kerberos 71CA0000 71CF7FFF 00058000
* cryptdll 766E0000 766EBFFF 0000c000
* schannel 76750000 76776FFF 00027000
* security 71F60000 71F63FFF 00004000
* VERSION 77B90000 77B97FFF 00008000
* dssenh 68100000 68123FFF 00024000
* hnetcfg 5F270000 5F2C8FFF 00059000
* wshtcpip 71AE0000 71AE7FFF 00008000
* DNSAPI 76ED0000 76EF8FFF 00029000
* winrnr 76F70000 76F76FFF 00007000
* WLDAP32 76F10000 76F3DFFF 0002e000
* rasadhlp 76F80000 76F84FFF 00005000
* ntdsapi 766F0000 76704FFF 00015000
* dbghelp 3FA40000 3FB49FFF 0010a000
*
* Edi: 00330072:
* Esi: 00330072:
* Eax: 00000000:
* Ebx: 00000008:
* Ecx: 00000008:
* Edx: 01020001: EC83EC8B 78816608 53008002 820F5756 000000A3 8510508D
* Eip: 77BD8944: D9F7AEF2 FE8BCB03 F30C758B FF468AA6 473AC933 740577FF
* Ebp: 3F6EF3A8: 3F6EF3E4 766F4FF6 00330072 766F4F84 00000008 0194A7FC
* SegCs: 0000001B:
* EFlags: 00010246: 00730075 00650074 005C0072 006C0063 00730075 00650074
* Esp: 3F6EF39C: 3F6EF410 77BD8930 766F4F84 3F6EF3E4 766F4FF6 00330072
* SegSs: 00000023:
* *******************************************************************************
* -
* Short Stack Dump
Any help will be appreciated.The AV is happening in the SQL Server engine. I've moved your post to the SQL DB Engine forum. Maybe someone here can help you.

Dan|||Alexandr,

Are you still getting this error? Can you start the service manually?

From the fragment of the output you have provided there is no way to tell what is wrong.

We either need a full dump file (C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\log\SQLDump0001.txt) or paste Short Stack Dump.

Regards,
Boris.|||Thanks for reply Boris.
I have reinstalled SQL Server on a brand new OS and it works fine now.

With the previous installation - i cannot start service manually - it gives the same error. I've tried to install SQL Express - and it gives the same error again.
I tried to start SQL Server even not as a service but as a console app - and it gives that error.
That may be happend because I already has installed SQL 2000 and MSDE on my PC.

Regards,
Alexandr.|||Alexandr,

An instance of SQL Server 2005 should coexist just fine with SQL Server 2000. I don't think that is the reason for the AV you were getting, although this is just a guess.

Since you have reinstalled the OS, I wonder if you have kept the dump file(s) that were created when the server generated the AV.

If yes, could you paste short stack dump here and we can take a further look.

Thank you,
Boris.|||Boris,

SQLServer 2005 works fine with SQL 2000 installed on the same box.
I haven't kept the stack dump or log files.

Thanks,
Alexandr.

Exception of type System.OutOfMemoryException was thrown

Hi,
Once in a while I get this error when working in reporting services
I am unable to save the changes made if I get this error
I increased PF Usage Memory size, but that does not work
can someone help me with this
Thanks
PonnurangamHi Ponnurangam,
I have seen the same issue. I believe that the MS Development Environment
for Reporting Services has a memory leak. I was cutting and pasting items
and watched the resident memory of the program grow by over 100 megs.
I work around this by occasionally shutting down the MSDE and coming back in.
Not sure if a fix is in the works. Hopefully so!
"Ponnurangam" wrote:
> Hi,
> Once in a while I get this error when working in reporting services
> I am unable to save the changes made if I get this error
> I increased PF Usage Memory size, but that does not work
> can someone help me with this
> Thanks
> Ponnurangam
>
>

Exception Has been thrown by the target of an invocation

Getting this error "Exception Has been thrown by the target of an invocation" when trying to create Integration Services Project. Any ideas what can be wrong?

Thanks.

I am receiving the same issue... were you able to solve this?|||In our case the problem was related to the installation image we used to setup our computers (every PC that used that image had the problem).

Exception Has been thrown by the target of an invocation

Getting this error "Exception Has been thrown by the target of an invocation" when trying to create Integration Services Project. Any ideas what can be wrong?

Thanks.

I am receiving the same issue... were you able to solve this?|||In our case the problem was related to the installation image we used to setup our computers (every PC that used that image had the problem).

Exception Has been thrown by the target of an invocation

Getting this error "Exception Has been thrown by the target of an invocation" when trying to create Integration Services Project. Any ideas what can be wrong?

Thanks.

I am receiving the same issue... were you able to solve this?|||In our case the problem was related to the installation image we used to setup our computers (every PC that used that image had the problem).

excell export doesn't work

I have a report with multiple tables, when I trie to export this report to
excell
it reporting services returns an error message:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. (rrRenderingError) Get Online Help
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
Index was out of range. Must be non-negative and less than the size of the
collection. Parameter name: index
can anybody help me solve this?"Dirkjan van Groeningen" <DirkjanvanGroeningen@.discussions.microsoft.com>
wrote in message news:F60A2429-8A44-4DE7-B162-D29FB36091E2@.microsoft.com...
>I have a report with multiple tables, when I trie to export this report to
> excell
> it reporting services returns an error message:
>
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. (rrRenderingError) Get Online Help
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown.
> Index was out of range. Must be non-negative and less than the size of the
> collection. Parameter name: index
> can anybody help me solve this?
Hi, I have the same problem. I have post this issue here 3 times with no
meaningful help.
Please post back if you find a solution.
Good luck,
Bryan

Excel XP - Cannot connect to OLAP 9 - Analysis Services 2005

MS Excel XP on Windows 2000 fails to connect to OLAP 2005 Cube with the OLAP 9 Provider. Excel gives the error: <initialisering datasource failed>. The same error appears when I try to connect to OLAP 8 cubes. Before I could access OLap 8 cube, I had to reinstall Office XP.

Windows XP with Office 2003 works fine. It can access both OLAP 8.0 and OLAP 9.0 cubes.

Does the new OLAP 9.0 provider only works with Office 2003?

Best regards,

Jakobsgaard

I have been investigating a bit more in this matter...The PC which is giving os all this trouble are running Windows 2000 with Office XP SP3.

If I registre msolap90.dll, both MS Olap 8.0 and MS Olap 9.0 fails with the error: <initialisering datasource failed> when I connect to a cube from MS Excel.

But if I only registre msolap80.dll, MS Olap 8.0 works fine again.

Best regards,

Jakobsgaard
-
regsvr32 "c:\program files\common files\system\ole db\msolap90.dll"
regsvr32 "c:\program files\common files\system\ole db\msolap80.dll"
|||

Windows 2000 does not have MSXML6 by default and Office XP does not install it (Office 2003 does install MSXML5 which the 9.0 provider is able to use, in the absence of MSXML6).

Installing MSXML6 solved the problem.

|||We are receiving a similiar error but are using Office 2003.

Did you hear anything from anyone else?

Mark e. Johnson|||Suresh Bansal Stated the following in a further post:

"ok i found the solution. we need to reregister the olap 9.0 provider before we can use it to connect SQL Server 2005 Analysis Service Cube with Excel Pivot Table :
regsvr32 "c:\program files\common files\system\ole db\msolap90.dll"
"

This did the trick for us.

|||THANKS A LOT THAT SOLVED MY PROBLEM!!

Excel reports to RS

We have several extensive reports in Excel that I
would like to port over to Reporting Services (am in process of testing
SQL/RS 2005), if at all possible. From what I understand, the only way to do
this is via a third party piece of software, such as OfficeWriterSE for
ASP by softartisans.com...
A couple questions:
1. Is there an open source alternative to the commercial third party
software (the cost of OfficeWriterSE is way beyond our budget)?
2. Does Microsoft plan on ever offering the capability of importing Excel
reports into RS? (I do like the ability of importing Access report
objects, so why not expand to Excel and Word too)?
3. Should I just forget the whole thing?
TIA!
Greg--My guess is that you should give it up. My guess is the 3rd party tool
allows you to create reports in Excel that are RS reports, not that it
importants existing Excel sheets into RS. Excel has an ability to be
unstructured that RS does not have which make it in my mind highly unlikely
you will ever see a tool from MS to do what you want. Access is very
structured (it is a database product after all) which is why they could
import Access reports.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"gms" <gms@.discussions.microsoft.com> wrote in message
news:5C29B68B-A8CB-458B-BC1F-C061ABC70F49@.microsoft.com...
> We have several extensive reports in Excel that I
> would like to port over to Reporting Services (am in process of testing
> SQL/RS 2005), if at all possible. From what I understand, the only way to
> do
> this is via a third party piece of software, such as OfficeWriterSE for
> ASP by softartisans.com...
> A couple questions:
> 1. Is there an open source alternative to the commercial third party
> software (the cost of OfficeWriterSE is way beyond our budget)?
> 2. Does Microsoft plan on ever offering the capability of importing Excel
> reports into RS? (I do like the ability of importing Access report
> objects, so why not expand to Excel and Word too)?
> 3. Should I just forget the whole thing?
> TIA!
> Greg--|||I guess I knew the answer all along! At lest this confirms it.
Thanks!
Greg--
"Bruce L-C [MVP]" wrote:
> My guess is that you should give it up. My guess is the 3rd party tool
> allows you to create reports in Excel that are RS reports, not that it
> importants existing Excel sheets into RS. Excel has an ability to be
> unstructured that RS does not have which make it in my mind highly unlikely
> you will ever see a tool from MS to do what you want. Access is very
> structured (it is a database product after all) which is why they could
> import Access reports.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "gms" <gms@.discussions.microsoft.com> wrote in message
> news:5C29B68B-A8CB-458B-BC1F-C061ABC70F49@.microsoft.com...
> > We have several extensive reports in Excel that I
> > would like to port over to Reporting Services (am in process of testing
> > SQL/RS 2005), if at all possible. From what I understand, the only way to
> > do
> > this is via a third party piece of software, such as OfficeWriterSE for
> > ASP by softartisans.com...
> >
> > A couple questions:
> >
> > 1. Is there an open source alternative to the commercial third party
> > software (the cost of OfficeWriterSE is way beyond our budget)?
> >
> > 2. Does Microsoft plan on ever offering the capability of importing Excel
> > reports into RS? (I do like the ability of importing Access report
> > objects, so why not expand to Excel and Word too)?
> >
> > 3. Should I just forget the whole thing?
> >
> > TIA!
> >
> > Greg--
>
>|||You can click on the 'Upload File' button in ReportServer and proceed
to upload to your heart's content all the Excel files you want to.
They'll open as Excel files within the Report Server's browser with full
Excel functionality. No need to shell out money for a 3rd party solution.
GeoSynch
"gms" <gms@.discussions.microsoft.com> wrote in message
news:5C29B68B-A8CB-458B-BC1F-C061ABC70F49@.microsoft.com...
> We have several extensive reports in Excel that I
> would like to port over to Reporting Services (am in process of testing
> SQL/RS 2005), if at all possible. From what I understand, the only way to do
> this is via a third party piece of software, such as OfficeWriterSE for
> ASP by softartisans.com...
> A couple questions:
> 1. Is there an open source alternative to the commercial third party
> software (the cost of OfficeWriterSE is way beyond our budget)?
> 2. Does Microsoft plan on ever offering the capability of importing Excel
> reports into RS? (I do like the ability of importing Access report
> objects, so why not expand to Excel and Word too)?
> 3. Should I just forget the whole thing?
> TIA!
> Greg--

Excel Rendering updated?

I'm wondering whether Katmai Reporting Services will do a better job of "rendering" to Excel. Quite Frequently, I create nice looking reports for the PDF renderer, only to to make a separate copy of that same report and mangle it so that I can get half of what I wanted.

For example:

1. I am frequently lining up the left and right edges of text boxes everywhere, as to not generate way too many columns in excel. As a result, I'm often formatting for excel to look, often ignoring the formatting needs of my data. The worst case scenario of this is when I had two rows of textboxes (roughly seven textboxes each) , and the PDF renderer did a beautiful job. However the Excel renderer would randomly choose to push some of the textboxes down into another Excel row, giving a checker-board look to my report. Hours were wasted in attempts to reformat a separate copy of the report to eliminate the Checkerboard look, to no avail.

2. Formatting Data in any way (FormatCurrency(), FormatDate(), ect) converts the data type to string, and my excel reports are flooded with smart tags saying "Convert to Number". These reports do not gracefully import into my client's applications. In addition to this, there is no way to format the textboxes so that Excel's Cell formatting will be given to the cells (right click on a cell, "Format Cells" and choose a category and some options with different categories). I can leave the data unformatted, but it looks SO unprofessional. So I have been evaluating several other Excel reporting packages that will allow me to Format Cells without changing the data types of my data to a string.

3. Images. Yikes! The PDF renderer has had some occasional glitches with images that some vendors have given us. We have thousands of vendors that give us images created with a large spectrum of consumer digital cameras. Occasionally, the PDF renderer refuses to render (a large gamut of error messages have been seen), while the TIFF renderer will suceed. I have even had an image (still do if you would find them helpful) that will not even render through the TIFF renderer. I had to open the image and "Save As " to get the TIFF renderer to work, but the PDF renderer would still not work. So we had to create some backup tools to "Resave the images" and also "use the TIFF version instead", both of which cost us personnel time.

Please let me know if these will be fixed in the Katmai RS?!?

For #1, the Excel rendering has improved in Katmai, mainly around reducing the number of merged cells. However, it looks like you are looking for more of a data renderer, which is currently not planned.

For #2, why are you using the Format... functions instead of setting the format property? If you set the format property, you should get numbers with the appropriate formatting.

For #3, it sounds like you are running into a bug, either with our PDF renderer or the framework image libraries. Have you filed repro cases at http://connect.microsoft.com?

Brian|||

Alternatively, if you are having problem getting http://connect.microsoft.com to work, you can email me directly with a sample of the problem images. Clicking on my name to the left will show my email address. Just be sure to put a good subject line so my inbox doesn't delete your email as spam.

Thank you.

Excel Rendering updated?

I'm wondering whether Katmai Reporting Services will do a better job of "rendering" to Excel. Quite Frequently, I create nice looking reports for the PDF renderer, only to to make a separate copy of that same report and mangle it so that I can get half of what I wanted.

For example:

1. I am frequently lining up the left and right edges of text boxes everywhere, as to not generate way too many columns in excel. As a result, I'm often formatting for excel to look, often ignoring the formatting needs of my data. The worst case scenario of this is when I had two rows of textboxes (roughly seven textboxes each) , and the PDF renderer did a beautiful job. However the Excel renderer would randomly choose to push some of the textboxes down into another Excel row, giving a checker-board look to my report. Hours were wasted in attempts to reformat a separate copy of the report to eliminate the Checkerboard look, to no avail.

2. Formatting Data in any way (FormatCurrency(), FormatDate(), ect) converts the data type to string, and my excel reports are flooded with smart tags saying "Convert to Number". These reports do not gracefully import into my client's applications. In addition to this, there is no way to format the textboxes so that Excel's Cell formatting will be given to the cells (right click on a cell, "Format Cells" and choose a category and some options with different categories). I can leave the data unformatted, but it looks SO unprofessional. So I have been evaluating several other Excel reporting packages that will allow me to Format Cells without changing the data types of my data to a string.

3. Images. Yikes! The PDF renderer has had some occasional glitches with images that some vendors have given us. We have thousands of vendors that give us images created with a large spectrum of consumer digital cameras. Occasionally, the PDF renderer refuses to render (a large gamut of error messages have been seen), while the TIFF renderer will suceed. I have even had an image (still do if you would find them helpful) that will not even render through the TIFF renderer. I had to open the image and "Save As " to get the TIFF renderer to work, but the PDF renderer would still not work. So we had to create some backup tools to "Resave the images" and also "use the TIFF version instead", both of which cost us personnel time.

Please let me know if these will be fixed in the Katmai RS?!?

For #1, the Excel rendering has improved in Katmai, mainly around reducing the number of merged cells. However, it looks like you are looking for more of a data renderer, which is currently not planned.

For #2, why are you using the Format... functions instead of setting the format property? If you set the format property, you should get numbers with the appropriate formatting.

For #3, it sounds like you are running into a bug, either with our PDF renderer or the framework image libraries. Have you filed repro cases at http://connect.microsoft.com?

Brian|||

Alternatively, if you are having problem getting http://connect.microsoft.com to work, you can email me directly with a sample of the problem images. Clicking on my name to the left will show my email address. Just be sure to put a good subject line so my inbox doesn't delete your email as spam.

Thank you.

Excel Pivot Table Limitations?

Dear Anyone,

We seem to have encountered a bug o a limitation but we're not sure what to make of it.

We are using Analysis Services 2005 RTM. Went have a 3 level dimension. We noticed that when we used the dimension in the page field of the pivot table, we noticed that not all members of some parents in the 2nd level does not display. We double checked by browsing the dimension using the Management studio and we confirmed that not all members in the lowest level is being displayed. The ratio is somewhere in the numbers of 45900/2500. The lower number being the only number of members that are being displayed.

The weird part is that we didnt encounter this problem with the Analysis Services 2000. Our current OLAP project now is a migrated version of our old data warehouse.

Any insights anyone?

Thanks,

Joseph

Couple of things to try.

One: Try to browse your cube using cube browser and not dimension browser in the SQL Management studio.

Two. Try building a simpler cube (just few dimensions) in AS2000 and migrate it to AS2005. Compare results in Excel. See if you see different results when browsing cubes of exact the same structure.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights

Excel Pivot Table for AS2005

I try to use the Excel Pivot Table to retrieve the data from AS2005 cube data. I have install the Microsoft OLE DB Provider for Analsysis Services 9.0", but I get the following error message: Insitialzaiton of the data source failed. However, when I use the SQL Server Management Studio, I can browse the cube data. As a result, I know I have permission the access the cube data. Why the Excel Pivot Table is not working for me?

This schenario is pretty common and should be working. There got to be something wrong with components installed.

Try applying the latest version of AS OLEDB provider from http://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&DisplayLang=en

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Excel Pivot Table and Time Dimension

I’m using the OLEDB Provider for Analysis Services 9.0 in Excel 2003 to get to my OLAP cubes in SQL Server 2005 Standard SP1.When I use Time as a Page filter in an Excel Pivot table, the dropdown looks like this (May_2006 is the default period):

-2006
-Qtr2_2006

+May_2006

+Apr_2006

+Jun_2006

+Qtr1_2006

+Qtr3_2006

+Qtr4_2006

+2004

+2005

I checked the field settings in Excel and it is using the data source order option.When I browse the dimension, the Time members are shown in chronological order.I’ve concluded that this behavior is a result of setting the default month in the Time dimension.Anyone know if this is simply the way it is when working with a defaulted Time dimension in Excel?

Moving to SQL Server Analysis Services forum.