Running a SSRS report in a report viewer control in .net

Do I need the report server running in order view a SSRS report in a report viewer control? I've created my report in .net and it works great when I'm viewing it in visual studio, but can I run it my web app without the report server.
The ReportViewer supports local mode where the report definition is distributed with the application and the application feeds the report with data. In local mode, the Report Server is not needed. More details here.sql

Running a SSRS report in a report viewer control in .net

Do I need the report server running in order view a SSRS report in a report viewer control? I've created my report in .net and it works great when I'm viewing it in visual studio, but can I run it my web app without the report server.
The ReportViewer supports local mode where the report definition is distributed with the application and the application feeds the report with data. In local mode, the Report Server is not needed. More details here.

Run report after parameter selected

My report has a Date parameter. Can the report be run automatically after the date is changed without clicking on View Report button?

Thanks

I don't think it can. The toolbar is generated by the reportserver and you can't hook into any events and there is no Autorun option to my knowledge.

The only hack I can think of is displaying the report in a custom page, view the source to find out the ids/names that RS assigns to your parameters and the name of the js function called when the "View Report" button is pressed. You then write some javascript that hooks into the onChage event of the dropdown and simulate the pressing of the button by calling the relevant function manually.

Like I said that is a real hack and is not likely to be very flexible but you could experiment. Eaither way you can't modify the Report Manager to do this you would have to write a custom page.

Run a view and Export results as a CSV file

I need to automate a process for a client and not sure how I can achieve the
following. any help on this would be appreciated.
1. Run a View for the results set
2. Export this data to a csv file.
3. Run a batch job which FTP's the data to an off site server.
Note I have developed the view for my data and know how to implement the FTP
transfer using a batch file/Command. What I don't know is how to export the
results automatically at the end of the view and executing the batch job.
Regards
Jeff
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.762 / Virus Database: 510 - Release Date: 13/09/2004
One option is to use DTS to do this.
You can use a data pump task to select from the view. Use a
text destination connection for the destination file and set
this to be a csv file. Then use an execute process task to
execute your batch job or you can use it to execute the
command line FTP to send the files to the FTP site.
-Sue
On Wed, 15 Sep 2004 07:30:03 +1000, "Jeff Williams"
<jeff.williams@.hardsoft.com.au> wrote:

>I need to automate a process for a client and not sure how I can achieve the
>following. any help on this would be appreciated.
>1. Run a View for the results set
>2. Export this data to a csv file.
>3. Run a batch job which FTP's the data to an off site server.
>Note I have developed the view for my data and know how to implement the FTP
>transfer using a batch file/Command. What I don't know is how to export the
>results automatically at the end of the view and executing the batch job.
>Regards
>Jeff
>
>--
>Outgoing mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.762 / Virus Database: 510 - Release Date: 13/09/2004
>

Run a view and Export results as a CSV file

I need to automate a process for a client and not sure how I can achieve the
following. any help on this would be appreciated.
1. Run a View for the results set
2. Export this data to a csv file.
3. Run a batch job which FTP's the data to an off site server.
Note I have developed the view for my data and know how to implement the FTP
transfer using a batch file/Command. What I don't know is how to export the
results automatically at the end of the view and executing the batch job.
Regards
Jeff
--
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.762 / Virus Database: 510 - Release Date: 13/09/2004One option is to use DTS to do this.
You can use a data pump task to select from the view. Use a
text destination connection for the destination file and set
this to be a csv file. Then use an execute process task to
execute your batch job or you can use it to execute the
command line FTP to send the files to the FTP site.
-Sue
On Wed, 15 Sep 2004 07:30:03 +1000, "Jeff Williams"
<jeff.williams@.hardsoft.com.au> wrote:
>I need to automate a process for a client and not sure how I can achieve the
>following. any help on this would be appreciated.
>1. Run a View for the results set
>2. Export this data to a csv file.
>3. Run a batch job which FTP's the data to an off site server.
>Note I have developed the view for my data and know how to implement the FTP
>transfer using a batch file/Command. What I don't know is how to export the
>results automatically at the end of the view and executing the batch job.
>Regards
>Jeff
>
>--
>Outgoing mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.762 / Virus Database: 510 - Release Date: 13/09/2004
>

rss data no adds/edits/deletes

I'm hoping someone can get me pointed in the right direction

we have SQL 2005 and I need to add a user account to let some only view the data

no edits / adds / deletes ?

can any one help

thanks

David

By default any created user and mapped user account is only member of the database role public. This role by default can′t Select, Insert, Update nor Delete anything. If you grant only Select to the user, he will only be able to select the data and will get an error message if he wants to do anything beyond that. (But don′t forget that the user will automatically inherit the permissions from every group he is a member of, including the public role)

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

yeah i know how

patch a empty batch @. save (record)

open with :ext: .txt logon

patch open

with extra :internet options import

|||

Thank you can you tell me how to add & Map a user

thanks

David

|||edits