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 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: *

  1. locheve

    Excluding saturday and sunday from date calculations

    Hello, I have created a report that requires me to subtract one date from another; Example the difference between 20th March 2013 and 25th March 2013 is 5 days. However i want the answer to be 3 days. I want to exclude saturdays and sundays from the formula. Does anyone know teh formula to...
  2. locheve

    Crystal Cross tab; How to label rows of data

    Hi, Thank you for replying. I had tries this but it doesn't do what i'd expect. when i click 'show summerized field labels' an extra column is added to table. inserted in all the data fields is a formula used in the table. so not having any luck with that. i have attached a screen shot. I...
  3. locheve

    Crystal - Cross tab - formula

    Hello, I have created a cross tab report showing promised dispatch dates of all our part numbers. The sales orders go out months but i have limited this report to 4 weeks. In the cross tab i have also added columns to show current stock available. I want to create a formula that subtracts...
  4. locheve

    Crystal Cross tab; How to label rows of data

    Hello, How can i label the rows of data with a heading? I have created a cross tab showing in the row the follwoing data; part number, description, stock on hand and work in progress stock. In the column are the shuipping dates. The row data do not have headings. How can i add headings to...
  5. locheve

    line spacings in a report

    ok thanks, this will work for one report that is sent out as a PDF. however i have a similar report that is sent to excel, so that people can then use to add comments to, when i export doing what you suggested would the report export in a user friendly way?
  6. locheve

    line spacings in a report

    Hi, I have created a simple report listing all open sales orders. The sales order is the unique piece of data. A sales order could have an unlimited number of lines on it. i want to alter the report to easily distinguish between order numbers. i could put an extra line spacing in between...
  7. locheve

    formula for select expert record

    thanks, will that formula include all dates that are older than todays date?
  8. locheve

    formula for select expert record

    Hi, I want to automate a sales order report i have created, based on the dispatch dates. I want it to show all orders that are overdue and due up 14 days from today. In the select expert record option i choose the relevant date field. In the 'in the period' option there is no suitable option...
  9. locheve

    Crystal Reports - Can you create a drill down in a cross tab

    Hi, when creating a cross tab it is possible to create a drill down? so, if you were to click on a piece of data in the cross tab it would display the chosen data related to it.
  10. locheve

    Crystal Reports - Adding a new column with additional data to a cross tab

    Hi, I have created a cross to display open sales orders with products listed and by dates. the sales order qty is in the cross tab. however i want to add an additional column, as the first column, that displays the stock of that product on hand. so this piece of data is not already in the...

Part and Inventory Search

Back
Top