Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: cs2009
  • Content: Threads
  • Order by date
  1. cs2009

    Win32Exception

    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=")...
  2. cs2009

    Adding a "!Modified" or "!Updated" icon to a document or list item

    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.
  3. cs2009

    Insert record having most recent trans date

    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 )...
  4. cs2009

    SQL Help

    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...
  5. cs2009

    SQLUpdate Help

    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...
  6. cs2009

    Report Manager Question

    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?
  7. cs2009

    Tablix with Cumulative Summing

    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...
  8. cs2009

    Filtering a Data Region by using the "IN" Operator

    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...
  9. cs2009

    SQL Help

    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...
  10. cs2009

    Query Active Directory

    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>;" & _...
  11. cs2009

    List data region with page break

    Using SSRS 2005. I have a report that uses a List Data region. I want to page break whenever a field value changes. I can't figure out how to do the page break. I see options for page breaking before and after the list, but this is not what I want. I need to page break whenever a field...
  12. cs2009

    Fuzzy Grouping using MS Access as a data source

    Using SSIS 2005 and MS Access 2000. Is it possible to use MS Access 2000 as a data source and destination for Fuzzy Grouping? I've tried using a connection manager of type Native OLE DB\MS Jet 4.0 OLE Db provider with a OLE DB source and get an error message stating, "The DBMS type or version...
  13. cs2009

    Lotus Notes UI Automation

    Using Visual Basic 2008, SQL Server 2005 and Lotus Notes client 6.5 thru 8.5.1. I have a Visual Basic program that automates the Lotus Notes UI to create an email in HTML format. The program does not send the email, but presents the email to the user to preview. This email contains a...
  14. cs2009

    MS Word 2007 Automation

    Using Visual Basic 2008. Below is a code snippet I use to automate Word: strLetter.Append("John Smith") strLetter.Append(Environment.NewLine) strLetter.Append("1 Main Street") strLetter.Append(Environment.NewLine) strLetter.Append("Any Town") strLetter.Append(Environment.NewLine)...
  15. cs2009

    Windows Clickonce application problems

    Using Visual Studio 2008. I have a click-once Windows application that is deployed using a url. I have one user out of a dozen who suddenly began experiencing problems executing the program after using it succesfully for a long time. She uses Internet Explorer 8.0 and her OS is Win XP SP3...
  16. cs2009

    MS Excel 2010 and MS Analysis Services 2005 XML Parser Error

    I have several sql server 2005 analysis services cubes that I connect to via MS Excel 2003 and MS Excel 2007. Several of my users recently upgraded their PC's to Excel 2010. These users now get the following error messages that prevent them from browsing the cubes, "XML for Analysis parser...
  17. cs2009

    Help with Select statement

    Using SQL Server 2005. I need help with a SQL Select statement. I have the following order numbers in a table and I want to select the lastest order number, which is the first 6 digits. The last 3 digits are the sequence numbers. order_no 123456_00 123456_01 123456_02 987654_00 987654_01...
  18. cs2009

    SSAS &amp; SSRS; Excel 2007 Report Action with Parameter

    Using SSAS & SSRS 2005; MS Excel 2007. I am attempting to add a Report Action to a cube that passes a parameter to a SSRS report. I have a Customer dimension with 2 attributes; customer number and customer name. The action is defined like this: Target Type: Attribute Members Target Object...
  19. cs2009

    SQL Help with Pivot

    Using SQL Server 2005. I have data in a table like this: Product Cost 1 Cost 2 Bkt MUOV18I001108 2.47 0.00 1 MUOV18I001108 0.08 0.00 2 MUOV18I001108 0.13 0.00 3 UOIBQVV237BGD 1.39 0.34 1 UOIBQVV237BGD 0.97 1.76 2 UOIBQVV237BGD...
  20. cs2009

    Drillthrough in Excel 2003

    I'm using SSAS 2005 and Excel 2003 with the XL addin installed. I understand the XL addin is no longer supported by Microsoft. I set up drillthrough for the cube and enabled drillthrough for a role. In Excel 2003 I have a "Cube Analysis" menu option as a result of installing the addin. The...

Part and Inventory Search

Back
Top