Display a image based on a value field

Hello friends
I have a problem displaying a picture on a table detail based on a value of
a column.
If this column have a value greather than 10, show a image, else show
another image. I don't know how to call the images on the statement below
=IIf(Fields!DIAS.Value > 10, show_image_1, show_image_2)
I've added the images to the project as a embedded images.
Can anyone please help me or give me an example?
Thanks for Help
BrunoI only know one line of VB code, which is what I use to show/hide
report elements. Maybe you can use it to help you write yours to work
the way it needs to.
=IIF(Parameters!ReportGroup.Value = 1 AND Parameters!ReportType.Value =1, False, True)|||Hi Bruno
I'm only a novice, but this works:
Create two identical table rows, one below the other, each row has one cell
showing the (same) database field - e.g. "ID" and one cell to hold the
appropriate image - row 1 holds image1, row2 holds image2.
Now set the visibility of each row using expressions:
row1: =iif(Fields!ID.value<10,true,false)
row2: =iif(Fields!ID.value>=10,true,false)
when you run the report, the rows will be visible with the appropriate
images appearing as the ID.values change
~grasshopper~
"Bruno" wrote:
> Hello friends
> I have a problem displaying a picture on a table detail based on a value of
> a column.
> If this column have a value greather than 10, show a image, else show
> another image. I don't know how to call the images on the statement below
> =IIf(Fields!DIAS.Value > 10, show_image_1, show_image_2)
> I've added the images to the project as a embedded images.
> Can anyone please help me or give me an example?
> Thanks for Help
> Bruno|||Create an image control on the report, make it show one of the images
you've embedded. In the properties of the image, you should be able to
see how the image is referred to in the "value" property. Now wrap the
=IIf statement around this. The image name will have to be in double
quotes because you are passing a string value to the property. For
example;
=IIf(Fields!DIAS.Value > 10, "Image1.gif", "Image2.gif")
If you wanted to show now image you could do;
=IIf(Fields!DIAS.Value > 10, Nothing, "Image2.bmp")
I haven't tried this but see no reason it shouldn't work for both
RS2000 or RS2005.
Cheers
Chris
Bruno wrote:
> Hello friends
> I have a problem displaying a picture on a table detail based on a
> value of a column.
> If this column have a value greather than 10, show a image, else show
> another image. I don't know how to call the images on the statement
> below
> =IIf(Fields!DIAS.Value > 10, show_image_1, show_image_2)
> I've added the images to the project as a embedded images.
> Can anyone please help me or give me an example?
> Thanks for Help
> Bruno

Discover relationships between existing tables of a database

Hello Friends,
I am right now working on a project that has a database with over 100 tables in a database. Because of extreme time constraints the developers didn't build in any relationships or constraints between or in the tables. Now I need to remodel the database such that the database is more structured and normalized. I don't have much knowledge about the database design since it is a 2 year old application and the person who developed the database is now gone. I know remodelling the database would require knowledge of the existing database and business rules.
I was wondering if there are any tools that could suggest or discover relationships between tables. For eg. Lets say there are two tables named 'Customer' and 'Order'. I notice that there is a column named 'id' in Customer and a column named 'customer_id' in Order. So I ask the tool to discover a relationship between id and customer_id and it tells me that there is a one-one or one-many or no relationship by comparing values. I heard ERWin would be able to do that but thats expensive. Please do let me know asap.Problem is, without any relational integrity and constraints designed into the database, it probably already contains a lot of data that violates the logical relationships. That makes it impossible for any tool to definitively say what the relationships should be based solely upon the existing data.
I have a script that finds natural keys within a table, which you can use to set the primary key, but that's about it.
Chances are, 10% of your time is going to be occupied with finding out what the relationships are supposed to be, while 90% will involve fixing the bad data you find.
And this: "Because of extreme time constraints the developers didn't build in any relationships or constraints between or in the tables" is total bull. They are just bad developers. I can set a constraint or a foreign key in 30 seconds. They just didn't want to be bothered taking the time to make sure their code submitted correct data to the database, and so they allowed the database to accept any old crap that is sent to it. That's why you have a mess on your hands.|||I used ERWin in order to deduce references. But unfortunately even that didn't suggest much. ERWin tries to deduce what would be relationships between tables. I guess now I have to use logic in order to figure out what the relationships would be.

Disaster

Hi Friends,
I want to know how disaster recovery work? It means What are the types
of Disaster why we planned for the recovery asn all those stuffs.
Please explain me briefly.
Thanks,
ManuSee this article.
http://databases.about.com/od/sqlserver/a/disaster.htm
Take alook into examples:-
http://www.sql-server-performance.com/disaster_recover_examples.asp
Thanks
Hari
SQL Server MVP
"Manu" <manojjkd@.gmail.com> wrote in message
news:1156161219.707153.306170@.b28g2000cwb.googlegroups.com...
> Hi Friends,
> I want to know how disaster recovery work? It means What are the types
> of Disaster why we planned for the recovery asn all those stuffs.
> Please explain me briefly.
> Thanks,
> Manu
>

Disaster

Hi Friends,
I want to know how disaster recovery work? It means What are the types
of Disaster why we planned for the recovery asn all those stuffs.
Please explain me briefly.
Thanks,
ManuSee this article.
http://databases.about.com/od/sqlserver/a/disaster.htm
Take alook into examples:-
http://www.sql-server-performance.c...er_examples.asp
Thanks
Hari
SQL Server MVP
"Manu" <manojjkd@.gmail.com> wrote in message
news:1156161219.707153.306170@.b28g2000cwb.googlegroups.com...
> Hi Friends,
> I want to know how disaster recovery work? It means What are the types
> of Disaster why we planned for the recovery asn all those stuffs.
> Please explain me briefly.
> Thanks,
> Manu
>

Disable printing / exporting

Anyone of you friends.. / MODERATORS

This is a hake of a challenge .. looks like Microsoft again left some "bug" in their SSRS..

Can anyone help me to know if I can "Hide" print icon on SSRS toolbar control .. ? or say

Remove TIFF /Excel from Export drop down list?

Sam

As far as the printing, here's how we do it (as the printing ActiveX control usually foobars on us, doesn't work except in IE under Windows and even then most of our clients are companies who lock down adding more activeX controls, it just makes more sense to tell them to do a Excel/PDF export...):

Add the ShowPrintButton property to the rsweb:Reportview tag in your .aspx source. Like:

<rsweb:ReportViewerHeight="450px"ID="ReportViewer1"runat="server"Width="100%"processingmode="Remote"SizeToReportContent="True"ShowPrintButton="false" />

I don't know how to limit the export options, though.

|||

http://servername/ReportServer?%2fReportFolder%2fReportName&Parameter1=&Parameter2=&rs%3aClearSession=true&rs%3aFormat=HTML4.0&rs%3aCommand=Render&rc%3aArea=Report&rc%3aLinkTarget=_top&rc%3aJavaScript=True&rc%3aToolbar=False

You could hide the toolbar completely such as in the example above.