I have a report that has headers, details, and footers. The detail is hidden. This report also has 3 subreports. The two subreports that I added do not relate to the database elements in the main report -- they just use two variables that are passed from main to sub. The two subreports work perf...

Is it possible to send the report generated by crviewer9 (Crystal version 9 component used in vb6 program) to an e-mail address. I have the export enabled and can export report to various formats on disk but can't see how to sent automatically to e-mail.<br/>Thanks for you help.

Is there a way to get scrollbars in the crviewer9 (Crystal v9 VB6 component) so that the scroll bars effect only the report portion being displayed. If I put out into a frame and manage my own scroll bars, the heading with the crviewer menu bar scroll off the screen -- I would like to scroll only t...

i want to set background image to report can any one tell how to set to whole report. i can set image to header, fotter, details, etc but cannot set for whole report

Dear sir,<br/> Am developing one serial communication project.can any one help me to read and write data through serail port using VB/C++/C#(in any language).<br/>Plz help me,my emailid is nageshbijoor@gmail.com

Hi,<br/>Crystal displays each row in one line.<br/>I'd like to display all rows in the same line separated by comma (,)<br/>Is that possible?<br/>Thanx

Hello All,I am having an issue with grouping/sorting. I have an Access Database, with about 70 records. Of these 70 records, I have a field "category", that can have about 14 different "categories", and need to have all these records show.However, when I select a category in the "select expert", a...

Hello friends,<br/>I am a newbie in crystal report - working on 9.2 version i have created a report and would like to view the same in an asp page -<br/>Please if anybody can help me out with this - wanted steps to acheive the same<br/>Thanks in advance<br/>sandy

Dear all,I found a problem and this makes me frustrated.I'm using VB6 and CR 8, When I saved a transaction and print invoice, there is no data printed on CR (I'm sure the there is a record saved in database). The big matter is it's happened sometimes.It runs ok for several transaction...

I am using percent bar chart in crystal reports.I have divided each bar into five sections and assigned different colorsIn preview, the chart is displaying perfectly with all the defined colours But if i invoke the chart using jsp and display it in web browser the colors which I have set are not...

HiI have a couple of reports that use subreports. Some work fine and others show the subreport info in the main report at preview but at runtime you have to click on the space where the subreport should be and it opens it in a new window. I can't find any significant differences between the o...

Hi, I hope someone can help with a little issue I'm having.I am running a report based around the contact trail for our order processing software. It's a log of notes relating to the customer service history of an order. The full data for each of the contacts is made up of a combination of...

Hello,I am trying to link two tables from different systems together to get some data. The problem is that the field in db1 is Text and the field in db2 is number. This is the only link I have between the two tables.Can I do a command to change the field in db2 to text?For example:select lpmrc#, l...

I have some images(stored as Blobs) that I want to print in a Crystal report. I use Crystal 10. I created a quick little report to read these & print a report. All that came out was a box. The image did not display. These images were stored in the database as .tif files - I think. How do I get them...

Hi anyone can help me to change a section name. this is my code ReportSectionController rsc = (ReportSectionController) targetdoc.getReportDefController().getReportSectionController(); Section sec = (Section) targetdoc.getReportDefController().getReportDefinition().getReportHeaderArea().getSections(...

Hi! All!I can't add Crystal Report 9 into VB 6 Project.I already Create Crystal Report 9 and I try to add Crystal Reports controls into VB 6 application Project -- > components & reference also.What are all the controls(dll or ocx) to be added in VB application components & reference for imp...

Hi,I'm using two databases (developer and production). I have modifications to do to a couple of reports (these are working perfectly fine with the VB.NET app we have).Thing is, once I had completed the new functionality and published it to production, the reports keep pointing to the old DB i...

I want to display employee pictures on a Crystal Report. I am using Crystal 10. The pictures are stored in my firm's web site in a photos subdirectory as employee id + ".jpg"

Dear Siri have a problem nd hope u will help me .."Actualy there is a Image Folder Like in Inetpub /wwwroot /image / pic.bmp ... so i want to pick this picture directly from the folder nd wants to show it in my Crstal Report Viewer nd i m using XML schema for showing other information from database...

Hi, How do one suppress a section if ANOTHER section is suppressed. The one section holds details such as Name, Surname, Contact Number.I have insert a "Suppress Blank Section" that will suppress that section if it's blank. However, how do i suppress the OTHER section based on this section.Supp...

1. how can i link crystal report 10 with vb6.0<br/>2. how can get the (picture or image) in crystal report 10 from direct to the file through vb6.0 application<br/>send me answer please.......

Hi,<br/>1)How to establish connectivity with Sql server from crystal reports?<br/>2)What are the ways to pass value from a stored proc in Sql to Crystal Reports.<br/>3)Kindly tell me some websites or books where you can read about how crystal reports work with Sql server

Hi, I have the images in a folder and the path is stored in a table for each record. Each record in the table is associated with a different image. I'm able to load the images dynamically in the crystal report. But when i create a Package using the Package & Deployment wizard, the images are n...

hello friend please try to help me out here.i am searching for this feature and benefit of vb.net crystal report and use it in my application. what i know abt this is it provide runtime customization of reports , ability to resize and reposition objects as well as pass parameters....

