Search results for query: *

Hi, i've designed a report showing some basic data with a cross tab at the bottom. some staff will simply print the last page to use, others will export the data to use in other reports/spreadsheets etc. the issue i have is that if i suppress the page header on my last page where the cross tab...

hi all, i have written a letter using crystal bringing a number of fields through. at the top are the 5 address fields. however my data isnt 100% complete. some might have nothing in addr 2 but something in 3 so there's a gap in the address which looks bad. i know the answer is using an array...

Hi all, i have a list of cash payments which i've grouped in 12 weeks plus one at the end for >12 weeks to show a timeline of cash recieved from start of a job. i've produced a line graph easy enough but they want two things on there i cant do. firstly they want a running total across the...

i know i should know this but i cant think of it. i need each group summary table to be on its own page but obv selecing new page after the group footer in the section expert produces a blank last page and i cant remember how to get rid of it thanks

hi everyone, i have a string field with a max length of 20 characters. This fields holds the initials of the people involved in the case upto a max of 5 people (but can be any between 1-5) seperated by a "/" [eg CXB/DG/FGT] becuase i need to seperate them out into each person so i can count the...

I think the answer to this is no but is it possible to group say on account number, but then have the groups appear in order of another field (i.e. oustanding balance)? thanks

I've just started working on a new database, and they store their customer address field as a string rather than a memo and all in one field rather than address lines. because of that when on the db a user enters a carriage return in the string field it enters a ; any ideas how to strip it out...

hi everyone, has anyone ever had to count up/strip out bank holidays from a report. i've built one that workds out working days betwen 6 dates. for example every case will have an open date, first call date, first seen date, last seen date and a couple of others in between and my report works...

Hi, i'm currently on a project writing reports for a new ERP system a company is implementing. Along the way i've been writing reports pointing to the various copies of the database all with diff names/port numbers. For some inexplicable reason 3 of the 100+ reports, originally pointing to...

ok, little bit of a strange one. each part we have to order has a date required and a set number eg part date req leadtime (number) 123 20/10/2008 20 they want me to work out number of working days before the date using the number, in this case it would be 20...

prob a really easy one but i just can't think of it. for each customer a report is producing i have a subreport which tells them which date we were last on site. i can do a date diff to tell me its 30 days or whatever but i dont know how to say well 8 of those were weekends so its only 22 days...

our order system and our credit control system are on 2 databases. i'm trying to give sales a list of outstanding orders approv and not approv by CC. i can bring the approv field through via a subreport in the details (or group header) and i have calculations in the details b section to say if...

Hi, i have a very complex report saved in v11 and i need to alter the SQL query directly rather than using the select expert. The reason being i cant link 2 tables directly as one is a date, the other a date time field. if i do this in the select statement it brings through every record which...

anyone know how? you can in 11 using roundup which i what i'm using locally but the server we house our free enterprise software on uses V9 and i really need to round a formula up and this isn't recognised. cheers carl

is there any way to pass information from a subreport back to the same line the subreport is on? i have a report that works out information on our machines at customers sites, basically when these machines break down. in the same tables in the info for the calls that are non break down, i.e when...

for every call we take there could be any number of visits needed by an engineer to fix the machine. linked to the call table is a thread table which has a visit number. grouping by call number, i'm trying to work out how many visits were needed to fix x number of calls in a period. using...

the following is a piece of data from our tracking system database (one table) ID status assembled YL04UTB(group) 2006-01-18 07:28:27 (min formula) 18 2006-01-18 07:28:27 143 2006-01-18 10:16:10 18...

i have a report that uses the following formula: datediff("n",maximum({@stop time},{CALL.CALL_NUMBER}), maximum({@start time},{CALL.CALL_NUMBER}))/60 it works out, at record level, the difference between two dates. the report is grouped by call number. is there anyway to sum this formula at...

i have a very simple report containing account numbers/names/bank details and how much they've paid this week and their contract no. grouped by account number and a unique id i've created (based on acc no + amt paid). if i export this to excel/word/adobe it all comes through fine, however when i...

is there any way i can get a formula to work out the difference between record 1 of column A with record 2 of column B. for example we're trying to work out how long it takes an engineer to get from one job to another. job number dispatch date time complete date time formula 1...