Search results for query: *

Thanks for your response but that still doesn't quite get me to where I need to be. To answer your question, if they choose Adjusted, they would only want to see transactions where the most recent status is adjusted. Putting the fields in the footer works to only display the most recent status...

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

You have to install an add-on for Timeslips that creates a datasource specifically for Timeslips. Once you install that add-on for Timeslips you will see a datasource called Timeslips. I think you may have had to pay for the code to install that add-on for Timeslips 10.5. I have Crystal...

Valerie, Crystal 11 is not compatible with any versions of Timeslips. I don't know the exact reason but I know that it doesn't work. You can use any version of Crystal up to 10 with Timeslips. Peachtree, which is owned by the same company as Timeslips, always includes a copy of Crystal and...

Thanks lbass that works beautifully for sums. Is there a way to use that functionality to get the average of a field instead of a sum?

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'm using Crystal 9 with Timeslips 2007. The main report contains the detail of current billing entries. The first subreport contains billing history but also has a field that shows the total of the current billing. This number should match the number at the bottom of the main report but...

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