Execute report and go directly to a save file option

We have a report that is basically a data file. It can have 2 rows or it can
have 100,000 rows. We are running into response time issues, memory issues,
etc. I know that RS is not the preferred method to deliver these sorts of
large data files. We need to do anything possible to satify the user at this
point and the amount of time it's currently taking to run this report with a
large amount of data, even when the report runs successfully, is unacceptable
to them. But, until we have time to re-design, is there any way to have the
report always prompt to save the file instead of waiting for the default HTML
format and then exporting to CSV? Any other short-term solutions?
StephanieFrom your own web page it is easy. Using URL integration you can specify the
format. Even if you are using Report Manager you could have a report that
has the appropriate parameters, they open it up and all you have in the
report is a link that says Export Data. Use the Jump to URL action (I also
make the link blue and underlined).
One other thing, perhaps you have seen this already.If you do this you will
want to change the CSV to use ASCII instead of unicode. Excel puts unicode
into a single column. To have RS export CSV in ASCII format you have to make
a change to a config file.
You only need to change in one place, rsreportserver.config. Reboot after
the change. The below shows commenting out the existing entry and putting in
the needed change to have CSV export as ASCII
<!--
<Extension Name="CSV"
Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/>
-->
<Extension Name="CSV"
Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
<Configuration>
<DeviceInfo>
<Encoding>ASCII</Encoding>
</DeviceInfo>
</Configuration>
</Extension>
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
news:10819562-B6BC-4535-BE4A-4B5AA6BD2B8A@.microsoft.com...
> We have a report that is basically a data file. It can have 2 rows or it
> can
> have 100,000 rows. We are running into response time issues, memory
> issues,
> etc. I know that RS is not the preferred method to deliver these sorts of
> large data files. We need to do anything possible to satify the user at
> this
> point and the amount of time it's currently taking to run this report with
> a
> large amount of data, even when the report runs successfully, is
> unacceptable
> to them. But, until we have time to re-design, is there any way to have
> the
> report always prompt to save the file instead of waiting for the default
> HTML
> format and then exporting to CSV? Any other short-term solutions?
> Stephanie

Execute Non Query: Command Text Property has not been initialized

I get this when I delete a row then save data in a data grid view control.
Hints to fix ?Hello
This is not the best group for this problem; you will get better
answers in a .Net group, for example
microsoft.public.dotnet.framework.adonet or
microsoft.public.dotnet.datatools.
It's not my domain, but I suppose that you should check the
DeleteCommand property of the corresponding TableAdapter in the
appropriate DataSet.
Razvan

Execute DTS package from .adp ?

Hello,

Currently I save a DTS as a storage file. I then run the storage file
with VBA code in the .adp(Access Data Project). This works if you run
the ADP on the Server but the users of the .adp will be opening it on
the network from their machines. When they do it says missing
custtask.dll and some other .dll these .dll are in the SQL server Binn
on the server so they are not on the users machines.
I could not register the .dlls on the user machines without SQL Server.

It would be great if I could solve this problem but I'm not sure
how....

Another possiblity would be to save the DTS SQL Server msdb table and
run it from the server but I do not know how to run the DTS using VBA
code or a SQL statement...

Please help with any documentation or suggestions,

ChuckHi

This may be useful:
http://www.sqldts.com/default.aspx?225

You could run the DTS package as a scheduled job
http://support.microsoft.com/?kbid=269074
or a job started manually
http://msdn.microsoft.com/library/d..._sa-sz_11uq.asp

John

<meyvn77@.yahoo.com> wrote in message
news:1126375425.946180.124620@.f14g2000cwb.googlegr oups.com...
> Hello,
> Currently I save a DTS as a storage file. I then run the storage file
> with VBA code in the .adp(Access Data Project). This works if you run
> the ADP on the Server but the users of the .adp will be opening it on
> the network from their machines. When they do it says missing
> custtask.dll and some other .dll these .dll are in the SQL server Binn
> on the server so they are not on the users machines.
> I could not register the .dlls on the user machines without SQL Server.
> It would be great if I could solve this problem but I'm not sure
> how....
> Another possiblity would be to save the DTS SQL Server msdb table and
> run it from the server but I do not know how to run the DTS using VBA
> code or a SQL statement...
> Please help with any documentation or suggestions,
> Chuck|||I really need to execute it using code or a SQL statement.|||So you will need to install/register all the dlls mentioned in the first
post on every client or possibly from your own stored procedure:

http://www.sqldts.com/default.aspx?210

John

<meyvn77@.yahoo.com> wrote in message
news:1126393799.257226.56930@.o13g2000cwo.googlegro ups.com...
>I really need to execute it using code or a SQL statement.

Execute DTS package from .adp ?

Hello,
Currently I save a DTS as a storage file. I then run the storage file
with VBA code in the .adp(Access Data Project). This works if you run
the ADP on the Server but the users of the .adp will be opening it on
the network from their machines. When they do it says missing
custtask.dll and some other .dll these .dll are in the SQL server Binn
on the server so they are not on the users machines.
I could not register the .dlls on the user machines without SQL Server.
It would be great if I could solve this problem but I'm not sure
how....
Another possiblity would be to save the DTS SQL Server msdb table and
run it from the server but I do not know how to run the DTS using VBA
code or a SQL statement...
Please help with any documentation or suggestions,
ChuckYou can dts runtime. You'd want to read the readme for details as to what's
distributable.
Meanwhile, you want to save your dts package on sqlserver (i.e. in msdb) and
then create a sqljob for the package. Then in your vba, you would invoke
sp_start_job 'jobname' to execute it.
-oj
<meyvn77@.yahoo.com> wrote in message
news:1126375373.241589.256440@.z14g2000cwz.googlegroups.com...
> Hello,
> Currently I save a DTS as a storage file. I then run the storage file
> with VBA code in the .adp(Access Data Project). This works if you run
> the ADP on the Server but the users of the .adp will be opening it on
> the network from their machines. When they do it says missing
> custtask.dll and some other .dll these .dll are in the SQL server Binn
> on the server so they are not on the users machines.
> I could not register the .dlls on the user machines without SQL Server.
> It would be great if I could solve this problem but I'm not sure
> how....
> Another possiblity would be to save the DTS SQL Server msdb table and
> run it from the server but I do not know how to run the DTS using VBA
> code or a SQL statement...
> Please help with any documentation or suggestions,
> Chuck
>