Showing posts with label business. Show all posts
Showing posts with label business. Show all posts

Friday, March 23, 2012

Image Property from Business object in Reporting Service 2005


Hi

I have a question from Reporting service 2005
I use Business Objects in My Report
and one of My object's property's type is "Image" or "BitMap"

when i Drop that property in my report and set value in "Fields!MyPicture.Value" and Run that then i see "#Error"

when i drop an "Image" from Toolbar and set that in "Database" and set value in "Fields!MyPicture.Value" and Run that then i see a red "X"

how can i show my image property from business object in my Report (.rdlc)

Thanks alot

Please read my answer in your other thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=467270&SiteID=1

-- Robert

Image Property from Business object in Reporting Service 2005

Hi

I have a question from Reporting service 2005
I use Business Objects in My Report
and one of My object's property's type is "Image" or "BitMap"

when i Drop that property in my report and set value in "Fields!MyPicture.Value" and Run that then i see "#Error"

when i drop an "Image" from Toolbar and set that in "Database" and set value in "Fields!MyPicture.Value" and Run that then i see a red "X"

how can i show my image property from business object in my Report (.rdlc)

thanks alotI have not used RS2005, but in Rs2000 that you need drop and drag a image component to your report and set database filed to this image, and then drag the image to you grid or matrix.
hope this can help you

Wednesday, March 21, 2012

Image from Business Object property?

Hello!
I'm using the local reporting services engine within a WinForm
application. I have a Business Object that contains a field which returns a
Bitmap. The Bitmap is created from other values within the same business
object. An example of the properties are below.
I'm binding my report to my BusinessObject and everything is going quite
well with the exception of displaying the graph bitmap within an Image
ReportItem. I've tried different Source types for the Image properties -
Database, Embedded, External but none seem to like the Bitmap within a
property on the Object Data Source.
I saw a few ways to develop a CustomerReportItem and will head down that
road but it seems like I'm missing something really simple. Any thoughts or
helpful tips are welcome.
Thanx,
Mike Q
public class MyBusinessObject
{
public decimal IndexValue
{
get
{
some calculations;
}
}
public Bitmap IndexGraph
{
get
{
Bitmap Result = Bitmap.FromFile("GraphTemplate.bmp");
Graphics g = Graphics.FromImage(Result);
Pen RedPen = new Pen(Brushes.Red, 5);
g.DrawLine(RedPen, 40, 0, 40, 50); // These values are calculated based on
the Index value.
return Result;
}
}
}I found the answer - instead of returning a Bitmap - return a byte[] from
the business object property
Thanx,
-q
"Mike Q" <MQuinn_q@.Yahoo.com> wrote in message
news:OMHy2SVrIHA.4280@.TK2MSFTNGP02.phx.gbl...
> Hello!
> I'm using the local reporting services engine within a WinForm
> application. I have a Business Object that contains a field which returns
> a Bitmap. The Bitmap is created from other values within the same
> business object. An example of the properties are below.
> I'm binding my report to my BusinessObject and everything is going quite
> well with the exception of displaying the graph bitmap within an Image
> ReportItem. I've tried different Source types for the Image properties -
> Database, Embedded, External but none seem to like the Bitmap within a
> property on the Object Data Source.
> I saw a few ways to develop a CustomerReportItem and will head down that
> road but it seems like I'm missing something really simple. Any thoughts
> or helpful tips are welcome.
> Thanx,
> Mike Q
>
> public class MyBusinessObject
> {
> public decimal IndexValue
> {
> get
> {
> some calculations;
> }
> }
> public Bitmap IndexGraph
> {
> get
> {
> Bitmap Result = Bitmap.FromFile("GraphTemplate.bmp");
> Graphics g = Graphics.FromImage(Result);
> Pen RedPen = new Pen(Brushes.Red, 5);
> g.DrawLine(RedPen, 40, 0, 40, 50); // These values are calculated based
> on the Index value.
> return Result;
> }
> }
> }

Friday, February 24, 2012

IIS

Hi,
A few of the machines have not got IIS installed (business related).
Is there a way to install sql server 2005 without having IIS on the machine?
Thanks

From my understanding the IIS Part is only for the reporting services, and som other smaller functions. You should remove the reporting service components and it should install.

|||

Tried that already and still sql server 2005 management studio does not appear.

|||

Are you able to install SQL Server?

What all components are you selcting while installing? Since you are not able to open Sql sever 2005, it seems like you are not selecting tools option.

Could you please give a snapshot of the error that you are getting?

