bind matrix or table to image or map

Hi
I want to create a report where data is fixed to certain areas on a map (eg
I have an image of Switzerland and regional data. The data should be
displayed ontop of certain regions of the map). When I deploy the report and
open it in Preview or with a browser, everything is moved: eg, if I scroll up
or down, the data moves but the map stays fix.
Is there a way to tie the dataobjects to the image so the data will always
stay ontop of the same point?
Thanks for any help,
SalvatoreYou can approximate this by placing the data regions in rectangles and
placing rectangles in specific areas you'd like.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Salvatore" <Salvatore@.discussions.microsoft.com> wrote in message
news:B2DE92AB-4D79-4E6F-AB4F-A53FEA25CC9B@.microsoft.com...
> Hi
> I want to create a report where data is fixed to certain areas on a map
(eg
> I have an image of Switzerland and regional data. The data should be
> displayed ontop of certain regions of the map). When I deploy the report
and
> open it in Preview or with a browser, everything is moved: eg, if I scroll
up
> or down, the data moves but the map stays fix.
> Is there a way to tie the dataobjects to the image so the data will always
> stay ontop of the same point?
> Thanks for any help,
> Salvatore|||Hi Ravi
I have try by placing the data regions in rectangles or placing Image in
rectangles but without success
Thanks for any help,
Salvatore
"Ravi Mumulla (Microsoft)" wrote:
> You can approximate this by placing the data regions in rectangles and
> placing rectangles in specific areas you'd like.
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Salvatore" <Salvatore@.discussions.microsoft.com> wrote in message
> news:B2DE92AB-4D79-4E6F-AB4F-A53FEA25CC9B@.microsoft.com...
> > Hi
> > I want to create a report where data is fixed to certain areas on a map
> (eg
> > I have an image of Switzerland and regional data. The data should be
> > displayed ontop of certain regions of the map). When I deploy the report
> and
> > open it in Preview or with a browser, everything is moved: eg, if I scroll
> up
> > or down, the data moves but the map stays fix.
> >
> > Is there a way to tie the dataobjects to the image so the data will always
> > stay ontop of the same point?
> >
> > Thanks for any help,
> > Salvatore
>
>

Bind Image Data to PictureBox

Hi,
I'm just starting w/ VB.NET and want to find out how to bind an image from a
field in a SQL Server database table to a PictureBox control. I am able to
get data from the database into text boxes, etc., and to navigate and query
to different records, but coming from the Access world, I'm not sure how to
get image data displayed. We want to scan a document (single page), and sav
e
it with it's related record and just be able to view it in a Windows Form.
I've tried a few things that haven't worked and would really appreciate some
help!
--
PaulJS(This problem should be posted in a .NET Group)
For the example of o picturebox you should go along like this (picturebox).
Binding myBind = myPBox.DataBindings.Add("Image", myDataTable,
myDataColumn);
myBind.Format += new ConvertEventHandler(FormatImageData);
private void FormatImageData(object sender, ConvertEventArgs e)
{
if (e.DesiredType == typeof(Image))
{
System.Byte[] bytes = e.Value as Byte[];
System.IO.MemoryStream stream
= new System.IO.MemoryStream(bytes);
System.Drawing.Image image
= System.Drawing.Image.FromStream(stream);
stream.Close();
// Re-assign formatted data
e.Value = image;
}
}
HTH, Jens Suessmeyer.

Binary Data Type

Hello Dears,

I was Maked Pictures table in sql server 2005 with Two Col pic_Id (int) and picture(binary)

i need now ro insert image into this table by Asp.net under VB.net Code i have in my form FileUpload and button control

and this is my Code

ProtectedSub btnLoad_Click(ByVal senderAsObject,ByVal eAs System.EventArgs)Handles btnLoad.Click

Dim content()AsByte = ReadBitmap2ByteArray(FileUpload1.PostedFile.ContentType)

StoreBlob2DataBase(content)

EndSub

