Hi,I need help regarding connectivity of Crystal Report 9 and Mysql, When Cr9 Report Wizard runs it does not show MyODBC 3.5 driver, the only way to connect is to create DSN. Is there any way to connect Cr9 with MySql 4.0 using ADO/RDO.One thing i need to mention is the same driver is used to connec...

I have 3 columns of data: Consumed Produced Yield 145.88 142.18 97.46 318.36 311.04 97.70 14.58 14.58...

Is it possible to display check box field in parameter form ?If yes,then how?

Hello,I'm having one small issue. I have 13 subreports, and in these subreports, I have a formula that adds up certain data fields. However, I need a formula in which it adds up all these fields globally but have been unsuccessful to do so.If anybody could shed some light on this, that would...

Hi Mr. Babu and every one,I'm very new to Crystal Report. I need to get the computer/machine name where the report resides and display it as string in one of the formula. I want to write a dll and call it from the formula workshop. However, I can't get my function from my dll (just a re...

Does anyone know what the gray border around the report is called and can it be removed? I am currently using CR XI and vewing the report via and application and ActiveX.<br/>Cheers.<br/>Mat.

hi,Currently i using the visual basic 6 and crystal report XI release 2 to develop one very small program. so i want to print the report direct to printer.then my question is may i know is it possible to disable the page range in printer setup dialog box at run time?here is my coding...Dim crxApp As...

I have a vb6 program that runs a Crystal Reports V9 .rpt via the RDC (crviewer). I load the form that contains the crviewer9; set parameters and run the report; I can rerun reports from this screen a bunch of times. In the dev environment (XP Pro), I can exit the form; reselect the form and once m...

I need to group by a memo field but it doesn't allow me, I tried making a formula in order to use it and I got a error Blob/Memo can't be used in formula...<br/>I'm using CR 8.5<br/>Please help

How do I go about counting a group of data as 1 item? For example, I have a user who worked on 11 work orders, but only 10 were completed and I am trying to get the # of work orders completed. The problem I am having is it is counting each work day for each completed work order, so for example, if...

Hi guys, I'm using CRXI Standard (eclipse plugin) and I have some trouble to customize my crosstab. I build a simple report with a crosstab in the header section that display the number of employe by department and by date.This cross tab has 1 row ==> date1 column ==> departmentHere'...

Hi,Here is the problem, i need to do the distinct sum of summary field based on Inv# field. This is in a groupIf the inv# is same i need to find the distinct sum of summary field. Here is the sample dataGHsup vend Date ST Inv# BOL Rel# DIS Summary583 AMO1 20070623...

How can i match a value in my query with a parameter that has range e.g:<br/>i want to check where order_date between {?Datapara}<br/>where date parameter is a single field that has range.

Hi all,I can't seem to find the solution to this. I have created a report with 5 subreports (which are now linked). The problem is when I run the reports, the 5 reports when run (with a combined page total of 17 pages), now duplicate these records and produce 700 odd pages.Can anyone help?Tha...

Do any of you know whether we can issue the the Query Hint (MAXDOP) setting inside the crystal report without rewriting an existing one using the standard crystal GUI (not the command file approach).Version: crystal 9We do not want to set the MAXDOP setting at the database or server level in SQL. He...

HI,<br/>Apparently when i added new column into exisiting CR, some of my data missing. how do i get it back?<br/>Attached screen shorts.<br/>p/s; the new column add-in is from another Table

Hi..<br/>I am facing a problem trying to determine whether a point in tie falls within a specific date and time range.<br/>Here is an example..<br/>Is 7/20/2007 1:23:45PM in the range between (Thursday 8:00 PM) To (Sunday 7:59 AM)<br/>Thanks

I have a report in which there is a column callled "Login Status".The values in the Login Status column can be 'Available','Successful' and 'Error'.I am able to get the count for each options.For example i have a table that has 10 rows.I am able to get number of rows th...

I'm fairly new to crystal so there may be an obvious solution but I just can't find it. So any help what-so-ever would be excellent and much appreciated...Problem:Database field shows correct value and works in formulas properly in group footer.In Report footer this same database field sho...

I have three parameters on report , one is boolean and two are dates.Condition is, if user selects True from boolean parameter,it should display all data from table regardless of date ranges,whereas if user select False it should display data within date range.Problem is its not giving any result i...

Hi, I'm using Crystal Report XI Standard (with eclipse) I would like to know if it is possible to calculate manually a column total.I know that it can be done automatically by the crosstab, but it is a simplified version of my problemColumns----PARTNUMBERSECTOR_NAMEQUANTITYMy crosstab looks lik...

I am new to crystal reporting Ii have an existing report with Job Numbers, Job Description and Total fields, The report works fine with the right sorting and groping in the Crystal report viewer. But once loaded in the ASP page it stops sorting and grouping in the asp page - companys brower page.A...

hello all,i'm trying to do the following:i need to grab all the data based on an entered date {?Date} where the start date is <= {?Date} and the stop date is either null or > {?Date}.here's what i'm using:({table.startdate} <= {?Date} and{table.stopdate} > {?Date}) or({t...

Hello,<br/>I need to change the content of a user custom formula from VB 2005 code. I am able to do that for normal formula fields but not for custom formulas. Any ideas!!!<br/>Thanks

Good Day!In the attachment, each production order has various costs like material costs, operations cost hence there are many lines for a production order. But the quantity is just 1 and 3 in the two production orders. How to total the quantity by item? When I sum it, it shows 20 instead of 4.Thanks...

Hi there.I was wondering if anyone could help me here.I need to select record details for the latest dates from two fields. The fields are:Date1; andDate2.I tried to use the Maximum formula, but can not get it to work (i.e it wont select the latest date from each of the fields, and supress all othe...

How do you make Grids in CR XI? I am creating a report that looks like a timecard where the end user prints out the report and then fills in by hand the information.<br/>thanks

Hi,I am a bit lost here and need some help. I have the following fields in my report:- Called Number<Text>- Rate<Number>- Duration <Number>- Price<Formula> => Rate * DurationNormally to simply sum the "Price" field I'd write: =>SUM({Cost_report.Calls})However, I ne...

Hello!I have some reports, all of which contain one or more subreports. All work fine in the preview window but some do not display the subreport information when I run them through my application whereas others do. I haven't set them up any differently so am baffled as to why they are behavi...

Hello All,Does anyone know of a way for Crystal to automatically develop a Table of Contents.I have about 20 headings all from a 'category' field in a table. However, all of these headings are in subreports.Any help would be greatly appreciated.Thanks,Adrian...

I added a new field to a stored proc that a crystal report is using to pull in data. How can I get the report to refresh so the field now shows up in the "Field Explorer"?

This is my problem: I have a report with 100 records. Every record was assigned a different {country.code}. I was given a hard copy with the list of 45 countries and their respective code (1 represents USA, 2 Mexico, 3 Spain etc). My report doesn't have the name of the country, only the code. I...

Hi,how to diplay Arabic data to Crystal Report from Cache Data base. I ma using VB 6 , Cache and Crystal Report 10I am able to update and retrieve the Arabic data between VB and cache, even though data is not readable as Arabic in Cache DB, rather it is stored like Junk values.When it comes between...

Does Subreports effects performance or speed of the report?

Issue: I need to join two fields so that I have something like this: CA150-1235text number{agent.number} & "-" & {transaction.number) CA150 1235but I keep getting this:CA150-1235.00I can't do format field to get rid of the decimals.can anybody helpTh...

I am grouping records on a primary field called "subject." Some of the records have related, or linked records elsewhere in the file. Even though these related records may have a different subject, I want to show them immediately below the related one, even though the subject may be different.For ex...

Hi. I have an application built in VB6 that uses Crystal 8, connecting to a DB2 database (on a mainframe). It has been in production now for a few years and recently started to show some major performance issues when trying to run a few basic reports through Crystal. One DB table in particular ha...

Hi Folks,I am CR XI..I have 2 numeric Fields in Report.I want to update the Field Data based on Below Condition.Let us assume report Fields Like A, BCondition: if A>10 and B=10 then B='Good'(String)else B=B(earlier data)Please help me out How do I apply this logicUrgent...Thnaks...

Hi,Iam having the database table ascompanyname year valuec1 2005 10c1 2004 8c1 2003 3c2 2005 5c2 2004 1c3 2005 8and i requried the r...

I am using Crystal report from vistual studio .net 2005 .I am not using any seprate crystal report software i am displaying report on the client side . i want to take the print of the report without having the print pop-up and print should come when the report is displayed. now i have to press the p...

Date range: I need to have my heading to look like this:<br/>From: 04/01/2007 To: 06/30/2007<br/>what would the whole thing need to be done including the space in the middle.<br/>I have selected the date range but I don't know how to display my heading like that!

Is it possible not to print a record if one of the field in query is 0 ?

Hello,<br/>I have a problem displaying the correct page numbers (or number of pages). I've inserted the page number field into the page header b, it will always shows 1/1, no matter how many pages i got. on the other hands...how do I solve this problem? <br/>Thanks!

hii had designed a report.there is a sub report in group header.the sub report is printed more than one time.at most 8 times. my report is actually a grade report of student of all semesters. and sub report prints the individually semesters.the reoport is desiged and prview is displayed in preview w...

Hello Genuisfriend i had three columns in my crsytal report that shows values asa = 1b = 0c shows nothing not 0 or some value as in database value of c = nullnow i want a+b+c using a formula but it is not showing the output as null is theirplease help out how can i get the resultas i want a+b+c = 1...

Hi,My Crystal Report has a box around each section (detail sections a&b). So, for example, John Doe might have 3 different sections and appear within 3 boxes. But now my client would like this box to group for each individual name, meaning John Doe's data should only be in one box. How would I...

I'm getting a Crrun32 with a yellow exclamation mark error when trying to run a cyrstal report. I've updated the crystal dll's and the crrun32.exe but it's still not working. I'm using 8.5, does anyone know what else would cause this?

Hi All , i got tired from the component crytsal reports but i need it to finish an application i'm building .i got the folloiwng error when i try to run the report.ONE : Cannot implicitly convert type 'CrystalDecisions.Shared.TableLogOnInfos' to 'CrystalDecisions.Shared.TableLogO...

Hi, I'm using CR4E Standard and I was wondering if this was a know bug of if it was the intented behavior of CR4E.Let's say I have a simple crosstab with 1 row, 1 column, and a total at the bottom of it.If I add a conditionnal formula on the field Row 1 (label Row 1) and that after I set t...

Hi all,<br/> i want to remove the field in my crystal report if the value of that fields are null.<br/>How can i do this?<br/>Thanks