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 Job From TSQL

Dear All,
I need some help on this problem.
I create a job on SQL Agent, the job had schedule as selected date and time,
but I want to have a optional choise to user to allow them start the job at
the web page, so I try to create a store procedure to start the job and
return the outcome for the job (Fail or success). And I use
msdb.dbo.sp_start_job to start the job, now I face the problem how can I kno
w
the job are finished and after the job completed, I need to check the result
of the job. Can give me some idea, what should I do for this.
TQhi
probably you can have a log table. The jon logs the data into the table. and
you can read it from the web page of u can have ur sp return a value.
did this answer your question.
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
---
"Judy" wrote:

> Dear All,
> I need some help on this problem.
> I create a job on SQL Agent, the job had schedule as selected date and tim
e,
> but I want to have a optional choise to user to allow them start the job a
t
> the web page, so I try to create a store procedure to start the job and
> return the outcome for the job (Fail or success). And I use
> msdb.dbo.sp_start_job to start the job, now I face the problem how can I k
now
> the job are finished and after the job completed, I need to check the resu
lt
> of the job. Can give me some idea, what should I do for this.
> TQ
>|||sp_hlep_job will give you the status and such but you will have to poll for
it periodically.
Andrew J. Kelly SQL MVP
"Judy" <Judy@.discussions.microsoft.com> wrote in message
news:97716C52-85C6-41F0-8BE8-EFB61EF3E0FD@.microsoft.com...
> Dear All,
> I need some help on this problem.
> I create a job on SQL Agent, the job had schedule as selected date and
> time,
> but I want to have a optional choise to user to allow them start the job
> at
> the web page, so I try to create a store procedure to start the job and
> return the outcome for the job (Fail or success). And I use
> msdb.dbo.sp_start_job to start the job, now I face the problem how can I
> know
> the job are finished and after the job completed, I need to check the
> result
> of the job. Can give me some idea, what should I do for this.
> TQ
>|||...or check out this article about how to use xp_sqlagent_enum_jobs to be a
ble to deal with the results since the results from sp_help_job cannot be in
serted into a table.
http://www.databasejournal.com/arti...10888_3491201_2
/Magnus

Rtrim

If Rtrim doesn't catch space at the end is there a way to catch strings that match but don't seem to get selected correctly when matching?Um, what do you mean by "Rtrim doesn't catch space at the end"? Or by "catch strings that match but don't seem to get selected correctly when matching"?|||Some sample data and some code would be helpfull.|||Is it possible there is some unwriteable chars there? Ie ASCII below 32?

I don't if the show up or not in SQL-Server, just related to C++ programming where unwriteable chars can mess up things.|||use this to check if the last char really is a space...

SELECT
ASCII(SUBSTRING(yourcolumnname, len(yourcolumnname), 1))
FROM yourtable

RTF Control

Hi,
Is there an RTFcontrol available for Reporting Services 2005 that will:
1. Allow selected text in the control to be Bolded?
2. Allow even justification of text on both left and right edges?
For Access, there is a control from FMS Inc that does that.
I need such a control to be able to move reports to RS.
Thanks.
Alan.Can i know what do u exactly want to do'
"Alan Z. Scharf" <ascharf@.grapevines.com> wrote in message
news:ePBwLiTdGHA.4532@.TK2MSFTNGP02.phx.gbl...
> Hi,
> Is there an RTFcontrol available for Reporting Services 2005 that will:
> 1. Allow selected text in the control to be Bolded?
> 2. Allow even justification of text on both left and right edges?
> For Access, there is a control from FMS Inc that does that.
> I need such a control to be able to move reports to RS.
> Thanks.
> Alan.
>|||Sumit,
1. I need to have paragraphs of text in a control that I can format as in a
word processor. The text would come from a database column, with each
product ID having it's own text.
2. I need to be able to make sume words Bold or Italic.
3. I also need the ability to have superscripts, since some of the text will
be used as footnotes.
4. I also need to fully justify the text so that both left and right edges
are even, no jagged right edge.
In Access, I do this with a third-party control called Total Access Memo
from FMSInc. You can see a description of that product at fmsinc.com. I
need its features.
With that product, you enter text in their word-processing-like editor, and
it stores the text in the database column with RTF coding. This formatted
text is then available for reports.
---
Please note that such formatting can be done in Crystal Reports.
That is in fact why I am posting this question.
Client wants to replace Crystal Reports with SQL Reporting Services. They
already have reports formatted as above in Crystak
So I have to be able to duplicate this RTF feature of Crystal. It's an
inherent requirement for a conversion to Reporting Services.
Thanks.
Alan
"Sumit Pilankar" <sumit.pilankar@.gmail.com> wrote in message
news:ecMIvrYdGHA.4720@.TK2MSFTNGP03.phx.gbl...
> Can i know what do u exactly want to do'
>
> "Alan Z. Scharf" <ascharf@.grapevines.com> wrote in message
> news:ePBwLiTdGHA.4532@.TK2MSFTNGP02.phx.gbl...
> > Hi,
> >
> > Is there an RTFcontrol available for Reporting Services 2005 that will:
> >
> > 1. Allow selected text in the control to be Bolded?
> >
> > 2. Allow even justification of text on both left and right edges?
> >
> > For Access, there is a control from FMS Inc that does that.
> >
> > I need such a control to be able to move reports to RS.
> >
> > Thanks.
> >
> > Alan.
> >
> >
>