Change the size of drop down parameter box

Im trying to make it so my drop down box on the parameter for my report
automatically fits or at least I can specify the size. Im using ssrs 2005
and there is a sroll bar on on both sides. I would like to increase the size
so I dont have these but dont know how to. PLEASE HELP!!!!On Jun 28, 12:04 pm, OWeston <OWes...@.discussions.microsoft.com>
wrote:
> Im trying to make it so my drop down box on the parameter for my report
> automatically fits or at least I can specify the size. Im using ssrs 2005
> and there is a sroll bar on on both sides. I would like to increase the size
> so I dont have these but dont know how to. PLEASE HELP!!!!
This is a pretty regular request on this news group. Currently, this
type of property cannot be controlled; but, hopefully it will be
available in the near future (perhaps w/SSRS 2008). Sorry that I could
not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||Is there a fix/update for this yet?
"EMartinez" wrote:
> On Jun 28, 12:04 pm, OWeston <OWes...@.discussions.microsoft.com>
> wrote:
> > Im trying to make it so my drop down box on the parameter for my report
> > automatically fits or at least I can specify the size. Im using ssrs 2005
> > and there is a sroll bar on on both sides. I would like to increase the size
> > so I dont have these but dont know how to. PLEASE HELP!!!!
>
> This is a pretty regular request on this news group. Currently, this
> type of property cannot be controlled; but, hopefully it will be
> available in the near future (perhaps w/SSRS 2008). Sorry that I could
> not be of greater assistance.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Jul 10, 1:14 pm, JMD <J...@.discussions.microsoft.com> wrote:
> Is there a fix/update for this yet?
> "EMartinez" wrote:
> > On Jun 28, 12:04 pm, OWeston <OWes...@.discussions.microsoft.com>
> > wrote:
> > > Im trying to make it so my drop down box on the parameter for my report
> > > automatically fits or at least I can specify the size. Im using ssrs 2005
> > > and there is a sroll bar on on both sides. I would like to increase the size
> > > so I dont have these but dont know how to. PLEASE HELP!!!!
> > This is a pretty regular request on this news group. Currently, this
> > type of property cannot be controlled; but, hopefully it will be
> > available in the near future (perhaps w/SSRS 2008). Sorry that I could
> > not be of greater assistance.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
I've checked Microsoft.com and haven't found anything available yet.
Regards,
Enrique Martinez
Sr. Software Consultant

Change Subtotal background color.

