Displaying traffic lighting images using MDX query

Hi All,

I want to display traffic light images in jpivot table depending upon the measures . I can be able to display color in the jpivot table. How to display images?

Thanks in advance.

Hi Rajha,

you have to create a KPI in your cube.

Edit your cube in BIDS and then go to KPI's tab. Create a new KPI and complete the form with MDX script you need for Value, Goal, Status and Trend. There you can also set Status indicator e Trend indicator (traffic light, gauge, standard arrow and so on).

|||

Hi Francesco,

Thank you very much for your help. I'm a newbie to mdx. Actually I am using some open source database and cube designer which doesnt have KPI property. Can I manually add that code to my mdx query? If so, can u tell me where I can found related documents.

|||

Hi Rajha,

I really don't know if there's a way to obtain the same in MDX but I'm thinking not.

What you can easily do is to color cell depending on the value in it like this:

WITH MEMBER MEASURES.DEMO AS

'[Measures].[Internet Sales Amount]' ,

FORE_COLOR = 'IIF ( MEASURES.DEMO < [Measures].[Reseller Sales Amount] * 0.7,

RGB(0,255,0),

RGB(255,0,0)

)'

SELECT

{MEASURES.DEMO} ON COLUMNS,

NONEMPTYCROSSJOIN([Date].[Calendar].[Month].Members,[Department].[Departments].[Department Level 02].MEMBERS) ON ROWS

FROM [Adventure Works]

CELL PROPERTIES VALUE, FORMATTED_VALUE, FORE_COLOR

At the moment I'm not able to find documentation about this but you can check on the web

Let me know if it's what you're looking for and please check my answer if you think if it was helpful anyway.

P.S. what product are you using that supports MDX?

Francesco

|||

Hi Francesco

Thanks for your reply. As I said in my first thread I can be able to show color depending upon the conditions but i cant bring images in the table.

I'm evaluating Pentaho which uses mdx for drill down reports.

Displaying of images

I have images on my report which are URLs pointing to another server. The
images appear fine in the preview enviroment but when running the report
from the WEB they turn to red X's and the SRC=''. I tried configuring an
account for unattended report processing using rsconfig but it doesn't seem
to help.
Anyone have any different ideas?
JacquiJacqui, how did you do that? I am looking at a report to use in a digital
dashboard fashion that will display a different image based on the data of a
field. This image would also be located on a different server. I will try
it and see if I get the same problem you do.
Thanks,
Alan
"Jacqui Ostrom" <jostrom@.formet.com> wrote in message
news:uqaX2weCFHA.520@.TK2MSFTNGP09.phx.gbl...
> I have images on my report which are URLs pointing to another server. The
> images appear fine in the preview enviroment but when running the report
> from the WEB they turn to red X's and the SRC=''. I tried configuring an
> account for unattended report processing using rsconfig but it doesn't
seem
> to help.
> Anyone have any different ideas?
> Jacqui
>

Displaying images that are accessed through URL

Hi,

I have trouble displaying images that are accessed through URLs in my report.
If I call the URL directly in the Browser the Image can be opened without problems.
The images can be accessed with an anonymous access.

When I deploy the report or in the Preview of Visual Studio I get the following message:

[rsWarningFetchingExternalImages] Images with external URL references will not display if the report is published to a report server without an UnattendedExecutionAccount or the target image(s) are not enabled for anonymous access.

In Layout View of Visual Studio the image is showen correctly.

The Images are stored on a Solaris maschine with WebSphere 6.0 as WebServer.

Any ideas?

Thank you.

Frank

You need to configure unattended execution account: http://msdn2.microsoft.com/en-us/library/ms156302.aspx

|||

I configured the unattended execution account, but there I can only use windows user. The images are on a Sun Server with Solaris 9 (Unix) which has different users. Allthough the Images can be accessed without any authorisation, so I think I don't need the unattended execution account.

Any more ideas

Thank you

|||

Have you ever figured this out? I am having the same issue, but the file is on the report server. Actually, it's not an image file, but an ASP.Net web application that creates an image on the fly. Like you, I can get it to come up in the development environment or if I enter the URL directly, but it won't appear in the deployed report.

