hey guys i have worked on<br/>data reports in VB but never worked with crystal reports<br/>could anybody tell me how to start up with it<br/>or tell me some books which i can refer

hi.<br/>i uesd vb2005 and CR 11.<br/>i want to display Message for .. if there is no record while selecting from database ,, i want to display some msg instead of Report Document ;<br/>how can i do .?<br/>pls help me

I'm using Crystal Report 7 ,use storc prcdure n vb 6. my prblem : let say in my system have company and their staff. how can i display one company and their staffname+ their picture. e.g: company A and their staff photo will appear n for cmpny B their staff photo will appear. means that the sta...

I am getting a Print Engine Error <br/>Invalid Group Condition? What is that?

I hope someone can help me get started on this. I wish I knew all of the terminology to use for this, but I have limited knowledge of Crystal Enterise 10. I am trying to figure this out as the person who created it is no longer around. He is my problem. I have a Crystal report ( Crystal 10) that...

From Crystal Report's Custom Style Dialog box, the max decimals and rounding are 10. We have to display some numeric fields with 15 decimals. If you know a way to do so, please let me know. Any help is apprecaited!

I'm running a crystal report from c#.net application, taking parameters from textboxes on the screen, using the parameters to do the data selection, and then printing the parameters in the heading of the report.The first time I run the report, it displays properly, with the correct info in the...

using crystal reports inside of visual studio and I have a report which shows productivity data for a number of reps, data comes out from the sql stored procedure one record for each rep per day.Then they need the data organized by rep (this is actually a drill down, summary for rep is just shown) a...

how can i do when want one photo appear for one staff. let say Company A in report, then all the photo staff of this company will appear in report. then if Company B then the staff of this company will appear. means that Companyid=photo staff.

My formula needs to use value from previous row,how can i access a value from previous row?

Hello,We would like to create a single report that contains two sub-reports. Each sub-report is based on a single set of parameters, but for two different databases, one for the current year and one for the previous year of data.We would like to have the single report call both subreports and then...

Question again regarding calculation on subreports.I have attached a part of my report,so its more clear what i am looking for i.e Subreport 3 is displaying result based on values from subreports 1 and 2 but only result for the first record on subreports is being displayed.

I have a report that displays 24 months of usage with a date for each months usage. i have created a running total that averages 24 months of usage but i only want average only 12 months of usage based on the date.For example: Date Usage RunningTotal...

i have 3 detail sections (assume detail prints 5 lines)detail a - prints every line detail b - has to print n blank lines if detail a prints < 10 lines otherwise nothingdetail c - has to print at 11th line alwaysi cant have this at footer because another detail e and detail fThanks...

I am creating an application (Crystal 11, VS2005, ASP.NET2.0) that generates a list of parameters for a given report at runtime. This parameter list is generated depending on which fields are used in this particular report. The application needs to be flexible enough to work with any of our reports...

Hi All<br/>Iam using a if-then-else formula and which is getting populated against each record accurately in the group. The report only has one group. What I want to achieve is the sum this formula at report footer level.<br/>Iam using CR Xi Rel 2.<br/>Many Thanks in advance.

Hello everyone, I am new to crystal reports. Ive been through some of the sample reports and have been learning. All of the samples use the Extreme Database that comes with Crystal Reports. Now I want to practice connecting to my SQL Server database but I havnt been able to figure that out. In th...

Hi,It is possible that in a server of application (ASP, VS.NET) in development it has as much the SDK of Crystal 9 and 10.This in will go to happen again itself in production.This server will go in such a way to take care of the applications that had been developed in Crystal Reports 9 and 10.The ap...

Hi Everyone,1- I need to know how to display a group total at the begining of each group instead of the end in a crystal report 11 report. For instance, I have a group in the report for sub category, I need to display the total for the sub category group at the begining of the group. 2- Inside a for...

Hello!I am trying to set up a report so that a group header can be suppressed if there is nothing in the details for that instance, but it doesn't seem to be working.My report is set up like this:Group1 - FacultyGroup2 - Person within FacultyDetails a - Contains Subreport showing Person's...

I have a condition on a parameter filed :1) There are two static values in parameter field i.e Region Cities2) If user selects REgion ,the next parameter fields should display all cities in this region and if user selects cities,next parameter should display all areas in thi...

I am getting the following error message when i attempt to set a date field as the group by condition in code. "The group options for a date, time or date-time condition field must be a date group options object." Does anyone know what this means or how it can be corrected? Im using VS2005 and ASP....

hopefully have better luck with this.I have two servers running the same database for two locations, I have a site setup to report for one of them and I want to make it report for both based on what location a person is in.I have it working when there are no parameters, however as soon as you enter...

Im new in crystal report. Is there a good tutorial on creating VIews.. how to create or modify.. thanks

hello,> i am designing a grade report and i got a problem, the problem is that me divided the report into two columns, me grouped the records on the basis of semesters. now i want to show the first semester's records in first column and second semester's records in second column, then t...

i want to use parent report's fields as a paramenter to sub reports. how can i do that??

Hi , Friends<br/> I have one formula which containc some of value .<br/> when i Click the the Option Suppress if Duplicate is not working<br/>any help in this regards<br/>thankx<br/>khaleel

