Search results for query: *

Hi, I have two applications to which I dont own the code. One has an API from which I can extract data and the other is a VB application. What I want to know is if it is possible to automate the transfer data from the first application to the other. I.e once the data is extracted, propergate...

Hi, I need to calculate the percentage of a total for each member of a group. The thing is the percentage should be calculated AFTER the total figure is arrived at. I can do it with a sub report where the total figure is calculated and passed through a shared variable but I'm sure there must be...

Hi! This problem is driving me crazy, I'm trying to pass a date parameter into a report through VB. My Code is as follows With CrystalReport1 .ReportTitle = frmMain.strRptName .ReportFileName = App.Path & "\test.rpt" .ParameterFields(0) = "fromDate;" & txtDateFrom.Text & ";true"...

Hi, I keep getting this error everytime I try to view my report from a VB application. It works fine on crystal reports. Strangely I got this error quite recently. Im running a VB5 application with an access database. Can someone help me because Im going quite crazy. Appreciate it Karim

Hi, Is there any way to display a formula on a report before it is evaluated, for example I have this report that has formula that calculates the sum in the details fields as sum = sum + detailvalue. This is placed in the page footer section. I heed this formula to display at the top of the...

Can anyone tell me how to create a balance brought forward field like this… Say I have a report that I run from the 15th of the month, I want a sum of transactions up till that day as a balance brought forward. E.g. Bal B/f 10,000 -> sum of all transactions till the 15th of the month...

Ok this is my code in basic syntax Dim Amt1 As Number Dim count1 As Number count1 = 1 Amt1 = (Nthlargest(1, {TAirTrans.FATrFare},{TAirTrans.FATrSINo})) Do while Amt1 <> Nthlargest(count1, {TAirTrans.FATrFare},{TAirTrans.FATrSINo}) count1 = count1 + 1 Loop formula = count1 but when I look...

Lets say I have a group based on invoice number as invno tktno amount 1 100 1000.00 1 101 750.00 1 102 500.00 1 103 500.00 2 109 300.00 3 110 950.00 3 111 750.00 lets say I print invoice #1, is it...

Hi, I have this major problem where when I include records from other tables, my original group functions i.e count and sum get messed up. The figures are totally different. This happens when I even enter one field from the other table. This table contains details of only one regord within my...

I currently have a database where the primary key is the ticket number (tktno) there are also fields with invoice number (invno) and pax names (paxname) a sample is ... tktno invno paxname invamt 1000 1 Mr. X 1000.00 1001 1 Mrs. X 750.00 1002 1...

Hi, Im trying print a report designed in Crystal Reports 8 from within a VB application. The report displays fine on the preview pane but when I try to print it within the application I get the error Error: 20510 Description: C:\application ... Invalid formula name I have tried to do this with...

I have a database storing details about invoiced air tickets with the following structure (which is very simplified). It is an access database and I can only use the access SQL editor. Table TairTrans – a transaction file showing details of an invoice. The pk is the ticket number (tktno). An...

I want to query a memo field. For example, if I have a table containing the following fields ID(Type Number) Details(Type memo) 100 &quot;Cannon bubble Jet printer model 100&quot; 125 &quot;HP lexmark printer model 300&quot; 150 &quot;Cannon lazerjet...