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 Mike Lewis 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. c123456rystal

    two years

    I have a report reflecting two years. 2005 and 2009 sales by customers Customers are the rows Months are the columns. as of now i have the report grouped by year, but i need to see each customer 2005 and below 2009
  2. c123456rystal

    COUNT FORMULA

    if {CustomerProgramHistorySummary.Year} = 2005 and <> 0 then {CustomerProgramHistorySummary.NetSales01} Above formula does not work.
  3. c123456rystal

    &gt; zero

    Below is my formula I need to show only sales greater then zero
  4. c123456rystal

    new report

    I have a data base with columns as follows: Name year program jan feb march etc. the year is from 2004 and to date months are jan. to dec. various programs as in program 1, 2, 3 i need to create a report sumarized by type of program with year 2005 and 2009 across and customer showing once...
  5. c123456rystal

    COUNT

    can I create a count as a runing total and count records each time a group changes?
  6. c123456rystal

    combine reports

    I created two reports reflecting summary by customer / by quarter by year (2008 and 2009 qrt 1, 2 etc) I did that since I was not able to have cross tab report reflecting 2008 1st qrt, 2008 2nd qrt to 2009 3rd qrt Can I combine the two reports such I see one big report from Jan. 1st 2008 to...
  7. c123456rystal

    customer showing multiple times

    I am having trouble reflecting on a report two years and the customer only once, Customer shows for both years: Report should be like this: should be like this: Customer 1 year 2008 year 2009 it shows twice for each year
  8. c123456rystal

    single line

    I am not able to group the customer to show on one line I am comparing two years and customers shows twice for each year
  9. c123456rystal

    new page

    I have a report that I would like to print a new page if the group changes
  10. c123456rystal

    single line

    customer name showing multiple times I have a report that I see customers showing multiple times All I need is a total by customer
  11. c123456rystal

    how to count rows in a report greater then zero

    Now, I think I need to insert a parameter asking what area?
  12. c123456rystal

    how to count rows in a report greater then zero

    My report is not pretty at all. Can I apply some gridlines or a template?
  13. c123456rystal

    how to count rows in a report greater then zero

    Thanks again. It worked. How do I go about to keep the Months Jan/Feb/ etc. to repeat on each page and the Report header? Thanks
  14. c123456rystal

    how to count rows in a report greater then zero

    Thank you so much. It worked. Now if the total sales is a zero, and total count of rows was zero, when I crate the average I get an error as a division by zer. How can I go around that? Again, thank you so much.
  15. c123456rystal

    how to count rows in a report greater then zero

    I should and I am sorry I did not I have a report reflecting sales by month in columns. Rows represent name of customers. I grouped the report by area. From above, I inserted a runing total counting the rows. (representing how many customers had sales) Now, I have to insert a formula were I...
  16. c123456rystal

    how to count rows in a report greater then zero

    Thank you so much. It did work. Now I have to use an average. Each column has a total (sales) and need to devide the nr. of rows to the total sales. Many thanks
  17. c123456rystal

    how to count rows in a report greater then zero

    I have a report and need to count nr. of rows with value greater then zero
  18. c123456rystal

    compare two years

    Hi, I have a data base and would like to compare data based on customer. Say customer 1 sales for year 2005, 2006, 2007 Then next customer say same

Part and Inventory Search

Back
Top