I have created a Crystal report for Peachtree that tracks serial numbers as items are purchased and then sold. My client wants to be able to filter the report by the status of the item. This is complicated because a separate transaction is created in the JrnlSNum table each time the status...
I have a formula in the detail section of my report that references the sum of another field. I need to get a sum of this formula field but Crystal tells me I can't do that. Is there any way to achieve this? It's Crystal 9 pulling data from Timeslips.
One of my Peachtree customers needs to export check data to an ASCII file so that they can upload it to their bank. I figured I could create this in Crystal. Each field needs to be a specific number of characters and some need to have leading zeroes to fill up the space. I figured out how to...
I created a billing worksheet using data from Timeslips. It's a pretty complicated report and has two sub-reports. The first time it runs the data in the first subreport is inaccurate. It appears that some of the data is duplicated. If I do a refresh and run the report again without changing...
I created a report that groups employee hours by week. I want a column that says "Week of" and shows the date of the first day of the week (which would always be Sunday). There is not always an entry for Sunday so I can't necessarily pull it from the data source. Is there a formula that can...
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.