Change height of image control

Is it possible to use an iif statement to set the height of an image
control. I have tried something like this, but it did not work:
iif(Parameters!parm < 20,1.5in,.5in). I also tried putting double quotes
around the 1.5in and .5in, but that didn't work either.
Thanks,On Jun 1, 9:33 am, "Tim Kelley" <tkel...@.company.com> wrote:
> Is it possible to use an iif statement to set the height of an image
> control. I have tried something like this, but it did not work:
> iif(Parameters!parm < 20,1.5in,.5in). I also tried putting double quotes
> around the 1.5in and .5in, but that didn't work either.
> Thanks,
As far as I know, it is not possible. Why are you needing to adjust
the image size? Are you trying to swap images?
Enrique Martinez
Sr. Software Consultant|||I have a subreport that will have a varying amout of lines. I have a bitmap
I am using for a border and would like to grow or shrink the bitmap based on
how many lines are in the subreport. I will probably need to resize the
subreport control too if that is possible.
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1180742850.339314.203650@.q69g2000hsb.googlegroups.com...
> On Jun 1, 9:33 am, "Tim Kelley" <tkel...@.company.com> wrote:
>> Is it possible to use an iif statement to set the height of an image
>> control. I have tried something like this, but it did not work:
>> iif(Parameters!parm < 20,1.5in,.5in). I also tried putting double quotes
>> around the 1.5in and .5in, but that didn't work either.
>> Thanks,
>
> As far as I know, it is not possible. Why are you needing to adjust
> the image size? Are you trying to swap images?
> Enrique Martinez
> Sr. Software Consultant
>|||On Jun 4, 7:37 am, "Tim Kelley" <tkel...@.company.com> wrote:
> I have a subreport that will have a varying amout of lines. I have a bitmap
> I am using for a border and would like to grow or shrink the bitmap based on
> how many lines are in the subreport. I will probably need to resize the
> subreport control too if that is possible.
> "EMartinez" <emartinez...@.gmail.com> wrote in message
> news:1180742850.339314.203650@.q69g2000hsb.googlegroups.com...
> > On Jun 1, 9:33 am, "Tim Kelley" <tkel...@.company.com> wrote:
> >> Is it possible to use an iif statement to set the height of an image
> >> control. I have tried something like this, but it did not work:
> >> iif(Parameters!parm < 20,1.5in,.5in). I also tried putting double quotes
> >> around the 1.5in and .5in, but that didn't work either.
> >> Thanks,
> > As far as I know, it is not possible. Why are you needing to adjust
> > the image size? Are you trying to swap images?
> > Enrique Martinez
> > Sr. Software Consultant
You might be able to achieve the same result via a border style in a
header of the subreport, etc. As far as I know, resizing the subreport
may not be feasible. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Would it be possible to move the subreport or other controls on the report?
Tim
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1180998091.389326.168520@.o5g2000hsb.googlegroups.com...
> On Jun 4, 7:37 am, "Tim Kelley" <tkel...@.company.com> wrote:
>> I have a subreport that will have a varying amout of lines. I have a
>> bitmap
>> I am using for a border and would like to grow or shrink the bitmap based
>> on
>> how many lines are in the subreport. I will probably need to resize the
>> subreport control too if that is possible.
>> "EMartinez" <emartinez...@.gmail.com> wrote in message
>> news:1180742850.339314.203650@.q69g2000hsb.googlegroups.com...
>> > On Jun 1, 9:33 am, "Tim Kelley" <tkel...@.company.com> wrote:
>> >> Is it possible to use an iif statement to set the height of an image
>> >> control. I have tried something like this, but it did not work:
>> >> iif(Parameters!parm < 20,1.5in,.5in). I also tried putting double
>> >> quotes
>> >> around the 1.5in and .5in, but that didn't work either.
>> >> Thanks,
>> > As far as I know, it is not possible. Why are you needing to adjust
>> > the image size? Are you trying to swap images?
>> > Enrique Martinez
>> > Sr. Software Consultant
>
> You might be able to achieve the same result via a border style in a
> header of the subreport, etc. As far as I know, resizing the subreport
> may not be feasible. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>

