Hi All,CAn any one help me plz asap.My template has 5 group headers which are using different fields.i want to print the reports in the sorting order of another field (call it as X) which is not using in this 5 group headers.This fiels X is not an measere, it is a dimentional(ie... 1a, 1b,1c,2a,2...

Unfortunately this isn't as easy as it sounds. I am trying to build a chart just like the one in the attachment (I made it in Excel to show what I want). It's a simple line chart that reflects a trend of data over a period of time. However, there may be multiple entries on one day (such as...

Does any one how to set it up so that a user can select all as opposed to indiviual or mulitple results when using a parameter field?

Hi,I want to return everything up to and including, the first letter of the second half of UK postcodes. They take the form "BN2 6DE" or "DN28 7YT". As you can see the first section can be either three or four characters. What I am looking for is a formula that locates the space in the string and th...

i have one report that shows all employees grouped by store, then region. this is accomplished by having a sub report for each region which has sub reports for each store.Main Report --By Region Sub Report --By Store Sub ReportWhat I would like to accomplish is have a summary that will sho...

I inserted a date prompt (range) into a "Page Header" of a "Crystal Reports", but when I refreshed the report, the date prompt did not display in the "Page Header". What am I doing wrong ?

Hi everyone,I have a data table which being displayed in a sub report.The table contains 4 columns. My problem is, that I have blank fields on the first two columns. Currently, it looks like this:-----------------------<field1> <field2>...

Is it possible to put a watermark in report off crystal report 4.6.<br/>I how do i do that?<br/>greets,<br/>Andr

dear friend,as you know, to adjust x,y position of any data field on Crystal report, we just open CR and manually put and adjust the datafield...But how if our VB application want to change this setting too ? how to pass the x,y parameter of specific data field to crystal report, so crystal report w...

Dear friend,As you know, in .NET, we can pass dataset as the datasource for Crystal Report.For example, we pass 10 rows for printing to crystal report.how to get the printing status for each row,for example, row 1-5 already printed, meanwhile row 6-10 are not printed yet due to out of paper ??Thank...

Hi,Nittu here...i am at enty level of crystal reports...i am into support team.i am facing a problem in most of the reports related to grp by.viz : i have a table called ward charges...wardid wardname charges1 ac room 19502 room #1 14003 room #2 1400i need to...

I have just started (yesterday) to use Crystal Reports. I'm almost embarest to ask this question, it may be a simple step or it maybe impossible. I'm trying to make a report that will show a trend over three months.My question is, I have a folder named "database", in that folder are 500 fo...

The folder info is:<br/> <br/>Crystal Reports is shipped and installed as part of <br/>the VB installation package except in VB6. This can <br/>be found in \common\tools\crysrep <br/>double click on crystl32.exe to install.

I have a field with more then 250 size characters.When i add the field as Data base field , i can add and see the values.But i want to apply formula on the field to match the value of the field with other table field.When i do so , i am getting "blob field or memo field can't be used in formul...

I have written a report which, depending upon the data year you want to analyze, runs against different databases. If you want the 1987 data, for example, you pull from the 1987 database, and so on.It is no problem to change ("update") the files to the correct year and then run the report...when you...

At runtime I need to extract the data source i.e. the SQL that fills the parameter. What properties of the parameter field definition has the SQL or data source stored.

Hi,Can anyone help me with this problem? I created a report using crystal report 8.5 in VB6.0. It works well in Sqlserver 7 and 2000. However, when I connect it in Sqlserver 2005, it has an error message of "Unable to access first record" followed by "SQLSERVER error". What seems to be the problem?T...

What is the best way to pass a value from the main report into a subreport, so it can be used in a formula field?

I am using Crystal 9 with microsoft GP. When I try to view the reports(more than 15 ata time) I get this error:Values does not fall within the expected range.<br/>I tried Installing a cr90win_en patch but somehow i could not finish the installation on my webserver.<br/>Help

Hi,<br/>I am using version 11 of Crystal and when exporting a report to excel it merges the text over multiple cells, the previous version I was using 8.5 did not do this, is there any way of stopping this

Hi,<br/>could any one tell me please, how to find out the number of rows on a page?<br/>I need it for some like:<br/>if rows-available < 6<br/> do some<br/>tia<br/>ron

Hi folks,..Project\application\Database\mydb.mdb..Project\application\Reports\myreport.rptthe above is the structure how my db and rpt is organised in relation to the application developed in VB.In the evening I copy the whole proj on to a CD.Everyday when I sit to design/modify a report, I do it on...

I create a report with CR9 for a invoice and now I look for a solution of a problem.The report looks like:row 1 Db_tttt_tttt_tttt_tttt__tttttttttttttttttttttttttttttt row 2 Db_______________ttttttttttttttttttttttttttttttrow 3 Db_______________tttt___9999______99999row 4 Db_______________...

When i try to print or preview a report ; receive the following message:<br/>Text Object<br/>"CRPaige library CRPaige(32).DLL cannot be found. <br/>It should be on the path.<br/>(OK)"<br/>If you click OK, this message appears:<br/>"Not enough memory for operation.

Hi all,Many of you might have noticed that the group name,field name,object name etc gets displayed in report (preview mode) as balloon tips. This occurs both inside CR environ as well as if the report is displayed from VB appln. Is there a way to stop them from appearing???// http://www.vbforums.co...

I am using VS.NET 2003 to develop ASP.NET applications with Crystal Reports. Lately, only on certain computers and servers, my existing Crystal Reports (displayed on a webform using the Crystal Reports Viewer control) have started displaying only about a 100 x 100 pixel square area of the report in...

Hi,I'm running a medical report where I need to find patients with BMI value = xx. However, it has to be the most recent BMI reading. That means, if a patient has a BMI reading of xx in March, but yy in June, then that patient should not be included in the report.Does anyone know of a formula...

I have a Crystal Report(Crystal 11) which displays employee photos & some info about the employee. When I am in preview mode & paging forward, I will reach a certain employee & get the Integer Division By Zero Exception. It is important to note that there is no math involved. If i remove the picture...

Hi ,We have recently installed a custom web application with some crystal reports that was developed for another site of our company. When we run some of the reports here, we get an error that does not occur at the other site. It looks like a string parsing function is not working properly. Does...

I have an array that pulls data from field. When I do a loop the first data does not appear. But the rest does.1. "NOTE 1: RUN PARTS OVER GAGE (GL-446) SIDE TO SIDE AND THEN BACK TO FRONT. HOOK MATERIAL MUST NOT RELEASE FROM PART."2. "TEST2"3. "USE A CALIPER ON EACH END"#2, #3 all print out...#1...

Sorry to be a noob here, but I've scoured the rest of the threads, and can't find the answer to my dilemma.I'm trying to write a report that returns the top 10 depositors (based on current balance) for each of our branches. I've broken out each branch into it's own group.Whe...

I am new to crystal report. I was supposed to rectify a problem in Crystal Report. My database has an employee number and wages for each month as a separate field. Again an employee can work in 2 units and get 2 different amt of wages for the same month. So the records looks like this for an individ...

Newbie question.... I could not find the answer in previous posts....In Crystal Reports XI, I would like to filter the top ten products my store sells in a date range. I would also like to know who the customers are purchasing the top ten products. I would like to design/create a report specifica...

I have a calculated value on a record. Is there a way to return that value to the next record like below?<br/>Record 1 : $300,000 $100,000 $200,000 {300,000-100,000}<br/>Record 2 : $200,000{from above} $100,000 $100,000 {100,000-100,000}

I have this formula that is supposed to calculate the YTD Charges and Units yet it's not working. I have 2 parameters that determine the dateranges of the report. @DATE which selects an entrydate or service date then the date range of dates based off that selection....can someone help me figure...

I have the "Crystal Reports Viewer Control" in one of my VB 6.0 applications. The report was working great on the Windows 2000 OS, but when I moved the application to Windows XP it now gives the error "Server has not yet been opened". I have made sure that a system DSN has been created for the ODB...

I'm fairly new to crystal, and I have a crosstab that list columns by a date field, and groups the date by quarter. In the header of each column, crystal displays "1/2007 ..... 4/2007...... 7/2007..... etc (its displaying the first month of the quarter). I want to convert that header from the m...

I have an existing report which displays cols A to E from an SP, and uses a SubReport to retrieve cols F & G.The ouptut displays OK, but I now need to export to Excel.When I select File > Export > Export Report > etc etc, for each row on the report, I now get 2 rows :...

hi friends, i took this moment to clarify question with you, very glad you would respond to help me.had designed a report which is using a parameterized stored procedure (MS SQL server) for fetching the records from database. Though report showing the correct record set, the parameter field...

Crystal Report 10Access DatabaseI have am e-mail field that I have placed on my crystal report. I would like to turn this field into a hyperlink, and have the crystal report show up in the e-mail as an attachment.Does any one have any idea if this can be done? If so, how?If any further information i...

I encounter a problem when I exporting a crystal report to text. The amount that have more than 12 digit will be truncated.For example, EUR 100,000,000,00.000, it will shown EUR 00,000,000,00.000, which the text file will have less digit that it should.I found the web site that saying modify the win...

I developed an application in vb.net, it has some reports in it, reports are developed using crystal reports item present in .Net.After the development is done when I loaded the application in Other PC which has only .Net Fromwork 1.1 Installed it is not Working and giving error "Failed to Load" or...

I have a sub report inside of a report. I want that sub report to become part of the main report (one report instead of two)...what is the easiest way to do this?

I have VB form named Booking where i can book Six items at once for a particular customer . Now these booking details gets stored in BookingMaster database table according to the following fields:Order NumberCustomer IDBooking dateDelivery dateQuantityItemSub ItemRateFor every item booked a new reco...

I have to create a report that will always show 12 detail lines per group, no matter how many records are in the group. For example, if there are only 8 records in the group I need to print 4 blank detail lines. I have it printing and breaking on the group just fine. How Do I get it to force the nee...

I have the following data for exampleGROUP SECTIONInvoice Number [Aug 8, 2007]DETAILS SECTIONItemNo | Description | Latest PurchaseDateSAMPLEA | DESCRIPTIONA | Aug 7, 2007SAMPLEA | DESCRIPTIONA | Jul 1, 2007SAMPLEA | DESCRIPTIONA | Jun 5, 2007...

Hi all,I am attempting to create and view a simple Crystal Report in VB.net and am running into some difficulty. - First of all I add my Microsoft Access database as a datasource.- Then I create a Crystal Report within VB.Net using the fields from my datasource e.g. MyReport.rpt- Finally I create a...

I am trying to write a simple formula that will count all of the Bankrupt status that appear in my report but cannot seem to get anything to work properly.The pseudocode formula I have attempted wasCount ({Field}) where {Field} = "BANKRUPT"I realize Where is not an operator, but its in essence what...

I need to display Spanish text (...accented words, upside down question marks, tildes' over the 'N's, etc...) in Crystal reports 9.The text is coming from an Oracle database that has been updated to an 8-bit character string to properly display the text in the database.But when the te...

I am using vb.net 2005 and have created 2 reports with Crystal. I have the reports showing fine by themselves, but what I want to happen is as follows:User generates a detail report > user views/prints report > user closes report > summary report opens > user views/prints summary.I want...