Search results for query: *

Another set of eyes here. It appears you are missing a space after "sum(CDR.MINUTES)" and before "as". See line sum(CDR.MINUTES)as Minutes just before the "from" clause.

Using Visual Studio 2008. I have this code fragment in a data grid view cell double-click event. System.Diagnostics.Process process = new System.Diagnostics.Process(); StringBuilder URI = new StringBuilder(); URI.Append("http://www.fedex.com/Tracking?tracknumbers=")...

Using WSS 3.0 Is it possible to add a "!Modified" or "!Updated" icon next to a document or list item whenever the document or list item has been modified? It should work similiar to the "!New" icon and disappear after a certain time period. I have the Office SharePoint Designer to work with.

You might want to look at passing a parameter from your main report to your drill-through report that identifies the person (a person id?).

The #Inventory table has duplicate item numbers with different balances and standard costs by trans date. How can I insert/select the most recent record from #Inventory using trans date? Insert Into #Balance ( ItemNumber , TransDate , Balance , StdCost , StdCostValue )...

I have this data in a table. OrderNo SeqNo Rep 111111 3 AX1 222222 3 ZT5 333333 1 AB7 333333 3 TM4 444444 1 WA9 When the order number repeats (see order number 333333) I want to return the record with the lowest sequence number. In this case it is...

I have data in a table like this: SortKey SortKeyNum 01-01-176DC HEAD 5.875"21 5/8'' Null 01-01-176DC HEAD 5.875"27 5/8'' Null 01-01-176DC HEAD 5.875"27 5/8'' Null 01-03-137DC SILL 6.0625" 23'' Null...

http://blogs.msdn.com/b/robertbruckner/archive/2008/10/13/repeat-header-and-visible-fixed-header-table.aspx

If I accidently delete a folder, report, snapshot, etc in Report Manager is there anyway to recover the object short of doing a ReportServer database restore?

I've used fuzzy grouping. I believe you will get much better results when you include additional fields in your matching logic such as zip code, state, city, etc. So, you will be matching on several fields instead of just one.

The RunningValue() function is what I need.

Using SSRS 2008 R2. I have data returned from a query like this: Month Order Count Jan 5 Feb 10 Mar 15 Apr 20 I need to sum the order counts over time (a cumulative count) like this: Jan Feb Mar Apr 5 15 30 50 Is...

Thanks, RiverGuy. If using a parameter is the only way to make the "IN" operator work then I will use one.

Using SSRS 2005. I'm trying to filter a data region by using the "IN" operator, but the region returns no records. I've tried different variations for the value expression such as: GL, A6, B6, C6, H6, GV, A7, B7, C7, H7, GR, A8, B8, C8, H8, GS, A9, B9, C9, H9 or Join(GL, A6, B6, C6, H6, GV...

Thanks also, Markros. You to are among the best. Your solution is simple and elegant.

Thanks, Boris. You are the best!

Using SQL Server 2005. I have this data: Order No Seq Comment 691164 1 This is comment A 691164 2 This is comment B 691164 4 This is comment D 123456 1 Comment X 123456 2 Comment Y 123456 4 Comment Z What would be the SQL to...

Got it figured out. should be: objCommand.CommandText = "<LDAP://dc=c-sgroup,dc=com>;" & "(&(objectCategory=User)(!userAccountControl:1.2.840.113556.1.4.803:=65536));" & "Name;Subtree" The exclamation mark (!) before userAccountControl.

I found this vbscript snippet that queries active directory for users whose "Password never expires" is checked. How do I change the query to return those users whose "Password never expires" is "Unchecked"? objCommand.CommandText = _ "<LDAP://dc=c-sgroup,dc=com>;" & _...

I got the list report to page break by placing it inside an outer list data region where I created a group on the field.