I have set the unattended execution account, restarted IIS, set permissions to the app's dll everywhere I could think... nothing works.

Interestingly, if you look at the report's source, you can see the images "src" attribute is an empty string, so the report renderer is blocking it.

|||Has anyone found a resolution for this. I have taken the same steps and still only get the RED X in the image space. Account used for unattended execution has admin rights and I can see the image when calling the URL directly from IE.|||

i am also desperately looking for a resolution here

Displaying images that are accessed through URL

Hi,

I have trouble displaying images that are accessed through URLs in my report.
If I call the URL directly in the Browser the Image can be opened without problems.
The images can be accessed with an anonymous access.

When I deploy the report or in the Preview of Visual Studio I get the following message:

[rsWarningFetchingExternalImages] Images with external URL references will not display if the report is published to a report server without an UnattendedExecutionAccount or the target image(s) are not enabled for anonymous access.

In Layout View of Visual Studio the image is showen correctly.

The Images are stored on a Solaris maschine with WebSphere 6.0 as WebServer.

Any ideas?

Thank you.

Frank

You need to configure unattended execution account: http://msdn2.microsoft.com/en-us/library/ms156302.aspx

|||

I configured the unattended execution account, but there I can only use windows user. The images are on a Sun Server with Solaris 9 (Unix) which has different users. Allthough the Images can be accessed without any authorisation, so I think I don't need the unattended execution account.

Any more ideas

Thank you

|||

Have you ever figured this out? I am having the same issue, but the file is on the report server. Actually, it's not an image file, but an ASP.Net web application that creates an image on the fly. Like you, I can get it to come up in the development environment or if I enter the URL directly, but it won't appear in the deployed report.

I have set the unattended execution account, restarted IIS, set permissions to the app's dll everywhere I could think... nothing works.

Interestingly, if you look at the report's source, you can see the images "src" attribute is an empty string, so the report renderer is blocking it.

|||Has anyone found a resolution for this. I have taken the same steps and still only get the RED X in the image space. Account used for unattended execution has admin rights and I can see the image when calling the URL directly from IE.|||

i am also desperately looking for a resolution here|||

I enabled anonymous access and that solved my issue.

|||

I found the solution for my problem. The mime type for the images was not set on the WebSphere Server.

After I set the mime type on the WebSpere Server, the images where shown correctly.

I hope this helps.

Frank

Displaying images that are accessed through URL

Hi,

I have trouble displaying images that are accessed through URLs in my report.
If I call the URL directly in the Browser the Image can be opened without problems.
The images can be accessed with an anonymous access.

When I deploy the report or in the Preview of Visual Studio I get the following message:

[rsWarningFetchingExternalImages] Images with external URL references will not display if the report is published to a report server without an UnattendedExecutionAccount or the target image(s) are not enabled for anonymous access.

In Layout View of Visual Studio the image is showen correctly.

The Images are stored on a Solaris maschine with WebSphere 6.0 as WebServer.

Any ideas?

Thank you.

Frank

You need to configure unattended execution account: http://msdn2.microsoft.com/en-us/library/ms156302.aspx

|||

I configured the unattended execution account, but there I can only use windows user. The images are on a Sun Server with Solaris 9 (Unix) which has different users. Allthough the Images can be accessed without any authorisation, so I think I don't need the unattended execution account.

Any more ideas

Thank you

|||

Have you ever figured this out? I am having the same issue, but the file is on the report server. Actually, it's not an image file, but an ASP.Net web application that creates an image on the fly. Like you, I can get it to come up in the development environment or if I enter the URL directly, but it won't appear in the deployed report.

I have set the unattended execution account, restarted IIS, set permissions to the app's dll everywhere I could think... nothing works.

Interestingly, if you look at the report's source, you can see the images "src" attribute is an empty string, so the report renderer is blocking it.

|||Has anyone found a resolution for this. I have taken the same steps and still only get the RED X in the image space. Account used for unattended execution has admin rights and I can see the image when calling the URL directly from IE.|||

i am also desperately looking for a resolution here

Displaying images that are accessed through URL

Hi,

I have trouble displaying images that are accessed through URLs in my report.
If I call the URL directly in the Browser the Image can be opened without problems.
The images can be accessed with an anonymous access.

