Create a hidden resource

Good day
I am using the CreateResource method (C#) to upload a jpg file to a report
server. I have completed this task, however I am manually navigating to the
Report Manager, going to the Properties section of the jpg file and checking
the "Hide in list view" checkbox.
I am sure this can be done programmatically, and I suspect it has to do with
this last parameter of the CreateResource method? Please could someone help
me.
ThanksI have managed to complete this, using the SetProperties method. The actual
property name I was looking for was "Hidden" - how simple :) I just set this
to "True"
"Imrahn" wrote:
> Good day
> I am using the CreateResource method (C#) to upload a jpg file to a report
> server. I have completed this task, however I am manually navigating to the
> Report Manager, going to the Properties section of the jpg file and checking
> the "Hide in list view" checkbox.
> I am sure this can be done programmatically, and I suspect it has to do with
> this last parameter of the CreateResource method? Please could someone help
> me.
> Thanks

Create a Condition for a DTS Task

I simply want an email to go out if any records in a table exist, else no email. I have other steps completed in this DTS job but this is the last step. Any ideas?
ddaveNever mind. I decided it be best to drop it into a stored procedure.

ddave

Counting a group of data as one

How do I go about counting a group of data as 1 item? For example, I have a user who worked on 11 work orders, but only 10 were completed and I am trying to get the # of work orders completed. The problem I am having is it is counting each work day for each completed work order, so for example, if one work order was worked on for 5 days, it counts that work order as five and not one. I need it to ignore the number of work days and just give me the one work order in the count.use distinct count instead.|||I tried that, but it does not work in this case. I am getting closer with it, but now I have a different problem. It seems that the total I need is always off by 1. For example, if a person worked on 7 work orders and 5 of them are closed or completed, it is giving me a count of six. I need to figure out how if a work order has a certain status, to take that total and subtract 1 from it, otherwise leave it alone. Any ideas?|||It would be good if you would post an example of your current report and your desired result.|||You might be able to use a running total with a formula to determine which records to count; reset at the appropriate level.