Search results for query: *

hello, I am writing a report using CR8.5 dev and GMCE 6.7 /SQL 2000 SP4 backend. I am writing a report that looks at closed sales and open sales. Both of these values are stored in different database tables, cal & conthist. these values need to be displayed on the same line. I have tried to...

you are too cool! thanks a bunch!

hello, I am writing a report in CR8.5 dev and i have a bunch of subreports in the group footer. These reports display sums of row counts based on the creation date I would like to be able to suppress the months (subreports) that have not occurred yet. so for my September07 subreport, my...

Hello, I have written a report in Crystal 8.5 dev and made a distribution kit. That kit was installed on our citrix box and we gave full control to all of the files for the users. The reports run just fine however we have run into a problem with printing. if you push the quick print button, it...

Hello, I have written a report in Crystal 8.5 dev and made a distribution kit. That kit was installed on our citrix box and we gave full control to all of the files for the users. The reports run just fine however we have run into a problem with printing. if you push the quick print button, it...

okay they did maintenance on the server and magically everything is working. but they did ask for something else. I *think* it can be done. The category group - @groupie; if {conthist.ref} startswith "BUT" then totext ("Fabric - Misc") else if {conthist.ref} startswith "ZIP then totext...

by the way - thanks a whole bunch for your help

this is what @prods is: if {conthist.ref} starts with "BUT" then totext ("Buttons") else - and so on. (sum({@BARNEYWON}, {@prods}) - (sum({@BARNEYLOS}, (@prods}) I placed the @BARNEYWON/@BARNEYLOS in details and suprssed it and I placed the TL formula in the group header for the second...

groups are in the right places. The {@BarneyWon},{@BarneyLos},{@prods},{@groupie}, {@BarneyTL} all work correctly. honest I swear on a pile of good chocolate - I have written everything that those formulas consist of. wait! I see something but it isn't going to count much; if...

the name of the formula is {@groupie} (sorry, misunderstood you) So I replaced my the formula on the group 2 sums with the groupie formula (sum({@BARNEYWON}, {@prods}}) - (sum({@BARNEYLOS}, (@prods}) changed to (sum({@BARNEYWON}, {@groupie}}) - (sum({@BARNEYLOS}, (@groupie}) you'd think...

it is exactly as I put it; if {conthist.ref} startswith "BUT" then totext ("Fabric - Misc") else if {conthist.ref} startswith "ZIP then totext ("Fabric - Misc") else if {conthist.ref} startswith "CBL" then totext ("Fabric") else unknown

thanks for the tip. I only dd it when it told me that the category summary wasn't going to work. I wonder if I need to add another formula for the group? if group1 = "Fabric" then "fabric" and so on. I wonder if the classifications that I am doing in group1 is too much to process at the time...

I get a message when I tried that. can do summary on this formula (or was it function) I think I even added at the top whileprintingrecords; thinking it was when the formula was being evaluated.

environment - GoldMine 6.7 GMCE - SQL 2000, Crystal Reports 9 pro. I am writing a report that at first I thought I could do as a cross tab but none of the formulas would work so I ended up taking another approach. below is what the end result is suppose to be; product: total fred barney...

Crystal 8.5 with distribution kit installed. Win 2003 standard server, SQL 2000 SP4, McAfee Enterprise Hello, I have written a report on my XP pro wrkstn using Crystal 8.5 developer that is a graph report. The report runs great in the RDC. When compiled and installed on the server, the report...

Hopefully I can explain this properly. I am a MSSQL/Goldmine admin and on my production box I am running SQL 2000 SP4/GoldMine 6.7. Legato Networker client is installed on this server. I know that Legato is not the latest version but the version under it. (sorry I am not the network admin so...

OMG! nevermind me - it was a date time vs just date thing thanks

thanks for the speedy reply! I have my parameter and when I select it, there is nothing to link to whereas if I use a database field I can link easily. I also tried linking a date field from the table that the parameter is on from the main form to the date field I want in the subreport and...

Hello, I am using CR 8.5 developer and I am writing a report that displays some formula from a subreport. I have on the main form 2 parameters (From_Date, End_Date) and I have a formula in thre select expert that works wonderfully. {CONTHIST.ONDATE} >= {?From_Date} and {CONTHIST.ONDATE} <=...

the main report has 2 groups, one for the userid and then the next one is the date. The subreports are linked by userid. The subreports are hardcoded for dates in the select menu. I have the sales count and shared numbervar formula on the cal subreport. the main page of the report in in the...