(This http://msdn2.microsoft.com/en-us/library/ms143506.aspx mentions that “Reporting Services, which is installed as part of SQL Server Express with Advanced Services, will not install on operating systems that do not include Internet Information Services (IIS)”. There should be no problem in installing SQL server without IIS (We tried in our lab we were able to install SQL Server without IIS).)

Thanks

Arpita

|||

Management Studio can be installed regardless of whether IIS is installed.

Management Studio is one of the "Workstation components", so you need to check that checkbox on the "Components to Install" page of the setup wizard. If you need to be more selective, you can also click the "Advanced" button the "Components to Install" page, expand the "Client Components" folder, and then install just the Management Tools to your machine.

Hope this helps,
Steve

IIS

Hi,
A few of the machines have not got IIS installed (business related).
Is there a way to install sql server 2005 without having IIS on the machine?
Thanks

From my understanding the IIS Part is only for the reporting services, and som other smaller functions. You should remove the reporting service components and it should install.

|||

Tried that already and still sql server 2005 management studio does not appear.

|||

Are you able to install SQL Server?

What all components are you selcting while installing? Since you are not able to open Sql sever 2005, it seems like you are not selecting tools option.

Could you please give a snapshot of the error that you are getting?

(Thishttp://msdn2.microsoft.com/en-us/library/ms143506.aspx mentions that “Reporting Services, which is installed as part of SQL Server Express with Advanced Services, will not install on operating systems that do not include Internet Information Services (IIS)”. There should be no problem in installing SQL server without IIS (We tried in our lab we were able to install SQL Server without IIS).)

Thanks

Arpita

|||

Management Studio can be installed regardless of whether IIS is installed.

Management Studio is one of the "Workstation components", so you need to check that checkbox on the "Components to Install" page of the setup wizard. If you need to be more selective, you can also click the "Advanced" button the "Components to Install" page, expand the "Client Components" folder, and then install just the Management Tools to your machine.

Hope this helps,
Steve

Iis

Hi,
A few of the machines have not got IIS installed (business related).
Is there a way to install sql server 2005 without having IIS on the machine?
ThanksAs far as I've understood (I'm still on 2000), there's no need for IIS. At least it's not listed in the software requirements for Express Edition.

IIS

Hi,
A few of the machines have not got IIS installed (business related).
Is there a way to install sql server 2005 without having IIS on the machine?
Thanks

From my understanding the IIS Part is only for the reporting services, and som other smaller functions. You should remove the reporting service components and it should install.

|||

Tried that already and still sql server 2005 management studio does not appear.

|||

Are you able to install SQL Server?

What all components are you selcting while installing? Since you are not able to open Sql sever 2005, it seems like you are not selecting tools option.

Could you please give a snapshot of the error that you are getting?

(This http://msdn2.microsoft.com/en-us/library/ms143506.aspx mentions that “Reporting Services, which is installed as part of SQL Server Express with Advanced Services, will not install on operating systems that do not include Internet Information Services (IIS)”. There should be no problem in installing SQL server without IIS (We tried in our lab we were able to install SQL Server without IIS).)

Thanks

Arpita

|||

Management Studio can be installed regardless of whether IIS is installed.

Management Studio is one of the "Workstation components", so you need to check that checkbox on the "Components to Install" page of the setup wizard. If you need to be more selective, you can also click the "Advanced" button the "Components to Install" page, expand the "Client Components" folder, and then install just the Management Tools to your machine.

Hope this helps,
Steve

Sunday, February 19, 2012

ignoring keys while Truncating tables

Hello everyone.

I'm working with a customers business application which is developed in MSSQL. The system has over 170 tables and there is no documentation by those who created it. Now the problem is that I have to write script that deletes all the data in all the tables but since there are foreign keys defined in the tables I can't delete the data. Ofcourse I can figure it out eventually by testing back and forth in which order I have to delete the data in the tables but since there are over 170 tables that could take a very long time.

Does anyone now how I can solve this?? is there for examaple a way to make SQL server to ignore the foreign key lookup? What can I do?? is there any way which I can see in what order I should delete the data in the tables?

appritiate any help or comments.

Thanks.

\Homan1. script out your deletes and run the script 170 times, eventualy you will clear out all the tables.

2. use Enterprise Manager to generate a diagram of all the tables in the database. This would tell you the exact order you would need to follow to get everything deleted.

3. in Enterprise Manager and Query Analyzer you can look up the dpendencies of any object. In EM right click on any object, select all tasks, dependencies, in QA press "F8" to show the object browser, select and object drill down till you see dependencies.

4. use sp_depends on all 170 tables/view to figure out the parents and or child relationships.|||If you are going to have to reload the database you are going to want to know your foreign keys.|||For reference of cascade delete refer to SQL TEam (http://www.sqlteam.com/item.asp?ItemID=8595) link.

Refer to this Code (http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=641&lngWId=5) and modify to accomplish the task.

HTH|||disable your fk checking before deleting data, and re-enable them after.