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: charbrad
  • Content: Threads
  • Order by date
  1. charbrad

    Project Server 2013

    Hello....can someone tell me how I can view my project in Microsoft Project 2013? I have completed the steps to connect to Project Server through Microsoft Project Professional 2010 and has been saved my project, but I can't seem to view it in Project Server. Any help would be greatly appreciated.
  2. charbrad

    SAP 4.0B

    Is there a table within SAP that will convert material numbers i.e. SAP material number to Customer material number for EDI outbound documents?
  3. charbrad

    Shading in Microsoft Project

    I created a new column "Actual Finish". Some of cells have a shaded rose colored background...can someone tell me what causes this. The data in these cells are in date format i.e. 05/23/2013. It does not occur in all cells. Thanks in advance
  4. charbrad

    Memory Issue

    I removed the memory from my Dell Dimension 8200 to take to get more memory, which they didn't carry anymore. I came back replaced the memory that I had taken out and the PC will not boot up. It makes long beeping noises. I removed the memory and and replaced it again. Can someone point me...
  5. charbrad

    Column Headings Between Groups

    Working in SSRS 2005 and I am trying to get the column heading to stop repeating for example Group 1 type item # size 23 1234 5 type item # size 25 5678 9 type item# size 19 6789 7 for every line within the group the column headings repeat...
  6. charbrad

    Group Subtotals

    I have a Tabular report in SSRS 2005. When I created the report I am grouped by sales type and I checked the check box to include subtotals. The subtotal is in the header instead of the footer. How can I get the subtotal to appear in the footer?
  7. charbrad

    Conditions

    I have a query that has two conditions in my where statement, for example WHERE CUSTOMER = 'ABCDE' AND ITEMNMBR = '1234' My problem is that if it finds ITEMNMBR = '5678' for CUSTOMER = 'ABCDE' then it should appear in the report and it does not...can someone tell me what I am doing wrong?
  8. charbrad

    Date Parameter in SSRS

    I have set up date parameters in SSRS 2005 that are not working. Under reports I click report parameters and enter the following criteria: Properties: Name BeginDate Data Type: DateTime Prompt: BeginDate Allow blank value is checked. Available Values = Non-queried Default values = Null I...
  9. charbrad

    Modify Column

    I am trying to modify a column of datatype char(31) to varchar(3) ALTER TABLE dbo.zyx_abcdef_hdr MODIFY vc_xxx_zzz varchar(3) I am getting error message: Server: Msg 170, Level 15, State 1, Line 2 Line 2: Incorrect syntax near vc_xxx_zzz' Any suggestions?
  10. charbrad

    Column needed from another database

    I have two databases database1 & database2. I can retrieve most of my information from a table in database1, but there is a column from a table in database2 that I need to complete my query. Is there a way to join this column from database2 to my ouput from data retrieved from database1?
  11. charbrad

    Date Problem

    I have a column within a table that is pulling the date, folder and file name as: #2007\12\12\15\DOCFILE1.TXT Is there a way to convert this in SQL to get just the date? 2007\12\12
  12. charbrad

    Adding Days to Date

    Is it possible to add days to a date? For example I have a date column with a date of 10/09/2007 then I have a column named date diff with 365. When adding 365 to 10/09/2007 it should give me 10/09/2008 in the final date column. I am not sure how to do this since the date and the value in the...
  13. charbrad

    Error: ADODB.Recordset error '800a0bcd'

    I have the below SQL statement in the beginning of my ASP page MySQL = "SELECT * FROM ShipSummary (NOLOCK) where ShipDate = DateDiff(d, 0, GetDate()+1)" If there are no records found the program stops and gives me an error: ADODB.Recordset error '800a0bcd'...this is because there are no...
  14. charbrad

    Display a break between date groupings....HELP

    I have been trying to display a break between date groupings without luck (using ASP Classic). I have tried many suggestions found in FAQ's or by searching Google..but nothing that works. It must be something that I am doing wrong...can someone help? body = "<HTML<STYLE...
  15. charbrad

    Blank Row Between Dates

    I have the below code and I am trying to insert a blank row when the date changes (column early_shpdte). I have tried multiple things such as char(13)+ char(10) but nothing works. I am just a beginner trying to master this skill. Can someone help me out? SELECT CASE when...
  16. charbrad

    Inserting Blank Line in Output

    I am trying to insert a blank line between categories. My output is: Shoes 12 Shoes 11 Shoes 10 Shoes 09 Socks 19 Socks 11 Socks 17 Socks 22 Boots 19 Boots 25 Boots 76 What I am trying to get is each category with a blank line in between like: Shoes 12 Shoes 11 Shoes 10...
  17. charbrad

    Problem with Subtotals

    I have the below code I am trying to subtotal by date MySQL = "SELECT ship_id, adrnam, prtnum, early_shpdte, shpsts, cponum, stgdte, host_ordqty, inpqty, stgqty, sum(host_ordqty-stgqty-inpqty) FROM ShipReport (NOLOCK) where (host_ordqty-stgqty-inpqty <> 0) GROUP BY ship_id, adrnam, prtnum...
  18. charbrad

    Error When Formatting Date

    I am receiving error: ADODB.Field error '800a0bcd' Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. /*****/*****.asp, line 21 MyRecordSet.OPEN MySQL, ssddbb dim stgdte if MyRecordSet.fields("stgdte") <> "" or...
  19. charbrad

    Format Date

    I am trying to format a date in an ASP page in which the date already appears (prior to formatting). I would like the date to appear as 9/07/2007 instead of 2007-09-07 11:13:08.000. See code below FormatDateTime(------, vbshortdate) I am not sure what to put in place of the dashes. If I...
  20. charbrad

    Sum by Date

    I am trying to sum quantities by date and I am having some difficulties, this is what I have so far: body = body + "<TR><TD BGCOLOR=""" & SHADE & """ COLSPAN=3 ALIGN=""CENTER""><b>Total:</b>&nbsp;</TD><TD ALIGN=""RIGHT"" BGCOLOR=""" & SHADE & """><B>" &...

Part and Inventory Search

Back
Top