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!

  • Congratulations Westi 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. Swetal2004

    Subreport

    Thank you lbass:
  2. Swetal2004

    Subreport

    Crystal 8.5 I have a report with two linked subreports. Is there a way to inserst linked subreports within these linked subreports. These reports are linked by Date field. Thanks.
  3. Swetal2004

    Export to Excel

    Hello: I use Crystal 8.5. This report contains one Main report and two subreports. The Main report consists of one Group (Location: North South...) and detail a(Coloumn Headings) and detail b (fields) sections. When exporting the main report to excel, each row appears after skiping 2 empty...
  4. Swetal2004

    Exclude group based on specific Criteria

    Thanks I was hoping if there was a way to do this without grouping or keeping it from being the part of the record set.
  5. Swetal2004

    Exclude group based on specific Criteria

    I am trying exclude other records if the group included at least one PERIN from the data set I bring in the report. Sorry if I missed to mention that before. Thanks
  6. Swetal2004

    Exclude group based on specific Criteria

    Thanks Madawc Let me try this and I will write you back
  7. Swetal2004

    Exclude group based on specific Criteria

    Madawc Williams, Turkbear Thanks for your quick response. I am bringing around 35000 records in the report based on my creteria and therefore I cannot hard code pt_id. I am trying to write a code or use parameter field so that it excludes all occourance of pt_id with Specialty of PERIN.
  8. Swetal2004

    Exclude group based on specific Criteria

    Sorry about not being very Clear. From the table above. If Specialty <> PERIN then all the occourance of pt_id 10001 and 10004 should be excluded from the report. Therefore on the report I should see the following. Pt_id Proc_cd Priority_cd Specialty 10002 66.1 01...
  9. Swetal2004

    Exclude group based on specific Criteria

    Hello: I have a table set up as below: Pt_id Proc_cd Priority_cd Specialty 10001 74.1 01 OB 10001 75.6 02 FAMIL 10001 66.2 03 PERIN 10001 31.7 04 FAMIL 10001 52.8 05 PERIN 10002 66.1 01...
  10. Swetal2004

    Breaking down data in the details section

    Thanks lbass I totally missed that. Swetal2004
  11. Swetal2004

    select

    Thank you much.
  12. Swetal2004

    group

    Thank you very much. It worked perfectly and sorry for the delay in writing you back
  13. Swetal2004

    select

    In a formula can I write as follows Select abc, xyz from tablename where lmn = 01
  14. Swetal2004

    Breaking down data in the details section

    According to me create a formula as below if {field_name} = A then 1 and name it as A Creat another formula if {field_name} = W then 1 and name it as W in the group create a summary field to count 'A' and another summary field to count 'W' This will count no of A's and no of W's I hope this...
  15. Swetal2004

    group

    Due to the nature of the report I cannot use crosstab. Can you please help me with the formula? I tried it by grouping by ID and creating fromula but only the first code shows up rest of the code are blank. Thanks
  16. Swetal2004

    select

    Is it possible to use select statement in Crystal Reports 8.5 or any other version. Thanks.
  17. Swetal2004

    group

    Hello! part of my data set from a table ID Code priority code 012655100191 36.01 01 012655100191 36.07 02 012655100191 37.22 03 I want to create a crystal report to display the above data as below ID Code Code Code for...
  18. Swetal2004

    loop and formula crystal 8.5

    I have to group my data on another field. So specifically don't want pt_id as a group. I was thinking of a loop structure if possible.
  19. Swetal2004

    loop and formula crystal 8.5

    I am connecting this table to another table and query on other field after I get unique pt_ids

Part and Inventory Search

Back
Top