Recent content by infotech2

Are there any chart packages out there that allow you to upgrade or change the default chart images with something a bit cleaner looking?

VesselName SRID Service Total Manf. Equip. Vessel - Group 1 Furuno - Group 2 (manf) $6,317.60 VDR - Group3 $6,317.60 Vessel 5862 $2105.86 Furuno VDR Vessel 5862 $2105.86 Furuno VDR Vessel 6051 $2105.86 Furuno VDR The above example shoudl...

Thanks for the suggestion LBass. I tried that, but the same thing happens when I do a distinct count. In my pie chart setup I add SRIDManf (the concatenated fields) to the "On Change Of" and to the Show Values. I set the summary options for a distinct count and it show 1 for item. If I do a...

I have a report that shows the cost of service manufacturers used, equipment type serviced, and the service request id. I would like to get a count of manufacturers in the report. The ServiceTable is joined to the ServiceCostTable and they are setup by a one to many relationship therefore there...

lbass - Thanks for the suggestion. I also wanted a way to show the numbers without the zeros so they are more readable.

Holy crap I'm a moron. Ian - That worked great. I just need another cup of coffee.

Thank you both for the quick response. Brian - I tried yours and it removed the decimal completely. Ian - I get "The remaining text does not appear to be part of the formula" for Replace to the last ). Thanks Again!

I have a database that stores some order numbers like this: 2301.000, 2301.001, 2301.002, etc. The .001 means the original service needed follow up. The only way I can find to display this number in Crystal is by formatting the number in this format: 0000.0000 so it shows up like this...

I did run into that problem with trying to use NULL as a filter. That's what led me to adding criteria to the FROM clause. Thanks for the replies. "Command" looks like a great feature I haven't even begun to explore. Much appreciated!

Ian, Thank you for the prompt response! I'll try the isnull filter. Along with the date parameters it might work. I am reporting off of my view, but eventually I want to hand this off to users and allow them to enter the dates they want. What is a command? I see it under the connections...

I have a SQL view that I created to return a list of services performed on contract vessels for a specific time frame. I wanted to return all contract vessels even if no services were performed and have a zero for those results. In order to do this I had to set the "where" conditions at the...

I found the correct tables and am going to list them here just in case anyone ever needs this type of report. GL_SourceJournalHistory GL_DetailPosting GL_Account

See the table and links below. Color coded for your viewing pleasure ;) AR_InvoiceHistoryHeader InvoiceNo HeaderSeqNo CustomerNo AR_InvoiceHistoryHeader InvoiceNo HeaderSeqNo SalesAcctKey AR_Customer CustomerNo GL_Account SalesAcctKey

I'm building custom revenue reports based on the Accounts Receivable module using Crystal Reports. Unfortunately, when an accountant does a Journal Entry, it throws my numbers off. I need a way to get those Journal Entries linked to an accountkey. I haven't been able to find anything in the...

The error was popping because quotes are needed around each number. Thanks for the solution, it works great!