Recent content by charbrad

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.

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

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

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

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

Worked like a charm...you are a genius.

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?

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

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?

worked perfectly....Thanks.

SQL

I am fairly new to SSRS could you explain how I would create a parameter in my source query for my dataset?

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

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;

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?