Search results for query: *

Hi,dgillz From your code,It's new style for me. So i am wondering how to coding for grouped the 1st,2nd level.I have 3 level grouping (supp/site/comp). This mean that i will adding formula for group by site and comp in formula at detail section. Thanks again for your help, Ndaa

Hi,dgillz I will try your suggestions and let you know the result. Thanks for your advice Ndaa

Hi,All I'm doing a manual group total. The problem is that the first of group total is zero. I'm using Crystal 7. The detail in attach file please. (http://rapidshare.com/files/155727223/Cryst_Q.doc.html) Any help would be much appreciated Regards Ndaa

Is there anyway that i could summary data with Crystal report as below Data sort by : Supp/Site/Due/Chq/FC. The result would be: Chq# FC# Chq_Due Chq_Amt PO# PO_Amt ----------------------------------------------------------- 13917 : ABC Co,.LTD...

Is there anyway that i could summary data with Crystal report as below Data sort by : Supp/Site/Due/Chq/FC. The result would be : Chq# FC# Chq_Due Chq_Amt PO# PO_Amt ------------------------------------------------------------ 13917 : ABC...

Hi,All I am new at this and creating a report using crystal report inside VB.NET(via select AS a Blank Report) When defined database(Database->Add/Remove Database->Available Data Sources:->select Stored Procedure) In Field Explorer,a field name in procedure not appeared but a parameter of...

I am trying to Update multiple row for example : Table1 : fld11 fld12 101 48A01 101 48A02 101 48A03 102 48A04 103 48A05 105 48A06 105 48A07 Table2 : fld21 fld22...

Hi,All I created a job for backup database by (Managemet->SQL Server Agent-> Job --> New Job ) the result is bckdata.bak 197474 KB and then I manual backup by (select database and click right select All Tasks -> Backup database ) the output is bckdata.bak 197459...

Hi,All How to naming the backup file with backup date in SQL server. The backup command as : Backup database DATA_W1 to disk = 'F:\backupdata\data.bak' with init skip I would like data.bak to be data_'sysdate'.bak Thanks in advance for any advise.

Hello All, Thank you for solving and then I try your suggestions. The program can run but did not display data just appear the crystal form that I designed. I run crystal report (report1.rpt) It's OK but when double click the execute file of report1. It's output same as call from VB...

Hi,All I have a problem with vb6 pass value to store procedure,that called by crystal report(7.0) as below is my code. Store procedure: create procedure PRN_VAT_RPT @rpt_date varchar(10), @company varchar(1) as select * from Tax_form where comp_code = @company and tax_date = @rpt_date...

Hi,vidru Thanks you so much.I'm using the ReplaceSelectionFormula is OK. Rgds Ndaa

Hi,DarrellW Thank you for your help.I used to using .Selectionformula as RptPrint.SelectionFormula = "{Trans_MatRecei.Comp_code} = '" & Trim(cmbCompany.Text) & "' and {Trans_MatRecei.Doc_NO} = '" & Trim(txtNumber.Text) & "'" Program display error message as : Run time error 20553...

Hi,All I have a problem when i pressed print button. The value could not passed to parameter in crystal report and the prompt wait for user input data in crystal report screen. Advice me please me. Private Sub cmdPrint_Click() RptPrint.Connect =...