I have three sub reports which has same parameter i.e. Delivery Date... Now when i run the project i get to select three parameters for each of them... I want one selection instead of three... How can i do this ?

does anyone know what Runtime DLLs are required to make the CRViewer work properly. I have registered crview.dll. crxdrt.dll and added in whatever didn't do the job on the dependecny walker. I seem to get an invalid tlv error every time I print the report. But if I install crystal XI on to...

I need to display a large # ie - 123,456,789 rounded to the thousands to get 123,457the rounding to thousands in crystal will only show this - 123,457,000i need to take off the zero's in the end. any thoughts?my source is a SQL table that i have formatted to show in thousands the way i want it...

Hello All !I come with a problem ! I've designed a report for billing purpose.there are not limit of records. I've to use DotMatrix Printer with continues paper stationery (Not Specific Length of Paper).When Last records print I want to stop the printer at the same time.But currently Print...

This is barely a programming question but here goes :Created a parameter report in Crystal XI Developer Ed.Created a VS 2005 VB.NET Crystal Reports program using the Windows Crystal Reports Project template.Doing nothing else I run it as-is and the first time through it asks for logon (as expected),...

Dear all,I'm having trouble creating a formula for the count of year-totals.I have a daterange from january 1st 2006 till august 1st 2007.The intention is to compare the totals of 2006 and 2007 but use the data from the same months in both years. So september '06 to december 2006 should b...

I want daily report of number of items booked subitem wise. For example: if i have following items booked:QTY | ITM | SUBITEM--- | -- | ----- 2 | Pant | Formal 1 | Pant | Cotton Style 2 | Pant | With Grip 3 | Pan...

Dear all,There is an error,"Missing Parameter Values" shown when sub-report includes in the Main report. (And there is no parameter setup in sub-report)What i do is to setup the datasource into sub-report by coding..I find that they runs fine when the main report, sub-report are separated.CAn anyone...

hi , i am newbie in crstal report,I had face a problem when i try to set the formula for selection.I hope to query record that inv_date and c_date bigger than certain date.so i set the formula like below:r.RecordSelectionFormula = "{ViewReportTraking.inv_date} >= DateValue('" & datefrom.ToSt...

I am using a Cross Tab Expert to display coverage information about auto insurance policies. In the SQL that is used, there is a Coverage Column and an Option Column. If the Coverage is Comprehensive and the Option is Full Glass, I am to print "Comprehensive - Full Glass", otherwise, print "Comprehe...

hi there I m trying to hide/supress sub reports that do not conatin any data.I am working with crystal report 8.0.1.0 . After all my efforts the subreport does not print but leaves a blank page and I am trying to avoid thatWhat i have done so farIn the main report I selectedunder file ->options -...

Hi, I need to count number of consequtive weeks within a group: Group_name consequtive: 2 person1 7/5/07 person2 7/19/07 person3...

HiI want to create a Crystal Report that displays the UserAccess of all Users.Well I have 2 tables Users and UserAccess.Users has the follwoing fields:Code,FirstName,LastNameAnd UsersAccess has the following fields:Appcode,Code,Type,AllowAn example of the data for user whose code is 4Users:4 John Ha...

Hi<br/>I have a report that displays all the Options available.Each Option is either Allowed or Not Allowed.<br/>If Allowed then I want to display the true sign(the icon resolved) otherwise X<br/>How can I do it?<br/>thanks

Can i pass total of a field of a subreport to main report using Crystal report 6.00.There is no shared variable here.I tried the other alternate. I grouped field in main report to get total of each group field. I put the variable on footer but i am not getting the total individual group at footer....

Hi,<br/>Can I retrive the datafiles(.dbf dbase) that is needed by a report (.rpt file) in C++ ?<br/>Wrong forum for c++, but maybe correct for Crystal Reports questions...<br/>example:<br/>I need to get this information from my xyz.rpt<br/>a.dbf and b.dbf is the data source for xyz.rpt

