Search results for query: *

Hi @all, (first of all: I hope that I will be able to describe my problem...) I'm looking for a way to open a report from the CE10-Server. Situation: A user-form in an Access-Database contains a tree-view-control and a list-box. The logon on the CE10-Server works fine: Set es =...

Hi jyoke, your suggestion only gives the value of the current group. What I'm looking for is an oppertunity to get the name of the current group, so that my function will be used in various groups, always working with those fields that are in this group. So I'm still looking for an answer...

OK, thanks a lot, we will look forward for CR9 or 10 - this will come in a few weeks... Wish you (all) a "Merry Christmas"!

Hi nagornyi, nope, no chance. We tried to get results in other reports that have similar problems. Our data is to complex to get the percentage on this way. The Seagate-support-service here at our company can't give any solution. It might be possible in a newer version - but we don't know if or...

Hi Madawc, sorry, I should give more comments ... Let's say the data may be the following (source is a qry-file named query): Gross2002 Country Section Premium 47345.83 DE 4110 Prov CTG_ETC 10589.65 DE 4110 Premium 12121.11 DE...

Hi Madawc, I can sum the two fields {Query.Premium} and {Query.Prov CTG_ETC} and calculate the ratio - that is not the problem while working within ONE group: If Sum ({Query.Premium}, {Query.GROUP5})<>0 Then Sum ({Query.Prov CTG_ETC}, {Query.GROUP5})/Sum ({Query.Premium}, {Query.GROUP5})*100...

Hi Madawc, my posting to your suggestion from yesterday has not be stored - so here again. The problem is not to create running totals - it is the ratio that must be calculated for each group, using 2 of the sum-fields in the group that have to be devided: If {Query.Premium} <> 0 Then...

Hi synapsevampire, Database is Informix (DSS). The query gets its data from a Select Fields From Table1 ... UNION ALL Select Fields From Table2 The following example is only a part of the SQL-statement which is about 30 KB (!) Example: SELECT q.u_biljhr AS BILANZJAHR, q.u_invjhr AS INVJAHR...

Hi @all, (Crystal Reports 8.0) My report (based on a query) has 5 groups, in each group the sum of 102 fields is calculated (17 rows, 6 columns). I need to calculate the ratio in 4 rows (i.w. 6x4 calculations) in each group. At the moment I get the result by using a formula like (for the inner...

First of all, I'm sorry for my english... Second: I'm a totally newbie working with Seagate-Info and Crystal Report... We have created a cross tab that sums up a total of 200,000 records. All sums for the 21 fields that have to be summed are calculated correctly. One cross tab-field should...