Change Data Source at run time

Hi,
I am using a web Report viewer control for viewing reports on a SRS 2005
report server.
Is it possible to change the data source of the report at run-time?
e.g. I have 2 identical databases - the live database and a test
database. I want to be able to set the data source to point to one of
these depending whether I am testing or not.
This was easily achieved with Crystal, but I cannot work out how to do
it using SQL Reporting Services.
Any help apprectiated.
Thanks.
PaulIf you are using the VS 2005 viewer control then I think you can set it in
there. Another option might be to base the report on a stored procedure
that returns records based on a parameter sent. For example, if parameter =1 then select from live database and if = 0 select from test database.
David
"Paul Cheetham" <PAC.News@.dsl.pipex.com> wrote in message
news:ODJVQZm2HHA.5884@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I am using a web Report viewer control for viewing reports on a SRS 2005
> report server.
> Is it possible to change the data source of the report at run-time?
> e.g. I have 2 identical databases - the live database and a test database.
> I want to be able to set the data source to point to one of these
> depending whether I am testing or not.
> This was easily achieved with Crystal, but I cannot work out how to do it
> using SQL Reporting Services.
> Any help apprectiated.
> Thanks.
>
> Paul|||see ths 2005 BOL at
http://msdn2.microsoft.com/en-us/library/ms156450.aspx
"Paul Cheetham" <PAC.News@.dsl.pipex.com> wrote in message
news:ODJVQZm2HHA.5884@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I am using a web Report viewer control for viewing reports on a SRS 2005
> report server.
> Is it possible to change the data source of the report at run-time?
> e.g. I have 2 identical databases - the live database and a test database.
> I want to be able to set the data source to point to one of these
> depending whether I am testing or not.
> This was easily achieved with Crystal, but I cannot work out how to do it
> using SQL Reporting Services.
> Any help apprectiated.
> Thanks.
>
> Paul

Change Control Application

Is there a decent application that costs under $1000 that can be used to
maintain change control on SQL Server database schemas and stored
procedures/triggers? Embarcadero had such a utility a few years ago, and
we did an early beta only to find it didn't actually work. I went back to
their site and see they apparently no longer market it.
It's incredibly useful to be able to point to a database on a server in
realtime, instantly create a snapshot of the files needed to recreate the
database, and then place those change files into a source control system.
Something that could automate much of this work would be a welcome tool.
Will
Hi
Apart from the scripting options available in Enterprise Manager you may
want to look at dbghost www.dbghost.com or red gate tools www.red-gate.com,
you would require a separate source code control system such as Source Safe
or PVCS.
John
"Will" wrote:

> Is there a decent application that costs under $1000 that can be used to
> maintain change control on SQL Server database schemas and stored
> procedures/triggers? Embarcadero had such a utility a few years ago, and
> we did an early beta only to find it didn't actually work. I went back to
> their site and see they apparently no longer market it.
> It's incredibly useful to be able to point to a database on a server in
> realtime, instantly create a snapshot of the files needed to recreate the
> database, and then place those change files into a source control system.
> Something that could automate much of this work would be a welcome tool.
> --
> Will
>
>
|||Hi,
Embarcadero still market that tool and i have it .
It is very effective and good.They have emproved a lot.
u can search again on there site\.
from
Killer

Change Control Application

Is there a decent application that costs under $1000 that can be used to
maintain change control on SQL Server database schemas and stored
procedures/triggers? Embarcadero had such a utility a few years ago, and
we did an early beta only to find it didn't actually work. I went back to
their site and see they apparently no longer market it.
It's incredibly useful to be able to point to a database on a server in
realtime, instantly create a snapshot of the files needed to recreate the
database, and then place those change files into a source control system.
Something that could automate much of this work would be a welcome tool.
--
WillHi
Apart from the scripting options available in Enterprise Manager you may
want to look at dbghost www.dbghost.com or red gate tools www.red-gate.com,
you would require a separate source code control system such as Source Safe
or PVCS.
John
"Will" wrote:
> Is there a decent application that costs under $1000 that can be used to
> maintain change control on SQL Server database schemas and stored
> procedures/triggers? Embarcadero had such a utility a few years ago, and
> we did an early beta only to find it didn't actually work. I went back to
> their site and see they apparently no longer market it.
> It's incredibly useful to be able to point to a database on a server in
> realtime, instantly create a snapshot of the files needed to recreate the
> database, and then place those change files into a source control system.
> Something that could automate much of this work would be a welcome tool.
> --
> Will
>
>|||Hi,
Embarcadero still market that tool and i have it .
It is very effective and good.They have emproved a lot.
u can search again on there site\.
from
Killer

