Recent content by danausten

Hi, I have a very strange problem where by some reports in the Crystal Reports Designer prompt for the parameters 3 times then completely ignores them and reads through all the records in the query! The problem doesn't occur on oother users PC's and the reports work fine in BO Enterprise...

Sorry, that is meant to be URL parameters not command line.

Hi, Is it possible to login to InfoView using command line parameters? Thanks Dan

Try removing the link and specifying the link in the record selection formula: IP_BENEFITS.ALT_REP2_CD = REPPHONE.ALT_REP2_CD You may also want to try making sure they are both strings: ToText(IP_BENEFITS.ALT_REP2_CD) = ToText(REPPHONE.ALT_REP2_CD) HTH

Hi, CR10 SQL Server 2000 I have a report which contains a group with 2 summaries. The summaries are distinct counts. I have a formula which is located in the group footer which is an average of the 2 summaries and I want to sort the group by the average. What is the best way of doing this...

thefox149, Unfortunatly, I haven't found a way to do this in Crystal. In the end I had to create an SQL view but this is by no means ideal.

I've been looking at the Business Objects solution for creating a manual running total for rows in a cross tab & was thinking that I could modify this to do a 3 month rolling total but can't seem to figure it out. Can anyone help? global numbervar RowNumber; global numbervar RunningTotal...

lbass, You are right, each record will be evaluated multiple times but I need to show all months for a given date range so a manual cross tab won't work as I won't know how many months to create formulas for. synapsevampire, I think I need to somehow use your record select foumula in the...

Thanks for the reply - you are correct in saying that I want 3 months rolling. Howevere, I need the 3 months rolling for each month in a given date range e.g. JAN FEB MAR APR MAY ... Customer 1 Customer 2 Customer 3 Customer 4 Customer 5 ... Is this possible in a cross tab?

Hi, CR10 SQL Server 2000 I am trying to create a cross tab that shows by month the quarter to date total i.e. JAN 05 will show a cumulative total for NOV 04, DEC 04 & JAN 05 FEB 05 will show a cumulative total for DEC 04, JAN 05 & FEB 05 MAR 05 will show a cumulative total for JAN 05, FEB...

Can you post the where clause from the record selection formula?

Hi, I have a small VB app to do this if that is any use? Dan

Create a custom function as follows : Function MyFunction (sFieldName as string) MyFunction = replace(mid(sFieldName,instr(sFieldName,".")+1),"}","") End Function Then create a fowmula to call the function with the field name : MyFunction ("{Employees.Employee_Lastname}") Remember to...

Hi, Does anyone have any more information on CE / CR 11 release dates / new functionality? In particular, we are considering purchasing APOS bursting manager but do not wish to make the purchase if it is going to be included in the next version of CE. Any advice would be much appreciated...

try totext({TestInstance.gradelevel)} = "0.00" totext will put 2 decimal place unless you tell it not to : totext({TestInstance.gradelevel),2} = "0