Search results for query: *

Hi Ibass SENSATIONAL... i have just used your code, finished my victory lap around the office and have now come back to say a big thank you. the concept of using something like supress as simply a space to declare a variable has openned up a whole new train of thought for me. Thanks again Kylie

Hello there I am working in Crystal XI and i have built a cross tab to display how many help desk calls were logged for each priority (Summarised Field A) and what percent of them met resolution SLA (Summarised Field B). Design looks as follows: Column Date...

IBass... truly this is amazing. congratulations :) i just used this for a cross tab i am building and give you title of GURU MASTER for this solution Thank you K

Hi there hanks for your replie. The accounting system is definately rounding. the problem is it calculates a discunt on the fly but does not store the value. It just stores a total of the whole invoice. So to show the discount value on the invoice i need to replicate the calculation...

Hi there I am using Crystal XI I have a problem that thee accounting application i am working with rounds any decimal with a .5 or .05 etc Down whilst Crystal will round it up. I dont want to get rid of rounding things etc... it is just a problem when a value such as 8.325 is calculated. My...

I am working in Crystal Reports 11. I am producing labels which display the name, artist and file number of art work to be shipped. Problem is one piece of art work can have numerous artists. So i inserted a subreport in the label amnd it doesnt seem to work. I am well versed in...

Hi there I am working in Crystal 11 Release 2 off lotus notes I need to display the contents of a web page in the report. these contents are dynamic, ie different for every record. I have a field in my datasource (i am loath to call lotus notes a database :)) the field contains a URL. I can...

THANK YOU... my goodness there is always something new isnt there, i would never have thought of going sbout it that way. thanks Kylie

Hello there I am using Crystal 11 and have a report grouped hierarchially. I have then created a summary field using the insert summary function and selecting the option to summarise across hierarchy. Problem: how can i use this summary within another formula. the total i want needs to have...

Hi there Thanks for that Madawc but unfortunately a large number of reprots have already been developed and i need to go back and apply the templpates to them. As a result i need the parameters to travel with the templates. Any othe thoughts form anyone. I really need to get htis done and i...

Hi there I am working in Crystal 10. I have built a template that has a parameter in it. The purpose of the paramter is so the user can enter their name as they run the report and it will be printed on the page. This is a requirement for ALL reports I design and is why i need the template...

forgot to say i am working in version 10

I am building a chart that is plotting daily activity... meaning there are hundreds of days to be charted. As a result it is not possible to label every day down on the group axis. Can i set the group axis to print only at set intervals ie every ten days etc whilst still plotting every single...

Hi there LB thanks heaps for that. i have tried changing the SQL and whilst it seems to be working i have waited nearly and hour and have managed so far to only bring back 247 records out of the 13 000 or so i am needing. I have realised too they may have had several transactions on their last...

Hi there I am using Crystal 8.5 off a clipper database I am trying to build a report that shows the last time a donantion was received from donors... then group that information by year So far it looks like this (grouped by donor number) {Donor Number} {payment number} {amount} {date} eg...

I am trying to calculate billable days for each month. the problem is I only have a from and a to date that the consultant worked ... so when the from date is from one month ie 29/05/2003 and the to date is 02/06/2003 how do I split it so the May days will go within the May grouping and the...