Automatically Regenerate on Depending on parameter input

Hello,
Is there a way to get the reports to automatically regenerate when a user
changes a drop down or selects a radio button?
Thanks
DylanOn Feb 20, 11:45 am, Dylan <D...@.discussions.microsoft.com> wrote:
> Hello,
> Is there a way to get the reports to automatically regenerate when a user
> changes a drop down or selects a radio button?
> Thanks
> Dylan
As far as I know, there is not a way to do that; unless, you are
embedding the report in an application, whereas, you can call a
refresh of the report on a given event.
Regards,
Enrique Martinez
Sr. ASP.NET/SQL Server Developer|||By giving "default value" the report runs automatically (rather pretend to
run, infact it substitutes the values) Otherwise you have to click on view
report to see the report. other option is to write custom code..
Amarnath
"Dylan" wrote:
> Hello,
> Is there a way to get the reports to automatically regenerate when a user
> changes a drop down or selects a radio button?
> Thanks
> Dylansql

AUTOMATE PROCESS

Hi

Currentyl after i transfer the data from another database(source) to datawarehouse. I need to click on the "process" button in order to see the latest result. Do it have a command or way to do it programmatically or using the SSIS to do it?

Anyone please point me the link for me to do the automate process ?

Thanks in advance for anyone provide me some clue.

There are plenty of different options

SSIS has an SSAS processing task.

You could script the processing from SSMS as an XML/A command and schedule it from SQL Agent or using the ascmd sample that was released with SP2.

You could write a .Net app using the AMO to initiate the processing.

|||

Hi Darren,

You again . And thank again for the pointing.

And i found more details explaination on this,

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=230156&SiteID=1

Just provide for those are interested. And is worked and simple.

Thanks

|||Yep me again . That's exactly what I had in mind.

automate passing

hi!

i already have a program that when you click a button it will get the new transactions in the database then pass it to another database now i need to automate the passing... once there is a new entry in the database it should automatically pass it to the other database. how could i do this?!

thanks!

I believe there is a way to do such mirroring if the databases are both SQL Server databases and if that is the case you should post the same question to the appropriate SQL form...

Otherwise one could write a service application, an application with no GUI which runs as a windows service i.e not as a user, but the system, to check for the transfer condition, then do the read from the first database then write out to the second database. Here are a couple of links to get you started.
Windows Service Application|||

my other database is Oracle. But thanks for the links you gave! it was very helpful! ^_^

i now know how to create the windows service but how can i modify my previous program... originally the button has to be clicked for the transaction to be passed.. it also has an interface (a form with 2 buttons). Any tips or suggestions as to how i would change it?

thanks again!

|||You need to isolate the business logic away from the GUI logic. Its a common problem for people writing quick code...it all gets placed into one layer.

What you need to do is create a new assembly (library assembly) which will hold just the logic of contacting the database and returning or processing into it the data. Once that code is in a separate assembly, have the GUI application reference that assembly then remove the current db access code. Then wire in the GUI to use the new database/biz logic code from the newly created assembly.

Once you have it broken out you can now work on creating a windows service which will do the work in the background so to speak.

As a developer, get into the habit of always separating the code into layers. You may have heard of a three tiered architecture and this is what you are striving for... The first layer is a GUI or service or unit test layer which contacts a business layer which in turn contacts the database layer. Each of those layers are in separate assemblies which lend themselves to being unit tested outside the application via either NUnit tests or console applications linking in... Good luck.|||thanks for the explanation! ^__^

automate exporting

Hi,

I have report on an aspx page. If I click a button, I want to automate the exporting process of the displayed report. Is this possible

thanks

Yes, use URLAccess and the rs:Format parameter.

http://msdn2.microsoft.com/en-us/library/ms153586.aspx
http://msdn2.microsoft.com/en-us/library/ms154040.aspx

Auto generate report without clicking on the "View Report"

Is there a way to automatically generate the report when the users
changes the parameter selection - without clicking on the "View
Report" button?
ThxFor what it's worth, you can just press the enter key - and if all required
parameters are filled, the report will refresh.
Not quite the same thing - but you need to do something to indicate that you
have finished in a cell.
"Harsh" <creative@.mailcity.com> wrote in message
news:fa671a26.0407161434.4bb91320@.posting.google.com...
> Is there a way to automatically generate the report when the users
> changes the parameter selection - without clicking on the "View
> Report" button?
> Thx