Dear all,I'm using Crystal report 8.5 as reporting tool and VB 6.0 and Oracle.i'm facing a problem as "Error no: 20599 Cannot open SQL Server""a.rpt" is the Report file and it contains subreports as x.rpt and y.rptx and y reports displays the address information of employeeMy coding is as...

How can I force a new page after a group has been printed?<br/>Ex:<br/>Group 1a (can be on many pages)<br/>Group 1b (needs to stay hidden until Group 1a prints)<br/>Group 1a Footer Prints.<br/>Then For a new page then... Group 1b prints (which takes up the whole page)

I am trying to write a formula for a report that sums up payments received, both positive and negative amounts.The issue I am running into is that when I drop the appropriate field as a Summary into the report, it displays a blank field in the details section for each entry that would've appear...

Hi,I am using crystal reports from last 5 years for smalll applications.Can anyone tell me that how to make the crystal report designer be the integrated part of your module so that user of our application can make report for himself by using the our database object , and need not to depend on us fo...

Hi all, I work for a small custom homebuilding company that uses the Timberline Accouting Suite with Crystal Reports 10. I'm trying to make a few custom reports but am having some trouble doing what I want. I'm trying to write a report, that for any given job will display each cost code f...

I have a V9 Crystal report with 2 parameters. It runs fine when I run the report 'directly', however, when I use the same report as a subreport, I cannot pass the two parameters to the subreport -- it comes up blank wihtout an error. 1 parameter works fine, but 2 is a problem.Any ideas?...

I am creating a application using vb and mysql database. I have to select the Candidate name for which I am going to view the crystal report.Please help me how to link and get the crystalreport through visual basic 6.0 and mysql.<br/>I am using crystal report 11.0

Hi, I'm trying to write a formula that will calculate a patient's age based on the visit date and then converting it into months. Anyone know how to do that?<br/>The variables would be:<br/>{DOCUMENT.CLINICALDATE}<br/>{PERSON.DATEOFBIRTH}

You can easily turn a parameter field into a login, to restrict access to a report and the data it might generate. However, if user #1 puts a parameter in, when user #2 opens the same report he can see the parameter previously entered by user #1...Crystal does not seem to "erase" the parameter value...

Hi We have a table change in the DB2 database. I mean an old table is being replaced with a new one. I updated the reports by replacing the old table column names with the new ones in all the reports. all the reports are running fine. there's one report which is giving Query Engine Error. it po...

I have a barcode printing formula in my report.when I run the report it starts looking for Crytalreports.msi file.Is this file required to print barcode?

Hi, I need help on this.in my report, if my total record are 25 and each page show 10 records then the last page just contain 5 records.. So..on the last page, half of detail section is empty (blank), because i set my footer to print at bottom page. what i want to do is filing the half empty detai...

when do we usually get 'Remaining text does not appear to be part of formula'<br/>Please reply ASAP

I have barcode printing formula in my report. When the report runs,itdoes not print the barcode , just prints the barcode text with some additional characters in the begining and end of the text.Is there any file missing in cryatal to print that barcode ? If yes then whats the name of this file ?...

I have 300-400 formulas, but since I do not have CR server really had no convenient place (no repository) for storing and recalling them. A friend put me on to: PHRASE EXPRESSa free utility. Just copy the formula, click on the Phrase Express icon in the task bar, give the formula a name, and the for...

Is there any option to print every page of the report twice?

Hi, I'm trying to find out the previous value of a record in Crystal 10. I know I need to use the previous({recordset}) to get it, however if the previous value is = to "something" I need to keep looking at down the recordset until the value does not = "something" I know it needs to be somethin...

Hi,has anyone encounterd a problem like this:when I try to open a CR (to view the design) I get this:00000000 D0 CF 11 E0 A1 B1 1A E1 00 00 00 00 00 00 00 0000000010 00 00 00 00 00 00 00 00 3E 00 03 00 FE FF 09 0000000020 11 00 00 00 00 00 00 00 00 00 00 00 01 00 00 00...and so on to00003ff0...

