Displaying Windows Icons

Sir/Mam

I am creating a task manager functionality in c#.net 2003. I am checking only for open microsoft applications . If any microsoft application is opened ,it will display the application name for ex "Microsoft Word" in the listview control and its status "Running" . Now, I want to display the icon for Microsoft word or any other microsoft application, how should I display it in the ListView control.?

I have tried by taking it in the imagelist , because I have a class which returns the Windows Icons for these applications which are opened. But, I am unable to display it.

Please help me?

Thanks,
Shivanee.
You will want to post this in a .NET forum not a SQL Server forum.

Displaying Windows Icons

Sir/Mam

I am creating a task manager functionality in c#.net 2003. I am checking only for open microsoft applications . If any microsoft application is opened ,it will display the application name for ex "Microsoft Word" in the listview control and its status "Running" . Now, I want to display the icon for Microsoft word or any other microsoft application, how should I display it in the ListView control.?

I have tried by taking it in the imagelist , because I have a class which returns the Windows Icons for these applications which are opened. But, I am unable to display it.

Please help me?

Thanks,
Shivanee.
You will want to post this in a .NET forum not a SQL Server forum.

Displaying Series Group Total for a RS 2005 Chart

Hi there,

I'm trying to create a chart in RS 2005 that will split one set of
data into two separate lines while at the same time, creating a line
that will also display the average of all records. Some background
may be useful:

TABLE

Student_IdAttended_Meeting_CountTest_ScoreTest_ID11090125851315011109522580231652

What I would like to do is create 1 line that shows the average test score for all students with the test id as the x-axis value, 1 line that shows the average test score for all students who attended at least 5 meetings, and 1 line that does the same for all students who attended less than 5 meetings. In the Values box, I am using "=cint(AVG(Fields!Test_Score.Value))", and I have set a series group with the group on expression as "=Fields!Attended_Meetings_Count.Value > 5". This works great for splitting the line representing all values into the two lines I want, however, the test_score for all students line goes away. Anyone have any ideas on how to generate this line again? I've tried adding it as another value, but the series group then applies itself to the new values line as well and I end up with 4 lines.

Help!
-Rich

Hi,

From your description, it seems that you want to show three average values in three different conditions, right?

Why don't you calculate these three values separately? See the following sample:

=CINT(AVG(IIF(Fields!Attended_Meetings_Count.Value > 5, Fields!Test_Score.Value,0)))

=CINT(AVG(IIF(Fields!Attended_Meetings_Count.Value < 5, Fields!Test_Score.Value,0)))

=CINT(AVG(Fields!Test_Score.Value,0))

Thanks.

|||

Hi there,

Thanks for the reply. I did try the values you had suggested above, however, I get the following error when trying to view the preview:

The Value expression for the chart 'chart1' has a scope parameter that is not valid for an aggregate function. The scope parameter must be set to a string constant that is equal to either the name of a containing group, the name of a containing data region, or the name of a data set.

Any other suggestions?

Thanks again!

Rich

displaying lines in between data in the details section

Hello,
I am in the process of moving all my sql server reports to reporting
services.
First of all, I am creating a table from the toolbar menu and then
moving the data fields to the reports. I need to insert a line in
between rows of data in the detils section. It should look as follows:
table Header
Details 1 Jaideep 123 anydrive
---
2 Pradeep 123 wynndrive
---
table footer
Thanks
JaideepSelect the row in the table and in the properties dialog set the
BorderStyle.Bottom to dashed
Steve MunLeeuw
"jai" <dbasybase@.gmail.com> wrote in message
news:1161014400.693162.231240@.i42g2000cwa.googlegroups.com...
> Hello,
> I am in the process of moving all my sql server reports to reporting
> services.
> First of all, I am creating a table from the toolbar menu and then
> moving the data fields to the reports. I need to insert a line in
> between rows of data in the detils section. It should look as follows:
> table Header
> Details 1 Jaideep 123 anydrive
> ---
> 2 Pradeep 123 wynndrive
> ---
>
> table footer
> Thanks
> Jaideep
>

Displaying HTML or other Rich Text Format content in Reporting Ser

