Search results for query: *

I am using a running total field to sum up a field (field1) based on an evaluation formula on another field(field2). However if the evaluation formula is not met i.e. the condition of the formula is not satisfied then it wont return anything. Is there a way to return a 0 value instead of...

I am currently launching a crystal report from within VB, which contains several subreports. The main report and subreports are all using different SQL statements to retrieve the data they need for the report. I have managed to get the main report working using the following code:- sqlstr1 =...

I have a date paramater field in one of my Crystal reports that lets me determine the month to run the report for. The parameter is called {?ReportDate}. I want to launch the report from a VB app and need to pass the paramater value to the report. The current SQL query to retrieve the data for...

I know this has been discussed somewhere before but I cant seem to find the post again. What i need to do is alternate the background colour of the group footer in my report. i.e. if there are 10 items in the group then the background colour of the 1st, 3rd, 5th, 7th and 9th item would be...

I have a data grid which is used to update fields on a database. The problem is that the update only occurs when the user changes rows in the data grid. This is a problem as if the user updates a cell then exits the program without changing rows, the update is lost. Is there an easy way to...

Okay, here it goes:- I need to replicate this code in crystal in order to avoid having a divide by zero error as TNoEnq can be 0 I have created a Formula called CPA in which I have the following code If {@TNoEnq} = 0 Then {@CPA} = 0 Else {@CPA} = ({@Cost}/{@TNoEnq})*1000 End If But it doesnt...

I am trying to link 2 datagrids so that if you change row in one datagrid it automatically selects the corresponding row in the other one. Each datagrid contains 2 seperate views of the same records so the number of rows is always the same and are in the same order. The code i am currently...

Is there any way when a user clicks on a field in a report (a red box appears around it), they can then click on a vb button placed on the viewer toolbar and it will read the contents of the field into a text box. Any help would be appreciated.

I am trying to export a report to excel(csv) format from crystal reports 9 in VB6. Everything is working fine, but i need to be able to change the colum widths of the columns to a custom value. This can be done, if you show the users the export dialog box below and allow them to specify a...

I have created several crystal reports and I now wish to write a visual basic frontend to view the reports. The reports import data using two sql queries from a single SQL database. Here is the SQL code I have in VB at the moment. Public Appn As CRAXDRT.Application Public cReport As...

I am using the following code to open a word document and insert two pictures:- Public WordApp As New Word.Application Public TestDoc As Word.Document Dim Sel As Word.Selection Private Sub LPCBtn_Click() Dim LogoRange As Word.Range Set TestDoc = WordApp.Documents.Open("C:\Documents and...

Is there a way to specify an SQL query for record selection instead of using the Record Selection Formula.

I have two tables, master and compperfloat. I am using the record selection formula shown below:- year({master.findate}) = 2002 and month({master.findate}) = 10 and {master.lender} <> 'AMC' On the report page i have put {master.lender} one of the fields from the {master} table which returns...

Is there an easy way using a formula to carry out the following:- Display {CompPerFLOAT.Lnamnt) where {CompPerFLOAT.Month} = '10' and {CompPerFLOAT.Year} = '2002' and {CompPerFLOAT.ApptoTeam} = 'N' as the where clause doesnt seem to be valid in the formula editor.

I have a field PPP, which is either true or false but what I want to do is count the number of Trues and divide them by the total number of entries. Is there an easy way to do this?

I have got a report where the data is summarised and grouped by lender, i.e. green, red, etc. Is there a way to change the font colour to relate to the lender, i.e. have the text in green if the lender is green?

I have got 2 group summary fields which are calculating net income and number of payouts per group. In the group summary I wish to include an average net income which is netincome/number of payouts. Is there an easy way to do this?

Im currently grouping a report by month with a formula :- month({master.FINDATE}) However, this groups the months by numerical value i.e. 1 for January. Is there an easy way to translate the numberical values into actual months so it displays 'January', 'February' etc. Any help would be great.