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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.