Search results for query: *

Hi all, I'm going on the BOBJ XI fasttrak course covering SABE201-401 in a couple of weeks and will be planning to take the exams in the month or so after. Can anyone recommend any reading material to study to back up what's taught on the course? Also any advice on exam content not found in the...

Hi all, We've recently patched our enterprise 10 installation to version 10.0.5.1498, patch history file below. Since patching, we've noticed some, but not all reports that are exported to either Excel or Excel data only are either missing their page header section completely or in the case of...

Hi Leslie, Was this enough info?

I'm using 6 tables, data samples as follows... The data in the basket field is actually quantity|product code|option type|comment|cost|second option t_order ------- OrderID 7313 Totals 40.50|3.75|0.00|44.25 Email test.test2@btinternet.com TelNo 1325318059...

Hi Leslie, Sorry for the delayed response. That would be great! Much appreciated. Do you need me to send you sample tables or just list all the tables I'm working with? As mentioned, this is the first time I've had anything to do with Access so let me know exactly what info you need and I'll get...

ah sorry. The data comes as database exports from the ISP's mysql database, each table being exported as a .csv file which I've then imported into the access DB. All the data imports into the DB in the same format as it was in the .csv so the array is how the order details are stored by the ISP...

The basket field contains the quantity and product code for each product ordered and where applicable, the name of any product related options that has been specified. The problem is that the field doesn't always contain the cost which can be variable depending what options have been specified...

Hi all, I'm totally new to access so be gentle :-) I've created the database that uses a macro to import data from a set of csv files into their relevant tables which works fine. The database holds ordering data for an online business with a t_order table which holds the main order information...

Thanks K, "you might generate a Word template which opens and reads from your exported document using an autostart macro." I'll give this a try as the fields would only ever be filled in after the report is created.

Hi all, I'm using a report created in CRXI-R2 as an automatically generated change control form which runs each time a change control ticket is logged. The automated side of the report runs fine and exports to word with no problems but unfortunately in the original template there are four fields...

Sorry, the data I'm working with apart from the address, phone num, company etc is in the format, OrderID Part# PartDesc 001 A12|B18|G99 40w BUC|LNB|1/4" Feedhorn And for the invoice I'm trying to get something along the lines of...

Hi, Does anyone know how to accomplish this? I've now got a split array and can get a count of the elements in the array and can also get the individual part codes returned by single fields for each but as there can in theory be any number of elements in the array for each order, I need to get...

Thanks Ido, I should explain that I'm fairly new to CR and to programming so I've been reading sample code on here and in CR help/BO support and I am now able to display seperate records in a static array (in this case 2 records) using these formula fields, how can I make a single field that...

Hi, I'm writing an invoice in CRXI which pulls data from an excel spreadsheet (which is exported daily by an ISP) and arranges with address, company logo, order id etc. I'm using the details section for individual part records which need to have part ID's and descriptions but the spreadsheet...

Thanks Lbass, that worked like a charm!

Ah, no there's no reason other than I wanted to have each subreport on a page of it's own and that seemed like the best way to accomplish it at the time. As you've undoubtedly guessed I'm pretty new to cr :) Would the best way to seperate these be by using the report footer(s) then? Thanks both...

No I'm currently using a report header section for each subreport. Until now all my subreports had been unlinked, this is the first sr I've needed to link to the main report.

Appologies for the late response. I'm trying to get individual counts of the total number of site records in four seperate geographical areas in the main report and then use them for calculations in subreports for example, the subreport I'm most concerned with shows only the sites which have...

Hi, I'm writing a report which uses several subreports, a few of them based on a number of sites grouped together in areas which have downtime records linked to them. I've got the main report setup to group first by area, then by site and in the area group header I've got a distinctcount of the...

I've managed to get the desired result, problem was I was trying to display the average in the group header for {SCCall.Call_CalT_Code} instead of the group footer where the sum variable field was located. After moving the average field all works fine. I'm using 5 formula fields to get this, 1...