Showing posts with label click. Show all posts
Showing posts with label click. Show all posts

Monday, March 26, 2012

ForEach file in folder - missing from dropdown list

I'm working through the SSIS tutorial, and am on lesson 2.
This says
"Double-click Foreach File in Folder to reopen the Foreach Loop Editor.

Click Collection.

On the Collection page, select Foreach File Enumerator."

The drop down only contains

foreach ado enumerator
foreach ado.net schema_rowset.enumerator
foreach from variable.enumerator
foreach nodelist.enumerator
foreach smo.enumerator

How do I get the "foreach file in folder" to appear in the drop down list?

Gary
A quick search of the forum will yield you the answer to your question.

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

Mmmn,

I got our technical support team to load the sql server service pack 2 to fix another problem a couple of days ago.

This has not cured this problem (but did fix the other problem I was having).

Funny enough, both problems indicated that certain registry keys could not be read..

I'll get our technical support team to set up a restricted user and run the C# program the knowledgebase article gives.

Gary

Sunday, February 19, 2012

for any button click event

Hi All,

I am new to sql server 2005.

I have developed an new report using sql server 2005

repoting services in Business intelligent Development studio

so any one can help me how to include this report

on any aspx page

ex for any button click event the report must be generated.

So please any one of you help me out.

Sandy,

From the FAQ's at: http://www.microsoft.com/sql/technologies/reporting/faq.mspx

Q. How can I add Reporting Services reports to my application?

A. Visual Studio 2005 (Standard and Enterprise editions) contains a set of freely redistributable Report Viewer controls that make it easy to embed Reporting Services functionality into custom applications. Two versions of the Report Viewer exist, one for rich Windows client applications and one for ASP.NET applications.

If you want more granular control, once the report is published to the report server you will notice that it has a URL. Simple link to that URL with a hyperlink, or, do a response.redirect or server.transfer on a button's click event. Once you have the full url to the report you can start playing with it to get the results you want. (i.e. Button 1 passes parameter(s) A, button2 passes parameter(s) B etc.)

For more guidence I suggest:

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

http://www.microsoft.com/sql/technologies/reporting/default.mspx