Search results for query: *

Hi I have CR 9 advance, however I am facing quite a bit of problem trying to get to know 'The Crystal Web Report Server'. First: How do I install The Crystal Web Report Server? Does it refer to RAS? If so how do i install RAS? Becuse during installation there are no references...

Hi I have CR 9 advance, however I am facing quite a bit of problem trying to get to know 'The Crystal Web Report Server'. First: How do I install The Crystal Web Report Server? Does it refer to RAS? If so how do i install RAS? Becuse during installation there are no references...

Hi bodwellr Have you managed to resolve the above issue? I am too having trouble with rpt1FielD assignment as well. ie: rpt1.AddGroup (1,rpt1FielD,14,crAscendingOrder) Set app1 = CreateObject("crystal.CRPE.Application") Set rpt1 = app1.OpenReport(strapppath &...

Thank you in advance.. I am using CRPEAut32 .dll Crystal Automation Server.. cr engine 6 object library... Done followings: Dim app1 As CRPEAuto.Application Dim rpt1 As CRPEAuto.Report Dim strapppath As String strapppath = App.Path Set app1 =...

Thank you in advance.. I am using CPEAUT32 Done followings: Dim app1 As CRPEAuto.Application Dim rpt1 As CRPEAuto.Report Dim strapppath As String strapppath = App.Path Set app1 = CreateObject("crystal.CRPE.Application") Set rpt1 = app1.OpenReport(strapppath & "\Last Year's...

Thank you in advance.. I am using CPEAUT32 Done followings: Dim app1 As CRPEAuto.Application Dim rpt1 As CRPEAuto.Report Dim strapppath As String strapppath = App.Path Set app1 = CreateObject("crystal.CRPE.Application") Set rpt1 = app1.OpenReport(strapppath & "\Last Year's...

Can anyone please tell me where to download CPEAU32.dll for Crystal report engine automation server? I got version 6 for net but i need version 7, I can't find one with CRW 9 but I need to use it. Any help would be appreciated.

Thank you all in advance.. I have just started using crystal ocx in VB I got the following report Last Year's Sales.rpt which i display. However, AT RunTime 1) I want to disable Group Tree. 2) I want export button hidden. 3) Assign a Title For 1 i can only see the following which carry the...

swampBoogie my message was above is refered to you..

Hi Nigel That is wonderful work, I have never seen this format before...... ...having SUM(Orders.[Order Amount]) > (select avg(s) from (select SUM(Orders.[Order Amount])AS s I thought you could only do this..... ...having SUM(Orders.[Order Amount]) > (select SUM(Orders.[Order Amount])From...

Hi Nigel Sorry would u pleae explain what do you mean by: 'The having clause operates on each group. Your aveerage needs to work on all groups so I guess you would have to repeat the query to get the average.' How can i do that?

I have the following SQL which works as SQL statment however it need to do a little bit more as mentioned below: SELECT Customer.Country, customer.[customer name], SUM(Orders.[Order Amount])AS [Sum Of Orders Placed] FROM Customer JOIN Orders ON customer.[Customer ID] = orders.[Customer...

I have the following SQL which works.. SELECT Customer.Country, customer.[customer name], SUM(Orders.[Order Amount])AS [Sum Of Orders Placed] FROM Customer JOIN Orders ON customer.[Customer ID] = orders.[Customer ID] GROUP by Customer.Country,customer.[customer name] HAVING...

FVTrainer Excellent it works! Its nice to find people, like you, who go a distance to help others. Many thanks

Still no luck. I have mailed it back to you as you have asked above ie with the saved data. Thank you.

Hi WhilePrintingRecords; Shared currencyVar RegSupSubTotal; NO, it retruns the correct values further: However placed in the subreport rpt in a higher position does return 0.00, same incorrect values as it does in the main report. This means that the @formula field containing the above...

No that does not work either I am really frustated. I even deleted all the fromulae and recreated them still no luck. Anyone with any clues PLEASE!

I am not sure if this would make any difference but the fields in report are from .dbf where as the main report uses maaccess .mdb

Thanks for your time first, Okay here we are then Sorry for the capital letters below just to make answer stand out. Question 1: Does this formula print on the subreport (i.e., is it visible)? YES Question 2: Is this formula producing the result you want within the subreport? YES Now, in...

Thank You FVtrainer Ok I know tried what you suggested still the WRONG result. Please note in subreport i am not using another variable but this instead sum({COMPANY.LASTYRSALE},{COMPANY.STATE}); Subreport WhilePrintingRecords; Shared currencyVar RegSupSubTotal := RegSupSubTotal +...