Function ReadBitmap2ByteArray(ByVal FileNameAsString)AsByte()

Dim imageAs Drawing.Bitmap =New Drawing.Bitmap(FileName)

Dim streamAs IO.MemoryStream =New IO.MemoryStream()

image.Save(stream, System.Drawing.Imaging.ImageFormat.Bmp)

Return stream.ToArray

EndFunction

Sub StoreBlob2DataBase(ByVal contentAsByte())

con.Open()

Dim cmAsNew SqlCommand("Insert into Pictures(Pic_Id,picture) values(@.id,@.pic)", con)

cm.Parameters.AddWithValue("@.ID", 1)

Dim p1AsNew SqlParameter

p1.ParameterName ="@.pic"

p1.SqlDbType = Data.SqlDbType.Binary

p1.Value = content

p1.Size = content.Length

cm.Parameters.Add(p1)

cm.ExecuteNonQuery()

EndSub

when i make run to my website it give me an Exeption in this statement

Dim imageAs Drawing.Bitmap =New Drawing.Bitmap(FileName)

it tell me that Parameter is not valid

i need help about this please

with my Best regard

khalil

In this line:

Dim content()AsByte = ReadBitmap2ByteArray(FileUpload1.PostedFile.ContentType)

You are passing in the contentType rather than a filename.

|||

HI

its does not work also its give me the same error what can i do

|||

Of course it gives you the same error, I didn't fix it, I just pointed out what was wrong. Pass in the filename of the file, not the contenttype.

Binary data into File.

Is there any way to save the image data into one file.... basically I have
one record in a table and I want to save that image data into one separate
file... is that possible ?
What do you mean by file? Are you talking about a database file or a window
file?
Andrew J. Kelly SQL MVP
"msnews.microsoft.com" <Noor> wrote in message
news:%23zXUsBJtFHA.3188@.TK2MSFTNGP14.phx.gbl...
> Is there any way to save the image data into one file.... basically I
> have one record in a table and I want to save that image data into one
> separate file... is that possible ?
>
|||Windows file...
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:utBvIlKtFHA.2756@.TK2MSFTNGP09.phx.gbl...
> What do you mean by file? Are you talking about a database file or a
> window file?
> --
> Andrew J. Kelly SQL MVP
>
> "msnews.microsoft.com" <Noor> wrote in message
> news:%23zXUsBJtFHA.3188@.TK2MSFTNGP14.phx.gbl...
>
|||Have you tried using DTS to export it to a file?
Andrew J. Kelly SQL MVP
"msnews.microsoft.com" <Noor> wrote in message
news:O1no8nKtFHA.464@.TK2MSFTNGP15.phx.gbl...
> Windows file...
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:utBvIlKtFHA.2756@.TK2MSFTNGP09.phx.gbl...
>

Binary (Image) in SSAS

I have an Image column in my database nicely imported by SSIS. I want to use these (product) images in my reports. These reports use a SSAS cube as source.

However, I'm unable to use this column as an attribute of my dimension. I get the error:
The 'Binary' data type is not allowed for the 'KeyColumns' property #0

I know there are alternatives like only storing the location of the file and using the url to get it, but that's not an option for me.

Thank you very much!Still nobody who can awnser this? |||

Look in the Adventure Works sample cubes in the Product dimension. They've got the logo image in there. The trick is to put an int ID as the KeyColumn and use the image datatype as the MemberValue.

Binary (Image) in SSAS

I have an Image column in my database nicely imported by SSIS. I want to use these (product) images in my reports. These reports use a SSAS cube as source.

However, I'm unable to use this column as an attribute of my dimension. I get the error:
The 'Binary' data type is not allowed for the 'KeyColumns' property #0

I know there are alternatives like only storing the location of the file and using the url to get it, but that's not an option for me.

Thank you very much!Still nobody who can awnser this? |||

Look in the Adventure Works sample cubes in the Product dimension. They've got the logo image in there. The trick is to put an int ID as the KeyColumn and use the image datatype as the MemberValue.