IMMEDIATE ATTENTION PLEASE.....

hi all..
hope u guys can help me out here.....
'm new to .net so hope to get all the basic infomr that would b required...

'm on a proj..basically a data mining proj...
'm using sql 2005 enterprise edn's analysis services to perform my data minning tasks...
here is what i'd like to know....
i've been following the sql online tutorial book...
n as per the tutorial on data minning...i have created a data source ... based on the decision tree algorithm i have even obtained some results..
now.....here is the problem..

i'd like to know if i can actually get all these obtained patterns onto a webpage...
i mean can i actually use asp.net n achieve this task of migrating the patterns generated at the bids to a webpage?

please guys if i can do so...then do tell me how to do so...
my proj dline is in 2 weeks....i need desperate help....
'm waitin...

here is how i vusualize my goal..... web pages that display patterns generated after an analysis has performed......

thxxxx... a ton
hanish

AS includes a set of data mining viewer controls intended for this. You can also query the mining models from RS.

See this topics in Books Online.

Using Analysis Services DMX Query Designer

And this link to download the Data Mining controls:

http://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&DisplayLang=en

The mining controls are halfway down the page.

|||

...umm...alrite thanks...

but the thing is i really don't wan't to open bids n check out the report.....

i am asking if there is any way how i can view the obtained patters at a report on a webpage without having to open

BIDS ....ll explain my problem ...........

my task is to illustrate data minning using asp.net as the front end and SQL server 2005 entp.as back end.....

BIDS will take care of all the data minning operations that i need to perform...and will generate reports corresponding to various data minning models.......

