Search results for query: *

Hey everyone.. I'm in the process of creating a report that shows a year to date spend total for all of our suppliers where the minority is set to Y. The issue is, when I add the running total in, it generates some ungodly numbers there are no where near that suppliers year to date spend...

Hey thank you for your reponse. After I posted...I started browsing other threads and I learned a little about cross-tabs. Thats exactely what I needed! :] Thanks again!

Hello, I am creating a report that shows all items ordered by job #. At the end of each job number I was to included a subtotal that shows the qty ordered for each item id. Does anyone know what I would need to do in order to create these totals? If I do a a summary, it gives me all of the...

Hello I'm trying to make a report that matches up with our database. The database can print reports with a date as of. I cant find anything regarding this type of selection formula in Crystal. Basically I have a report that I want to see data for as of lets say 5/31/2007. Anyone know how...

i got it! I just did if {inv type}="dm" then {inv amt}*-1 else {inv amt} Thanks for the help though!

Hello, I am trying to create a report that shows the totals of all checks sent to a supplier. Some of the checks have credits which show up as negative. But, the running total adds these amounts instead of subtracting. How do you get the running total to subtract the credit amount instead of...

nevermind!!!! I got it. THANK YOU SO MUCH LBASS!!!!!!!!!!

How do I insert the maximum?

Hey Everyone, lbass that didnt seem to help my problem. I made some print screens to better help you all underdstand. <img src="http://i66.photobucket.com/albums/h242/snakedog12/exp1.jpg"/> Here is all our data. What we want to do is add another field in called SEQ 19. Since we dont have...

Rosemary, multiple records are showing up when I insert the formula into the field. There are a total of 19 sequences within a job but we only want sequence 19 to show up. we have tons of jobs and we want all of the open ones to show and if it has a sequence 19, we want it to show but if it...

Its Crystal V. 11 And the formula is if {job.sequence}=19 then {job.free.fields} else "" and its doing it correctly except it will return: Job# Sequence19(formula) job 601254 job 601257 1-005-005 job 601257 job 602548 I Don't want it to duplicate as its doing...

Hey everyone, I'm trying to create a formula for a report at work and its not turning out right. What I want it to do is if jobsequence=19 then show data, if not then leave it blank. But, everytime I do it, it will show the jobs with sequence 19 but it will also duplicate it and leave the...