I created a Matrix report with subtotals.
It would be easier to read if the subtotals were shaded.
How do I shade the subtotal box. Not the lable box.
I can see the box labled totals and it is shaded it is the real total box
that I need to shade.
Thank you
Scott BurkeScott,
Using the inscope() function with the names of the matrix rows you are able
to tell when the row is a subtotal or not, then place the iif function in the
background color and sometimes the font color.
If you need more help I can find my code example. Last contract have to dig
it up.
Reeves
"Scott Burke" wrote:
> I created a Matrix report with subtotals.
> It would be easier to read if the subtotals were shaded.
> How do I shade the subtotal box. Not the lable box.
> I can see the box labled totals and it is shaded it is the real total box
> that I need to shade.
> Thank you
> Scott Burke|||Thanks for your time. However, Visual Sudioes has an error and shut down.
now the report I was working on is gone........
I will try your suggestion when I rebuild the report
Thanks again.
Scott Burke
"Reeves Smith" wrote:
> Scott,
> Using the inscope() function with the names of the matrix rows you are able
> to tell when the row is a subtotal or not, then place the iif function in the
> background color and sometimes the font color.
> If you need more help I can find my code example. Last contract have to dig
> it up.
> Reeves
>
> "Scott Burke" wrote:
> > I created a Matrix report with subtotals.
> >
> > It would be easier to read if the subtotals were shaded.
> >
> > How do I shade the subtotal box. Not the lable box.
> >
> > I can see the box labled totals and it is shaded it is the real total box
> > that I need to shade.
> >
> > Thank you
> > Scott Burke|||On May 31, 8:38 am, Scott Burke <ScottBu...@.discussions.microsoft.com>
wrote:
> Thanks for your time. However, Visual Sudioes has an error and shut down.
> now the report I was working on is gone........
> I will try your suggestion when I rebuild the report
> Thanks again.
> Scott Burke
> "Reeves Smith" wrote:
> > Scott,
> > Using the inscope() function with the names of the matrix rows you are able
> > to tell when the row is a subtotal or not, then place the iif function in the
> > background color and sometimes the font color.
> > If you need more help I can find my code example. Last contract have to dig
> > it up.
> > Reeves
> > "Scott Burke" wrote:
> > > I created a Matrix report with subtotals.
> > > It would be easier to read if the subtotals were shaded.
> > > How do I shade the subtotal box. Not the lable box.
> > > I can see the box labled totals and it is shaded it is the real total box
> > > that I need to shade.
> > > Thank you
> > > Scott Burke
Also, you could try an expression similar to this in the background
color property:
=iif(Fields!FieldName.Value Like "subtotal*", "Yellow", "White")
Where FieldName can be from an adjacent cell.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Hi EMartinez,
I tried that but it did not work.
I tried the expression : =iif(Fields!textbox6.Value ='Total','lightgrey','transparent')
The box next to it is named "textbox6" with a value of
"Fields!magazinename.value"
The errror is "out of scope".
I am trying to referance the box name or the contents in the box?
Scott Burke
"EMartinez" wrote:
> On May 31, 8:38 am, Scott Burke <ScottBu...@.discussions.microsoft.com>
> wrote:
> > Thanks for your time. However, Visual Sudioes has an error and shut down.
> > now the report I was working on is gone........
> >
> > I will try your suggestion when I rebuild the report
> > Thanks again.
> > Scott Burke
> >
> > "Reeves Smith" wrote:
> > > Scott,
> >
> > > Using the inscope() function with the names of the matrix rows you are able
> > > to tell when the row is a subtotal or not, then place the iif function in the
> > > background color and sometimes the font color.
> >
> > > If you need more help I can find my code example. Last contract have to dig
> > > it up.
> >
> > > Reeves
> >
> > > "Scott Burke" wrote:
> >
> > > > I created a Matrix report with subtotals.
> >
> > > > It would be easier to read if the subtotals were shaded.
> >
> > > > How do I shade the subtotal box. Not the lable box.
> >
> > > > I can see the box labled totals and it is shaded it is the real total box
> > > > that I need to shade.
> >
> > > > Thank you
> > > > Scott Burke
>
> Also, you could try an expression similar to this in the background
> color property:
> =iif(Fields!FieldName.Value Like "subtotal*", "Yellow", "White")
> Where FieldName can be from an adjacent cell.
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||OK. I found the answear. Please try NOT to laught too loud. It will hurt
my feelings.
On the totals box there is an arrow in the upper right corner. If you click
on the arrow you will get the properties of the total box itself. Click
anywhere else in the box adn you get the properties of the subtotal label box.
Have fun over the weekend.
Scott Burke
"EMartinez" wrote:
> On May 31, 8:38 am, Scott Burke <ScottBu...@.discussions.microsoft.com>
> wrote:
> > Thanks for your time. However, Visual Sudioes has an error and shut down.
> > now the report I was working on is gone........
> >
> > I will try your suggestion when I rebuild the report
> > Thanks again.
> > Scott Burke
> >
> > "Reeves Smith" wrote:
> > > Scott,
> >
> > > Using the inscope() function with the names of the matrix rows you are able
> > > to tell when the row is a subtotal or not, then place the iif function in the
> > > background color and sometimes the font color.
> >
> > > If you need more help I can find my code example. Last contract have to dig
> > > it up.
> >
> > > Reeves
> >
> > > "Scott Burke" wrote:
> >
> > > > I created a Matrix report with subtotals.
> >
> > > > It would be easier to read if the subtotals were shaded.
> >
> > > > How do I shade the subtotal box. Not the lable box.
> >
> > > > I can see the box labled totals and it is shaded it is the real total box
> > > > that I need to shade.
> >
> > > > Thank you
> > > > Scott Burke
>
> Also, you could try an expression similar to this in the background
> color property:
> =iif(Fields!FieldName.Value Like "subtotal*", "Yellow", "White")
> Where FieldName can be from an adjacent cell.
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||Scott,
I'm not laughing as I did not even know that existed, thanks for the find.
Reeves
"Scott Burke" wrote:
> OK. I found the answear. Please try NOT to laught too loud. It will hurt
> my feelings.
> On the totals box there is an arrow in the upper right corner. If you click
> on the arrow you will get the properties of the total box itself. Click
> anywhere else in the box adn you get the properties of the subtotal label box.
> Have fun over the weekend.
> Scott Burke
> "EMartinez" wrote:
> > On May 31, 8:38 am, Scott Burke <ScottBu...@.discussions.microsoft.com>
> > wrote:
> > > Thanks for your time. However, Visual Sudioes has an error and shut down.
> > > now the report I was working on is gone........
> > >
> > > I will try your suggestion when I rebuild the report
> > > Thanks again.
> > > Scott Burke
> > >
> > > "Reeves Smith" wrote:
> > > > Scott,
> > >
> > > > Using the inscope() function with the names of the matrix rows you are able
> > > > to tell when the row is a subtotal or not, then place the iif function in the
> > > > background color and sometimes the font color.
> > >
> > > > If you need more help I can find my code example. Last contract have to dig
> > > > it up.
> > >
> > > > Reeves
> > >
> > > > "Scott Burke" wrote:
> > >
> > > > > I created a Matrix report with subtotals.
> > >
> > > > > It would be easier to read if the subtotals were shaded.
> > >
> > > > > How do I shade the subtotal box. Not the lable box.
> > >
> > > > > I can see the box labled totals and it is shaded it is the real total box
> > > > > that I need to shade.
> > >
> > > > > Thank you
> > > > > Scott Burke
> >
> >
> > Also, you could try an expression similar to this in the background
> > color property:
> > =iif(Fields!FieldName.Value Like "subtotal*", "Yellow", "White")
> > Where FieldName can be from an adjacent cell.
> > Hope this helps.
> >
> > Regards,
> >
> > Enrique Martinez
> > Sr. Software Consultant
> >
> >|||On Jun 1, 1:59 pm, Scott Burke <ScottBu...@.discussions.microsoft.com>
wrote:
> OK. I found the answear. Please try NOT to laught too loud. It will hurt
> my feelings.
> On the totals box there is an arrow in the upper right corner. If you click
> on the arrow you will get the properties of the total box itself. Click
> anywhere else in the box adn you get the properties of the subtotal label box.
> Have fun over the weekend.
> Scott Burke
> "EMartinez" wrote:
> > On May 31, 8:38 am, Scott Burke <ScottBu...@.discussions.microsoft.com>
> > wrote:
> > > Thanks for your time. However, Visual Sudioes has an error and shut down.
> > > now the report I was working on is gone........
> > > I will try your suggestion when I rebuild the report
> > > Thanks again.
> > > Scott Burke
> > > "Reeves Smith" wrote:
> > > > Scott,
> > > > Using the inscope() function with the names of the matrix rows you are able
> > > > to tell when the row is a subtotal or not, then place the iif function in the
> > > > background color and sometimes the font color.
> > > > If you need more help I can find my code example. Last contract have to dig
> > > > it up.
> > > > Reeves
> > > > "Scott Burke" wrote:
> > > > > I created a Matrix report with subtotals.
> > > > > It would be easier to read if the subtotals were shaded.
> > > > > How do I shade the subtotal box. Not the lable box.
> > > > > I can see the box labled totals and it is shaded it is the real total box
> > > > > that I need to shade.
> > > > > Thank you
> > > > > Scott Burke
> > Also, you could try an expression similar to this in the background
> > color property:
> > =iif(Fields!FieldName.Value Like "subtotal*", "Yellow", "White")
> > Where FieldName can be from an adjacent cell.
> > Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
Glad you solved the problem. Let me know if I can be of greater
assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Change SqlCommand Based On Combo Box Selection

I have a textbox, combo box, and a button on a form. I would like to perform a different query depending on the combo box selection. I thought I could do something such as:

if (cboSearch.Text =="Selection1") { scCmd ="SELECT * FROM tblTable WHERE txtSearch = @.Selection1"; }else if (cboSearch.Text =="Selection2") { scCmd ="SELECT * FROM tblTable WHERE txtSearch = @.Selection2"; }else { scCmd ="SELECT * FROM tblTable WHERE txtSearch = @.Selection3"; }

However, this obviously does not operate as I would need it to. What is the proper method for conditional SqlCommand statements like this?

You need to pass the value in as a Control Parameter.

http://msdn2.microsoft.com/en-us/library/system.web.ui.webcontrols.controlparameter.aspx