Search results for query: *

I have a report that contains one sub-report. Both the main report and sub-report are using SQL commands. The two reports use the same query in their respective commands. The main report points to a production server and database and the sub-report points to a test server and database. I do this...

I had a few reports created that had linked tables using some user defined fields. For some reason, when I ran the reports today I had lost the linking between tables. Whn I tried to relink the talbes the user defined fields I had used where not availalbe in the database expert. I could see...

I'm trying to create a sum of all the values returned in a column, i.e. I want to add up all the values of the column quantity. For some, no pun intended, reason this is driving me to fits. This is my select statement: select E.ItemCode, E.Dscription, E.Price, A.U_CardCode, A.U_DocNum...

I have two tables. One contains zip codes, county names, and salesTaxCode. The second table contains a County,State field, a sales tax percent field, and a salesTaxCode field. I want to strip out the county name from the County,State field. There is a comma seperating the County and State...

I'm working on a stored procedure that will increment a sored value by 1 when ever a new customer or vendor is created. My customer and vendor numbers are of the format C001234 and V001234 respectively. I want to increment the stored value after a new customer or vendor is created. In other...

I'm working on a cross tab report that shows the average number of members for a union on a monthly basis. Some groups of the union are only counted quarterly and for the months where they are not counted my report shows 0. I would like to display the value from the months where there is a...

Howdy: I'm working on a report that will display the deferred revenue across many months, usually 1 to 2 years. Each month a small portion of deferred revenue is recognized and subtracted from the total deferred revenue. Example: The original sales transaction is for $12,000. Each month...

I'm trying to creat an aging report based on the due date of the invoice. I would like to use a cross tab report and the aging functions of Crystal. I have formuals created (Example: DueDate in Aged0to30Days)for each of the aging periods I want, and have placed them in the columns and have...

Does any one know of any issues with running Crystal XI on a Windows 2003 Small Business Server? I installed the software, which went fine, but when I try to start the program it does nothing. The event viewer shows a fault by crw32.exe. Any ideas would be great. Ralph

I am working on a commission report where the commission paid is based on the profit margin of the product sold and the products the salesmen sells. The higher the margin the higher the commission and if the salesperson is responsible for product line 1 his commission levels are X if a...

I am running reports using CRS XI and have run into a situation where fields that look fine in the report designer are printing longer than the length on the report. In other words, a field is truncating when printing or viewing in CR XI when I view or print the report using Info View the field...

I'm working on a report that returns sales information grouped by item. The detail information contains quantities, selling price, extended price, etc. I have a subreport in the group footer that looks for a certain discount level for the item. I want to return this cost back to the main...

I have created a report in verson 8.5 based on a Crystal Query. I now want to base the report on a stored procedure in SQL Server so that the users do not have run the query before running the report. The stored procedure is written, but I do not know how to change the report to look at the...

Howdy: I'm working on a report that in essense count the number of Purchase Orders created by each department in a company. I need to calculate the department's percentage of purchase orders compared to the total aomunt of purchse orders. I can count the number of PO's for each department...

I am writting a purchase order status report, by department, based on a Crystal Query. One of the specs calls for a summary page at the end of the report that will list the totals for each department. I am currently goruping by department and can calclulate the total for each group but do not...

I wrote a report based on Crystal Query. There is one integer field in the query that should return values of either 1,2,3,4,5, or 6. When I view the query results the vlaues returned look fine. However when I place this field in the report I'm writing the values being returned are not...