Change Control Application

Is there a decent application that costs under $1000 that can be used to
maintain change control on SQL Server database schemas and stored
procedures/triggers? Embarcadero had such a utility a few years ago, and
we did an early beta only to find it didn't actually work. I went back to
their site and see they apparently no longer market it.
It's incredibly useful to be able to point to a database on a server in
realtime, instantly create a snapshot of the files needed to recreate the
database, and then place those change files into a source control system.
Something that could automate much of this work would be a welcome tool.
WillHi
Apart from the scripting options available in Enterprise Manager you may
want to look at dbghost www.dbghost.com or red gate tools www.red-gate.com,
you would require a separate source code control system such as Source Safe
or PVCS.
John
"Will" wrote:

> Is there a decent application that costs under $1000 that can be used to
> maintain change control on SQL Server database schemas and stored
> procedures/triggers? Embarcadero had such a utility a few years ago, and
> we did an early beta only to find it didn't actually work. I went back t
o
> their site and see they apparently no longer market it.
> It's incredibly useful to be able to point to a database on a server in
> realtime, instantly create a snapshot of the files needed to recreate the
> database, and then place those change files into a source control system.
> Something that could automate much of this work would be a welcome tool.
> --
> Will
>
>|||Hi,
Embarcadero still market that tool and i have it .
It is very effective and good.They have emproved a lot.
u can search again on there site\.
from
Killer

CellSetGrid

Richard,
Long time no talk.
I am trying to run your cellsetgrid control but it gives me an error "A
connection cannot be made. Ensure that the server is running."
Any idea what it is?
thanks
SaranyaRichard,
I am getting an error when I try to load cellsetgrid in windows 2003
server/ SQL 2000 in my laptop.
It says something like "a connection could not be established, check if
server is running". It looks like you have set that custom error
message up in the control. Can you tell me what are the pluasible cause
to trigger that error message.
I never had problem figuring out AS 2000 issues before. This time I
give up. Unless the creator can help me.
so please!!!
thanks
Saranya

Causing a PostBack when user changes a parameter in Report Viewer

Does anyone know of a way to cause a postback when the user changes a parameter in the report viewer control? I need it to postback even if it is just text that was changed in a textbox. Basically I need it to do the same thing as when you click on a DateTime parameter to set a date.

I need this because I am allowing the user to save the settings as a preset to a XML file without having to first run the report. The GetParameters() method won't give me the new client selections without first running the report. But a postback will allow the GetParameters() method to give me the right parameters without running it.

Any ideas?

Nevermind...I have a workaround.

I just added a submit() to the "onclick" event to the Save Preset button. This updates the Report Viewer and then calls my C# function to get the parameter settings.

Catching Events

Hi,

I'm trying to catch an error and trigger a control flow to handle it. I introduce a control flow to catch "OnError" event, but , despite muy package has some errors it doesnt work...

Another issue, if i omit an error on a transformation object ( in order let the flow continue executing), can this error be managed by an event or record it in a log?

Thanks

Albertoim wrote:

Hi,

I'm trying to catch an error and trigger a control flow to handle it. I introduce a control flow to catch "OnError" event, but , despite muy package has some errors it doesnt work...

Thanks

How do you know it doesn't work?

|||

Because the flow i have added to execute when the error event happens does not execute.

|||I have added the event handler at the top level ( Package) for errors events and information events indeed and, as i said before, the flow to execute in this events does not execute. May i have to set some propertie to enable event catching?|||

Hi,

I have done several tests in a new blank project and error events work properly. I have notice that, in th project where i cant catch events, the txt log file is allways blank, so , i supose its something worng with the events, that for any reason arent raised.

