Recent content by Srinvb

  1. S

    Crystal Report v9 - Complex conditions in displaying

    Hi I have checked the following code In my previuos reply i put the {Ftype} this is your database field which should be having "Dead" and fType is the formula(shared var) As mentioned earlier follow same procedure ,create a group on Item no ...etc put the following code in the detail section...
  2. S

    Ascending order

    HI if i am not wrong you want "ALL" to be shown first and rest of the values sorted right ? if that is the case provide some special characters to the string "-- ALL --" this will be placed first and rest of the values are sorted accordingly.
  3. S

    Crystal Report v9 - Complex conditions in displaying

    Hi I probably did not totally understood your porblem but,the only one thing i understood is that if at all there is a "Type" Dead for a particular item(Group) you would like to suppress the record. since you are already using the Shared variable instead of checking the record count check if...
  4. S

    Adding dummy data to a report

    I would probably try the crystal report Arrays.By creating dynamic arrays and assigning the fields to the arrays. Then i can check each upper bound of an array and if they are not multiples of 10 then i could always add an empty string to an array and increase my counter to accommodate the...
  5. S

    Crystal Reports help

    Hi Let me give you this suggestion ,Hope it works. Create a group on the Day(only Date of the Date field,Eliminate the time part if available). Create a running total In Fields to summarize take the field for which you need Maximum{Field} . then in the Evaluate section select Use a formula...
  6. S

    How to make y-axis of report footer start from 8"

    Hi Let me try as ,iam not having crystal report installed on my machine .iam still giving this a try. Hope this works. Since you want to a minimum of six records even tough there are less than six records.(what if more than 6 records per group?) divide the detail section into 6 detail...
  7. S

    Pass Crystal formula result to Stored Proc and use in 'where' stmt

    Try this since you already have the string of states @StringOfStates ( i assume you build this from multiselect parameter using the JOIN Function), then change the subreport links select the @StringOfStates as the mainreport join condition from the subreport @STATE_CODE as the join...
  8. S

    crystal reports urgent attention pls

    If using Crystal Report XI ,Then you have field & Report Explorers. Check in the Report Explorer(tree structure of the report layout) in the Section which has any drawing objects in it (line,box).
  9. S

    need urgent help

    Iam not sure which version of Crystal reports you are using but for Crystal reports XI My Idea would be creating a command object with an sql,there could be other ideas also i.e if you are using SQL Server as your database then(since you are saying it as a static parameter make it dynamic...
  10. S

    move row records to column fields

    If i understood the problem correctly then try the below and check the results Create a group on Person ID, Create three formula's @freset take a shared string variable in @freset place it group header Shared Stringvar ConcatStr:=""; Take another formula place in the detail section @fConcatStr...
Back
Top Bottom