Recent content by Flupke

Thank you for your help. Can you please tell me how I can add a tag and how I can refer to that tag in a formula on another tabpage? Many thanks, Michel

In an Excel file, I have 13 tabpages, for each month one tabpage + one tabpage for the totals. On each tabpage, I have a list of people, sorted by number. On the total page, I have formula's that add the figures on the monthly pages for each person. When I sort the people on a month-page in...

I use a formula to calculate sales per half hour. It goes like this: time(hour({tblTV_Acties.TVAC_Tijdstip}), (if minute({tblTV_Acties.TVAC_Tijdstip}) < 30 then 0 else 30),0) Now I would like to calculate per 15 minutes. I tried to modify that formula, but it does not...

In a Crystal 8.5 report, I go to Database => Visual linking expert. I right-click on a link and choose Options. I want to make a left join or right join link, but the "SQL join type"-frame is greyed. I cannot change anything. How can I make a left or right join between two tables? My report is...

Hello, In my report, I want data grouped on a Person_id. However, I want the data sorted on the Person_name. How can I achieve grouping on an ID and still sort on the NAME? Many thanks and greetings from Bruge (Bruges - Belgium), Michel

Thank you for your answer. You wrote: "Try changing your viewer to Active-X or Java." How can I do this? I view the reports in Crystal Reports itself, not through a program. Michel

In Crystal Reports XI release 2, I set a parameter as type Date. When prompting for that date, I get a calendar, through which I can browse. Sunday is set as first day. Is it possible to let the week begin with Monday? The calender also appears as a page of my Internet Explorer. In Crystal...

I'm almost getting there, but not quite. You were right about the currency! Now I have no error, the colon is there and when I preview the subreport only, the correct values are displayed on the subreport. So far so good! But when I view the main report, the shared variable does not have the...

Thank you very much for your kind help. However, I did not manage to achieve my goal, because I'm not so familiar with programming in Crystal Reports. Am I right in supposing that "subamt" is the name of the variable? In the formula in the subreport, I get an error message "A number is required...

I have a report with a value that is a sum in a group footer. In that report is a subreport with also a value that is a sum in a group footer. How can I make a formula that compares these two values. When I make a formula in the main report, I can of course access the value in the main report...

In Crystal Reports 8.5, I have a report with a subreport that run fine in Crystal Reports itself. When I invoke the report from Visual Basic 6 through OCX, the report (and all others) run fine only if I remove the subreport. This is my code: crpt.ReportFileName = "rptInkomstenStortingen.rpt"...

Indeed! That helped! Thank you very much for your quick answer. Can you please tell me what was going wrong en what could possibly be the reason of that problem? Many, many thanks, Michel

Hello, In my Visual Basic 6, when I want to make an exe, the item File => Make Project1.exe is no longer highlighted, so it is not possible for me to make an exe of my program any more. Can anyone tell me what's going on and how I can fis this? Many thanks and greetings from Brugge (Bruges -...

Hello, Thank you for replying. My goal is indeed to assemble all the different bits in one document. When I copy a very large Excel spreadsheet and paste it into Word, only the amount that can be put in one Word-page is copied. The rest seems to have vanished. Unless I do something wrong...

Hello, I want to copy several items (spreadsheets, graphics, text, ...) from different Excel-sheets, along with other items (images, ...) into one file, so it can be printed and presented as one bundle of pages. When I choose copy and paste (special) into Microsoft Word, it never gives me the...