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!

  • Congratulations SkipVought 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: *

  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

    Worked like a charm...you are a genius.
  7. 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?
  8. charbrad

    Conditions

    Sorry I made a mistake in my code, it should read: WHERE CUSTOMER <> 'ABCDE' AND ITEMNMBR <> '1234' so if it finds the above criteria it should not return any records, but if it finds CUSTOMER = 'ABCDE' AND ITEMNMBR = '5678' then it should return the records and it does not. I hope...
  9. 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?
  10. charbrad

    Date Parameter in SSRS

    worked perfectly....Thanks.
  11. charbrad

    Date Parameter in SSRS

    I am fairly new to SSRS could you explain how I would create a parameter in my source query for my dataset?
  12. 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...
  13. charbrad

    Modify Column

    thank you. To change from null to not null my syntax would be: ALTER TABLE dbo.zyx_abcdef_hdr ALTER COLUMN vc_xxx_zzz varchar(3) NOT NULL;
  14. 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?
  15. charbrad

    Column needed from another database

    Thank you....have a star!
  16. charbrad

    Column needed from another database

    We are using SQL2000
  17. 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?
  18. charbrad

    Date Problem

    I used 10 in place of 8....worked like a charm. Have a star!
  19. 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

Part and Inventory Search

Back
Top