Search results for query: *

I have a Job in Process scheduler, which contains four app.engine programs. How can I stop the Job at the second process if the first process do not create any transactions. Here is an example. GLPPPOST, ADB_POST and ADB-CALCX in the job. If GLPPPOST do not post any Journals I want to stop the...

I established new ODBC connection to connect to SQL Server 2000. However I can't see the stored procedures. I checked the Stored procedures in the Options. If I click on + sign to expand tables, views and store proc's Crystal reports crashed. If I uncheck the stored procedures in options then I...

This is what I did finally and it worked out for me. I changed the formula like this. if {?@parameter} <> " " then formula = false else formula = true end if Thank you all for your great help in this. -MP

Playing around with this Issue. I was not too sure, but I guess there should be something wrong with the formula. Because when I check "Suppress(No Drill Down)" button I did't see any blank pages. When I enter the formula using the parameter field then the blank pages appear again.

Madawc/Synapsevampire, Thanks for sharing your Ideas. When I used "Suppress Blank Subreport" I see blank pages because subreports finds something if I pass blank or null. So I opened section expert and I see two check boxes one says "Suppress(No Drill Down)" and another "Suppress Blank...

Thanks a lot for your valuable suggestion. I tried sorting using the formula. Now as you said I sorted the table field and displayed the formula on the report as usaul. It works great. MP

We are running CR 10.0 and we have a report as of follows: Main report with 3 groups. Report footer a: Index for sub report A Report footer b: Sub report A Report footer c: Index for sub report B Report footer d: Sub report B I am passing parameters through the main report to the sub...

I have a number field and I am using a formula to print string '-' when there is null value. I could remove decimals and zero's in the Cstr function. Now how can I sort this column. If isnull({tablename.fieldname}) then formula = "-" else formula = Cstr({tablename.fieldname},0,"") end if...

synapsevampire, In our case, I am already using the formula as VBAnewguy did to convert the blanks to zero's. Now the users want in a different way. If the record field value is zero then display zero or if the record field value is null then display "-". If I changed the formula to display the...

I have a Sales report which shows sales information for 10 weeks. I have few total and sell through calculated columns after 10 week columns. I want to suppress, Hide the next 9 weekly columns if we have data only for 1st week. I could do that by using a formula with ISNULL on the 9 fields in...