Possible values for custom property in combobox

I have a custom property and want to offer the possible values at designtime in the property sheet or editor in a combobox. I there a way I can accomplish this? Or do I have to make a custom UI for this?

Thanks,
HenkHave a look at the updated BOL topic Doug posted for your earlier (http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=74057).

You probably want to use an enumeration to define the values, and set a TypeConverter as per the example in BOL.

For more advanced properties, or where you want a fancy UI, then set a UITypeEditor instead. There are a few more UITypeEditors in the box (Framework 2.0) now as well -

UITypeEditor Hierarchy
(http://msdn2.microsoft.com/library/bfc7teys(en-us,vs.80).aspx)|||Thanks Darren, I missed the post (and a valuable one!) indeed. Unfortunately I can't use an enumeration, because I need to determine the possible values dynamically from a table. Guess, that if I will persue this, I need an UITypeEditor

Regards,
Henk|||You can write a TypeConverter with dynamic values, but for more interaction
you will need a UITypeEditor. For example on tasks that consume connections, I use a custom UITypeEditor to display a drop-down of connections, and offer a <new connection> option. This needs you own code to do, as I want to do fancy stuff when selecting the new option.

It may be easier to do in a custom UI rather than through the advanced UI. You can provide a richer user experience, especially when there are interactions between several properties. Talking to other properties can be done by working through the context reference you get, but it can be a pain.

There are plenty of articles out there on Property Grids, and converters/editors, and the underlying concepts have been around for a while, totally unrelated to SSIS, so be sure to check out regular .Net resources too, e.g.

The Code Project - PropertyGrid and Drop Down properties - C# Programming
(http://www.thecodeproject.com/csharp/DropDownProperties.asp)

Possible to Loop thru dataset using Custom Code?

Is there a way to pass a record set into a function of custom code?
If so?
What datatype should I use?
I have been told its impossible to loop thru the dataset...
Can you get the INDEX of the First row and the INDEX of the last row as
a parameter into a custom function?
regards,
Stas K.Mr. Sorcerdon,
Your best bet would be to implement a Custom Data Processing extension.
This will give you access to dataset being consumed by the report.
Specifically, the IDataReader has a Read method which walks the
dataset.
Andy Potter|||I dont you to go too deep into it, but basically make an Object as a
parameter and then read that object using this extension?
Is there a place where I can get code for this Custom Data Proccessing
extension?|||It is a class library that sits between your data source and your
report's dataset. It implements interfaces from MSRS.
Here's the MSDN article about a Custom Data Processing Extension.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_extend_dataproc_5c2q.asp
There are several good samples out there. Teo Lachev has a good one
that a google search will return.
Andy Potter

Possible to add a Flash Player control to a report?

I'm working on a project where the client wants us to create custom charts which have features not found in the standard Reporting Services charts. I would like to use flash to build this and have found an existing flash charting package for which I have the code and which I plan to expand.

Here's the problem:

The client wants to include these charts in his Reports. Is there some way to add a flash control to a report so that it will appear on the web page as a fully-functional flash presentation, which can then be included when printing or exporting?

The alternative, would be to figure out some means of generating the chart using flash outside of the report, exporting a bitmap of the chart and then saving the bitmap to a known location on the file system so It can be referenced by a report. This has some serious complications, and may not be feasible.

Any ideas?

Embedding flash into reports is not supported. While there are several third party advanced charting packages available which specifically integrate with SSRS2005 Standard, Enterprise, or Developer editions (based on the CustomReportItem extensibility feature), they also cannot use flash because it is currently not supported.

-- Robert