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 Mike Lewis 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

    Thank you so much. I tried MsWord it works perfect. Thanks again
  3. crystalreport85

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

    I want to export to excel so that user can input some data.That is the basic idea. I don't know whether it is a good idea.I found in some section(crystal report) the field are having different field width under the same column. I am not aware of macro would you please tell me more in details...
  4. 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
  5. 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...
  6. crystalreport85

    Sum is getting doubled!

    hi fisheromacse, The formula(crystal report sum) says @sum sum({table.physical_qty},{table.itemid}) It should work but it is returning double the value for example: 20 it prints 40. hi lbass, My report data look like this itemid aaa tagno physical_qty computer 1000 100...
  7. 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...
  8. crystalreport85

    Suppress a row field in the crosstab

    Thank you very much for clear that . I took your suggest to work it out
  9. crystalreport85

    Suppress a row field in the crosstab

    Thank you. So it can't be done in the cross tab itself? I was thinking becoz of the version (using 8.5)I got this problem.
  10. crystalreport85

    Suppress a row field in the crosstab

    hi lbass, I get blank col in case of 'pic' but the summary field is loaded. with condition --table.field <> pic like -------(blank) ------ 5 5 5 5 From customize style i check 'suppressed the empty row and col' Thank you
  11. crystalreport85

    Suppress a row field in the crosstab

    Hi lbass , Sorry Still i have problem. I told wrong it should be like this Row field --table.cust name column field ---table.item summary-- sum of total quantity I created this formula if {table.field} = "pic" then " " else {table.field} i used this formula as my column field and add this...
  12. crystalreport85

    Suppress a row field in the crosstab

    I am using cross tab in the footer of report section column field --table.cust name row field ---table.item summary-- sum of total quantity I hope it helps Thank you
  13. crystalreport85

    Suppress a row field in the crosstab

    thank you so much Now if {table.field} in ["pic","frame"] then "pic/frame" else {table.field} Thank you so much lBass. now I get pic/Frame 10 10 instead of pic/Frame 5 5
  14. 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...
  15. 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...
  16. 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
  17. 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...
  18. crystalreport85

    Underlay Following Section

    I have the same problem. lbass,Would you please tell me how to stretch page header b vertically Thank you
  19. crystalreport85

    Sort Alphanumberic Field

    Sorry ..the sort I need is 1 3 44 54 54a 54B 56 56B 60 so on.. I tried this logic @FSort end:=right(sNo,1); if not isnumeric(end) then sWinNo:=trim(replace(sNo,end,"")); else sWinNo; and used Fsort field to sort and printed {table.sno } field but the field printed number first and...

Part and Inventory Search

Back
Top