Search results for query: *

I created a report that accurately displays all then desired info for my mailing labels. However, the size of the mailing labels is off. I need to select Aver 5160, it is currently using a different template. Does anyone know how to change this setting or is it only possible in the mailing...

thanks. It was easier than I thought. I just selected all the running totals and put the formula in for all at one time. Crystal Reports XI, MSSQL 2000, ODBC

Thank you so much that worked! I know mind copying and pasting into each format field. What exactly does the 0 and the "" stand for? just curious. Crystal Reports XI, MSSQL 2000, ODBC

Yeah that seemed like the obvious choice, only thing is I have about 7 separate running totals for all 12 months I was trying to avoid all that extra work of creating individual formulas for each running total. I think I will try to redo the entire report with grouping options Thanks anyways...

So I searched through past threads and didn't find an answer to this question. I have several Running Totals which calculate the declared value of work to be performed for building permits, sorted by month. Running Total Name: JulyRes [July Residential] Field to Summarize: {APBLDG.DECLVLTN}...

I have several values (numeric) in the millions, that I rounded to the millions. However I want to display only $20 for $20,000,000 $14 for $14,000,000 etc. It's probably an easy solution, but I need it quick. Crystal Reports XI, MSSQL 2000, ODBC

Just got CRXI last week, and I am having problems suppressing summaries when result = 0 I have tried making formulas in Format Editor. Is there something new with CRXI that prohibits this? Format Editor, Suppress Formula: when . . . Sum ({@JulyRplan_disp}) = 0 No Errors, but does not...

glthornton, I had the same problem a month ago, and finally the solution is exactly what LBass has stated. you must first pull in all patients, with all admission dates, then filter to dipslay only the first admission date (using minimum function in Group Selection), then filter to display...

Thanks for the help. The data is now showing the minimum date reviewed. Crystal Reports X, SQL Server, ODBC

Ok, here it goes . . . {@Plan#} = If IsNull({VBRBLDG.PLANNO}) or length(trim({VBRBLDG.PLANNO})) = 0 then {VBCBLDG.PLANNO} Else {VBRBLDG.PLANNO} VBRLDG is table tracking Residential Building Permits. VBCBLDG is table tracing Commercial Buildling Permits. PLANNO is building plan number...

Lbass, What do you mean "from 'table'.'table' I am not that familiar with SQL commands; do I need 2 tables there? Also where you have 'cust_ID' I would have {@Plan#} = If IsNull({VBRBLDG.PLANNO}) or length(trim({VBRBLDG.PLANNO})) = 0 then {VBCBLDG.PLANNO} Else {VBRBLDG.PLANNO} Can...

when I added the alias table APACT_1 the dates came in just the same as the original table. You mentioned "link where they are different." I linked from the Date/time field in the original to the Date/time field in the alias table. Is that correct? Crystal Reports X, SQL Server, ODBC

Attempting to use formula: {@Initial v Revisions} if {@Plan #} = previous({@Plan #}) then "Revision" else "Initial" However, it does not allow grouping on this formula. Under the Crystal Reports X Help index it states: "Note: Using this function in a formula forces the formula to be...

you just select File>Export>select PDF file from drop down menu then you choose your desired save location and file name

Ok, this might be easier to solve . . . Formula: {@CompDttm} = If {apact.compdttm}=previous(apact.compdttm) then "1" else "0" I made this formula and then tried to do a Select Expert setting the value equal to "1", but the formula is not available in the choose field box (in Select Expert)...

using Crystal Reportx XI, SQL Server 2000, with ODBC When I tried your suggestion as a formula it states: "that must be evaluated at a later time." (referencing the {APACT.COMPDTTM} Formula: [/b]{@Plan} = If IsNull({VBRBLDG.PLANNO}) or length(trim({VBRBLDG.PLANNO})) = 0 then...

I have to sort sets of plans reviewed and I need only the date of the first completed review. I tried: Minimum({APACT.COMPDTTM}) but some of the reviews are completed simultaneously, but I still only need the first to display. I incorporated a Group Sort Exports to suppress when: {@Plan...