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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.