now i intend to create a UI using asp.net(c# codin.) and then link these web-pages to the already obtained reports.....can i do it without having the user open BIDS?

plzzzzzz plzzzz guys help me.....

thx.....

|||

That functionality is exactly what the data mining controls provide. The user doesn't have to use BIDS to see the results. For that matter, if you develop a report in Reporting Services and deploy it, the user doesn't need BIDS.

For your task, you need to look at the data mining controls. Or you could query directly through ADOMD (an OLEDB provider), but the mining controls handle the visual display for you.

|||

hi jwelch

thx for ur instructions for my problem.......

as per u instructed i d/loaded Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider which i suppose helps provide the data mining controls....... here is an honest appeal...after having installed it i havn't really seen any change or havn't really been able to discover the data mining controls...

i am certain that it is because i am totally new to sql server, i am getting a little nervous if i can really do this task, please would u mind helping me in achieving my task......

i've done minning on the adventure datawarehouse and now have obtained the patterns which i can view in BIDS......i would now like to know the steps i should follow to make use of the data mining controls by which i can migrate these results onto a browser.......you have told me this is possible ...please i have no other option but to take your help do consider my request ......

waiting for your reply..

|||

any body here ...

plzzzzzz help me in figurin my way out.....

mr.john u der?

|||

No, it's not the OLE DB provider. It's the data mining viewer controls. They are about 4 items below the OLE DB provider.

http://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&DisplayLang=en

Microsoft SQL Server 2005 Datamining Viewer Controls

The Data Mining Web Controls Library is a set of Microsoft Windows Forms controls that enable software developers to display data mining models created using Microsoft SQL Server 2005 Analysis Services in their client-side applications. The controls in this library display the patterns that are contained in Analysis Services mining models.
|||

hj wrote:

any body here ...

plzzzzzz help me in figurin my way out.....

mr.john u der?

hanish,

you really need a course on forum ettiquette: don't demand things, don't write all in capitals (your subject line), and don't expect people to do your work for you.

What exactly are you wanting? It seems to me that you want to know how to run or request reports from within a standard ASP.Net page?

|||

i do apologize ,

yup sluggy u got my prob rite......im tryin to run the results i got after the minin operation from within a std asp.net page..

hey..n thx ...mr.john....

|||

hi ...'m back again with my nt so good doubts..

;m stuck on thiz one thing mr.john...........

after havning installed the data mining viewer controls what is my next step....i mean i don't even see these contrls in my web dvlpr toolbar....

after going tro some threads here..i figured out that the nxt step is to add the viewer contrls into the toolkit of visual c# web dvplr.....

but ;m not succesful in doing so.....

jus like i told u before ...my task is to bring out these patters onto a web page.........

one more doubt......

is there any tutorial about what each of these web contrl does? whr can i learn more bout these controls......are there any sample videos i could get access to, to actually know more about how to use these controls....

please help me ....thx a lot

hanish|||

hj wrote:

hi ...'m back again with my nt so good doubts..

;m stuck on thiz one thing mr.john...........

after havning installed the data mining viewer controls what is my next step....i mean i don't even see these contrls in my web dvlpr toolbar....

after going tro some threads here..i figured out that the nxt step is to add the viewer contrls into the toolkit of visual c# web dvplr.....

but ;m not succesful in doing so.....

jus like i told u before ...my task is to bring out these patters onto a web page.........

one more doubt......

is there any tutorial about what each of these web contrl does? whr can i learn more bout these controls......are there any sample videos i could get access to, to actually know more about how to use these controls....

please help me ....thx a lot

hanish

Have you looked in your C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls folder? You may need to install the SQL Server Samples to use this.

|||

yup...dat is de exact prob....i did install dm viewer controls but den din find a samples folder under \Program Files\Microsoft SQL Server\90.......

now i did install all the samples that came with the sql cd..could u tell me whr i could download these samples from the net.....

my sincere thanks mr john..

feel like ur the only one replyin to my posts here..

thx again.......

hanish

|||one more question...'m working with sql server 2005 enterprise edn........do i hav to install sp2 for sql server to achieve my tasks...|||

hj wrote:

yup...dat is de exact prob....i did install dm viewer controls but den din find a samples folder under \Program Files\Microsoft SQL Server\90.......

now i did install all the samples that came with the sql cd..could u tell me whr i could download these samples from the net.....

my sincere thanks mr john..

feel like ur the only one replyin to my posts here..

thx again.......

hanish

This link has the lastest sample applications for SQL Server.

http://www.microsoft.com/downloads/details.aspx?FamilyId=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en

|||

hj wrote:

one more question...'m working with sql server 2005 enterprise edn........do i hav to install sp2 for sql server to achieve my tasks...

I don't think it is required. However, the samples I referenced above have been updated for SP2.

IMMEDIATE ATTENTION PLEASE!!!

hi all..
hope u guys can help me out here.....
'm new to .net so hope to get all the basic infomr that would b required...

'm on a proj..basically a data mining proj...
'm using sql 2005 enterprise edn's analysis services to perform my data minning tasks...
here is what i'd like to know....
i've been following the sql online tutorial book...
n as per the tutorial on data minning...i have created a data source ... based on the decision tree algorithm i have even obtained some results..
now.....here is the problem..

i'd like to know if i can actually get all these obtained patterns onto a webpage...
i mean can i actually use asp.net n achieve this task of migrating the patterns generated at the bids to a webpage?

please guys if i can do so...then do tell me how to do so...
my proj dline is in 2 weeks....i need desperate help....
'm waitin...
thxxxx... a ton
hanish

i'd like to code in c#...so plzz tell me a way out of this prob.....|||

if you dump your results into a table you can report against it using .net tools like OWC (i. e. FrontPage, Excel, RS).

Also, here is the link to the article on how to build a model dynamically:

http://www.aspnetpro.com/newsletterarticle/2004/10/asp200410ri_l/asp200410ri_l.asp

|||

my task is to illustrate data minning using asp.net as the front end and SQL server 2005 entp.as back end.....

BIDS will take care of all the data minning operations that i need to perform...and will generate reports corresponding to various data minning models.......

now i intend to create a UI using asp.net(c# codin.) and then link these web-pages to the already obtained reports.....can i do it without having the user open BIDS?

plzzzzzz plzzzz guys help me.....

thx.....

|||

Included with SQL Server as a sample are the sample Data Mining web viewers - I think this should give you what you need. You can see them in action by launching the sample from here http://www.sqlserverdatamining.com/DMCommunity/LiveSamples/52.aspx

Also you can render your results as a report using the example here:

http://blogs.msdn.com/jamiemac/archive/2006/06/22/642541.aspx

|||hello Hanish,,,
i need decision tree code in c#,if u have plz help me.........
nd reply me at innocent_desire_89@.hotmail.com,waitng 4 ur reply
tcsql

images not showing up on server

I am serving up reports using the web service using the render method.
The reports have images on them. The following scenarios work
.Net application and Reporting Services are all on the same
workstation. Images show up and everything works well.
.Net application on same workstation and I point to Reporting Services
which is on Test environment server A. Images show up and everthing
works well.
This is not working
.Net application is on server B and Reporting Services is on the same
server A. The report shows up but all images show up with the red x.
What can be different between the code on my local workstation and the
code on the server? I have copied all the neccessary files out there.
Is there something on my workstation which has Visual Studio installed
that is not on the server B which only has IIS installed? Or is there
something else I could be missing in the migration to the server
environment?We have found that the report comes up just fine in the server
environment but the image is using different credentials than the user
that is logged in. If we run impersonate as user ABC, all reports come
up fine under ABC, but the image prompts a login box. The image wants
to load under the users that logged in and not the user we use to
impersonate. Any thoughts on how to get around this?

Images in SQL Database

Am building ASP.NET application and using sql 2000 server for data store. I
intend to store images in the sql server but am wondering is this a good
choice or not. I have a choice of storing them on the file system but which
is better.
The application is for a school assessment system and the images will be for
the students thus the number will grow overtime. I need to deploy the more
robust and effecient mechanism so please someone advice me....
Thanks alot in advance
You may find this article useful:
http://www.aspfaq.com/show.asp?id=2149
David Portas
SQL Server MVP

Images in SQL Database

Am building ASP.NET application and using sql 2000 server for data store. I
intend to store images in the sql server but am wondering is this a good
choice or not. I have a choice of storing them on the file system but which
is better.
The application is for a school assessment system and the images will be for
the students thus the number will grow overtime. I need to deploy the more
robust and effecient mechanism so please someone advice me....
Thanks alot in advanceYou may find this article useful:
http://www.aspfaq.com/show.asp?id=2149
David Portas
SQL Server MVP
--sql

Images in SQL Database

Am building ASP.NET application and using sql 2000 server for data store. I
intend to store images in the sql server but am wondering is this a good
choice or not. I have a choice of storing them on the file system but which
is better.
The application is for a school assessment system and the images will be for
the students thus the number will grow overtime. I need to deploy the more
robust and effecient mechanism so please someone advice me....
Thanks alot in advanceYou may find this article useful:
http://www.aspfaq.com/show.asp?id=2149
--
David Portas
SQL Server MVP
--

Images From Sql Database

I have a database in sql server with a table containing a few images stored as binary data and there unique ids. From a Visual Basic.NET Application I want to use the crystal report to display 1 of the images based on the id that it is fed. How can I read and image from the sql database and display it in a Crystal Report? Any help offered is greatly appreciated.I've used a stored procedure to get the images from db and then add the blob field to the report. problem is that the wizard "enter parameter value" keeps prompting while you're going to drag the blob to your report. I still haven't find a solution for this problem.|||Just drag the blob column to report and go to preview mode and check if it is displaying the image|||I too have the same problem But in the case of Auto cad images(*.dwg)

I am saving the image in image field (SQL server) in binary format

Is there any solution for that?

Reply as much as earlier!|||What is the error you get?|||While adding the image field(SQL server) in crystal report,it doesn't showing any error

But

1.If the image format other than autocad(*.dwg) then it is showing the image as it is.

2.But in the case of autocad image it doesn't showing anything the field space would be blank.

If anyone guide me for this prob,please help me out

My project has been delayed because of this problem

Lingeswaran.r|||Hi all
I have some problem load image to Crytal Report 11

I have database from sql Server. The Columns Images after.
The column
Column name Data Type Length Allownulls
Picture varchar 50 *

After i save to database is

image\picture.jpg.

When i drag the column to Crystal Report 11 it have only is image\picture.jpg.
Can you help me ?
Display the picture.jpg is a picture
Thank you.|||Hi,
I had face the problem in Sql server with CrystalReports11 at Visual studio2005. By doing the following way you can solve the problem.

Let assume table "Item_t" having "ItemPicture'' column and its datatype is "Image'' and assume picture is stored in that table.

fecth the picture data to a datatable.

Let assume the picture is in dtItem & write the following method

private DataTable ConvertPicture(DataTable dtItem)
{
DataTable dtReturn = dtItem.Clone();

foreach (DataRow dRow in dtItem.Rows)
{
DataRow drRow = dtReturn.NewRow();

// Convert the picture into binary format

Byte[] bPictureInByte = (Byte[])dtItem.Row["ItemPicture''];
System.IO.MemoryStream mStream = new System.IO.MemoryStream(bPictureInByte ); // convert as stream
Bitmap pictureBimap= new Bitmap(mStream);//store in a Bitmap

// save the picture data in Local harddisk as .jpg file
pictureBimap.Save("C:\\temp\\Itempicture.Jpg", System.Drawing.Imaging.ImageFormat.Jpeg);

//Read the same jpg Picture from your Local harddisk
System.IO.FileStream fs = new System.IO.FileStream("C:\\temp\\Itempicture.Jpg", System.IO.FileMode.Open);
System.IO.BinaryReader br = new System.IO.BinaryReader(fs);

//convert to byte[] & save in your new data row
drRow = br.ReadBytes((int)br.BaseStream.Length);
br.Close();

//add the datarow to the datatable dtReturn;

dtReturn.Rows.add(drRow);

}

return dtReturn

}

now you passing the dtReturn data table to your .rpt file and print the Image.

Best wishes|||But now i don't want to Write a picture into the SQL Server
I only want write a link of it.
Example: image\picture_name.jpg
After that i load into Crytal Report.
How I can to do it ?
You can help me ?

If i write to sql server is no proplem.|||Hi all,
I want to display image in report but I can't. The following is what I do.
I create a report in C#.NET 2003, using CR XI. Data is stored in SQL Server 2005, and I store image as BLOB field. I design by drag and drop fields into report. In my code, I connect to database, get mydataset by executing a sql string, and then using rpt.SetDataSource(mydataset). All data in text field is ok but image field is empty.
Anybody help me, please.|||I know why I can't display image in report now. A simple reason is the aslias name of image field in sql statement and the image field name in my report are different.

But now I don't understand the reason why sometimes I can 't drag image field from tree view into report. Anybody know?

Images aren't being displayed in deployed Reports

Hi everybody,

When I develop and run (preview) a report in my machine (Vs.net 2003), the report is displayed correctly, including images.

But, when I deploy the report to the server (Win2k Server), the report runs OK, but the images are not displayed!

I've already tried everything I found in the internet about this problem .... changed the way of put the image in the report (Embedded, External), tried an image with only RGB colors, changed the account for unattended execution (rsconfig) .... but nothing worked!!!

Does anybody have any idea about what might be happening?

Thanks a lot!!Make sure cookies are enabled in your browser. Images rely on sessions and sessions rely on cookies.

To better diagnose this you can right click on the missing image icon right after rendering report, go to properties and copy link for the image. Make sure you copy the entire link. Then paste it in the address bar of the same window that displays report. You'll see better error message.|||Yes, cookies are enabled.

Actually, view the properties of the image was the first step I took ...

The image link:
http://server/ReportServer?%2fOpexReports%2fReport1&rs%3aFormat=HTML4.0&rs%3aImageID=6b02dc52-73b7-489e-8dfe-730e6d9bfd6b

when I copy the link in IE, I get this error:

Reporting Services Error

---

The stream cannot be found. The stream identifier that is provided to an operation cannot be located in the report server database. (rsStreamNotFound) Get Online Help|||I SOLVED THE PROBLEM!!

I discovered that images in report rendering rely on session and cookies.
When you have and underscore "_" in the server name, this may cause some session problems.

So I update the field UseSessionCookies to 'False' in the ConfigurationInfo table, in the RS Database. The images are now displayed!

Regards!|||

Hi Rodrigo,

I am also facing the problem similar to your problem. I have followed your approach for solution, but unfortunately i am not able to get the solution.

Can you please provide me some approach for solving this problem

Regards,

Vikas Khandpur

|||

Just change the IP address to the computer name and it will work

Images aren't being displayed in deployed Reports

Hi everybody,

When I develop and run (preview) a report in my machine (Vs.net 2003), the report is displayed correctly, including images.

But, when I deploy the report to the server (Win2k Server), the report runs OK, but the images are not displayed!

I've already tried everything I found in the internet about this problem .... changed the way of put the image in the report (Embedded, External), tried an image with only RGB colors, changed the account for unattended execution (rsconfig) .... but nothing worked!!!

Does anybody have any idea about what might be happening?

Thanks a lot!!Make sure cookies are enabled in your browser. Images rely on sessions and sessions rely on cookies.

To better diagnose this you can right click on the missing image icon right after rendering report, go to properties and copy link for the image. Make sure you copy the entire link. Then paste it in the address bar of the same window that displays report. You'll see better error message.|||Yes, cookies are enabled.

Actually, view the properties of the image was the first step I took ...

The image link:
http://server/ReportServer?%2fOpexReports%2fReport1&rs%3aFormat=HTML4.0&rs%3aImageID=6b02dc52-73b7-489e-8dfe-730e6d9bfd6b

when I copy the link in IE, I get this error:

Reporting Services Error

---

The stream cannot be found. The stream identifier that is provided to an operation cannot be located in the report server database. (rsStreamNotFound) Get Online Help|||I SOLVED THE PROBLEM!!

I discovered that images in report rendering rely on session and cookies.
When you have and underscore "_" in the server name, this may cause some session problems.

So I update the field UseSessionCookies to 'False' in the ConfigurationInfo table, in the RS Database. The images are now displayed!

Regards!|||

Hi Rodrigo,

I am also facing the problem similar to your problem. I have followed your approach for solution, but unfortunately i am not able to get the solution.

Can you please provide me some approach for solving this problem

Regards,

Vikas Khandpur

|||

Just change the IP address to the computer name and it will work

Images aren't being displayed in deployed Reports

Hi everybody,

When I develop and run (preview) a report in my machine (Vs.net 2003), the report is displayed correctly, including images.

But, when I deploy the report to the server (Win2k Server), the report runs OK, but the images are not displayed!

I've already tried everything I found in the internet about this problem .... changed the way of put the image in the report (Embedded, External), tried an image with only RGB colors, changed the account for unattended execution (rsconfig) .... but nothing worked!!!

Does anybody have any idea about what might be happening?

Thanks a lot!!Make sure cookies are enabled in your browser. Images rely on sessions and sessions rely on cookies.

To better diagnose this you can right click on the missing image icon right after rendering report, go to properties and copy link for the image. Make sure you copy the entire link. Then paste it in the address bar of the same window that displays report. You'll see better error message.|||Yes, cookies are enabled.

Actually, view the properties of the image was the first step I took ...

The image link:
http://server/ReportServer?%2fOpexReports%2fReport1&rs%3aFormat=HTML4.0&rs%3aImageID=6b02dc52-73b7-489e-8dfe-730e6d9bfd6b

when I copy the link in IE, I get this error:

Reporting Services Error

---

The stream cannot be found. The stream identifier that is provided to an operation cannot be located in the report server database. (rsStreamNotFound) Get Online Help|||I SOLVED THE PROBLEM!!

I discovered that images in report rendering rely on session and cookies.
When you have and underscore "_" in the server name, this may cause some session problems.

So I update the field UseSessionCookies to 'False' in the ConfigurationInfo table, in the RS Database. The images are now displayed!

Regards!|||

Hi Rodrigo,

I am also facing the problem similar to your problem. I have followed your approach for solution, but unfortunately i am not able to get the solution.

Can you please provide me some approach for solving this problem

Regards,

Vikas Khandpur

|||

Just change the IP address to the computer name and it will work

Images And SQL 2000

Hello,
I'm looking to add imaging to an insurance application that was written in
house. We are programming in .Net with SQL2000 as the back end. The images
will be on average 50K and need to be stored for 7 years. Users will need
to retrieve these images from a web client to make underwriting decisions.
I was leaning towards storing the image in the data base, but while
researching the project the examples I've seen on the market all use a path
to a location to reference the image. This makes me think they either they
have found some issue with store large amounts of data in the data base or
they developed so early they the support of storing images in databases wasn
't there.
Our current SQL data base is 30Gig and the Image store we have is 275 Gigs.
I was hoping to get your opinion on the pluses and minuses of storing images
in a SQL data base.
Thanks in Advance,
MarkIn article <uyaJvCNmDHA.2652@.TK2MSFTNGP09.phx.gbl>, mark@.getamco.com
said...
> I'm looking to add imaging to an insurance application that was written in
> house. We are programming in .Net with SQL2000 as the back end. The images
> will be on average 50K and need to be stored for 7 years. Users will need
> to retrieve these images from a web client to make underwriting decisions.
> I was leaning towards storing the image in the data base, but while
> researching the project the examples I've seen on the market all use a path
> to a location to reference the image. This makes me think they either they
> have found some issue with store large amounts of data in the data base or
> they developed so early they the support of storing images in databases wasn
> 't there.
> Our current SQL data base is 30Gig and the Image store we have is 275 Gigs.
> I was hoping to get your opinion on the pluses and minuses of storing images
> in a SQL data base.
The pluses are that you have everything in one place for backup and
storage. The minuses are that you have everything in one place.
I find that I can use much cheaper storage for files than I use for my
database as a whole and I can easily add new volumes when I need to grow.
For some it's easier to just use the database for everything. In my
situation I have about 14 terabytes of image data in about 70 million
files driven by 35GB database.|||i read someplace that if you store images in SQL the front end must compose
the images from binary, send the images to SQL which in turn convert the
images into binary again to keep it in the tables => over head?
i am also in insurance business, don't see such apps using SQL to store
actual images. Hard drive being cheap ins't a reason I would save images in
SQL.
"Mark" <mark@.getamco.com> wrote in message
news:uyaJvCNmDHA.2652@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I'm looking to add imaging to an insurance application that was written in
> house. We are programming in .Net with SQL2000 as the back end. The
images
> will be on average 50K and need to be stored for 7 years. Users will need
> to retrieve these images from a web client to make underwriting decisions.
>
>
> I was leaning towards storing the image in the data base, but while
> researching the project the examples I've seen on the market all use a
path
> to a location to reference the image. This makes me think they either
they
> have found some issue with store large amounts of data in the data base or
> they developed so early they the support of storing images in databases
wasn
> 't there.
>
> Our current SQL data base is 30Gig and the Image store we have is 275
Gigs.
>
> I was hoping to get your opinion on the pluses and minuses of storing
images
> in a SQL data base.
>
> Thanks in Advance,
> Mark
>

Image not showing Up

When a build a report in vs.net and click the preview tab, the images show up correctly on the report output. But after I deploy the report to the reportserver and view the report, the images do no show up. Just the outline where the images should be. Do
you have any suggestions as to why the images are not showing up? Thanks.
Joe S.
If this is in a web browser, and you right-click the image and hit
properties, what is the URL that is given? Have you deployed the images to
that location?
http://www.aspfaq.com/
(Reverse address to reply.)
"Joe S." <JoeS@.discussions.microsoft.com> wrote in message
news:3BD15438-CF3F-414B-A743-BC75F106EAF4@.microsoft.com...
> When a build a report in vs.net and click the preview tab, the images show
up correctly on the report output. But after I deploy the report to the
reportserver and view the report, the images do no show up. Just the outline
where the images should be. Do you have any suggestions as to why the images
are not showing up? Thanks.
> --
> Joe S.

Image not showing Up

When a build a report in vs.net and click the preview tab, the images show u
p correctly on the report output. But after I deploy the report to the repor
tserver and view the report, the images do no show up. Just the outline wher
e the images should be. Do
you have any suggestions as to why the images are not showing up? Thanks.
--
Joe S.If this is in a web browser, and you right-click the image and hit
properties, what is the URL that is given? Have you deployed the images to
that location?
http://www.aspfaq.com/
(Reverse address to reply.)
"Joe S." <JoeS@.discussions.microsoft.com> wrote in message
news:3BD15438-CF3F-414B-A743-BC75F106EAF4@.microsoft.com...
> When a build a report in vs.net and click the preview tab, the images show
up correctly on the report output. But after I deploy the report to the
reportserver and view the report, the images do no show up. Just the outline
where the images should be. Do you have any suggestions as to why the images
are not showing up? Thanks.
> --
> Joe S.

Image not displaying webform reportviewer

Hi ,

I am using SQL server reports thru web services to display that in web form . Charts are not dispalying coming with [x] image.

I am using VS .NET 2003 . Text is coming properly only problem with the image.

Can anyone suggest me the possible solution for that.

thanx in advance

I'm having this issue as well. Did you ever get it resovled?
Anyone?

sql

Image From DB - There but not there

Tribe,
I'm struggling with the poorly implemented image handling in SSRS
(which is represented through ASP.NET via
Microsoft.Reporting.WebForms)
First off, SSRS/Reporting team - External Images should mean exactly
that. The report should express EXACTLY what I enter into the Value
field for an External type image in a report. The fact that the engine
interprets and munges this field is an utter travesty. If I enter "/
myDBImageDumper.aspx" this text is what should be expressed out
through the Web report viewer. Period. The use of this property
"UnattendedExecutionAccount" in order to allow the report engine to
render local images is a complete and total hack
Now, in dealing with a simple database supplied image in the reporting
body of a report, I've got an Image type field in a SQLExpress table.
I've loaded this field through a web FileUpload and stored the bytes
in the field. I can render these bytes out through a web page by using
the Response.WriteBinary(reader[IMAGEFIELDPOS]);
I mention this as I know that the image now in the database in the
correct mime format (jpeg).
So, back to the report. I've added an image field to the body of the
report (I want it in the header by alas that is also an
impossibility). To this field I've assigned the mime type "image/
jpeg", the Source of Database, and a Value of:
=System.Convert.ToBase64String(Fields!UserCompanyImage.Value,
"InvoiceHeader_InvoiceHeader")
And of course the image does not render.
Adding that same value to a text field however allows the Base64 to
get dumped out in to that field. Which proves the data is there.
However, I'm baffled as to how to get this image to show up.
Clues anyone
DCTribe,
I lied. I can get the image to show up in the body of the report by
using just the straight byte dump:
=First(Fields!UserCompanyImage.Value, "InvoiceHeader_InvoiceHeader")
But what I'm really trying to do is to get the image up in the header.
So I've got another identical image up in the header and I've got its
Value set to :
=Reportitems!imageLogo.Value
Where imageLogo is the name of the first, body of the report, image.
The header image does not render.
Clues 2?
DC
On Oct 8, 2:44 pm, bangeye <davecl...@.gmail.com> wrote:
> Tribe,
> I'm struggling with the poorly implemented image handling in SSRS
> (which is represented through ASP.NET via
> Microsoft.Reporting.WebForms)
> First off, SSRS/Reporting team - External Images should mean exactly
> that. The report should express EXACTLY what I enter into the Value
> field for an External type image in a report. The fact that the engine
> interprets and munges this field is an utter travesty. If I enter "/
> myDBImageDumper.aspx" this text is what should be expressed out
> through the Web report viewer. Period. The use of this property
> "UnattendedExecutionAccount" in order to allow the report engine to
> render local images is a complete and total hack
> Now, in dealing with a simple database supplied image in the reporting
> body of a report, I've got an Image type field in a SQLExpress table.
> I've loaded this field through a web FileUpload and stored the bytes
> in the field. I can render these bytes out through a web page by using
> the Response.WriteBinary(reader[IMAGEFIELDPOS]);
> I mention this as I know that the image now in the database in the
> correct mime format (jpeg).
> So, back to the report. I've added an image field to the body of the
> report (I want it in the header by alas that is also an
> impossibility). To this field I've assigned the mime type "image/
> jpeg", the Source of Database, and a Value of:
> =System.Convert.ToBase64String(Fields!UserCompanyImage.Value,
> "InvoiceHeader_InvoiceHeader")
> And of course the image does not render.
> Adding that same value to a text field however allows the Base64 to
> get dumped out in to that field. Which proves the data is there.
> However, I'm baffled as to how to get this image to show up.
> Clues anyone
> DC|||Tribe,
Here's the trick (what a mess)
In order to get a dynamic JPEG image out of your database and into the
header of your report you must:
Add a textfield to the body of your report.
Assign the value of that textfield (call this text field
txtImageData):
= Convert.ToBase64String(Fields!MyImageStreamField)
Add an image type to your report header.
Assign the Mime type to image/jpeg and the Source to Database
Assign the value to :
= Convert.FromBase64String(ReportItems!txtImageData.Value)
Your image will then have the byte data that was originally in your
image column in your database table.
DC
On Oct 8, 3:04 pm, bangeye <davecl...@.gmail.com> wrote:
> Tribe,
> I lied. I can get the image to show up in the body of the report by
> using just the straight byte dump:
> =First(Fields!UserCompanyImage.Value, "InvoiceHeader_InvoiceHeader")
> But what I'm really trying to do is to get the image up in the header.
> So I've got another identical image up in the header and I've got its
> Value set to :
> =Reportitems!imageLogo.Value
> Where imageLogo is the name of the first, body of the report, image.
> The header image does not render.
> Clues 2?
> DC
> On Oct 8, 2:44 pm, bangeye <davecl...@.gmail.com> wrote:
> > Tribe,
> > I'm struggling with the poorly implemented image handling in SSRS
> > (which is represented through ASP.NET via
> > Microsoft.Reporting.WebForms)
> > First off, SSRS/Reporting team - External Images should mean exactly
> > that. The report should express EXACTLY what I enter into the Value
> > field for an External type image in a report. The fact that the engine
> > interprets and munges this field is an utter travesty. If I enter "/
> > myDBImageDumper.aspx" this text is what should be expressed out
> > through the Web report viewer. Period. The use of this property
> > "UnattendedExecutionAccount" in order to allow the report engine to
> > render local images is a complete and total hack
> > Now, in dealing with a simple database supplied image in the reporting
> > body of a report, I've got an Image type field in a SQLExpress table.
> > I've loaded this field through a web FileUpload and stored the bytes
> > in the field. I can render these bytes out through a web page by using
> > the Response.WriteBinary(reader[IMAGEFIELDPOS]);
> > I mention this as I know that the image now in the database in the
> > correct mime format (jpeg).
> > So, back to the report. I've added an image field to the body of the
> > report (I want it in the header by alas that is also an
> > impossibility). To this field I've assigned the mime type "image/
> > jpeg", the Source of Database, and a Value of:
> > =System.Convert.ToBase64String(Fields!UserCompanyImage.Value,
> > "InvoiceHeader_InvoiceHeader")
> > And of course the image does not render.
> > Adding that same value to a text field however allows the Base64 to
> > get dumped out in to that field. Which proves the data is there.
> > However, I'm baffled as to how to get this image to show up.
> > Clues anyone
> > DC

Image does not display

Hi post,
I have created a simple report using VS.net with an embeded image.
when I open the report from my PC the image displays well not a problem.Also
for any users this works fine.
My PC name is "Personal1"
Report server exists on Server: "Server1"
url used to access this Report is http://Server1.gar.abc.com/Reports
BUT the problem is
When I access this report from other servers(Personal2,Personal3 etc)
it does not display image(Or it display missing image icon).
Can someone suggest the cause and problem.
thanks
-aslamSolved this problem from the link
http://www.codeproject.com/useritems/RenderStreamImages.asp
-aslam
"replyaslam" wrote:
> Hi post,
> I have created a simple report using VS.net with an embeded image.
> when I open the report from my PC the image displays well not a problem.Also
> for any users this works fine.
> My PC name is "Personal1"
> Report server exists on Server: "Server1"
> url used to access this Report is http://Server1.gar.abc.com/Reports
> BUT the problem is
> When I access this report from other servers(Personal2,Personal3 etc)
> it does not display image(Or it display missing image icon).
> Can someone suggest the cause and problem.
> thanks
> -aslamsql

image datatype

Is the Image Datatype to store pictures and if so how would you transfer a picture in asp.net into a sqldatabase that has this datatype?

if it isnt for pictures what is it used for?the image datatype can be used for any binary files. Not just images.

Check out microsoft's 23 C# samples. One of them does exactly what you want!

http://msdn.microsoft.com/vcsharp/downloads/samples/23samples/default.aspx|||it doesnt work:(
i tried to download it and it said it could not perform my requestsql

Im not able to connect to SQL server using ASP.NET & VS.NET

plzz help me ,
I use VS.NET --> VB.NET --> ASP.NET appln.

Database : Nortwind using SQL data adapter

And plzz let me know what are steps in connecting to database.

I've tried something but i'm getting " Login failed for user 'HOME-HG0B8FTI7Y\ASPNET'. "
error.

Some1 out dere solve this problem

Server Error in '/WebApplication6' Application.
------------------------

Login failed for user 'HOME-HG0B8FTI7Y\ASPNET'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'HOME-HG0B8FTI7Y\ASPNET'.

Source Error:

Line 89: Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Line 90: 'Put user code to initialize the page here
Line 91: Me.SqlDataAdapter1.Fill(Me.DataSet11.Categories)
Line 92: Me.DataBind()
Line 93: End Sub

Source File: d:\inetpub\wwwroot\WebApplication6\WebForm1.aspx.vb Line: 91

Stack Trace:

[SqlException: Login failed for user 'HOME-HG0B8FTI7Y\ASPNET'.]
System.Data.SqlClient.SqlConnection.Open()
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState)
System.Data.Common.DbDataAdapter.Fill(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
System.Data.Common.DbDataAdapter.Fill(DataTable dataTable, IDbCommand command, CommandBehavior behavior)
System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
WebApplication6.WebForm1.Page_Load(Object sender, EventArgs e) in d:\inetpub\wwwroot\WebApplication6\WebForm1.aspx.vb:91
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()Hi there,

This happens when asp.net user account doesn't have enough permissions to access the specified database. Try thislink

Hope this helps|||It is eating my brain. U gave right solution|||Glad it worked for you...

Have fun programming..:)

I'm Looking For : ReportViewer tutorial With C# && .NET

Hi All ,

If you will send to me a link I'll be very grateful .

Thanks In Advance
Boaz Shalev.Take a look at the Web Analyzer starter kit at http://lab.msdn.microsoft.com/vs2005/downloads/starterkits/default.aspx.|||That link redirects to this:
http://msdn.microsoft.com/vstudio/default.aspx

I'm Looking For : ReportViewer tutorial With C# && .NET

Hi All ,

If you will send to me a link I'll be very grateful .

Thanks In Advance
Boaz Shalev.Take a look at the Web Analyzer starter kit at http://lab.msdn.microsoft.com/vs2005/downloads/starterkits/default.aspx.|||That link redirects to this:
http://msdn.microsoft.com/vstudio/default.aspx