Search results for query: *

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!

lbass, Thanks for the reply. For some reason when I check the code, I get an error stating "A string is required here" and the account codes get highlighted. Our account codes are in number format like this: 1111-01 or 1111-02. Any ideas? Madawc, That is definatlly less code but I like the...

Sorry for being unclear. I really didn't mean to have the subject Q, but I couldn't modify it after I hit submit. We have sales account codes that invoices get coded to so that our finances can be tracked by those codes. For instance, code 1 would be for the sales of airtime hardware. Code 2...

I have a cross-tab query that contains the Fiscal Quarters (1, 2, 3, 4) and the total sales for that quarter based on sales account code. I need a row with codes combined with the name "Sales" and a total for each quarter. Some codes are in order (1,2,3,4) others are not (6,9,10, 15). How can I...

I have a database for entering service orders. I need to make sure that a Service Company isn’t assigned the same "Place" more than once. Places can have the same name as long as they are in different countries, or are assigned to different companies but a service company should never have a...

Thank you for the sift response. Your suggestion worked like a champ.