Search results for query: *

Hi, You can use shared variables which will be public to both main and sub reports. In Subreport, create a formula xx: Shared numberVar IsBlank; If Isnull(yourfieldname) then IsBlank := true else IsBlank := false ; ** insert the formula xx into subreport ** in Main report, section...

Hi, You are right. {SYSOENT.ORDER_DATE} = MINIMUM({SYSOENT.ORDER_DATE}) won't give you anything related with Customer ID. In the Report Designer, find Help (click F1) and learn what's the options for minimum function, after that, you may understand LB's comments. Ted

Hi, I had worked with both CR8.5 and CR10 with Oracle as Database. Business view is confusing stuff and only shipped with Crystal Report 10 Advanced edition but CR 10 Professional edition which I'm using right now. I really doubt about the fact that whether anyone have been using Business...

Hi, I did sth similar by creating a customized CSP page in CE8.5 which get the information from url querystring sent from outside website of CE and generate the report displayed on the calling application, however, that was for on-demand reporting but scheduling, so I don't know the code to...

Hi, Yuo can use Cdate(parameter_stringdate) in your selection formula. Ted

Hi, I'm not sure about CE8.5, but it definitely can be done with CE10 by creating a file event, probably CE9 can do it too. In CE10, you have 3 type of events: 1. file-based event, by creating a specified file in anywhere CE can reach to trigger the report to run, which applies to what you...

Hi, You can simply do it by creating an additional table with only 2 records inside, then add the table to database expert without joinnnig it with the logic tables, however, you will get warning for that which you can just ignore it, after that, you will get your records twice in preview. it...

Hi, Please tell us your version, db info and details why is not working. go to selection formula to check the code there which will have the code generated by selection expert, or try below formula: other conditions and ( {yourtable.fieldname1} = parameter1_name or...

Hi, I used the formula all the time and it always works. You may need to add IsNull condition in your EmptyDetail formula, or you may not need to use EmptyDetail formula to suppress the section, you can directly write a formula into the suppression option with checking the detail value, like...

Hi, What exactly is nothing happens, coming out as blank page or you did get something but what you need? There is one more place you may need to check, in Options under file menu, under reporting tab, you need to uncheck a check box with same suppress conditions as in report options. Hope it...

Hi, I'm using CR10 now, but should be same for CR11. In the report options, make sure un-check suppress printing if no records, otherwise, you will get a blank page. Then write a formula in the suppress option of section expert in where you want to suppress, like: If Isnull(one of your...

Hi, Your question is bit confusing. where do you want to dislay record, in detail section or in group footer section? If in detail section, right-click to format field, under common tab, select check box for suppress if depulicated display string; If in group footer section, then group it...

I think the initial array should be: StringVar Array Split_LossPaid := ["100", "0", "100-"] too, because the array was generated by adding up the detail values to be the grouping sum amount to display, and in my options of report, my default setting for number is "100-" for negative value...

Hi LB, The negative value needs to be displayed as "100-" in the report, that means it occupies one more charactoer space but positive value doesn't not, that's also why I add a space behind in my formula. Thanks, Ted

Hi, Can you try to compare only year and month in your selection formua, like: ToText({table.hiredate, "yyyyMM") = Totext(DateAdd("M", 1, currentdate), "yyyyMM") I didn't test it but it should work, and also if it works, you need to make sure check SQL Query to see if the formula will impact...

Hi LB, The problem has been solved by adding a cross-tab into my group footer and it does what I need. Still don't know why we have different outputs, but at least I can move on. Thanks for your time and patient. Ted

Hi LB, Thanks for your reply. Blow is my formula to add a space behind. @display WhilePrintingRecords; StringVar Array Split_LossPaid; NumberVar i; For i := 1 to Ubound(Split_LossPaid) Do( If ToNumber(Split_LossPaid[i]) >= 0 then Split_LossPaid[i] := Split_LossPaid[i] +...

Hi LB, Same, still doesn't work. What's your email, I can send you a screenshot of the report, you will see. thanks, Ted

No luck too. I did explicitly add a space behind any positive number and tried your way. Crystal always ignores the space if it is the last character. Ted

Hi LB, Thanks for your reply. It tried with your suggestion, but seems didn't work either. And, you are right, the format should be: StringVar Array Split_LossPaid := ["100", "0", "100-"]; I'm really not sure how to make it work. Ted