Recent content by Rob2k2

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

Ignore last post, just founf the FAQ section..lol

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

Thanks, thats exactly what I was after.

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

Thanks a lot worked a treat

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

Many thanks for your reply, will give it a go tonight.

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.

Thanks a lot, all I needed however was the:- .ExcelConstantColumnWidth = 10000 Rob

Just found that out on crystals knowledgebase as well, was just about to post the same thing. It was the cselexpt.ocx file, it hadnt been included with the distro package and consequently not registered. Thanks anyway.

I am also having the same problem, any ideas anyone?