Customise Report Parameters in Report Manager

Is it possible to add custom controls in for parameters in report manager?

I have a parameter that requires the user to click a button and select a bunch of things in another form. How can i do this in reporting services?

I also would like to change the layout of the parameters toolbar, ie. make text boxes smaller widths, show/hide parameters based on other parameter values.

I know i could write my own web page that does this and hide the parameters toolbar when they run the report, but this would mean that we lose other functionality that report manager has, eg. scheduling.

Does anyone know if customising the report manager will become available in a later version?

You're correct that you can't customize Report Manager like this in RS 2005. You're also correct that if you wrote your own app using the Reporting controls in VS 2005, you'd have a lot of flexibility.

As for whether you'll be able to do this customization of RM in a later version, I doubt it, but there is "talk" of shipping add'l VS Reporting controls for things like scheduling and security, so you could build your own RM implementation.

Customise Report Parameters in Report Manager

Is it possible to add custom controls in for parameters in report manager?

I have a parameter that requires the user to click a button and select a bunch of things in another form. How can i do this in reporting services?

I also would like to change the layout of the parameters toolbar, ie. make text boxes smaller widths, show/hide parameters based on other parameter values.

I know i could write my own web page that does this and hide the parameters toolbar when they run the report, but this would mean that we lose other functionality that report manager has, eg. scheduling.

Does anyone know if customising the report manager will become available in a later version?

You're correct that you can't customize Report Manager like this in RS 2005. You're also correct that if you wrote your own app using the Reporting controls in VS 2005, you'd have a lot of flexibility.

As for whether you'll be able to do this customization of RM in a later version, I doubt it, but there is "talk" of shipping add'l VS Reporting controls for things like scheduling and security, so you could build your own RM implementation.

Custom DataFlow Transformation not showing up in toolbox

I've created a custom data flow tranformation and it isn't showing up in the Tool Box Items to be added under the Data Flow Items tab (right click on tool box, 'Choose Items...', then clicked Data Flow Items).

I have done the following:

signed the assembly,

added to GAC,

copied the dll to C:\Program Files\Microsoft SQL Server\90\DTS\PipelineComponents.

It worked previously when I was just starting out, however now I cannot see it. What would cause it to not show up? Everything compiles fine. How would I determine how to fix it so that it shows up?

Apart from the component being in the GAC, there are two key steps to be taken for a custom component to be recognized by the BI Studio:

placing the binary under the folder where SSIS design time checks to enumerate pipeline components, which is at <SQL Installation Folder>\90\DTS\Pipeline Components (I'd double check this on the target machine via the reg key at the very bottom, cause it could be different on a 64bit or in a production server)

Custom Data Extension - Designer Extension Could Not Be Loaded

Hi All,

I've managed (finally) to get a Custom Data Extension to work in Reporting Services 2005. The next problem I have is that whenever I click on the "data" tab when creating a report (from Visual Studio 2005) an error appears: "The designer extension <ext name> could not be loaded. Check the configuration file RsReportDesigner.config".

Is there some way of getting rid of this error message? Such as creating a designer, if so does anyone know how (I don't need the designer to do anything, just not crash)? I can still modify the data for the report etc its just annoying that's all.

Cheers,

Dan.

Make sure that you have your data extension registered in the
RSReportDesigner.config file, located here: C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\. Also, to use the generic query designer, be sure to add the following line to the <Designer> element of the config file (changed to use the name of your data extension).

<Extension Name="DataExtrensionName" Type="Microsoft.ReportingServices.QueryDesigners.GenericQueryDesigner,Microsoft.ReportingServices.QueryDesigners"/>

Ian|||

Hi Ian,

Thanks for the quick reply that worked a treat! Nice one.

I'm guessing there is a way to create your own designers? I'll look into the QueryDesigners namespace and have a poke about :-)

Thanks again,

Dan.