prompt for parameter in a view

I would like to create a view that will prompt the user for a parameter.
Much the same way a user can provide the paramenter for a query in Access.
Seems like it should be simple, but I don't know how to do it.
Any ideas?
Thanks
Tyler
Hi,
SQL Server will not prompt for a user input. Access will allow because it
have both Front end and back end.
Thanks
Hari
SQL Server MVP
"Tyler" <Tyler@.discussions.microsoft.com> wrote in message
news:CA2CA968-4B15-4ED6-AECF-FE3C17C119AB@.microsoft.com...
>I would like to create a view that will prompt the user for a parameter.
> Much the same way a user can provide the paramenter for a query in Access.
> Seems like it should be simple, but I don't know how to do it.
> Any ideas?
> Thanks
> --
> Tyler

progress indication from ssis app in VB

Hi

am calling an ssis app from my vb programme. It takes about 5 minutes to run. What is the best way to provide progress feedback to my vb user.

Cheers

Ants

I

Ants Hurdley wrote:

Hi

am calling an ssis app from my vb programme. It takes about 5 minutes to run. What is the best way to provide progress feedback to my vb user.

Cheers

Ants

I

Package.Execute() has an overloaded constructor that allows you to pass in a IDTSEvents object. As far as I'm aware this allows you to get events out of the executing package - after which you can surface them to your VB app.

Take a look here for more info:

DtsContainer.Execute Method
(http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.dtscontainer.execute.aspx)

-Jamie

|||There is also a sample event listener code at
http://msdn2.microsoft.com/en-us/library/ms136090.aspx|||

Hi

Thanks for this - I am not sure if I am understanding this correctly as I am new to this but I want to show the progress as the package is executed. I.e. my Package has 15 steps, so I would like to show a progress bar or something to let the user know that things are happening. Not just show a success or failire.

Cheers

|||

The sampel only demonstrates overriding the OnError event, but you can override any of the other events, such as OnPreExecute and OnPostExecute, which will give you begin and end notices for each container. See here for more information on the DefaultEvents class-

DefaultEvents Members (Microsoft.SqlServer.Dts.Runtime)
(http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.defaultevents_members.aspx)

|||

Ants Hurdley wrote:

Hi

Thanks for this - I am not sure if I am understanding this correctly as I am new to this but I want to show the progress as the package is executed. I.e. my Package has 15 steps, so I would like to show a progress bar or something to let the user know that things are happening. Not just show a success or failire.

Cheers

Well that's not really a SSIS question. SSIS can tell you its progress and its up to you how you display that information in your app. A progress bar is an option I guess.

Note that BIDS uses the same mechanism to populate the "Package Execution" tab when you debug a package .

-Jamie

Programmatically setting UpdateParameters for a SQLDataSource control

I need to provide defaultsand sometimes overrides for items in SQLDataSource's UpdateParameters. I am attempting to do this in a FormView's ItemUpdating and ItemInserting events as follows:

//======================================================================== // FormView1_ItemUpdating: //========================================================================protected void FormView1_ItemUpdating(object sender, FormViewUpdateEventArgs e) {// not sure if this is the bets place to put this or not? dsDataSource.UpdateParameters["UpdatedTS"].DefaultValue = DateTime.Now.ToString(); dsDataSource.UpdateParameters["UpdatedUserID"].DefaultValue = ((csi.UserInfo)Session["UserInfo"]).QuotaUserID; } 

In the example above I am attempting to set new values for the parameters which will replace the existing values.
I have found that using the DefaultValue property works ONLY if there is no current value for the parameter.  Otherwise the values I specify are ingnored.
The parameters of an ObjectDataSource provide aValue property but SQLDataSource parameters do not.
How can I provide an override value without needing to place the value in the visible bound form element?

If you can answer this you will be the FIRST person ever to answer one of my questions here!!!
Thanks,
Tony

I figured it out. I still don't know if this is the best way to provide defaults but this works. If anyone has a better method I would appreciate any input

You can use the NewValues property of FormViewUpdateEventArgs and the Values property of FormViewInsertEventArgs

//======================================================================== // FormView1_ItemUpdating: //========================================================================protected void FormView1_ItemUpdating(object sender, FormViewUpdateEventArgs e) {// not sure if this is the bets place to pout this or not? e.NewValues["UpdatedTS"] = DateTime.Now.ToString(); e.NewValues["UpdatedUserID"] = ((csi.UserInfo)Session["UserInfo"]).QuotaUserID; }

Programmatically create a Report Model

We would like to take advantage of the Report Builder tool to provide
end-user ad-hoc reporting. The database for the application can be
different depending on how the client configures it (they can add various
fields and data collection forms). At TechEd, I attended a session on
Microsoft Dynamics AX 4.0 and its tight integration with Reporting
Services/Report Builder. This is very much in line with what we'd like to
do. I imagine the users adding a field (through our interface), setting a
few properties, and then after some automated process occurs, they would be
able to use Report Builder to access any data collected in that field.
What we'd like to do is programmatically generate and maintain a report
model based on how the individual install is configured. I've found some
documentation that makes me believe this is possible, but I'm hoping someone
can nudge me in the right direction. The ReportingServices2005 class has
several model related methods (CreateModel) and I found the .xsd for the
semantic model XML file
(http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/SemanticModeling.xsd),
but no real documentation on how to put together a Report Model document
from scratch. Looking at the files generated from BIDS is somewhat
overwhelming and I have no idea where I'd pull most of the information.
Any help that can be provided would be greatly appreciated. Thanks!
RussellHi Russell,
Thank you for your posting!
From your description, my understanding of this issue is: You want to
programmatically manage the Report Model xml file (smdl). If I
misunderstood your concern, please feel free to let me know.
I would like to know what information you want to pull from the Report
Model. The smdl file is a xml file and I think you could control the file
in VS .NET.
The CreateModel of the Reporting Services 2005 class is used to upload the
Report Model file to Report Server. I think it is not quite meet your
requirement.
Here is an article about refine a report model.
Refining a Report Model
http://www.sqlmag.com/Article/ArticleID/50048/sql_server_50048.html
Hope this information will be helpful and please let me know the result.
Thank you!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Russell,
I would like to know whether the information is helpful. Feel free to let
me know if you have any questions.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Russel
did you have any success with that? did you solve it by creating the SMDL
File with an XMLTextWriter or did you find an other solution? an oblect that
could be referenced?
i am having the same problem and would like to establish the SMDL file fully
by code, from scratch.
any info is appreciated.
Kind Regards, Rene
"RussellReed" schrieb:
> We would like to take advantage of the Report Builder tool to provide
> end-user ad-hoc reporting. The database for the application can be
> different depending on how the client configures it (they can add various
> fields and data collection forms). At TechEd, I attended a session on
> Microsoft Dynamics AX 4.0 and its tight integration with Reporting
> Services/Report Builder. This is very much in line with what we'd like to
> do. I imagine the users adding a field (through our interface), setting a
> few properties, and then after some automated process occurs, they would be
> able to use Report Builder to access any data collected in that field.
> What we'd like to do is programmatically generate and maintain a report
> model based on how the individual install is configured. I've found some
> documentation that makes me believe this is possible, but I'm hoping someone
> can nudge me in the right direction. The ReportingServices2005 class has
> several model related methods (CreateModel) and I found the .xsd for the
> semantic model XML file
> (http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/SemanticModeling.xsd),
> but no real documentation on how to put together a Report Model document
> from scratch. Looking at the files generated from BIDS is somewhat
> overwhelming and I have no idea where I'd pull most of the information.
> Any help that can be provided would be greatly appreciated. Thanks!
> Russell
>
>