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!

Recent content by c83user

  1. c83user

    Display date as first day of the week for last 5 weeks

    If the report is run today it should display,first day of the week for the current week and also first day of the week for last weeks.
  2. c83user

    display date for whole week on x-axis in chart

    I used this filter for date. [Ls_DATe]>=(CASE (_day_of_week(current_date,1)) WHEN 1 THEN _add_days(current_date,1) WHEN 2 THEN _add_days(current_date,-2) WHEN 3 THEN _add_days(current_date,-3) WHEN 4 THEN _add_days(current_date,-4) WHEN 5 THEN _add_days(current_date,-5) WHEN 6 THEN...
  3. c83user

    display date for whole week on x-axis in chart

    I need to display summary of productlines for each product ,for the whole week.if today is thursday the xaxis should display count for producs(camping equipment,cookin gear)etc for mon ,tuesd and wednesday.if its start of the week .i need to display the product count for monday. How do i put in...
  4. c83user

    Union versus Aggregation

    I have table A and Table B which has a date field in common.A has some inventory 1 and B has inventory 2.I need to add these inventory values to show up in the crosstab with separate filters on inventory 1 and 2.What could be used instead of union.Join on date instead of union does not give...
  5. c83user

    Union versus Aggregation

    When I use union the report performance is very slow.What is the workaround ?Can I still get the data I need and not use a union.I have too many union queries.(I'm using Union in Report Studio)
See more

Part and Inventory Search

Back
Top