Search results for query: *

Hi, i'm hoping someone can help with a query I have... I am trying to build a Human Resources Hierachy report - Basically the report has staff names, details such as cost code, and department etc etc, and also their line manager. What I need to do is show a drill-down, starting at the top...

Hi, i've done a search, i'm sure its on here but have spent a while looking but cant find anything. I have an email field, which i need to trim to show only before the "@" : So for example: my_name@domain.com should return just: my_name Thank you UrbanHim Crystal XI Report Writer London...

In our Oracle database we capture the time our website takes to complete an order (the automated process between when a client clicks "SUBMIT ORDER" to when the screen refreshes saying "ORDER COMPLETED" etc - anyway, this time is recorded in Milliseconds. I need two new formula fields...

Everytime one of our clients reads a news or info article on our website, an entry is added against their account ID for that date for either "Info" or "News". So I have a table with just three fields in it: Date Type (either "News" or "Info" Account_ID I have two groups, group1 on Type and...

Hi, i'm hoping someone can help... ive seen similar posts on here but having gone through responses, still cant get this to work. I have a report with four parameter's in it... ?View Type - Picklist ?Exchange - Picklist ?Site Type - Picklist ?Account ID - Type in (over 500k entries) What I am...

This is a really simple request, but I cant seem to do it. I am building a report based on Orders recieved per minute. I then need to add a graph which shows both Total orders per minute, and average orders per minute. The total orders i'm ok with, i have a Sum of ORDER_HISTORY_ID however, I...

I've done search around this forum and it appears that connecting to Excel from BOE is not feasible... I have a report which links a spreadsheet to an Oracle table. The spreadsheet is updated daily with current Exchange Rates, this then links to an Oracle table, and the report runs perfectly...

I have a report which is based around our client database, my users's want to be able to select the ACCOUNT.ID that they want to see in the report by typing it in, if they dont enter a value, they want to see all ACCOUNT.ID's. I've tried following instructions from this thread, which is very...

I’m trying to do a report which shows data for the last full month, plus the same month for the previous year. At the moment I have two reports, one pulling data for last month and another pulling data for same month last year, whereby I have to manually enter the date range myself. However...

I need to run a report for a date range that I cant for the life of me work out how to do it... I have a Date field: {AUDIT_ACCOUNT_EXCHANGE_ACCESS.CREATED_DATE} which needs to show data from (and including) the THIRD friday of the previous month, to the THIRD thursday of the current month. I...

Ive done a search on here, there are some historic posts on this subject but still need some advice on this matter: I have a report which has a charge and currency field: Currency Charge Rate GPB AUD 1.23 ? ? USD 0.86 ? ? EUR...

I need to chop a field which changes in length, but it always needs to be chopped before the third full stop. So I have a field like this: AF.DGGTT.OCV.542 AF.DGGTT.OCV.100 AF.DGGTT.OCV.898 BT.GL.DR.GHT.564.561 BT.GL.DR.ABT.G64.L61 BT.GL.DR.BAG.455.122 BT.GL.DR.LRT.FD.VGT BT.GL.DR.GHT.564.561...

I can use Crystal Reports fine on the machine I have it installed on, however, when I remotely connect to it from any other machine (using MSTSC) whether it be from home or another machine in the office, Crystal Reports freezes if I try to edit the report, field explorer or Visual Linking or...

I need to create a report which shows all the clients that have amended their address for currentdate-1. The table I am using, AUDIT_ACCOUNT_ADDRESS, has multiple records, because every time the client amends their address a new AUDIT_ACCOUNT_ADDRESS record is created. So for each client, we...

I have a report which has the following informtion: ACCOUNT_ID ACTION USER ID ADDRESS ID MOD.DATE CRE.DATE AB2131 Insert SA1 12 18-Mar-08 18-Mar-08 AB2131 Insert SA2 12 18-Mar-08 18-Mar-08 AB2131 Insert SA3 12 18-Mar-08 18-Mar-08...

I have a report which is comparing previous address with current address, each time a client amends their addresses, a new address record is added to our Oracle database. I therefore have two tables.. ACCOUNT AUDIT_ACCOUNT_ADDRESS I have linked using ACCOUNT_ID which appears in both tables...

Our Oracle database stores all our clients addresses, if they make a change to address, we keep the new and the old. I am building a report which looks at current address and compares it to previous entries, and shows where there is a difference. Initially it would flag all difference when...

I have reports which take 2-3 hours to run, they are reading through an Oracle table which has over 30m records in it, each with 40 fields. I am only bringing back certain criteria, but as I understand it, Crystal will read all records first, and then bring back what it needs. I am led to...

I have two fields, one for Date and one for Time, I have joined them in a formula field as follows: @DateTime datetime(date({Detail.DateChangeDue}),time({Detail.TimeChangeDue})) This is great, its showing 28-Feb-2008 17:00 This field shows previous and future dates and time. This report is...

Hi, i'm hoping someone can help with a formula I want for Select Expert. I am running a report on our Heat database, we have a field which shows order a call was resolved. At the moment my report is returning multiple records, with the resolve order numbered from 1-10 depending on how many...