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 dencom 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. crystalreport85

    Label Printing in desktop computer and not in LapTop

    I am using crystal report 8.5 which I ran through DataFlex 7 version.Trying to print label size 3x1 with Avery 5163 to print 10 labels per page .And printing direction is Down then Across. My problem is it is working fine in the desktop computer but when trying to print from labtop(window xp)...
  2. crystalreport85

    Export Crystal report with pic to Excel in the same format and layout

    I am trying to export Crystal report 8.5 to Excel. What are the options I should choose to get the same format and layout.And also I need to get the company logo(picture) in the excel. Right now I am not getting the image. Any help is appreciated. Thank you
  3. crystalreport85

    How to pick one record from the group

    The report I am working returns more then one record because of the linkage. group1 ord number--order#1 group2 itemno lineno quantity color 1 10 1 1 10 1 1 10 1 group2 itemno lineNo Quantity color 2...
  4. crystalreport85

    Sum is getting doubled!

    This is my layout of my report Group by Location Grp by itemid grp by tagno displayed fields {table.physical_qty} and {table.computer_calculated qty} in grp footer of tagno i display {table.physical_qty} and {table.computer_calculated qty}. I want to suppress the grp if the sum of...
  5. crystalreport85

    Suppress a row field in the crosstab

    In a cross tab I have this as a result pic frame mirror stand cust1 5 5 1 2 cust2 5 5 3 1 but I want to print pic and mirror together as 5(count of the record),since they are one item. How do I do that? i want something like this pic/frame mirror...
  6. crystalreport85

    Bar code function

    I using this function StringToCode39 to convert my number to barcode. My question is about the font size. Can I have any font size or it will truncate my barcode if i increase it.I am using it in the label format, so maximum how much i can increase the size. I am wondering whether the font...
  7. crystalreport85

    Print the date as dd-Short-Month-yy

    I would like to know how to print the date as 3-Mar-11. Orginal date field is coming from db as 3/4/2011. How to convert it? Thank you so much
  8. crystalreport85

    Page header for the Subreport

    In the main report I am placing my subreport in the group footer.And my subreport goes more then one page . I need header for each page.I have one group in the subreport. I have text field in the report header of the subreport. Like item# order# desc ---- ------ ----- Group...
  9. crystalreport85

    Sort Alphanumberic Field

    I got this field Before sort: 1 44 56 54 54a 56b 54B 3 60 ------------------- I need to sort like the following 1 3 44 54 54a 54B 56b 54 60 Crystal sorts the number first and alpha last. How do I sort like above? Any help is appreciated. Thank you in advance
  10. crystalreport85

    Top N Sort

    My question is user will pass the N value. Taking that value and sort the record by TOP N . How to accomplish it? For ex: user passes 10 to see only top 10 records at a time later 5 to see only top 5 recs .. Is it possible to do in crystal? Thank you
  11. crystalreport85

    'A string can be at most 254 character's long ' error

    thread767-367436 I am trying to print all the values(more then 254) from the array at a time. I am using crystal report 8.5 I used the following code of synapsevampire from the thread thread767-367436 whileprintingrecords; stringvar array MyArray := {?a}; //your array stringvar MyOutPut...
  12. crystalreport85

    Print a RowField of crossTab and its corresponding pagenumber??

    My Cross Tab report shows the products with the parts used and what the sizes were. looks sort of .. Glass Su productname width|height width|Height w1 34 40 23 34 w2 12 23 43 45 w3 --- --- --...
  13. crystalreport85

    Store a field from the crosstab to an array

    I get error 'A Cross-tab row has been specified on a non-recurring field' when add the following code to one of the row field Local StringVar sWinNo := Trim(Mid({Ord_Cfgt.Ship_Via_Name},11,10)) ; WhilePrintingRecords; Shared StringVar Array ArrWinNo; If UBound(ArrWinNo) = 1 And Minimum(ArrWinNo)...
  14. crystalreport85

    Pick a field from the crosstab and the pagenumber at the same time

    In an existing report I need to make some changes. It is a cross tab report that give the details of the all the items by catagory. Cross tab is placed in the group footer and is grouped by catagory and itemid. In each page 5 items description is displayed and there can be more then 50 page. My...
  15. crystalreport85

    Duplication when page header and the detail section appear together.

    I trying to display a memofield in the detail section whenever the item id changes. At the same time my customer want to display it in the page beginning, so I have placed the memo field in the page header. The problem is when the detail section memo field print at the page beginning ,it become...
  16. crystalreport85

    Passing Subreport Results Back To The Main Report

    how to get info from the subreport that onthe last record it should set a variable and pass to the main report . how to do it
  17. crystalreport85

    How to stop the file printing after certain condition the subreport

    I have a fields like cart#,bin# and a counter and i am passing order# and counter to a subreport and print the item# correspond to the bin#. If the item# is 0 then it should end the file even though bin# display more then item#. File should end as soon as there is no item# .How get the value...
  18. crystalreport85

    how to set record counter and reset after it reached certain number

    i am trying to add a field where is generate a sequence number. how to generate sequence number and when it reaches 80 it should reset to 0 and start from 1,2,3.. please help Thank you
  19. crystalreport85

    How to change the height so that the field can wrap in cross tab

    thread149-1564472 From the thread 'Row width autosize in crosstab' I have a question.One of the users explained a solution for Row width problem by changing the height. please clearly Explain how to implement it in cross tab dynamically Thank you in Advance
  20. crystalreport85

    I could not see the suppressed field in design view

    I am trying to modify the existing report. But I could not see the supressed field in the design view . how to see? Is there any setting. Thank you in advance

Part and Inventory Search

Back
Top