Any news on this? I'm trying to test for the time simply querying a small table with a geography data type, and the query returns this error.

It's SS2008 R2....

Thanks.

Unfortunatlye, I may have to create a custom email subscription process, one that

1. calls the RS report's SQLAagent job that saves the file to a fileshare,

2. then...

Reporting back some solutions:

For Android users, I had them switch from QuickOffice to KingSoft Office which is free and works great, even for complex, multisheet XL files generated by RS...

The problem with using a csv file is that it's a fancy report with formatting and charts--multiple sheets. I could try a pdf or some other workaround, but was hoping...

Thanks for the reply.

BTW, I forgot to mention that it WILL reuse the plan query plan that has parallelism -- if it exists. I was trying to plan for...

Regarding Progress and odbc, we have a similar process: We pull data from Progress 9.1D into SS2000 and SS2005 using Progress merant 3.6 odbc drivers. Simple DTS jobs execute these...

I have wanted to do that exact thing.

I'm not familiar with xml, is there a way for a dataset in a report to refer to its own rdl (which...

Eddy,

Thanks. I'm the SQL Server guy at our company. I will need as much information as I can get in order get (spoon feed) our Progress "dba". I have a...

[quote-0

Best way to go is export/import

or wxhat we do now while setting up a new env. and still working operational with progress for keeping data equal is

working with windows services,

any...

I found out (by accident one day) that SSRS will export formulas when the formula references other report textboxes using the ReportItems function(). Here is a smiple example. For instance...

enter...

If the parameter is generated from a query, then it's due to a RS limiation. URLs don't pass parameters that are generated by a query. If anyone knows a workaround,...

This won't help much, but...from what I understand, Progress allows any size value to be inserted into a field even though the schema may have char length defined. Don't know...

Perhaps he's not displaying all half million rows, but using a summary or matrix to show totals by group. Even in this case, RS still has to handle the half...

I too have had the same message. I set up a subscription that works when I send to a list of VALID email addresses specified in the format:

...

Thanks, guys. I tried each method, however, none listed that file. I'm thinking it must be an Access database. I will try to rename the file and see who screams.