Search results for query: *

Im trying to write a report in Crystal reports verison 14. Im basically trying to pull out sales but want to group by date, but not use the year, as i want to compare the same date for each year. So for example i might enter a date on my report of 24th Nov 2015. I would then want it to bring...

Hi, hope this is not in the wrong section I'm using Crystal reports XI. Now, my subject question might sound easy, however its not working the way I want. I have created a hyperlink field that goes to a website to show a picture. Its for people that work in my company. The link is basic...

I have done a report in Crystal Version 10. Ive used the Format multiple columns on the detail section and the report works fine. Im now trying to make the report look a bit better, by putting the results in boxes. The problem I have is on the last page of the report, the data produced finishes...

Im hoping someone can help me. Im trying to do a report but dont have enough room on the page. So I would like to continue the names along the bottom, of the page. I know I can do it by having the group split ie a and b, but I want to have the report to look like this, and not have it directly...

Im trying to create some mail labels in Crystal version 10. Im using the wizard but im not getting any joy from it. Im using user-defined label. I enter in the measurements from the label sheet i have. However crystal says this is 3 labels across, which is correct, but is says its 7 down which...

Im trying to do a report, which will show sales of a product, and then other types of products sold with it. In my example, I want to see how many DVDs are sold, in total and then see how many have the product TV sold with them (on the same agreement number). Im pulling the data from a table...

I have an excel sheet, with a macro which then prints it. I want this to print to a PDF. Im using adobe acrobat 6 professional. Now I have added to this excel sheet the following command in a macro: ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True This then uses the default...

Hello I have a list of emails that I have pulled into Crystal version 10. now most of these emails are fine. However I have some that have had characters to the beginning of them. I think this was some sort of logging reference from a previous program. This is an example of some 100-2345...

Im writing a report, and need to do something very simple but I cant seem to do it. I have a field which contains postcodes. This is just numbers and letters like "WD24 1AB" or "HP2 4JK". All I want to do is get rid of the spaces in the fields ie "WD24 1AB" to "WD241AB" or "HP2 4JK" to "HP2 4JK"...

Im trying to write a report, that picks up certain records in a given month. The report also shows a year to date and for the week for these records, which ive got working fine. Now I know I could type the dates in at the beginning of each month but I would like to automate it. Also these...

I have a report, in Crystal, and it uses a subreport. Now the way I understand Crystal to work is, it refreshes the main report, then subreport. then does the same thing again, for each record I want. Is there a way to tell Crystal just to refresh the subreport and then the main report, as im...

This should be very easy to do, but I cant do it. I have 3 tables. One has a list of Employees, one has a score in it for the perfomance for a month, and another has there performance for a year. I have pulled out a unique code, from the employee table and the 2 other tables have this code in...

I have a report, where Im grouping by location. I’m pulling out sales info for one product and then comparing it as a percentage, against another product sales. I want to do a position for the highest conversion rate. The report looks like this so far: Location Product1 Product2 Conversion 1...

Hello, not sure how to do this so thought I would ask on here. Im pulling out sales information, and I want to count the number of sales where 2 products have been sold on the same sale ID. eg I want to count how many sales are done product1s are sold with product2s: SaleID Item Qty...

Im trying to do a report where I will show figures for the last 8 weeks. My first field is the following: if {DATE} in LastFullWeek then {QTY} else 0 This works fine. Then for the week previous to that I do: if {DATE} in Dateadd("d",-7,minimum(LastFullWeek)) to...

Hello Im trying to get a figure to round up on a report im doing. The number is worked out by another sum, which I just look at in another field. I want to round this up to the nearest 0.5 for example: 1.23 would round up to 1.50 1.01 would round up to 1.50 1.99 would round up to 2.00 4.45...

Hi all. Im trying to get excel to count through a column of cells of data and only count cells which has data, thats been highlight in bold. I then want to put this a total at the end. EG cells A1 to A10 have the data in them, I would like to put in Cell A11 the total of bold items

Im trying to publish some figures as a text message to mobile phone users. Some one has sorted this out the text messaging side for me, with something that runs in a macro. The problem I have is in this macro, the message it sends has to be put in ". What every i type in these " will then be...

I have a report which i need to do positions on. I have tried doing the top N sort, but cant seem to do it ont fields I want too. I have 2 figures, and I would like to say on both which is the highest out of all the others. and have a number for there position, ie 1st, 2nd, 3rd, etc. The fields...

I have an excel sheet which querys another excel sheet, every 10 mins. This sheet it querys, is produced automatically. I seem to get errors now and then, if the sheet is being updated. The error is along the line of "cant find book1.xls" it then asks if you would like to re try (yes...