When I deploy the report or in the Preview of Visual Studio I get the following message:

[rsWarningFetchingExternalImages] Images with external URL references will not display if the report is published to a report server without an UnattendedExecutionAccount or the target image(s) are not enabled for anonymous access.

In Layout View of Visual Studio the image is showen correctly.

The Images are stored on a Solaris maschine with WebSphere 6.0 as WebServer.

Any ideas?

Thank you.

Frank

You need to configure unattended execution account: http://msdn2.microsoft.com/en-us/library/ms156302.aspx

|||

I configured the unattended execution account, but there I can only use windows user. The images are on a Sun Server with Solaris 9 (Unix) which has different users. Allthough the Images can be accessed without any authorisation, so I think I don't need the unattended execution account.

Any more ideas

Thank you

|||

Have you ever figured this out? I am having the same issue, but the file is on the report server. Actually, it's not an image file, but an ASP.Net web application that creates an image on the fly. Like you, I can get it to come up in the development environment or if I enter the URL directly, but it won't appear in the deployed report.

I have set the unattended execution account, restarted IIS, set permissions to the app's dll everywhere I could think... nothing works.

Interestingly, if you look at the report's source, you can see the images "src" attribute is an empty string, so the report renderer is blocking it.

|||Has anyone found a resolution for this. I have taken the same steps and still only get the RED X in the image space. Account used for unattended execution has admin rights and I can see the image when calling the URL directly from IE.|||

i am also desperately looking for a resolution here

Displaying images that are accessed through URL

Hi,

I have trouble displaying images that are accessed through URLs in my report.
If I call the URL directly in the Browser the Image can be opened without problems.
The images can be accessed with an anonymous access.

When I deploy the report or in the Preview of Visual Studio I get the following message:

[rsWarningFetchingExternalImages] Images with external URL references will not display if the report is published to a report server without an UnattendedExecutionAccount or the target image(s) are not enabled for anonymous access.

In Layout View of Visual Studio the image is showen correctly.

The Images are stored on a Solaris maschine with WebSphere 6.0 as WebServer.

Any ideas?

Thank you.

Frank

You need to configure unattended execution account: http://msdn2.microsoft.com/en-us/library/ms156302.aspx

|||

I configured the unattended execution account, but there I can only use windows user. The images are on a Sun Server with Solaris 9 (Unix) which has different users. Allthough the Images can be accessed without any authorisation, so I think I don't need the unattended execution account.

Any more ideas

Thank you

|||

Have you ever figured this out? I am having the same issue, but the file is on the report server. Actually, it's not an image file, but an ASP.Net web application that creates an image on the fly. Like you, I can get it to come up in the development environment or if I enter the URL directly, but it won't appear in the deployed report.

I have set the unattended execution account, restarted IIS, set permissions to the app's dll everywhere I could think... nothing works.

Interestingly, if you look at the report's source, you can see the images "src" attribute is an empty string, so the report renderer is blocking it.

|||Has anyone found a resolution for this. I have taken the same steps and still only get the RED X in the image space. Account used for unattended execution has admin rights and I can see the image when calling the URL directly from IE.|||i am also desperately looking for a resolution here|||

I enabled anonymous access and that solved my issue.

|||

I found the solution for my problem. The mime type for the images was not set on the WebSphere Server.

After I set the mime type on the WebSpere Server, the images where shown correctly.

I hope this helps.

Frank

Displaying images in a report

Hi all

I have a report and I display specific images based on the parameter selected. i.e. If parameter value = "1" then I display "image1.jpg". The images were added as a part of the project so I was able to display the images by setting the value property on the images to the image file name. So if I want to display image1.jpg then I would set the value property of the image to "image1.jpg".

Now I have decided to create a folder called "images" in which I want to keep all the images. So I have removed the images from the project. In the value property of the image when I put "/images/image1.jpg" it doesnt work. I have also tried "images/image1.jpg" When I run the report in the Preview mode, the image is not shown. How do i fix this?

The directory struncture is so:

Reports folder

--images folder

-image1.jpg

-image2.jpg

--report1.rdl

--report2.rdl

Thanks guys!!

