Search results for query: *

I am using the Crystal SQL Desinger, My Table Name is REJECT and Field names within REJECT include: TIMESTAMP, SHIFT, PARTNUM, LINEID, RETURNPART. The Field RETURNPART contains either a 0 or -1. I would like to create two expressions from this field. I would like to count all the records that...

I am unfamilure with the synax of the Crystal SQL designer. Can anyone give me a good source, or example of how to use an expression in the SQL Designer? I have a table called "REJECT" which contains a field "RETURN". The field RETURN contains a 0 or -1 as type number...

ramc2000, If you want to make a graph on a while printing record formula i can send you a sample report that will show you how you can do this. It is somewhat complex, and it takes a little while to set up. Email me to request this copy at jdecker@gentex.com DecHer

right click on the chart and select "format chart", general. Click on the Numbers tab and choose the catagory, in your case general. This works for CR 8.5 DecHer

ok thanks Ken

Ken Can you provide an example? When I tried that It only displayed the last value that formula calculated in the subreport graph. I need the graph to display the each value(yield) for each group(date). K I am trying to make a line graph, when I did this i got each element on its own line...

I am trying to create a graph on whileprinting records formula. I have a string called DayYieldStrngVal which puts a shared whileprintingrecord calculation into a string and the string looks like: ^.89^.90^.83^.92^ I am trying to use a split statement to seperated this string in a sub report...

I am trying to create a line graph of values calculated by a formula in the group footer #1. This formula uses shared variables which I have been told can’t be graphed in a main report and must be graphed in a subreport. When I tried graphing the shared formula it only displayed the last value...

I have the fomulas that each on looks like... Shared Numbervar Array myarray[1]; next formula Shared Numberar Array myarray[2]; I place all of them into the show values of advanced chart and each formula displays on a separated line(on a line graph) for every Change of Date. How can I get the...

the array will hold 12 numbers, can you explain how to put my array into formulas(plural), i put my array into one formula but am having trouble stepping through the array in the chart. I can only get one number of the array to display in the chart at one time. Thanks.

I have a shared numbervar array in the main report that i am trying to graph in a subreport. I can get the array to display in the detail section but only the first record is showing up in the chart, which leads me to believe that it is not steping through the array properly. I have tried to...

I have a report that contains two sub reports. The main report and subreport1 each have one shared numbervar. Subreport 2 uses those two variables and multiplies them with the results of a run total formula. Everything works great within Crystal reports, however if i export this to a word...

Hello, I have a small number of reports(3-7) on a network that 27 people need to be able to view, change parameters, and print. I am looking for recommendations for a viewer, what has worked, what to avoid, etc. Thanks in advance for any advise. DecHer

ok I will start over and try the wizard, thanks

My Form is not bound to the table. I need to keep the text box that the user enters RejectID unbound so that they type the number in compared to selecting it from a list, otherwise that list would be 2000 itmes long. Let me know what you think.

Hello, I am trying to update a table based on an ID the user enters into the form. I have a table called tblReject which contains a RejectID, Date, and a boolean field called Rework. I want to have the user enter in the RejectID into the form and change either the Date or the boolean value or...

Hello, I have one boolean column in a table. I want to run a query that displays in one column the count of true values as well as another column that displays the count of false values. How would I go about doing this with either the access qurey builder or sql syntax? Thanks, Jason

I Have a "sub yield" field that is a formula, it is made up of "Amount Passed"/"Amount Attempted". So for each "area" (which is one of my groups) it is calculating a new "sub yield". I need to multiply all of these "sub yields&quot...

I am making a yield report that calculates the yield for an area of our line. My report has a sub yield field that i need to calculate on or summerize for a total yield. The problem is that summary field options are addition, standard dev. and others but not simple multiplication. I need to...