Showing posts with label toolbox. Show all posts
Showing posts with label toolbox. Show all posts

Thursday, March 22, 2012

Adding user control to reports

I'm trying to use my own user control (build with vb.net).
I've added the user control to the toolbox but it's disable.
How can i enable it?If its disabled, its likely you cant use it in reports. Do you want to use
it in the actual report or as a report parameter?
Mark
"Ido" wrote:
> I'm trying to use my own user control (build with vb.net).
> I've added the user control to the toolbox but it's disable.
> How can i enable it?|||I want to use it in the actual report. I'm using the same user control on a
regular windows form without any problems. I've got this problem only with
the sql report service.
"Mark" wrote:
> If its disabled, its likely you cant use it in reports. Do you want to use
> it in the actual report or as a report parameter?
> Mark
> "Ido" wrote:
> > I'm trying to use my own user control (build with vb.net).
> > I've added the user control to the toolbox but it's disable.
> > How can i enable it?|||In 2000 you cannot do this. There is going to be some additional
capabilities for adding in user controls but I am not really up to speed on
it. I doubt that it will be as simple as taking a user control you have that
works in winforms.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ido" <Ido@.discussions.microsoft.com> wrote in message
news:7E584A7E-BB1F-4FE0-84BC-53090DA90D6A@.microsoft.com...
>I want to use it in the actual report. I'm using the same user control on a
> regular windows form without any problems. I've got this problem only with
> the sql report service.
> "Mark" wrote:
>> If its disabled, its likely you cant use it in reports. Do you want to
>> use
>> it in the actual report or as a report parameter?
>> Mark
>> "Ido" wrote:
>> > I'm trying to use my own user control (build with vb.net).
>> > I've added the user control to the toolbox but it's disable.
>> > How can i enable it?|||Bruce is right. There is a new feature in RS 2005 called CustomReportItem
which allows you integrate custom controls. There is a design time UI
component and a runtime component (which will run inside report designer
preview and on the report server). These controls have to implement certain
interfaces and there are some restrictions on what these custom controls can
generate in the report output. Although this sounds very limiting, you will
get many other RS features for free (e.g. support of your CustomReportItem
control across all rendering output formats, creating and rendering history
snapshots, subscriptions, etc.). The implementation of such custom controls
is however not trivial.
You may want to check out Chris Hays' brand-new sample in the meantime:
http://blogs.msdn.com/chrishays/archive/2005/10/04/CustomReportItemSample.aspx
I will also post some samples and tips around implementing CustomReportItems
in future. There is also a book currently being worked on about how to
implement such CustomReportItem controls to extend the capabilities of SQL
Server 2005 Reporting Services.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uvWVJltzFHA.2076@.TK2MSFTNGP14.phx.gbl...
> In 2000 you cannot do this. There is going to be some additional
> capabilities for adding in user controls but I am not really up to speed
> on it. I doubt that it will be as simple as taking a user control you have
> that works in winforms.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Ido" <Ido@.discussions.microsoft.com> wrote in message
> news:7E584A7E-BB1F-4FE0-84BC-53090DA90D6A@.microsoft.com...
>>I want to use it in the actual report. I'm using the same user control on
>>a
>> regular windows form without any problems. I've got this problem only
>> with
>> the sql report service.
>> "Mark" wrote:
>> If its disabled, its likely you cant use it in reports. Do you want to
>> use
>> it in the actual report or as a report parameter?
>> Mark
>> "Ido" wrote:
>> > I'm trying to use my own user control (build with vb.net).
>> > I've added the user control to the toolbox but it's disable.
>> > How can i enable it?
>sql

Thursday, February 16, 2012

Adding Custom component to the Tool Box

Hi,

I was trying the SSIS programming samples,that comes with installation of SQL Server 2005, I want to load the ChangeCase DLL in the toolbox.

The readMe file gives the direction. It does not work. It says you will see component in once you see DataFlow Task button( clicking Choose Items in the tools box).

I cannot load the custom component to the toolbox, Can I get some help.

Thank you,

Have a quick look at this -

How do I install a task or transform component? - http://www.konesans.com/faq.aspx#installtask

You do not see you component in the "SSIS Data Flow Items" tab? If it is not listed there, then it is not installed correctly. Components must be place in the GAC so that they can be found at run-time. They must also be placed in the SSIS specific PipelineComponents folder so that they can be found by the designer. This is where the Choose Toolbox stuff looks. By default this is -

C:\Program Files\Microsoft SQL Server\90\DTS\PipelineComponents

The location is actually defined in a registry key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETFramework\AssemblyFolders\DTS Pipeline Components". The AssemblyFolders is where VS searches for assemblies that can be added like this.

Adding custom buttons to the parameters toolbox?

Hi,

I am interested in adding custom buttons to the parameters toolbox (under "View Report"). I'm trying to provde a way for users viewing the report to go "Back" or up a level (in the drill through reports). Does anyone have any information on this topic, or know if it's even possible?

Thanks in advance,

-Brandon

It is not possible to change the built in parameter bar.

As far as addressing your issue, you can put a hyperlink on each report and in the Jump To URL section use an expression like =“javascript:history.back()”|||I figured as much, but it never hurts to ask.... thanks for the sugestion, I'll just rig up something as usual.