In project properties, "DisableEventHandlers" is set to False.

Can anyone help me? Thanks.

|||

Are the errors immediate or near immediate? This scenario of "package level event level handler not firing and empty package logger file" sounds as if you're receiving errors on package load or on package level validation, very early in the attempted load/validate/execute execution sequence.

If particular, what kind of error events are being you receiving? Please attempt to run the package via dtexec (32 or 64 as appropriate) as well and then post the text of the first few errors.

|||The

package works fine... these errors are things like insert a row with a duplicate PK etc... i know that these kind of errors exists because the source table has dirty data. I would like to handle these errors catching an event.

The problem is that no event is raised when i open the log file is completely blank.... i think these two things can be related.

Catching Events

Hi,

I'm trying to catch an error and trigger a control flow to handle it. I introduce a control flow to catch "OnError" event, but , despite muy package has some errors it doesnt work...

Another issue, if i omit an error on a transformation object ( in order let the flow continue executing), can this error be managed by an event or record it in a log?

Thanks

Albertoim wrote:

Hi,

I'm trying to catch an error and trigger a control flow to handle it. I introduce a control flow to catch "OnError" event, but , despite muy package has some errors it doesnt work...

Thanks

How do you know it doesn't work?

|||

Because the flow i have added to execute when the error event happens does not execute.

|||I have added the event handler at the top level ( Package) for errors events and information events indeed and, as i said before, the flow to execute in this events does not execute. May i have to set some propertie to enable event catching?|||

Hi,

I have done several tests in a new blank project and error events work properly. I have notice that, in th project where i cant catch events, the txt log file is allways blank, so , i supose its something worng with the events, that for any reason arent raised.

In project properties, "DisableEventHandlers" is set to False.

Can anyone help me? Thanks.

|||

Are the errors immediate or near immediate? This scenario of "package level event level handler not firing and empty package logger file" sounds as if you're receiving errors on package load or on package level validation, very early in the attempted load/validate/execute execution sequence.

If particular, what kind of error events are being you receiving? Please attempt to run the package via dtexec (32 or 64 as appropriate) as well and then post the text of the first few errors.

|||The

package works fine... these errors are things like insert a row with a duplicate PK etc... i know that these kind of errors exists because the source table has dirty data. I would like to handle these errors catching an event.

The problem is that no event is raised when i open the log file is completely blank.... i think these two things can be related.

Catching Events

Hi,

I'm trying to catch an error and trigger a control flow to handle it. I introduce a control flow to catch "OnError" event, but , despite muy package has some errors it doesnt work...

Another issue, if i omit an error on a transformation object ( in order let the flow continue executing), can this error be managed by an event or record it in a log?

Thanks

Albertoim wrote:

Hi,

I'm trying to catch an error and trigger a control flow to handle it. I introduce a control flow to catch "OnError" event, but , despite muy package has some errors it doesnt work...

Thanks

How do you know it doesn't work?

|||

Because the flow i have added to execute when the error event happens does not execute.

|||I have added the event handler at the top level ( Package) for errors events and information events indeed and, as i said before, the flow to execute in this events does not execute. May i have to set some propertie to enable event catching?|||

Hi,

I have done several tests in a new blank project and error events work properly. I have notice that, in th project where i cant catch events, the txt log file is allways blank, so , i supose its something worng with the events, that for any reason arent raised.

In project properties, "DisableEventHandlers" is set to False.

Can anyone help me? Thanks.

|||

Are the errors immediate or near immediate? This scenario of "package level event level handler not firing and empty package logger file" sounds as if you're receiving errors on package load or on package level validation, very early in the attempted load/validate/execute execution sequence.

If particular, what kind of error events are being you receiving? Please attempt to run the package via dtexec (32 or 64 as appropriate) as well and then post the text of the first few errors.

|||The

package works fine... these errors are things like insert a row with a duplicate PK etc... i know that these kind of errors exists because the source table has dirty data. I would like to handle these errors catching an event.

The problem is that no event is raised when i open the log file is completely blank.... i think these two things can be related.