CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com

Search:

Type: Posts; User: jade1977

Page 1 of 5 1 2 3 4

Search: Search took 0.37 seconds.

  1. Re: Track if the report has been Drilled-Down?

    I'm sorry I miss understood! I do that a lot since I read these in the morning. I honestly cannot think of a way to do that, unless you have the same information twice, once on a hidden line, with...
  2. Re: "Not supported" error when trying to export to pdf

    I'm just checking... you do have Adobe installed, right? Some times its the simplest errors that drive me the craziest!
  3. Re: Track if the report has been Drilled-Down?

    If I'm following you... yes it is possible. I have a similar report which shows dates and a total amount on one line, when you click on the date (or amount) it drills down to show each amount broken...
  4. Replies
    1
    Views
    3,240

    Re: Conditional Total in Crystal report

    Sounds like you need to use a running total, and in the condition field place the (Currentdate - {TranDate}) >= 180
  5. Replies
    4
    Views
    18,892

    Re: Crystal report handling null values

    Try placing a space between the " ". Don't know why that works sometimes for me, but I suspect that is because our database was not very well designed, and users would use a space to delete data.
  6. Replies
    3
    Views
    817

    Re: Sum field with same index! Help needed!

    You only use the select formula, no if statements needed. Also you will get two Cs in the report because the formula is going to show for every record. Maybe you need to place the formula in a group...
  7. Replies
    5
    Views
    3,963

    Re: Record selection formula editor error

    Try



    {records.entrance_date} in {?entrance_date} to {?entrance_date2}
  8. Replies
    3
    Views
    817

    Re: Sum field with same index! Help needed!

    First off, it is THEN not THAN.
    To find the sum of field 2 you'll need to create a running total, and then use that if field 1=c.
    Finally, I would think a select statement would work better here....
  9. Re: sum calculated with the formula crystal report

    I think what you want is to break this into two formulas.



    shared numbervar v1;
    f1 = x1 * y1 / z3;
    v1:=v1+f1;
    f1
  10. Re: Subreport Paramenter need to inherit parent

    What I think is happening is that on one report the field is a datetime and on the other it is a date. If you make them both the same type, you'll then see the field listed in the Select data based...
  11. Re: Data manipulation challenge..I'm stumped!

    Just use a cross tab report. For the columns you will need to change the results of the parameters to formulas I believe, but then it should give you what you need.
  12. Replies
    6
    Views
    7,676

    Re: Array of values

    If you first create a subreport, just to build the array from that table, then pass the shared variable to the main report it can be done.
  13. Replies
    1
    Views
    660

    Re: Data Two Years Or Older

    Without knowing the particulars of your report, I don't think anyone can truly help you.

    I'm not sure what you mean by being at the mercy of the database. The report can only gather information...
  14. Re: Records appear based on condition in subreport

    Make the field in a subreport a formula using a shared variable. On the main report also place that same shared formula.. so

    Subreport



    shared variableName = {field.name}


    Main Report
  15. Replies
    1
    Views
    863

    Re: Basic Report Help!

    Did you try changing the table join from an Inner Join to either a Left Outter or Right Outter Join?
  16. Re: display subreport results as field in main report

    First of all, replace your + with &. From what I remember from classes, + should really only be used in mathematical formulas and the & should be used for concatenations.

    Now, in the subreport...
  17. Re: Output results horizontal rather than vertical

    I believe the only way to output data horizontally is with a cross tab table.
  18. Replies
    1
    Views
    860

    Re: Finding Textbox Height

    I'm not even sure if I'm following you question, but I don't think you can do what you want to do.
  19. Replies
    2
    Views
    1,671

    Re: horizontal data in crystal reports

    The only way to do it is with cross tabs. If you look around in the Cross Tab Expert, on the last tab (sorry, I can't remember the name right now), there is an option to suppress Row Total or Column...
  20. Replies
    1
    Views
    822

    Re: most recent activity with condition

    Group the report Client.
    Create a running total.
    Field to summarize: the date field
    Type of Summary: Maximum
    Evaluate: Use a formula {type.field}="Transfer"
    On change of group.

    I believe...
  21. Re: Parameter list dependent on another parameter

    It depends on what version of Crystal Reports you have.
  22. Replies
    3
    Views
    1,015

    Re: Replicate Subreport based on Parameter

    Now I think I'm following. I don't know if this can be done, at least not directly in CR. Maybe using VB or something else, but I can't help you there, sorry.
  23. Replies
    11
    Views
    21,312

    Re: Crystal Reports Formula

    That is easy enough. Create your parameter and then in the select expert



    {?parameter} = {department.number}
  24. Replies
    3
    Views
    1,015

    Re: Replicate Subreport based on Parameter

    Need more information about the report to give an answer.
  25. Replies
    2
    Views
    727

    Re: Weird Suppression Behavior

    It's just because your ) is in the wrong place. Try

    Trim({Personen.bisB_PersonalNumber}) = ""

    And yes, the English version also calls it the details section :)

    You could also try

    ...
Results 1 to 25 of 104
Page 1 of 5 1 2 3 4





Click Here to Expand Forum to Full Width

Featured