Dear All, i am visual basic Programmer.But new to crystal report . I coded like below report1.Formulas(1) = "compadd2='" & (PockAdd2) & "'" 'Place report1.Formulas(2) = "compadd3='" & (PockAdd3) & "'" 'City report1.Formulas(3) =...

Hi.. I am using Crystal Report XI first time with .net. I tried to create a new report with Report Viewer in a form using CRAXDDRT. I got an error message that I do not have a New Report API Licence. The Crystal Report is genuine and licenced. I tried coding similar to VB 6 and CR 8. Is it corre...

hii am totally new to this crystal report.i am creating simple crystal report.i select new from file menu than->custom->Datafileit open up one dialog box from which i select my database which is not password protected.after selecting this database it ask me for password.i don't know which...

Hi,My table looks like..accountno datecreated balance ecode100 09/04/07 50 a 101 09/04/07 60 b 102 09/04/07 70 c 103 09/04/07 90 dI am using the formula..IF {TEST_TEMP.ECODE}="b" THEN {TEST_TEMP...

I am displaying the records in a single page. i have set the separatepages=false.<br/>But i am seeing the crosstab column names(dynamically generated) appearing at the end of each page. though i have chosen singlepage option . how to display the column names only once in the header.?

Hi all,I created cross-tab report, like the following table Ajax Flash PHPMay 2007 5 7 1June 2007 5 5 4July 2007 6 4 2August 2007 8 4 6I want that, if user click on any value of this table, it'll show a linked report. Example : click on "...

Hi guys,I'm very new to Crystal reports and I've scoured the internet looking how to add two 'sums together in a field.In group header 3 I'm trying to add the following two sums togetherSum ({WMLocnHandlingMediaConf.QtyStor}andSum ({WMLocnHandlingMediaConf.QtyIn}And I really don&...

Hi guys, i am new around here, so be gentle!I am trying to make a crystal report using vb.net 2005. When i add a new item to my website (crystal report) i choose "Add Command". I write the following code:--------------------select panathdate from properties where pid=@id--------------------It then a...

I have Crystal Report 9 installed. I created rpt in VS2003 and set database as a dataset. Also, I developed a VS2003 dll to print report.When I called the dll in VS2005, always got the error as the title: Failed to load database information. Even I made up datasource in dll, no luck. So there must b...

It is easy to use a parameter field to select records for a report. But I can not figure out how to use a parameter field to select which field you want to select on.For example, in my file I have 4 fields, an ID field and Var1, Var2, and Var 3. Each record will have a "Y" or an "N" in VAR1, in VAR2...

I am having a heck of time doing what seems to should be simple. I have a stored Procedure (SQL Server) with one parameter that returns a records set. When I put this into a Crystal ver 9 report it prompts me for the param and produces the report. When I use this report as a subreport in a main...

Dear all, Is there any option for creating a View in a server and the base table are in another server?Ex: TEST_LIVE is an SQL Server and TEST is another sql server.Can i create a view in TEST_LIVE server from the table in TEST server.Is it possible? Kindly help..Regards,Raj...

Hi all,Thanks for looking at this.I am trying to figure out a little problem i have with a report.We have 2 shifts, 1 starts at 06:00 and the other Starts at 18:00I want the report to only show the previous shifts Data, which will need to be exported to a PDF and emailed to a group. but the latter p...

HiMy client is getting the following error message Error in formula <check>.'If not IsNull({@sApplicant2}) Then'A number, currency amount, boolean or string is expected here.The error box is entitled 'Print Engine Error'This is from a compiled 8.5 executable I created for h...

I've been trying to move some more complex reports from VB DataReports to CR.I have a CR report that is linked at runtime to a ADO recordset. Although the recordset has some NULL data, entire rows of information will come up blank. If I put in a null substitution in the fields, the substituti...

as stated at the title above - Method "RetrieveSqlQuery" of object "CrystalCtrl" failed. i run the vb codes line by line, and untill i reached this line of code .RetrieveSqlQuery, i got this error message.may i know how to solve this...? its urgent...i cant find any solution anywhere...