Search results for query: *

Sounds easy enough but I failed to mention that my details are in another subreport. Is there a way that I can create these formulas below in the subreport with details, \\FINAL SALE if ORDDET_STR = 'FINAL SALE' then '1' else '0' \\COUNT FINAL SALE count({@FINAL SALE}) \\COUNT LINE ID...

Hello, I am using CR 8.5 with a SQL DB. I am printing invoices with a subreport for returning product. I want to supress the subreport if all line items are FINAL SALE and print the subreport if not all items are FINAL SALE. The datatable that returns as FINAL SALE or blank is ORDDET_STR The...

I am using CR 8.5 with an ODBC SQL datasource. I have two identical subreports in the Details section of my report that when run separately display all details/line items. When viewing the preview and when printing not all of the details/line items show up. I have each subreport formulated to...

Hi Ian, I was able to successfully create all three new formulas (Init, Eval, Display) After testing it against my data it appears that the result is less than it should be. I've attached an example image of the report where blank spaces are suppressed data. Could the suppressed data be...

Ian, When attempting to create the first new formula 'Init' I receive an error message stating, 'A variable name is expected here' and the cursor falls in front of the word datediff. Thoughts? Thanks

Crystal 8.5 I need to calculate the average of a datediff and am not finding any previous posts with formulas that work with my report. I currently have three formulas to achieve my datetime and one datediff formula converted to seconds. The datediff is calculating the seconds between two...

Is it possible to run the .exe version of my report and prompt for a change to the 'startswith' selection formula upon printing? Currently the report runs as if the 'startswith' formula is saved data. Modify Selection Formula is selected. Save Data With Report is unselected. Crystal 8.5...

Looks like I got it to work. I entered a Nth Smallest summary into the Group Footer and then used the TopN/Sort Group Expert. Thanks!

Is it possible to sort data by it's font color in Crystal Reports 8.5? For example, if group header font color is red then bring to top. Thanks

And I'm back. The report breaks in two different ways depending on the value of 'SharedNumber Var AutoBatchTotal' and the formula for @OpenPicks. //PF @MyTotal and @OpenPicks //@MyTotal WhilePrintingRecords; Shared NumberVar AutoBatchTotal; if isnull(sum({Ordzones.ORDZONES_TOT_LINES})) then...

Thanks Ian! I have yet to see the values drop to 0 since I made the changes. Hopefully this evening I'll know whether or not I formulated correctly.

Crystal 8.5 MainReport RH = Cross-Tab PHa = Cross-Tab Subreport 1 PHb = Subreport 2 D = Suppressed RF = Suppressed PF = RH Cross-Tab SharedVar formula AND Sum of All SharedVar I have a sum of three sharedvar in the page footer of my main report that was working as expected until one of the...

lbass, you've done it again! Thank you so much for your help as always. Now to teach myself how and why that formula works so I can use it in the future.

Okay, I got the SQL Expression to take. ( SELECT min(A."ORDZONES_ZONE") FROM Ordzones A, Ordhead B WHERE A."ORDZONES_ORDNO" = B."ORDHEAD_ORDNO" AND B."ORDHEAD_STATUS" = Ordhead."ORDHEAD_STATUS" and A."ORDZONES_RCON_TYPE" = Ordzones."ORDZONES_RCON_TYPE" ) I then put it into my Select Expert...

I've hit a road bump. After entering, SELECT min(Ordzones."ORDZONES_ZONE") FROM Ordzones."ORDZONES_ZONE" WHERE Ordhead."ORDHEAD_STATUS" = Ordhead."ORDHEAD_STATUS" and Ordzones."ORDZONES_RCON_TYPE" = Ordzones."ORDZONES_RCON_TYPE" For my SQL Expression, I receive "ODBC Incorrect syntax near the...

This is how I have my report grouped/sorted, Group 1 = {ORDER STATUS} = 301 (suppressed) Group 2 = {ORDER TYPE} (There are 8 order types) Group 3 = {ORDER ZONE} = AA, BB, CC Ultimately, I want a sum of the {TOTAL LINES} of the first {ZONE} that an order exists in (Group 3). And, a sum of the...

Searched for a previous thread but could not find one/deciper formulas. I'm using Crystal Reports 8.5 I have three groups. The only details are in group #3. Group #3 = AA, BB, CC How do I suppress duplicates in the proceeding GroupH 3 details? GroupH 1 - 100 GroupH 2 - Red GroupH 3 - AA 1 2...

Thank you so much lbass! All three formulas worked. You've made me a hero at work!

REL DATE & REL TIME = CST BM DATE & BM TIME = EST I am trying to adjust BM TIME aka {ORD_TIME} The corresponding date field is BM DATE aka {ORD_DATE} The only instance in which the time adjustment to {ORD_TIME} would affect {ORD_DATE} would be between 000000 - 010000

I tried the dateadd function and it tells me that a date is required where I have {Ordhead.ORDHEAD_ORD_TIME}. I typed 'date' in front of the Ordhead field and it then wanted me to close the parenthetic after the word 'date' stating that the remaining text did not appear to be part of the...