Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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?