Search results for query: *

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

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

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

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

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?

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

thanks this worked.

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

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

Thanks for the comment, that last one worked.

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.

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