Search results for query: *

I have a list of 1,174 part numbers in an Access table. I need to convert the column of numbers to a row and format them to be used as a filter in Crystal Reports 2008. From: 123 456 789 To: "123", "456", "789" I understand that Crystal has a limit of 1000 items and I have 1,174. I don't...

Charliy. Thank you! so much for replying, I didn't know I could add an Excel file as a table in Crystal Reports. That was very helpful!! I tried your first suggestion adding the report as a table, it displayed the data but report didn't run correctly, it ran for several hours reading several...

I am using Crystal Reports 2008. I have been asked to create a report listing part numbers related to a specific project. I have been given a spreadsheet with a list of those part numbers 3,513 part numbers to be exact. I only want the report to display information related to those 3,513 part...

It looks like it screwed up my table formatting. Sorry. That makes it a lot harder to read. I'm not sure how to go back in and edit it.

Hopefully I can explain this clearly. I have been struggling with this for three days. I have a report I'm trying to create which is usually run monthly, which is no problem to create. My problem is that I have been requested to run this monthly report by week for a time frame of three...

Thanks much, you really know your stuff. :-D

Your recomendation was: {table.date} = NthLargest(5,{table.date},{table.group#2}) I origionally entered: NthLargest (5,{IH_INSPECTION.IH_DATE_INSPECTED} ,GroupName ({IH_INSPECTION.IH_LOT_NUMBER}) ) I made the correction of removing the groupname. This is what I am using...

I put the formula in GF1 the result I get is "TRUE" instead of the date on line 5.

Thanks guys for the help. Maybe I'm not doing something correctly? IanWaterman, I tried your suggestion I put the formula in GH2 and the other in GF1. I get the error "This Field Cannot Be Summarized". Crystal doesn't seem to want to summarize running totals. lbass, I tried your first...

I am trying to get my report to print an inspection date in the Group Footer 1 row. My problem is I need a date from a specific row number within a grouping. The below example is a piece of my report. I created a formula in the section expert for GH2 to suppress RunningTotal greater than 5...