Search results for query: *

Does anybody know a work around/fix/patch for crystal 8.5 and newer mdacs(MDAC is Microsoft's data access component)? It seems that 8.5 only works with the 2.5 mdac and when our pc images which where upgraded to newer mdac (2.6/2.7) the users are having big issues with crystal now ( locking and...

I know there has to be a way ( I can not find it crystal help ) , but how can I code the report to print 2 , 3 or 4 copies of a report ( with same detail information and so on ). thanks, John

I keep getting this error on a rpeort , ( that has no custom veiws or anything ) just a basic odbc report .Any ideas what could be causing this error? This same report works on three other machines and fails on one specific machine.

Is there away to do this. I am top ending my first group but with in this group I need to group by the top sum of a location ( make sense ). Problem is groups take precedence over the sorts . So I can't really use the top end function ( it seems to lose it effect the more groups that are involved ).

My outer most group is my invoice number and I have the reset page number checked. This works great for when the invoice changes the number is reset . the problem I am having is if the invoice spans 2 pages the "page number" does not increment to 2 or so on ( it stays 1) . any ideas...

crystal reports error is as follows "An attempt was made to access C:\help.rpt past its end " any idea what is happening here?

ok I have it sharing a variable but it seems to be only taking the last record and if I am wanting to do more one sum ( for example I have three groups and I am wanting to share the three different sums ) . This dosn't seem to work either. For each sum I created it's own shared variable which on...

I can not get this work , any idea where I am going wrong here? I am wanting to return a subreport sum and add it to a main report sum. in the subreport I have this in it's own formula Shared numbervar Batch :=Sum ({Tkbatch.Qty}, {Tkbatch.Qty}) this is in the main report in it's own...

I know there is way to do this , can't find it out right now . But how do I repeat a group header ( so when my detail spans to a second page ( the header repeats on the second page ) ?

I have a report that I need a sum on , the only problem is that I need to use the (supress if duplicate option), so the record only apears once ( do to the grouping and a right outer join I get the qty displaing 3 time( links are correct for this return to get the decription I need))). But when...

Is there away to repeat a group header on each page? I can not use the page header section. For example lets say I am group by customer name and I have a thousand name ( first letter A ) I want that group header to show on ever page ( as the header ) . Now when it switches to be ( New header...

Is there any way to set the ( where n is" " ) part to a formula or parameter? I understand you can hard code it here , but I need that to be able to change it by a parameter. Meaning if one time the user wants it for to return 5 and the next time 50( they can just change the parameter...

I have a report that runs on a OKI 320 and I was wondering if anybody knows how to turn off the ( Near Letter Quality )? Is this a printer setting or is this somthing I can set on the rpt? I built the rpt on the oki default fonts and I have two rpts that run on this printer, one does near letter...

Does any body know how I can do this, what I am doing is changing a group through a Formula running of a parameter. Now everything works find except that if one of my outputs is of a different format. For example ( if sort =a then string, else if sort=b then string, else if sort=c then date)...

First I am on win 2000 and running version 8 of crystal. Now does any body know how I can build a report off of a custom sql statement , this is the statement ( an easy statement ) (select A.* from tkhist1 A Union all Select B.* from tkmhist B Union all Select C.* from rrhist C ) I can not use...

How can I change the sort in a formula? For example if{?Sort}="A" then {Rrload.TrackNo} this will sort {Rrload.TrackNo} in Ascending order how can I ( with code ) change that? is it somthing like {{Rrload.TrackNo},'D'} to change it to descending? Thnaks , John

any ideas what might be causing this error ( and how to fix it ). Crystal list this as ( user cancelled )and says the user clicked the cancel button ( problem is the user didn't ). Thanks, John

I need to create a grans total sum that is built off the sum of the main report and the sum of the subreport. Can this be done? Thanks, John

First Have you ever seen or know what error 656 is? It is pertaining to a sub report. I saw your post on sub reports links with parameters. Now my question, lets say I have a sum on the main report and a sum on the sub report, is there a way for me to sum them both (if so how) to get a total sum...

I have a report with a copy of the main report as a sub report, the report has to run off (many)Parameters. My problem is that when trying to link the subreports links ( parameters are not displayed at all) is this not an option( I can do formulas and feilds ,but no parameters?????) ? John