Search results for query: *

I have a sales report by salesman and customer. Sales Cost GP %of Total Joe Salesman 1. Customer 1 2.00 .50 1.50 33.3% 2. Customer 2 5.00 2.00 3.00 66.6% Totals for Joe 7.00 2.50 4.50 Sales and Cost are running...

I'm having the same issue. I'm using a subreport and shared variable, but only for background purposes, I don't need to show the subreport. But when I suppress it or put it in another section I loose the data and my totals are 0. Any way around this?

I made the less than or equal to changes on the parameter from the subreport link. It's working great. Thank you.

And the link from the parameter to the subreport field has to be an equal join, correct? There's no way to say less than or equal to?

I have a main report with three subreports. I would like to prompt for a date in the main report, then shared that to each of the subreports (and select on that date). But you can't use a shared variable in a selection formula. How can I apply using a parameter in the subreport that links to...

I'm running into another issue. When I run the report without suppresssing the subreport, my calculation in the main report (subreport1-subreport2) works fine. But when I suppress the section to hide the subreports my shared variables return only 0. Is this because my main report shared...

It's working perfectly!! Thank you for your help.

I'm new at shared variables and I think my issue is along the same lines as this. I have three subreports, and I want to total the three subreport values in the main report. It works fine until one of the values isnull (it just grabs the value from the previous record). I'm assuming null is...

the fix() function is working. Thank you very much!!!

I need to turn 1.25 hours into 1 hour and 15 minutes. I'm trying to use the Int() function to subtract the interger so I can calculate the remaining minutes. But the Int() is not working consistantly. I have two records that have 1 hour and the first record with the int function returns 1 and...

I'm attempting to create a crystal report using an excel spreadsheet. I highlight my area to use but when I click Create Crystal Report, I get 'server has not yet been opened'. The excel spreadsheet is originally from a crystal report exported into excel. We would like to freeze the...

oh, I figured it out!!! I made a formula to set any qty that fit the suppress criteria to 0, else give the qty. The I used the "running total using a formula" on that new formula. Even though it was incorporating the suppressed records, they were all set to 0, and I was able to get...

What does your formula say? I've added a company total but my running formula total is still incorporating suppress data.

Is there a way to use a running total using a formula WITHOUT have a grouping? When I place the reset in the report header it incorporates the records I am suppressing. Is there a way around that?

Crystal Version 8.5 and Centura SQLBase db. I can pull all the minimum shipdates on the order but I need to view all the records in the db to determine the min. Using a parameter is what is tripping me up. Is there a way to just "show" records within a date range rather than...

Is there a way to evaluate records that do not fit in a parameter? I have several shipments for one order. I only want to show the very first shipment for each order. Say the first shipment goes out 12/12 and the second goes out 12/13. If I run my report(by using a parameter by shipdate) for...

Thank you. That worked perfectly!

I have a report that I want to run for a salesman. I want to total/group all sales dollars by customer, but sort the customers by sales amount, the greatest being first. How do I still group and total my dollars by customer and have my sales amount sort? If I add a sales amount group above...

I decided to go a different way. I put the fields in the header of the group and used a running total to get my totals based on the change of order number. Thank you for all your help!

I went to selection expert, button-holed "Group Selection", then put in the formula as Mininum(feild,group) and got the message "Result of selection formula must be a boolean". Where am I going wrong?