One thing you could do is embed the images so they're available without being published separately. But if you have a very large number of alternative images, I guess this might be cumbersome.

For dynamic images, you can create a parameter with the location/path of these reports, such as file://.... or /. finishing up with the final path slash. Now your values are something like

Code Snippet

IIF(paramvalue = "1",paramlocation & "image1.jpg", paramlocation & "image2.jpg")

... or maybe if the "1" represents a part of the image filename, it's really just something like the following (no IIF):

Code Snippet

paramlocation & "image" & paramvalue & ".jpg"

... IOW, you can fully-qualify the path, and this is one way I know for sure it works.

I'm not entirely clear on where you put the images and whether, therefore, the relative path you're using is going to work as you think it is. If it's on the Report Server you can try using Globals!ReportFolderand Globals!ReportServer to build up the image path but I haven't personally had much luck doing it that way.

You may also be using ReportViewer and trying to set the folder according to where your EXE is (or your webapp if it's a webform ReportViewer)? I think you still need to fully-qualify that path.

>L<

|||I have several images that I need to change based upon a parameter being passed in. I put the images in my images folder on my website and changed the image names to each parameter being passed. I then placed a web image on the report and changed the value of the image in properties to something like the following. "=http://server/images/" & Fields!parameter.Value & ".jpg" This way it changes the image based upon a parameter. Basically changing the image property to a string. Hope this might help.

Jason

displaying images horizontally - not vertically

I am trying to display image data stored in a database field using SRS 2005.
The image data is employee photos and I can get them to display in one column
straight down the report using a List control.
Is there a way to get them to display in 3 columns sorting across the page?
This would be like a High School yearbook layout...
Like this...
Pic 1 Pic 2 Pic 3
Pic 4 Pic 5 Pic 6
Instead of like this...
Pic 1
Pic 2
Pic 3
Pic 4Hi,
I'm not sure if this is done differently in SRS 2005 but in SRS 2000, you
can set the Columns property on the Report Page. Just click the page and
then in the Properties window, specify the number of columns needed (3 in
your case).
Hope that helps.
Assad
"jj#10" wrote:
> I am trying to display image data stored in a database field using SRS 2005.
> The image data is employee photos and I can get them to display in one column
> straight down the report using a List control.
> Is there a way to get them to display in 3 columns sorting across the page?
> This would be like a High School yearbook layout...
> Like this...
> Pic 1 Pic 2 Pic 3
> Pic 4 Pic 5 Pic 6
> Instead of like this...
> Pic 1
> Pic 2
> Pic 3
> Pic 4
>

Displaying images from SSAS data source

I'm trying to display the images from the Adventure Works SSAS database in a SSRS report.

I've added an image object to the table, set MIME to image/jpeg (as it is set in the value fiel of the attribute in AW SSAS database) but I'm getting just a 'x' instead of the image and following output:

Preview complete -- 0 errors, 1 warnings

[rsInvalidExpressionDataType] The Value expression used in textbox ‘LargePhoto’ returned a data type that is not valid.

Preview complete -- 0 errors, 1 warnings

[rsInvalidExpressionDataType] The Value expression used in textbox ‘LargePhoto’ returned a data type that is not valid.

Preview complete -- 0 errors, 1 warnings

[rsInvalidExpressionDataType] The Value expression used in image ‘image1’ returned a data type that is not valid.

[rsInvalidDatabaseImage] The Value expression for the image ‘image1’ did not evaluate to an image.

Preview complete -- 0 errors, 2 warnings

But displaying images the same way just using the relational AW DW table DimProduct works well.

(the only difference I've seen is: in the query generator from SSAS there is a cryptic text value displayed as the value of the LargePhoto attribute, if using relational table there is a '<binary>')

relational query:

select productalternatekey, largephoto from dimproduct

SSAS query:

WITH MEMBER measures.test

AS

[Product].[Large Photo].currentmember.membervalue

SELECT NON EMPTY

{ [Measures].[Internet Sales Amount], measures.test } ON COLUMNS,

NON EMPTY { ([Product].[Product].[Product].ALLMEMBERS * [Product].[Large Photo].[Large Photo].ALLMEMBERS) } ON ROWS

FROM [Adventure Works]

Where is the problem ? How can I display images from SSAS in SSRS ?

Any ideas are appreciated.

Jan.

A binary member value comes from SSAS as Base64-encoded. You need to use the following expression in your textbox Value property in SSRS:

=System.Convert.FromBase64String(Fields!test.Value)

|||

Great help Teo!

That's it, thanks a lot !

Jan.

Displaying images clarafication

I have seen many postings regarding asp. sql and images. One posting
on another group stated that images (jpg, etc) can be called by a db
instead of being stored on the db.

I am asking for some help with coding such a thing. What I want to do
is include in the db the location (url) for the image so I can add it
a pserson's record set and then be able to have it called from the db
to post on a web page.
This is for an awards system.

Thanks for any help.

Davedavestrike (davestrike@.nventure.com) writes:
> I have seen many postings regarding asp. sql and images. One posting
> on another group stated that images (jpg, etc) can be called by a db
> instead of being stored on the db.
> I am asking for some help with coding such a thing. What I want to do
> is include in the db the location (url) for the image so I can add it
> a pserson's record set and then be able to have it called from the db
> to post on a web page.
> This is for an awards system.

I think you have misunderstood something. SQL Server is not able
to invoke an URL. Well, OK, you write an XP or an COM object for the
task, but that would be to retrieve data from the URL into the server.

The usual alternative to storing images within the database, is to
only store a filename (or for that matter a URL), and the you retrieve
that filename to the application, and then the application retrieves
the file.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Displaying images

Hi,

I am a new VWD user and have been trying to set up a website that allows 1 user to upload images into to SQL Express database and then display them with a variety of other fields.

I have searched the forums, several books and many ASP "training" websites to find out how to do this. Every website seems to teach how to display a list of employees or show photo gallery, but none explains how to upload an image, save it in the appropriate field(s) in the database, and then display it when requested in a Datagrid or Details View using VWD and SQL Express 2005

Can any one give me directions to a solution, or send me a simple solution to this?

The best example of what I need is is a real estate listing, wherethe property for sale has 8 to 10 descriptive fields and 1 to 3 images that are displayed.

Any help would be appreciated.

Spacecaetrg.

I've not seen a response to the above reported request for help.

My problem is exactly the same and I would appreciate any help that can be provided.

Thanks

pmurphy5263

|||

What about this? add an image into a database:

http://alpascual.com/blog/al/archive/2006/11/11/Code-Snip-_2200_Add-images-into-a-database_2200_.aspx

|||

Thanks Al for such a quick response.

I am using VWD and SQL 2005 Express. In defining my SQL table I set up one column as an image. What I don't understand (and I assume I am missing something really simple here) is how I move data into that column (field).

After defining the table I tried adding to the image column.(while still in VWD using "Database Exlporer" and "Show Data Table)..........that is where I am stuck.

What is the expected as an entry to this column?

Whenever I try to insert anything into that column I receive the following message.

Invalid value for cell.....

"The changed value in this record is not recognized as valid.

.Net Framework Data type byte[]

Error Message: You cannot use the Result pane to set this field data to values other than Null."

I am a newbie. Guess I don't have to tell you that.

Any more help will be appreciated.

Thanks

|||

Hi

Make sure the column type is " image " and Here you can find a full sample:Save and Display Image with Sql Server.

If you still have problem ,Could you pls post your table structure and some code ?thanks.

Displaying image from db in crystal report

hello there

I am using VB.Net 2003 with oracle 9i. My table contains a BLOB field that contains images. I tried to create a report (crystal report that is packed with VB.Net 2003) by including the table and dragging the BLOB field onto the report. But when i try to run the report, it gives me "Failed to open a rowset" error. If i run the report without the BLOB field, the report works fine.

Any idea?!?!

Thanks in advance
AndyHow did you store the images in the table?
Sounds that some images are corrupted
Visist this site and see if you find solution
www.businessobjects.com

Displaying De-Serialized Images in Reports

PREFACE:
I have a field in my SQL Server database that is called "Ink" and is Text as
the datatype.
I have put into this field a Base64 String which represents serialized
digital ink collected on a Tablet PC.
I wrote a small piece of Custom Code in the Report to de-serialize the ink
and transform it into System.Drawing.Bitmap, but it does not render in the
report.
QUESTION
Is it possible to display images in a report from a function that returns a
data type of System.Drawing.Bitmap?
If not, can I ask how you are planning to implement digital INK support in
databases?
--
Shawn Nanto
Leszynski Group, Inc.
Bellevue, WAImages can be directly displayed when they are returned as Base64 encoded
byte array. The image type has to be "Database" and you must set the
MimeType to the correct image format.
Note: System.Drawing.Bitmap is not supported.
The relevant section in the RDL file would look similar to this:
<Image>
<MIMEType>image/bmp</MIMEType>
<Source>Database</Source>
<Value>=Fields!InkImage.Value</Value>
...
</Image>
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Shawn Nanto" <ShawnNanto@.discussions.microsoft.com> wrote in message
news:0A54FC08-2ECB-4996-B585-5F7E4BA3A8C9@.microsoft.com...
> PREFACE:
> I have a field in my SQL Server database that is called "Ink" and is Text
as
> the datatype.
> I have put into this field a Base64 String which represents serialized
> digital ink collected on a Tablet PC.
> I wrote a small piece of Custom Code in the Report to de-serialize the ink
> and transform it into System.Drawing.Bitmap, but it does not render in the
> report.
> QUESTION
> Is it possible to display images in a report from a function that returns
a
> data type of System.Drawing.Bitmap?
> If not, can I ask how you are planning to implement digital INK support in
> databases?
>
> --
> Shawn Nanto
> Leszynski Group, Inc.
> Bellevue, WA

Display tiff in Reporting Services

I have a file directory of tiff images that I need to display dynamically with reporting services. I receive the following error message: "The value of the MIMEType property for the image ‘image1’ is “image/tiff”, which is not a valid MIMEType." After looking it up sure enough tiff is not a valide type. Does anyone know of a way to display tiff images in reporting services.

Thanks,

Ross

Well I see plenty of threads on tiffs in the forums so it must be possible. I'm not sure why you're getting the error though.|||Not sure what your situation is, but one way to display a *.tif file in reporting services is to drag the image tool from the report items onto the canvas and select "Web" from the radio boxes options. Reference your url http://localhost/images/yourTIFname.tif. As far as doing this dynamically, I'm unclear as to what it is that your actually trying to do and why you want to do this in reporting services in the first place as apposed to some other means. There are a lot of easier ways to display images, instead of using reporting services to do this.|||I currently have it set to web however the images are not on a web server. I have to access them via a file path file:\\servername\image\1234.tif. The image tool in reporting services does not support the *.tif format. Is there a way to work around this limitation?|||

I wasn't able to find a solution. I'll have to force the users to publish their CADs in another format. If someone finds a solution in the future to display tiff images in ssrs please post it here for others to see.

Thanks,

Ross

|||

Pardon me. The image control in a report does support TIF.

Could these be multi-page TIFFs by any chance? I guess those might not be supported.

>L<

Display tiff in Reporting Services

I have a file directory of tiff images that I need to display dynamically with reporting services. I receive the following error message: "The value of the MIMEType property for the image ‘image1’ is “image/tiff”, which is not a valid MIMEType." After looking it up sure enough tiff is not a valide type. Does anyone know of a way to display tiff images in reporting services.

Thanks,

Ross

Well I see plenty of threads on tiffs in the forums so it must be possible. I'm not sure why you're getting the error though.|||Not sure what your situation is, but one way to display a *.tif file in reporting services is to drag the image tool from the report items onto the canvas and select "Web" from the radio boxes options. Reference your url http://localhost/images/yourTIFname.tif. As far as doing this dynamically, I'm unclear as to what it is that your actually trying to do and why you want to do this in reporting services in the first place as apposed to some other means. There are a lot of easier ways to display images, instead of using reporting services to do this.|||I currently have it set to web however the images are not on a web server. I have to access them via a file path file:\\servername\image\1234.tif. The image tool in reporting services does not support the *.tif format. Is there a way to work around this limitation?|||

I wasn't able to find a solution. I'll have to force the users to publish their CADs in another format. If someone finds a solution in the future to display tiff images in ssrs please post it here for others to see.

Thanks,

Ross

|||

Pardon me. The image control in a report does support TIF.

Could these be multi-page TIFFs by any chance? I guess those might not be supported.

>L<

display programatically images,text in a page

hi everyone.
i want to build a page that all datas,images will store in sql server.
i want to display images,text from database in a page with a template (images left of the page,text near the image and like...,programatically)
there will be very much data . about 500-1000 pages data.
is this possible with sql server?
can SQL server store big datas?
if it is possible can you give me an idea.Yes, it is entirely possible. The method I use on my personal website does not store the image in the db, just the URL to the image. However, it is possible to store binary data in sql. Do a search on google.com and you will find all kinds of tutorials.

display images from AutoCAD or Visio

How can we display images from AutoCAD or Visio (or any other OLE Server
object stored in an image-type field in SQL Server) in a Report Services
report?
-propheadPlease check this related posting:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=850bd765-5c85-41c2-a9ed-3ba003a4b7f6&sloc=en-us
Note: only certain image formats (mime types) can be used in Reporting
Services.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"prophead" <prophead@.discussions.microsoft.com> wrote in message
news:5DE2D6B6-4D2A-4049-8C0C-B2DFCFB322B6@.microsoft.com...
> How can we display images from AutoCAD or Visio (or any other OLE Server
> object stored in an image-type field in SQL Server) in a Report Services
> report?
> -prophead

Display images ...

Hello,
I have a customstrings.xml file containing the following:
<string id="sidContactDisplayFormat">{0} - {1} - {2}</string>
<string
id="sidContactFormatFields">contact_name,contact_p hone,contact_vip_flag</string>
In the ascx file I have:
DataStore("ContactsQuickFind").SetCustomColumn("co ntact_display",
"sidContactDisplayFormat", "sidContactFormatFields", "sidContactEmptyString")
which is using the field referenced in the customstring file.
then the display is done through a dropdownlist:
<aw:DropdownList ID="ddlContactQuickFind" RunAt="server"
PreserveItems="true" DataBindMode="GetData"
DataSourceName="ContactsQuickFind" DataTextField="contact_display"
DataValueField="contact_id" ItemDataSourceName="Contact"
ItemDataField="contact_id" OnSelectedIndexChanged="DoContinue"
AutoPostBack="true" Width="300">
<asp:ListItem Value="1">sidNoneDecorated</asp:ListItem>
<asp:ListItem Value="0">sidSelectResultCount</asp:ListItem>
</aw:DropdownList>
My question is I want to display the VIP flag instead of the file value in
the display:
<img src="http://pics.10026.com/?src=http://altiris3/AeXHD/images/icnVIP.gif" />
How can I do this?
Thanks
Dominique
I think you got the wrong newsgroup here... this has nothing to do with xml
and databases.
You may want to try one of the more generic xml groups.
Best regards
Michael
"Dominique" <Dominique@.discussions.microsoft.com> wrote in message
news:4C6C5A88-65C1-4A43-8996-4B2846ED0975@.microsoft.com...
> Hello,
> I have a customstrings.xml file containing the following:
> <string id="sidContactDisplayFormat">{0} - {1} - {2}</string>
> <string
> id="sidContactFormatFields">contact_name,contact_p hone,contact_vip_flag</string>
> In the ascx file I have:
> DataStore("ContactsQuickFind").SetCustomColumn("co ntact_display",
> "sidContactDisplayFormat", "sidContactFormatFields",
> "sidContactEmptyString")
> which is using the field referenced in the customstring file.
> then the display is done through a dropdownlist:
> <aw:DropdownList ID="ddlContactQuickFind" RunAt="server"
> PreserveItems="true" DataBindMode="GetData"
> DataSourceName="ContactsQuickFind" DataTextField="contact_display"
> DataValueField="contact_id" ItemDataSourceName="Contact"
> ItemDataField="contact_id" OnSelectedIndexChanged="DoContinue"
> AutoPostBack="true" Width="300">
> <asp:ListItem Value="1">sidNoneDecorated</asp:ListItem>
> <asp:ListItem Value="0">sidSelectResultCount</asp:ListItem>
> </aw:DropdownList>
> My question is I want to display the VIP flag instead of the file value in
> the display:
> <img src="http://pics.10026.com/?src=http://altiris3/AeXHD/images/icnVIP.gif" />
> How can I do this?
> Thanks
> --
> Dominique
|||thanks
Dominique
"Michael Rys [MSFT]" wrote:

> I think you got the wrong newsgroup here... this has nothing to do with xml
> and databases.
> You may want to try one of the more generic xml groups.
> Best regards
> Michael
> "Dominique" <Dominique@.discussions.microsoft.com> wrote in message
> news:4C6C5A88-65C1-4A43-8996-4B2846ED0975@.microsoft.com...
>
>

Display images ...

Hello,
I have a customstrings.xml file containing the following:
<string id="sidContactDisplayFormat">{0} - {1} - {2}</string>
<string
id="sidContactFormatFields"> contact_name,contact_phone,contact_vip_f
lag</str
ing>
In the ascx file I have:
DataStore("ContactsQuickFind").SetCustomColumn("contact_display",
"sidContactDisplayFormat", "sidContactFormatFields", "sidContactEmptyString"
)
which is using the field referenced in the customstring file.
then the display is done through a dropdownlist:
<aw:DropdownList ID="ddlContactQuickFind" RunAt="server"
PreserveItems="true" DataBindMode="GetData"
DataSourceName="ContactsQuickFind" DataTextField="contact_display"
DataValueField="contact_id" ItemDataSourceName="Contact"
ItemDataField="contact_id" OnSelectedIndexChanged="DoContinue"
AutoPostBack="true" Width="300">
<asp:ListItem Value="1">sidNoneDecorated</asp:ListItem>
<asp:ListItem Value="0">sidSelectResultCount</asp:ListItem>
</aw:DropdownList>
My question is I want to display the VIP flag instead of the file value in
the display:
<img src="http://pics.10026.com/?src=http://altiris3/AeXHD/images/icnVIP.gif" />
How can I do this?
Thanks
--
DominiqueI think you got the wrong newsgroup here... this has nothing to do with xml
and databases.
You may want to try one of the more generic xml groups.
Best regards
Michael
"Dominique" <Dominique@.discussions.microsoft.com> wrote in message
news:4C6C5A88-65C1-4A43-8996-4B2846ED0975@.microsoft.com...
> Hello,
> I have a customstrings.xml file containing the following:
> <string id="sidContactDisplayFormat">{0} - {1} - {2}</string>
> <string
> id="sidContactFormatFields"> contact_name,contact_phone,contact_vip_f
lag</s
tring>
> In the ascx file I have:
> DataStore("ContactsQuickFind").SetCustomColumn("contact_display",
> "sidContactDisplayFormat", "sidContactFormatFields",
> "sidContactEmptyString")
> which is using the field referenced in the customstring file.
> then the display is done through a dropdownlist:
> <aw:DropdownList ID="ddlContactQuickFind" RunAt="server"
> PreserveItems="true" DataBindMode="GetData"
> DataSourceName="ContactsQuickFind" DataTextField="contact_display"
> DataValueField="contact_id" ItemDataSourceName="Contact"
> ItemDataField="contact_id" OnSelectedIndexChanged="DoContinue"
> AutoPostBack="true" Width="300">
> <asp:ListItem Value="1">sidNoneDecorated</asp:ListItem>
> <asp:ListItem Value="0">sidSelectResultCount</asp:ListItem>
> </aw:DropdownList>
> My question is I want to display the VIP flag instead of the file value in
> the display:
> <img src="http://pics.10026.com/?src=http://altiris3/AeXHD/images/icnVIP.gif" />
> How can I do this?
> Thanks
> --
> Dominique|||thanks
--
Dominique
"Michael Rys [MSFT]" wrote:

> I think you got the wrong newsgroup here... this has nothing to do with xm
l
> and databases.
> You may want to try one of the more generic xml groups.
> Best regards
> Michael
> "Dominique" <Dominique@.discussions.microsoft.com> wrote in message
> news:4C6C5A88-65C1-4A43-8996-4B2846ED0975@.microsoft.com...
>
>