Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. TedLiu

    help suppressing records..

    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...
  2. TedLiu

    Supressing Data to first occurance

    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
  3. TedLiu

    Stored Procedures from Crystal 8.5 to 10

    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...
  4. TedLiu

    Manually triggering a CE event

    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...
  5. TedLiu

    String to Date Conversion

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

    Manually triggering a CE event

    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...
  7. TedLiu

    printing records more than once

    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...
  8. TedLiu

    Dynamic Prompt

    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...
  9. TedLiu

    Suppress group header if detail section is blank

    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...
  10. TedLiu

    Suppress group header if detail section is blank

    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...
  11. TedLiu

    Suppress group header if detail section is blank

    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...
  12. TedLiu

    flitering

    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...
  13. TedLiu

    Print array problem in crystal report

    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...
  14. TedLiu

    Print array problem in crystal report

    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
  15. TedLiu

    Formula for Next Full Month?

    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...
  16. TedLiu

    Print array problem in crystal report

    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
  17. TedLiu

    Print array problem in crystal report

    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] +...
  18. TedLiu

    Print array problem in crystal report

    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
  19. TedLiu

    Print array problem in crystal report

    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
  20. TedLiu

    Print array problem in crystal report

    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

Part and Inventory Search

Back
Top