Search results for query: *

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...

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 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

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 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...