Search results for query: *

Hi philhege, I don't quite understand this phrase: "write a Web part to query the DB and join the comments with the stock table, and allow editing of the comments field in the Web part" can you show me some example or any web page with tutorial that i can refer to? edm

Hi, I am newbie to Sharepoint. My boss intended to do this: create a excel file which pull data from MS SQL DB (Stock Master table), then allow end user to key in more comment in Excel (add new column). He want to have this excel publish in Sharepoint so that everyone can add in comment...

Hi synapsevampire, If I create new report using this SP then no problem, i can see all field. When i map, i take turn off the match type field as well, but still didn't see any field there. I always face this same problem whenever i need to remap my CR to another database. edm

Hi, I always face the same problem. I am using CR9 with SQL2000. I developed a report using Stored Procedure (SP) using DB-1 then the same report will be map to 2nd database, DB-2. The SP is exactly the same. The different is just database name which change from DB-1 to DB-2. I am not using...

Hi, I found the solution. It is kind of stupid that you have to unlink or break your sub-report and map it to new server, then insert the subreport again in main report then everything will work fine. edm

I tried just simply click ok. But when i run the report, all formula cannot work, and it keep on saying field missing. So it didn't work if just click on OK. And I try this too: Create new blank report and use SP2 from Database B, and i can see all the field available. But if I remap the...

Hi, I am using CR 9.22 and using MS SQL Stored Procedure. I created 1 BalanceSheet SP A (stored procedure) in database A and the same SP B also available in database B. And i had created CrystalReport A which is using SP A and working fine. But now i need to remap my CrystalReport A to use SP B...

Any coding example? edm

Hi, How can I found out Field Name and Table which contain certain value? For example, I have Customer Code of "AA1100", but the problem i need to search through whole database to find out which table and field that contain this value, is it possible to do this in MS SQL 2000? edm

Hi LB, BroughtForwardFigure on 1st page is directly call out from table. CarryForwardFigure is sum of BroughtForwardFigure + each Figure in detail section. CarryForwardFigure need to be shown on each page but not last page. BroughtForwardFigure on 2nd (or above) page will be...

Hi Hilfy, I can get BroughtForwardFigure to be repeated on each page as i locate this formula in Repeated Group Header. But for Group Footer, there is no option for me to repeat it on every page. I need to show CarryForwardFigure once after detail section for each page, any clue? Thanks

Hi, I want to repeat a section on each page, this section (BroughtForwardFigure) need to appear once after group header section or before start of detail section on each page and end of detail section on each page(CarryForwardFigure). This is something like Page Header and Page Footer, but...

Hi, I want to show Running Page Number according to group: My report (customer account statement) is grouped according to Customer Code, my customer code start from AA001 to ZZ999, Reports layout example: AA001 address Page 1 1. xxx 2. xxx .... .... AA001 address...

Hi, My hosting server using IMail server, they done something on IIS SMTP service. Whenever I try to send mail using cdonts.newmail by using ASP Script then I got permission denied error message. After I discuss with my hosting company, then insist me to use the IMail to send mail through web...