Recent content by TheShookster

LB - You are the man. Thank you!

Thank you for your response, I already had the formula before posting this thread. The problem is that the chart expert in CR 10 does not let us use formula fields in it. The Shookster

In the chart expert, you can either use field from a table, Total Running field or command. It does not let you edit or insert a formula. In that case, how can I edit your recommendation (below) to the chart? Count({ordtask.testcode},{ordtask.testcode})%{testcapacityplanner.capacity} Thank You...

I have implemented your suggestions but with no success. When I run the command on my database it is working just fine. However, when I am trying to insert the pc field (from command) to the Group Footer, Crystal is crashing. Is there any other way to insert a formula to a chart?

The chart has 2 columns: 1) Scheduled tests - which is the running total field #numOfTests - for that I had to use "Group By" testcode. 2) capacity - which has one value per testcode. As far as the rows: As written above, display the information per testcode.

Thank you for the quick response, the formula is the following: {#numOfTests}/{TESTCAPACITYPLANNER.CAPACITY}*100 #numOfTests - is actually a count on the testcode field and is a Running Total Field. The command I have tried is the following: select Count(ORDTASK.testcode)/max(capacity)*100...

Hello, I have a report than ot its x axis I hace certain tests, and on the y-axis I need to display the % (which is a formula field defined by me). The problem is the Chart Expert does not show formula fields, therefore you cannot implement it on the chart. I have tried to create seperate...

BecauseI am printing 2 labels in a row, so each row is counted as 2. But what if I would like to print odd number of labels. That was the reason why I used a counter that if it will exceed the noLabel passed, it will supress it.

synapsevampire thanks, I already created the table on the fly... and I used the method of counting rows... The report is working fine if I don't exceed one page. ex:If I were to choose 5 labels, it will print 5 labels just fine. But, if I were to print 21 labels and it exceed one page, it will...

synapsevampire thanks, From the application than I am running, the user is passing the number of labels he/she would like to print. In Crystal I get this parameter and convert it to a number. numberVar noL := ToNumber ({?noLabels}); At the beginning of the form, I declared a global counter...

I have a simple problem but it seems that it takes me forever to solve it. I created a report to print labels. I am passing an input from the user that says the number of labels he/she would like to print.I am using the 'Format with multipile columns' option to print 2 labels by detail. The...

Hi there, I am using Crystal 10. In the report I have trendline. I will use this reports in few variations. Is there any way to a pass a parameter with the type of trendline(linear, logarithmic etc.)? If no, is there anyway to do it in excel 2002? thanks theShookster

Solved, Thanx

Working! one last question: if I were to choose 20 labels to print, at the end of the page it cut the label in the middle. Is there any way to avoid uncomplete labels from appearing whenever it displays. Thanks, TheShookster

Thanks, I am looking into that right now. TheShookster