Adjust Parameter Dropdown control Size/Length

Dear Anyone,

Is there a way to adjust Parameter Dropdown control Size/Length of a report so that it would no longer display a scrollbar?

Thanks,
JosephSorry, this is not a customizable property.

-Danielsql

Adjust Parameter Dropdown control Size/Length

Dear Anyone,

Is there a way to adjust Parameter Dropdown control Size/Length of a report so that it would no longer display a scrollbar?

Thanks,
JosephSorry, this is not a customizable property.

-Daniel

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

Adding Table Columns

Any help with this will be appreciated:
I have a simple table control in a report that has values in cells, some of
the cells contain values based on values of fields in the dataset i.e.
IIF(Field1 < Field2, Field1, Field2). How would I go about adding together
the actual results of cells in a grouping rather than also specifying the IIF
logic in the group for the sum textbox? The results are not the same compared
to if you had to add the results of the cells. See the table below of what is
happening:
Field1 |Field2 |Cell Value = IIF(Field1 < Field2, Field1, Field2)
Detail |1000 |2000 |1000
Detail |2000 |1500 |1500
Group |
Footer| 3000 |3500 |3000 (I want this toreflect 2500)
Ideally I would use the ReportItems collection but you can only use that in
the page header or footer. Am I doing something stupid or missing something?
Hope this makes sense!Hey just do a sum (Field!txt.value, "Group1") which will sum that group and
need not use cell value.
Amarnath
"WvanWyk" wrote:
> Any help with this will be appreciated:
> I have a simple table control in a report that has values in cells, some of
> the cells contain values based on values of fields in the dataset i.e.
> IIF(Field1 < Field2, Field1, Field2). How would I go about adding together
> the actual results of cells in a grouping rather than also specifying the IIF
> logic in the group for the sum textbox? The results are not the same compared
> to if you had to add the results of the cells. See the table below of what is
> happening:
> Field1 |Field2 |Cell Value = IIF(Field1 < Field2, Field1, Field2)
> Detail |1000 |2000 |1000
> Detail |2000 |1500 |1500
> Group |
> Footer| 3000 |3500 |3000 (I want this toreflect 2500)
> Ideally I would use the ReportItems collection but you can only use that in
> the page header or footer. Am I doing something stupid or missing something?
> Hope this makes sense!sql

Adding Radio button in SQL Reporting services? Is there a work ar

Hey Peeps,
Is there anyway I could get a radio box added to my report either by adding
the radio button control to the tool box or adding a custom DLL with radio
button functionality. My objective is to simulate a "Jump to report" inbuilt
functionality using radio buttons. Like when the end user clicks on either of
the two radio buttons, he should see another report with parameters passed
into the second one. Any quick help is heartfully appreciatedI know some people have done something similar using windings font. I just
have a textbox with a phrase and make it blue and underlined.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Balaji" <Balaji@.discussions.microsoft.com> wrote in message
news:D65FA0B1-7845-43E6-A3C0-5B520ADF6BFF@.microsoft.com...
> Hey Peeps,
> Is there anyway I could get a radio box added to my report either by
> adding
> the radio button control to the tool box or adding a custom DLL with radio
> button functionality. My objective is to simulate a "Jump to report"
> inbuilt
> functionality using radio buttons. Like when the end user clicks on either
> of
> the two radio buttons, he should see another report with parameters passed
> into the second one. Any quick help is heartfully appreciated
>|||Hey Bruce,
Thanks mate, for the quick reply. But if I were to use a text box (shrinked
to a very small size) then does it function like radio button. Like in the
sense, does it toggle on and off on simultaneous clicks'
"Bruce L-C [MVP]" wrote:
> I know some people have done something similar using windings font. I just
> have a textbox with a phrase and make it blue and underlined.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Balaji" <Balaji@.discussions.microsoft.com> wrote in message
> news:D65FA0B1-7845-43E6-A3C0-5B520ADF6BFF@.microsoft.com...
> > Hey Peeps,
> >
> > Is there anyway I could get a radio box added to my report either by
> > adding
> > the radio button control to the tool box or adding a custom DLL with radio
> > button functionality. My objective is to simulate a "Jump to report"
> > inbuilt
> > functionality using radio buttons. Like when the end user clicks on either
> > of
> > the two radio buttons, he should see another report with parameters passed
> > into the second one. Any quick help is heartfully appreciated
> >
>
>|||No, it does not.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Balaji" <Balaji@.discussions.microsoft.com> wrote in message
news:352D0DFE-4CF1-4E31-B8D8-8D9E88A54753@.microsoft.com...
> Hey Bruce,
> Thanks mate, for the quick reply. But if I were to use a text box
(shrinked
> to a very small size) then does it function like radio button. Like in the
> sense, does it toggle on and off on simultaneous clicks'
> "Bruce L-C [MVP]" wrote:
> > I know some people have done something similar using windings font. I
just
> > have a textbox with a phrase and make it blue and underlined.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Balaji" <Balaji@.discussions.microsoft.com> wrote in message
> > news:D65FA0B1-7845-43E6-A3C0-5B520ADF6BFF@.microsoft.com...
> > > Hey Peeps,
> > >
> > > Is there anyway I could get a radio box added to my report either by
> > > adding
> > > the radio button control to the tool box or adding a custom DLL with
radio
> > > button functionality. My objective is to simulate a "Jump to report"
> > > inbuilt
> > > functionality using radio buttons. Like when the end user clicks on
either
> > > of
> > > the two radio buttons, he should see another report with parameters
passed
> > > into the second one. Any quick help is heartfully appreciated
> > >
> >
> >
> >|||Hi,
This article could help you:
http://www.sqljunkies.com/Article/?type=2&cat=32
success pakam
"Balaji" wrote:
> Hey Peeps,
> Is there anyway I could get a radio box added to my report either by adding
> the radio button control to the tool box or adding a custom DLL with radio
> button functionality. My objective is to simulate a "Jump to report" inbuilt
> functionality using radio buttons. Like when the end user clicks on either of
> the two radio buttons, he should see another report with parameters passed
> into the second one. Any quick help is heartfully appreciated
>

Adding an Image

Hello:

I have an Image control on my report .

I have a Class for example :

public Class Class1

private _MyPic as System.Drawing.Image

public property MyPic as System.Drawing.Image

......

end

end

the Dataset Of My Report is Class1.

i Drop an Image from toolbar in My Report and set Source to Database and set value to =Fields!MyPic.value

befor showing the Report i Create an object from Class1 and fill MyPic and set DataSet of Report to that Object

but i see a Red X instead of Picture

please help me

thanks alot

Setting the image source = Database is correct, but you have to convert the System.Drawing.Image into the actual image data as byte array.

Here is a C# code snippet to convert an image into a byte[] using a MemoryStream:

// save image to byte[]
System.IO.MemoryStream renderedImage = new MemoryStream();
myImage.Save(renderedImage);
renderedImage.Position = 0;
return renderedImage.ToArray();

-- Robert