Search results for query: *

I've got this really simple report that is grouped by customer code and, when run from crystal reports (locally on my machine) works perfectly and shows me 10 groups of data. If I save this report into Business Object Enterprise, add the database password and then schedule it to run straight...

I've written a quick report which produces a list of records and the dates they were added to the table. When I group these record by the creation date and then within the Change Group Options window change the 'Section will be printed' to for each month - I can see how many records were created...

I got a BI workspace being used as my home page when opening the BO Launchpad. This workspace contains a crystal report which I need to be refreshed every time I open the launchpad. How do I do this. Many thanks Stuart.

Is there any way of exporting a crystal report onto multiple excel worksheets. I've got a report that has multiple invoices on it and I need to split the details onto seperate sheets. I've got CR version 14.0.5.882 and excel 2010 Any help would be greatly appreciated. Stuart.

Hi, I've created a publication within Business Objects 4.0 which creates an email to our customers, attached 2 reports to the email and automatically sends the email to the receipiants. One of the attachments is a spreadsheet and I have just been told that they need to be encrypted and possibly...

Hi, I'm using CR2008 and I'm trying to export to CSV a report that has 1 detail section and multiple Group Footer #1 (a,b,c) sections. The problem is that only the detail section is being exported to the csv file. When viewed on screen I can see all records but the export file is only showing...

I've got a crystal report (2008 version) written which comes from an Oracle 11g database. This report contains many fields 2 of which are dates. When I run the report for a small number of records (100-) the date fields show as the correct date. When I run the report for a large amount of...

I'm using BO enterprise XI and one of my reports has about 80 different instances setup to run at the end of each month. Is there any way of doing a bulk reschedule so that I can get all of these reports to run now instead of going into each one and changing the recurrance. Many thanks Stuart.

I've got several business object reports that are shown as Crystal Report format in the infoview. When I try to view these reports all I see is Null in the top left hand corner. All other reports that export to excel,pdf etc work fine. Is there something not running which allows me to view...

I've got a crystal report that has the criteria: DateDiff("M",Field1},CurrentDate)>24 When I run the report directly from crystal report I don't have a problem but when I put it into business object enterprise and run it from there I get the error message: Error in File...

Is it possible to create a table where the table name comes from a string. For example: DECLARE @tbname varchar(30) SET @tbname = 'tbl_' & YEAR(GetDate()) & '_Postings' SELECT Col1 as C1 Col2 as C2 INTO @tbname FROM dbo.Table

I'm trying to get a list of all my business object reports that are saved in enterprise and which data source they come from. I've tried using query builder but don't seem to come up with the info reuqired. Any help would be greaatly appreciated. Thanks Stuart

Is there any way of indicating the first record in a group. I know there is a 'ONFIRSTRECORD' function but this only works for the whole report. The data looks a bit like: AA10 112456 1 08/06/2009 Capital -130,000.00 -130,000.00 * AA10 112456 1 08/06/2009 Rental 10,000.00 -120,000.00 AA10...

Is there a quick formula to do the following: I've got the table below A B C 1 Minimum Maximum Range 2 0 49,999.99 < £50k 3 50,000.00 249,999.99 < £250k 4 250,000.00 649,999.99 < £650k 5 650,000.00 1,999,999.99 < £2m 6 etc...

I am trying to split a string into an array. I thought I had managed it with the following code: Numbervar NoteLength := Len({Opportunity.oppo_downtimenotes}); Numbervar a; Numbervar b; Numbervar counter; //Calculate the number of Date/Time records in Downtime Notes For a := 1 To NoteLength Do...

Is it possible to publish a CRXI report which has an excel spreadsheet as it's datasource onto BOE. I've tried to do this and keep it keeps failing with an error message The database logon information for this report is either incomplete or incorrect. . The report works when I run it directly...

Is there any functions similar to "OnLastRecord" that can calculate the last record of a group.

I've got a main report which contains 4 sub-reports. Each of these subreports creates a shared variable which I want to use in the main report. The subreports are sitting in the detail section but I want to use the variables in the report header. Is there any way I can force the subreports to...

I'm trying to schedule a report (created in crystal reports xi) in BOXI which when run, exports to excel 2007. This report has well over 100,000 records and therefor should be put on multiple worksheets. The report seems to run ok but then seems to fall over with an error: Error in File...

I need to be able to calculate the number of hours between 2 datetime fields but excluding any weekends. Is there a simple formula to do this. I'm using crystal XI. Many thanks for any help. Stuart.