Search results for query: *

Hi Guy's i am trying to create a dts active x component using vb to run an existing crystal report and shell it out into excel... I am new to doing this and have searched the net to no avail... i don't want to use a third party app to do this... but i need some idea where to start... does...

The formula field uses the following formula If {VIDS_RPT_IPSC_ADV_RENT_TOTAL.Type}= 'B2B' then if (Previous({VIDS_RPT_IPSC_ADV_RENT_TOTAL.ServiceDESC})={VIDS_RPT_IPSC_ADV_RENT_TOTAL.ServiceDESC}) and (Previous({VIDS_RPT_IPSC_ADV_RENT_TOTAL.Rate})={VIDS_RPT_IPSC_ADV_RENT_TOTAL.Rate})then...

I have created the view in SQL server 2000 and then created the cross tab using crosstab expert.... I have then created two calculated fields that I am then using in the summary field rather than the normal sum / percentage fields.... because of the fact that i need to perform a different type...

it's crystal reports version 9?

Opps just found out can't have spaces in links to file.... the image is on this post.... http://www.rostronassure.co.uk/screenshot.png

The crosstab is created in crystal reports.... VIDS_RPT_IPSC_ADV_RENT_TOTAL is the Data source. I have attached an image of the actual crosstab result.... you will see the end column is balance. the two fields in here are calculated fields the count is calculated using the following script -...

Re IBASS nope tried looking into that already... i have had another issue like that and had to change a different formula so it was one of the first things i checked. But thanks

Hi, sorry new to the forum but could really do with some help.... I have a crosstab in crystal 9 looks like this - all B2B B2c Balance serviceDESC Rate T1 8 100 50 25 25 T2 8 129 128 2 -255 the data is pulled from a sql server 2000...