I am trying to make a report that lists phone calls that are grouped by time (using group export). I can do it by hour using the option "section will be printed: for each hour" but i need it to do it for each half hour and there is no option for that. It is possible do to it? How can i do it (In Cry...

I have a crystal report and it is printing an extra blank page at the end. I have the detail ruler coming right up to the end of the text and I have surpressed the report header and footer. Any idea?

I am using VB 6.0 and Crystal Reports (I'm new to this) and am trying to create an application that will do the following without requiring a user to click on a button:1) Automatically Open an existing Crystal Report (.rpt) (It will be the same .rpt file every time)2) Automatically refresh the...

Dear All,I developed an application in VC++ 6.0 with Crystal Reports 9.0.Now i want to deploy my application on client machine but i don't now what components (files, dll) of CR are required to register or deploy with my application.Would some body please help me, its really very urgent....

I have used version XI and version 8.5 but have been unable to open two of my reports. The error messages are: 'Failed to open document' and 'Invalid report version'. I do know, after searching the forum, that it they were not saved in version 9 of CR. Any suggestions would...

Hi all,I am trying to build the report using Stored procedure. When i called the stored procedure through crystal reports i got an error "database connector error: 'cannot obtain error message from server' ". I am calling stored procedure like thisCALL ESDEVOBJ.WXGCRINV (' ', &...

One of the chart options for the gauge chart is to provide a beginning and ending value for a quality band in order to shade a portion of the gauge. I know how to do this using the report designer, but this requires me to set the values at design time. I want to be able to set the values at runtim...

I have a table for tracking transportation mode to work for each pay period. There are five modes 1=Transit 2=carpool3=bicycle4=walk5=vanpoolThe pay period database fields are below. A number is entered for each day representing the mode (the field type in the SQL db is char) . I would like my repo...

Forgive the novice nature of this question.I have a report that I want to create four groups for. Prior to grouping, I've created a Sum for an amount field. I get a Total of $1000.00 (for simplicity sake I'm making up a number).I create the first grouping and subtotal that group. No pro...

Hi All,When i tried to "save as" or "save" a report, CRW will generate error stating thatAn error has occurred in your application.If you choose Ignore, you should save your work in a new fileIf you choose Close, you application will terminate.When i click any of the button, another prompt came out,...

In my report i have display employee photo, photo path is saved in database.<br/>how to retrieve the path and display image

Hi, I'm having a problem and I was wondering if this was a known bug. I'm using Crystal Report XI Standard with eclipse.For some reasons, when I display my reports, some of the fields are displayed in bold. There is no obvious pattern because let say I have 500 records displayed, there can...

first post, forum looks like it might help me keep from pulling my hair out :)noob here to sql and crystal reports, but learning as I go. I hope I can get a bit of guidance here.I am designing a report to show productivity of employees across our system. I have a query that I am using to extract d...

I have a report That list phone calls that are received by users. These calls are grouped by user, then by Month, week, day and hour. I want to make a chart that shows the calls by day of week (Sunday, Monday, Tuesday, etc) and this chart will be in the footer of the user group ( The chart will sho...

hi<br/>How i set mailing label wizard in run time <br/> Label size<br/> Gap between label <br/> Page margine<br/> Printing direction<br/> No of label across/ down page

Hello !I'm new in the world of CR and I'v a problem.... and I need help :)I'm developping an application that open reports (with SQL Server Data) under VB6.I use Date Format dd.mm.yyyy in my app (I'm Swiss and that's the standard for us...)In my VB app, when I must Select re...

Dear All,I'm new to Crystal Reprots and ASP, and need advises regarding to my problem belowI have two database in same SQL 2005 SERVER for TEST and LIVE Environtment, and I've created more than 100 reports with Crystal Reports 11 and call it from ASP classic page.The problem is how can I c...

I have a requirement to compare the data from different data bases ( Oracle , Sybase, DB2) and hight the data if its different then Oracle data.We have the same data in Oracle ,sybase and DB2. I now need to connect to all these DBs and get the data and then compare them and provide hight light if th...

I am kind fo new to Crystal (about 3 or 4 months)I am trying to show the expected retirement balance of a participant in a chart. I have a future value formula that I am pretty sure works correctly. the formula below. Whileprintingrecords;if {RPT.DEFERPCT} = 0.00 then"0.00"elsetotext(FV((.05/12), (...

I have crystal reports in my VS2005 project. We have wrapped dll for report printing, but using version 9.2.3300.0. So I got Error "Query Engine Error" when printing. If I use Crystal Reports 10.2.3600.0, It works fine. <br/>How can I print report (10.2.3600.0) by wrapped dll (9.2.3300.0)?

I often use a parameter to pass multiple, distinct values to a report for selection or other purposes. For example, If I want data for two quarters for the year (say, second and third quarters), I will pass these two values and select records based on them.However, I often want to actually print the...

I have date range parameters on main report.I want to use those parameters in a subreport to display records between parameter date range,how can i do that?

Hi All,I have some reports developed in crystal report 8, and these are called from VB6 using OLEDB. These reports were developed on win 2000 professional environment, and are installed on win XP (client place). But some of the reports are not previewing (it always shows preview before printing) - M...

My crystal report has a where clause (entered in using the Select Expert feature). It correctly selects according to a report parameter.If I open the report in Crystal, I'm prompted for the parameter value. It correctly displays the parameter on the report, and filters the results.When I call...

Hi All,I am in the process of creating a number of reports for use as subreports in a main overall report. This works fine when the subreports use one page...however I have now got a problem as the subreports are dropping the page header field in the main report, therefore not showing the field hea...

I'm trying to read a database and show the selected records in a pick list for a parameter in a crystal report. i've attached the database to the report and selected the database and field on the 'Set Default Values' screen of the parameter. But the records in the table are not b...