i want to add roman counting with a text field. but i could'nt found the way to print roman counting. is there some way to print roman counting ? ? ?

HiI'm using crystal reports for eclipse to develop a web application , my web application is a JSF application and it uses hibernate (ORM) to hide DB details from the webdeveloper , so he directly works with POJOs.I know that CR4E enables me to work with POJOs , so my questions are:1- How can i...

Hi, This is Manoj. I have a requirement where I should select two dates and we need a graph. The x axis is for the dates and y axis for the ratings from 1 to 10.(Static). The x axis also have 5 different points for each month.We are using crystal repors embedded in .net1.1 version.Please help for th...

This should be fairly easy by my reckoning but i just can't seem to figure it out.I'm fairly new on crystal reports so i'm learning on the fly as i do this and i have my boss asking me if it's ready heheOn the screenshot attached all i want to do is group if their are multiple re...

i have a table of student containing multiple studnet's multiple records.results of different exams during a semmmester.ie.(students) (marks) (exam type)abc 10 quizabc 20 assignmentsabc 40 finalxyz...

We are using the HTML Viewer and we would like to have the ability to print the entire HTML report. We understand that you can "right click" the report and select the "Print" option. However, when we do this it only prints the first page of the report. Is there another way to print the report fro...

I am trying to create a report and get a specific total, but it is not working correctly. I have a group of workers and I am able to count how many Work Orders they have worked on in a given month, however when I try to get a total of how many they completed, I run into a problem because it is coun...

I have Crystal reports 8.5 and Im trying to generate a report that will give all of my sales orders with the part numbers price and the address they shipped to but I keep getting alot of duplicate fields so I used a suppresion forumla below{InvoiceDetail.PartNumber} = previous({InvoiceDetail.PartNum...

I am using VB6 and CR9.I have some CRs using Access as DB and I am converting them to conect to SQL server DB. What I did now is to change their connection to SQL at design time. But it took long time to reinput the fields on the report since DB has been changed. I wonder if there is better way to...

Example:2 Column in Database:1 -- MDate (Specific Date) eg: 13/06/20072 -- MoneyWhat i Want:From sunday till saturday..MDate must be within the range of the week..sum(Money) of the week is also to be shown..How to let the crystal report show every week "sum(Money)" from june to december..?...

Hi,<br/>there is a requirement of making Login name field just 4 characters. This is Group name type field which shows login names. We have to decrease the length of login names to save space. How shd I proceed?<br/>Thanks

Hi,I have a system in ASP.Net 2003 that it makes access to CE 10 and presents the result in CrystalReportViewer object. When giving a click in the next button page the CrystalReportViewer does not present nothing, also the Toolbar disappears. Somebody knows to say me what it is happening?Thanks...

Can a Crystal Report call for the Stored Procedure ?<br/>and get return values ?<br/>If so.. how to achieve to call the stored procedure ?

HI ,We are using Crystal Reports 8.5,ASP 3 and VB 6 for our application..We run Crystal Reports from ASP using VB Dll..We get an error in ASP page when we run Crystal Reports:Seagate Crystal Reports Activex Designer Error '80043ac2'Dos ErrorBut this doesnt come always and we are not able t...

I have a report that displays a lot of information. I only want to show a certain data that is related to a specific "student ID". We are writing this program in C#. We are using the Crystal Report packaged with Visual Studio. Can we pass a variable from the program to crystal? Thanks for any...

I have three subreports in detail section of main report.The first two subreports have detail records.In third subreport i want to diplay result of sum of values on two of the subreports record wise as below :SUBREPORT 1 SUBREPORT2 SUBREPORT3 55 6...

hi, i have dataset containing values of student's subject's with following formatstudentid test_type Marks1 lab 41 assignment 101 final 152 lab...

Hi, I'm using Crystal Report Developper XI with Eclipse and I'd like to know if it's possible to put some logic in a Cross-table Here's my problem:I made a simple cross-table to track orders deliveryExample:---| 20/06/07 21/06/07 22/06/07 -------------------Order 1 | 44...

I have a dynamic parameter which is also displaying All static value as first item in th list.I want to make ALL as default in the parameter but its giving problem.Problem is when i set ALL as default it doesn't display dyanamic values!

invno frecref pono ---- ------ ---- INV0000006 INV000000601 X0000009INV0000006 INV000000601 X0000010INV0000006 INV000000601 X0000043INV0000006 INV000000602 X0000009INV0000006 INV000000602 X0000010INV0000006 INV000000602 X0000043INV0000006...

Hi all,<br/>I need help. I want to have bookmarks in my report after exporting to pdf format. How to do this?<br/>Using: CR 11 R2, JRC for exporting<br/>Thanks for reply

Hello everyone, Is it posssible when I click the field in main subreport, it will show the subreport... I have five field and five subreport.<br/>Pls. help...<br/>Thanks!!!

Hi Everyone,I have a basic problem, am calculating two fields, which works fine when both have values (0's included), however when there is nothing populated in the field I don't get a result.Therefore how do I default a null to a zero so this can be calculated?Thanks all......