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 think ive worked it out. I had the line box ending in the details section. I copied the line box into the report footer and it now works how I wanted to. I feel stupid, but thanks for the help lbass

They are down, then across. The report goes over 2 pages. All the information is pulled from an access data base, and placed in the details section. Is that what you wanted to know lbass?

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...

Oh and yes I did enter all those details in

The sheet is A4, must admit i have not been asked anywhere for that. Will have a look but if you can direct me that would be great

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...

Thanks LB. In the mean time I worked out away to do this, with a bit of your help. I dont get the numbervar things but from playing, I think ive got it and it works. Thank you, a star has been added

Thanks LB, for getting to this so soon. There is one problem. I cant see how you have linked the DVDs with the TVs. Maybe I havent made myself clear, or maybe ive misread your post. I need to pull out all the DVD sales, and show how many had a TV with them. So for example a location could sell...

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...

Thank you for that, how obivous was that. Saw the option, and sorted. Just had to get it to use the sendkey functions to send it too pdf, instead of create. Many thanks for your help

Right tried this, and does the same as excel it seems. Also didnt seem to want to know about macros written in excel. Does anyone know of another way to do this?

Thanks for that, I will have a look. Did look at this a few years ago for something else but dont think certain sheets ran due to macros in them. Will check it out

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...

That works fine. Many thanks for your help

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...

I have had this in reports before, and I think its the same as what ive doen to fix it try this. Hope it works if Sum ({@Net Income},{CUST.CNAME})<>0 then if Sum ({DLOG.DLREV$},{CUST.CNAME})<>0 then if(Sum ({DLOG.DLREV$},{CUST.CNAME})<=0,1,(Sum ({@Net Income},{CUST.CNAME})/Sum...

Once again you have come up tops lbass. Many thanks