Search results for query: *

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

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

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

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

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

Hi, How can I find 'free space' in the Outlook calendar using VBA? For example: for the 11/10 the calendar has meetings from 9:00 - 11:30 and 15:00 to 17:30. How can I identify the 11:30 - 15:00 as 'free space' ? Thanks Dan Austen

Hi all, I'm trying to create a report (CR10) that will show a 4 weekly rolling total (total of the 4 most recent weeks). How can I achieve this? Example data: Week no cases 4 weekly total 1 10 10 2 10 20 3 10 30 4 10 40 5 20 50 6 10 50 7 0 40 8 0 30 9 0 10 10 50 50 I guess this...

Hi, I'm using Crystal Enterprise 10 to query the enterprise database. What I want do is get a list of all reports with their full folder structure i.e. : Report name Folder Report1 home/Folder1/Live Report2 home/Folder1/Live/abcd Is there one SQL suery that I can use to...

Hi, I have setup a number of reports that use SQL Commands. Each of these reports has a start date parameter and an end date parameter. When the reports are run some of them correctly prompt for 'Start Date' first then 'End Date'. But some reports prompt the other way round. I can't work...

Is there any way of formatting a cross tab so that every other row has a different background colour? I created the following formula and applied it to the background of each column on the cross tab but the colouring goes out of synch and the cross tab ends up looking like a chess board...

Hi, What would be the code to display a list of a users (by user name) groups in CSP Thanks