I ran that exact script to test for numerics and a few others and they all came back as numerics. In regards to T.ORTRXAMT, even if I don't have...

Yeah I saw that post. The curious thing is this thing has worked for almost a year and just stopped working either after installing SQL 2005 SP2 or an...

Yes. That is the first thing I thought of. I even went as far as temporarily setting the SQL Agent Service user Administrator rights.

-min -m C:\FOLDER\File.zip C:\FOLDER\*.txt

Any help with this would be greatly appreciated!

That was it Steve.  I didn't remember doing it, BUT the default is not to show them in the cube browser in VS as well.  You have to select to...

Excel 2007.

I am not sure what it truly is since it is created in the Business Logic wizard of VS.  Some of the code is hidden when this is used.

Since...

Okay.  Cleared the keys and reinputted them and it got me in but now its giving me the ol' "Bad Data" errors on the reports and when I go into...

Yeah did all that.  The install works if I wipe out the RSDBKEY, but it would take a long time to set everything back up on Data Sources and such. ...

Any help with this at all would be greatly appreciated.  I'm dying here.  This is not the only report we are having this problem with and they are crucial reports...

Chris,

THe report has drill down detail, so Excel is required.  Plus, the users like to reformat and massage the data.

Here's the code:

<?xml version="1.0" encoding="utf-8"?>

<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">

  <PageHeader>

    <ReportItems>

     ...

Thanks for responding Chris...

The report exports to CSV and PDF no problem.  The Open/Save dialog box pops up immediately, whereas the dialog box never appears with the Excel export.  The export doesn't...

What would be the disadvantage of using derived tables like:

Select

IM.Item, ISYR1.SalesYR1, ISYR2.SALESYR2 

from ItemMaster IM

Inner Join

(Select Item, ItemSales as SalesYR1 from SalesDetail where Date <= @param1 and Date >= @param2) ISYR1

on IM.ITEM...

Coach James,

I have tried just exporting to excel from two sources: 1) Preview in the Report Designer in Visual Studio 2) internet explorer through Report Manager.  Also I have had...

Bill,

Thanks for the reply.  I am using just a few rows to test the export and opening it in Notepad.  Again, no quotes around text fields.  Very frustrating!