For a report I am creating, I need to display rich text format content, that
will be saved in the database, on a reporting services report. This data
will include bolds, bullets, italics, indents, etc.
Is there a way to show this content formatted correctly in Reporting
Services? We were planning on storing the data as HTML in the database but
reporting services is displaying the actual HTML code and not the content.
Does anyone have any ideas? Any help is greatly appreciated! ThanksSSRS only prints plain text. You can't display HTML or RTF.
"giggleraz" <giggleraz@.discussions.microsoft.com> wrote in message
news:B5F25DF8-285F-4052-A159-74E4863A9829@.microsoft.com...
> For a report I am creating, I need to display rich text format content,
that
> will be saved in the database, on a reporting services report. This data
> will include bolds, bullets, italics, indents, etc.
> Is there a way to show this content formatted correctly in Reporting
> Services? We were planning on storing the data as HTML in the database
but
> reporting services is displaying the actual HTML code and not the content.
> Does anyone have any ideas? Any help is greatly appreciated! Thanks|||Does anyone know if this will be possible in SQL 2005 RS? Surely this is a
basic requirement in a reporting tool
"Brian Bischof" wrote:
> SSRS only prints plain text. You can't display HTML or RTF.
>
> "giggleraz" <giggleraz@.discussions.microsoft.com> wrote in message
> news:B5F25DF8-285F-4052-A159-74E4863A9829@.microsoft.com...
> > For a report I am creating, I need to display rich text format content,
> that
> > will be saved in the database, on a reporting services report. This data
> > will include bolds, bullets, italics, indents, etc.
> > Is there a way to show this content formatted correctly in Reporting
> > Services? We were planning on storing the data as HTML in the database
> but
> > reporting services is displaying the actual HTML code and not the content.
> > Does anyone have any ideas? Any help is greatly appreciated! Thanks
>
>|||Not sure if this helps but what I had to do to get bullets was to start the
old Windows character map...not sure if it still comes with XP but if you
have an older version of windows such as 95 or 98 or 2000 you can start
character map by "Start" RUN and typing charmap.exe
Go to the Time New Roman font, scroll down about half way and you'll find a
BULLET (code 2022), you can copy it then paste it into a Textbox object and
it will display fine.
"IWantItalics" wrote:
> Does anyone know if this will be possible in SQL 2005 RS? Surely this is a
> basic requirement in a reporting tool
> "Brian Bischof" wrote:
> > SSRS only prints plain text. You can't display HTML or RTF.
> >
> >
> > "giggleraz" <giggleraz@.discussions.microsoft.com> wrote in message
> > news:B5F25DF8-285F-4052-A159-74E4863A9829@.microsoft.com...
> > > For a report I am creating, I need to display rich text format content,
> > that
> > > will be saved in the database, on a reporting services report. This data
> > > will include bolds, bullets, italics, indents, etc.
> > > Is there a way to show this content formatted correctly in Reporting
> > > Services? We were planning on storing the data as HTML in the database
> > but
> > > reporting services is displaying the actual HTML code and not the content.
> > > Does anyone have any ideas? Any help is greatly appreciated! Thanks
> >
> >
> >

Displaying Custom Properties for custom transformation in custom UI

Hi,

I am creating a custom transformation component, and a custom user interface for that component.

In

my custom UI, I want to show the custom properties, and allow users to

edit these properties similar to how the advanced editor shows the

properties.

I know in my UI I need to create a "Property Grid".
In

the properties of this grid, I can select the object I want to display

data for, however, the only objects that appear are the objects that I

have already created within this UI, and not the actual component

object with the custom properties.

How do I go about getting the properties for my transformation component listed in this property grid?

I am writing in C#.

You don't have to use a Propery Grid at all. If using a custom UI, then use any form control.

Pipeline components do not expose their properties through a nice (wrapper) object, you may want to write your own wrapper object and pass that to the property grid control.

I'm not quite sure what you mean when you talk about selecting the object to display data for. You decide the object. Start with DTSComponentMetadata90, as first made available to you in IDtsComponentUI.Initialize. You are passing that through?

|||The reason why I wanted to use the property grid was because it just looks nice and keeps a standard with what most of the component UI's are using. My next option that I have already started to work on in the mean time is to just use text boxes because they are simple to use.

I am passing the metadata through.

In the properties dialog of the "Properties Grid" there is a property until the "Behaviour" section called "SelectedObject"

In the list that is provided I can only select objects that I have added to my windows form. If I select one of those, it shows me what I would expect, the properties for that windows form object (such as a text box).

I have no idea how to add properties of the actual component using the metadata however. Some instruction on how to do so would be greatly appreciated.

Thanks|||

Create a wrapper object, that is simply a class with properties that mimic your component level properties. Then in code set the SelectedObject to this object. You cannot use the "designer" to select an object that is not on your form, and the SSIS component object will never be on your form.

Your wrapper class should query IDTSComponentMetadata90 and use the CManagedComponentWrapper to call SetProperty (sp?) to save the values.

|||Can you please provide a small sample as to how to create this wrapper object. I am not too familiar with any of this yet so it would be a great help if you could.

EDIT: Figured it out, thanks for your help.

Display empty rows

I am creating some reports with crystal reports 8.5

I made crosstabs listing the sales of certain products by store and month.

The stores are listed in the rows, products and months are in the columns. In the complete yearly reports everything is fine, because there are no empty rows.

When i create subreports for just a certain month or product, there might be empty rows, like, there might have been no sales of that particular product, in that store in that month. Instead of just displaying a row with the store name and Zero value, it just doesn`t show the row at all.

I need those empty rows to show and display zero values. The option "suppress empty rows" is not checked.

Any ideas ?

Example
...............January 2007
...............Product 1
Store1......0 <- this row is not displayed
Store2......6
Store3......24You'll need an outer join somewhere, rather than an inner join - read the help on join types, or describe your current tables and joins.|||I am just beginning in crystal but I did have the same issue but my training yesterday was about table joints.
You have to have your primary table as your "source" table where you have most of your data. When you link your secondary table, go to link options and you need to have the linking as "left join or outter join ...not Equal". Even though you have no value on that one record, it will show it with an empty cell or box but you will see everything else from that record. I still wouldn't know how to display the zero.