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!

Register Log in
  • Congratulations derfloh 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. francesguan

    how to force data into SP and recognized by crystal report

    Hi, I am creating Order Verification report(OV) which for shooting out automatically by Visual Cut. in the Stored procedure for OV,I am trying to force the data into a table:FR_OVLog and delete the data from another table:FR_OV; so every time report running, it will delete data from table FR_OV...
  2. francesguan

    User Name in report

    Hi, a basic question: how to show user name in crystal report? Thanks, Frances
  3. francesguan

    page footer

    Hi, I have a packing slip report printed out for 2 pages, which data actually only need one page. I tried to take out the unnecessary 2nd page, I found I delete some thing from the page footer, and shorten the length, it worked. but when I extend the length again, it still keep in one page. so...
  4. francesguan

    month sort problem

    created a shipment report, need to be sequenced by month, like Jan, Feb, Mar,... but when grouped by month, it automatically put "Apr" as the first then "Aug", then "Dec" any idea to let the month sequence in natual? Thanks, Frances
  5. francesguan

    how to take out a parameter

    Hi, I am trying to hardcode "startDate" and "EndDate" for a report,so I can use it for Visual cut. I can take out parameter "DateStart" and "DateEnd" from select expert,but I can not delete them in field explorer->parameters fields,they appears as used mark. also if I click on refresh, enter...
  6. francesguan

    UserID

    Hi, is there any way I can print userID which user used to log into window on the crystal report? Thanks, Frances
  7. francesguan

    multiple-valued parameter can only show the last one

    Hi, I have a parameter: Salesman created which allowed multivalue chosen when user run the report. and I put this parameter on report header, so user will know what the value they choose for the parameter. but the problem is it only shows the last value they choose, although report shows all...
  8. francesguan

    share spread sheet with more people

    Hi, I have an excel file,which used to collect material shortage information, several people from differenct workstation need to enter into this spreadsheet. I also want other group people, like purchasing, can read this report. but if one person open this Excel report,even in idle time...
  9. francesguan

    print UserID in crystal report

    Hi, all, I want the report print out the user name as the same they log into Syteline. I use @userID:="BG~USERID~" and it is working for some of the reports, while for order verification report, it only print out: BG~USERID anybody know why this happens? thanks in advance, Frances
  10. francesguan

    combine two table into one

    Hi, anybody know how to combine two tables into one and still save the result into one of the table? I have a complicated cystal report which used a table I imported from excel file before, and now this list should be greatly enlarged, obviously it's not good for manually adding all the records...
  11. francesguan

    variable come from subreport could not be summarized

    Hi, I defined the variable in subreport, and used in mainreport, looks good till I need to create a summarization for this field. it tells me: this field can not be summarized. Is it true that variables from subreport can not be "Total" any more? how can I get that "total"? any kind of...
  12. francesguan

    variable come from subreport is not matched to the item in main report

    Dear all, I once create shared variable in subreport and used in main report. but today I have spent hours and still can not figure out why the result I got in main report is not matched to subreport. the following is how I did: in subreport, whileprintingrecords; shared numbervar...
  13. francesguan

    how to get a value from subreport?

    Hi, all, I am trying to count the number of total lines from subreport, then compare to how many lines need to be shown up in packing slip, which is in main report; the purpose is to prevent partial shipping. is there anybody know how to get the value in subreport to use in main report...
  14. francesguan

    the page size was not large enough to format the contents

    hi, when I add a subreport, it shows me: "the page size was not large enough to format the contents of an object in the report" whatever I change the format in subreport, does not work. anybody can help? Thanks! Frances
  15. francesguan

    cystal report 8.5 has running total

    hello, can anybody kindly confirm whether cystal report 8.5 has running total or not? I am trying to move running total from 9.0 to 8.5 and don't know how. Thanks in advance Frances
  16. francesguan

    Page Header plus page footer is too large for the page

    Hi, is anyone know why I get this error message from crystal easy viewer? " Page Header plus page footer is too large for the page " Thanks, Frances Guan
  17. francesguan

    how to take out some items from a complete parameter drop down list?

    I am trying to take out several items from a complete parameter drop down list, like if I set parameter @customer, and when you get all data from customers, it could be more than 1000 customers, I want all of them except customer_1, customer_5, Customer_100; how can I get it? any comments and...
  18. francesguan

    about saving to repository

    when I try to save an image to the repository, it shows me:can not save object "%1s" into the repository, is there anybody know what happend? I am using crystal report 9
  19. francesguan

    crystal report viewer

    Hi, all, do you know which viewer is good for Crystal report 9? I am looking for a viewer product. any kind of comments are appreciated. someone told me when opening a report with 3 subreports and need to enter 4 times password is because of the viewer-Crystal Ease, anybody has the same...
  20. francesguan

    log on subreport

    I created a report which has 3 subreports, while other one open the report, 4 times prompt to ask password for the database. is it possible that password passing from main report to subreport?

Part and Inventory Search

Back
Top