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

    help with adding calculated aged days to the sql command section

    I have created the sql statement under the command section of the database expert. I want to added a calculated filed to calculate # of aged days and make that as a table field. How would I do this?? I have tried by adding "today()-dbo.trans.trans_date as aged" but I don't think it is...
  2. memewang

    help on total for grouping

    I have a report desiged as following and having trouble getting the total. The report is group by aging bucket. Can somebody please help? Aging <30 days (group header1) Tras# Dollar amt userid a234 50 aaa444 a234 50 cxd565 5678 100 ddh588...
  3. memewang

    Failed to open a rowset

    I have got this error message: Query Engine Error: 'If tables are already linked then the join type cannot change.' Failed to open a rowset. I am using crystal v.10 and i am trying to link 3 different tables to Table A ( my primary table) and when i changed one of the link to left outer join...
  4. memewang

    Left join on crystal report

    I am a new user to Crystal report version 10.Does anybody know if Crystal report writing tool allow users to do left join or right join with multiple tables? thanks
  5. memewang

    Need to calculate # of days

    I am trying to create a report that will return # of records which meet the following criteria. need to pull records that exceeds 360 days for post date and status ="active" and records exceeds 30 days for receive date. The post date has data type of "Date" and receive date has data type of...

Part and Inventory Search

Back
Top