I wanna be creat a table of contents for Reports. so plz give me a suggestion how to create a table of contents in Crystal Report 10.0. We are using ASP.net as a front end and Sql Server 2005 as a backend. For generating report, I am using crystal Report 10.0. I have require item # which if formatt...

Can some one tell me the difference b/w Creating Command and Using Report wizard with Select Expert.<br/>I m talking about Report performance.<br/>Which one is best.<br/> Creating Sql Command or Use Select expert to load Data.

Can some one tell me the difference b/w Creating Command and Using Report wizard with Select Expert.<br/>I m talking about Report performance.<br/>Which one is best.<br/> Creating Sql Command or Use Select expert to load Data.

Hi,<br/>I have what is hopefully a simple question:<br/>How do I convert a database value of 1 or 0 to a Y or N so it is displayed as such in the report?<br/>I am using CRXI.<br/>Thanks!<br/>jb

When there are truly no records present that would normally show for a specific group, the group header doesn't show up on the report. As the default, I understand that things are working correctly when this happens. Now, how can I force the group header to show anyway? Is it as simple as an IF...

in crystal report 9, need to suppress header section from printing if Details section of the report is blank (field in detail section is empty). How?.

Hi All,Really need advise and help out there!I'm using CR11 with SQL d/b platform. I did manage to publish the report via web. But have some issues here:1) Can I enable user to choose which paper size to print? How?2) Is it possible to allow user to specify the sorting order in the report? How?...

Hello everyone,<br/>I need to build a Java interface for JSP to interact with crystal reports.<br/>Could anyone recommend any book or forward me the url's where I can find the related material with examples.<br/>Eagerly Waiting for reply!<br/>Thanks,<br/>Prathima.

CR XI posted a work-around/solution for inserting a row title in a cross tab report by creating a separate "fake" group, overlaying it and copying the cross tab to the fake group's section. It also discussed horizontal pages.How do you repeat the label on subsequent/multiple pages though?...

Hi, there,Is there anybody here who is working with data warehouse with Crystal Reports as a tool? Would you please share some experience with me?I used to work with Oracle reports. It seems to me that Crystal needs to bring all the table data back to client before I may link the tables to get query...

i am using crystal report application in visual studio .net. Now, I make one crystal report, has 5 groups. Now, I want to change their order from VB .net application. What to do for that?? I'm new in crystal report.

I have problem to remove Decimal Places. I have formula and Summary field which sums integer numbers, but they appear in this format 9.00. If I use Crystal Report Designer I can fix this by using Format Field->Number but I want to do this programmatically.

Hi,I'am new to Crystal reports,I created a formula based on that i have to fetch column value from databasefor that i wrote a very simple query in SQLCOMMANDas SELECT <TABLE.CPLUMN> FROM <TABLE>WHERE <TABLE.OTHERCOLUMN>='@CRYSTAL REPORT FORMULA'when closing the comm...

Hi!I have a report with sale lines grouped by date. Every line has the ClientCode, Kilos, Price, and LineTotal.The question is as follows: How is the formula that I need use to have the Kilos sum just for the customers with ClientCode 9000 in every date group.Would be possible perform this without...

CR 10. Recently we are bring up some reports through web (ASP), it works for first few times but it then having vbscript error, as follows:Microsoft VBScript runtime error '800a01ce'The remote server machine does not exist or is unavailable: 'session(...).OpenReport'/Reports/repo...

Hi All,I am new in Crystal Report.net2005.I have used VB.net Application, Access 2003 as back end database.I am using dataset for viewing crystal report.My prob is that:For th first time my reports are taking too much time to show.But the next time it's not taking so much time.It's happeni...

Hello, I am new to Crystal Reports so any help would be greatly appreciated! I have a report that counts incidents for each hour in a 24 hour period. When I graph the results, the first line is wrong, but the rest of the graph is correct. I don't understand why the first line is not charting...

it was a Report with 1 parameter where {t.field}={?param1}and 1 parameter with 'allow multiply values' had join({?param},",") - I will call it {@param123}.Record selection had :{t.field}={?param1} and{t.field123} in split({@param123},",")****************Request happened that I add tons of...

Hi, I'm new to using crystal XI. I need to make a summary report for investors. Basically I need to have a "chart" for each investor in different funds summarizing different fields. I'm able to create the chart for each field for each fund in the report header. But I am unable to have 1...

Hi allI have added crystalreportviewer using ASP .net (VB .net)I was able to view the report when I run the web page onmy server. Everything seems fine on the server.However, if I access the crystal report on a client machine,it will prompt for guest login and password to the server machine.I am usi...

Dear Anyone, I'm experiencing an error in printing my report in crystal using unbound fields. The initial printing is fine. But when I exit the crystal report screen and try to reprint the report, this error message pops up "This field name is not known." I've been working on...

Hi !I've an table which have 32 Columns. Table will Normally have 15 records. Because in A-4 Size paper 32 Columns cannot appear in single partition. I want to make double partitioned report which contains 16 column with 15 records in upper portion & remaining 16 columns and records in lower h...

Hi all,Must we install Crystal Report server before we can read crystal report on ASP .net application viaweb browser within local intranet.Can a client machine access Crystal report on local server that do not have Crystal report server installed via web browser.Regards,Curious...

how to incorporate data from more than one table(having no relation) in detail section of crystal report 9...

Hello,I have a report that I have put in Crystal Enterprise so that users can go and run the report as necessary. The report has 3 parameters that the users will choose when they run the report. One is a location, the other is a date (picks from a calendar), and the other is a boolean to choose if...

Hello,I've got a subreport and a main report. The subreport is placed twice in the main report. I've placed the report in two detailsections.The first is the original and the second is the copy. Both are excatly the same. I need to supress a string in the first subreport and another in the...

Hi I am using VB.net and new verson of crystal Reoprt but I am not able to Print the rtf data which contains pic/ objects

In Crystal Report,how can we check the number of records are returned from database.<br/> I need to check the no.of record are returned.i want to print specific string for eg.(No. Records to Print) to user on the basis of no of records.

Hi to all,I am new to crystal report,Kindly help me .I am Using Crystal report XI with ASP.Net.I am populating my report using Sql Query, and my query is providing only relevent data only.When my report is accessible by multiple user it become very slow,how to speed up it, Pls provide me proper sol...

Hi !I've an table which have 32 Columns. Table will Normally have 15 records. Because in A-4 Size paper 32 Columns cannot appear in single partition. I want to make double partitioned report which contains 16 column with 15 records in upper portion & remaining 16 columns and records in lower ha...

HiI am trying to run a web application which is done using asp 3.0 which uses crystal reports 8.5 for reporting. I am not able to view the report in the browser, it is just showing the Crystal reports viewer control.Please help me in trobleshooting this...Thanks,R.K.T. Ashoka...

Dear All,<br/> Where can I found information to draw Graphs using Crystal Reports<br/>Thanks In Advance<br/>Dan

I have to sum up 3 coulmns and display it as a 4th column. How do i do this in crystal reports. I am using version 10 and i am new to crystal reports. any help is appreciated.

Can anyone help me in finding a good crystal reports 10 manual which gives step by step procedure for creating simple and complex reports. Thanks in advance

Hello all, we currently run Crystal Reports 8.5 here at work. Every week around the same time the whole system seems to fall over. A restart of the iis seems to fix the problem but I am endevouring to get to the bottom of the issue. I have pasted the problem below: For those of you experts who could...

Ok, ill start from the start.I have a standard field from a database in my report. the field records numberical data, but records five numbers in the same field, eg the field looks like this: -2.0, 1.3, -1.1, 3.6, 4.1. I wanted to average these values, so I wrote 5 formulas, each one extracting one...

I have a formula that supresses the page footer after the first page. However, I had hoped that the detail section would take that area on the next page, but it isn't. It's like it is still reserving the space for the page footer - it's just not printing it.Is there some option I am n...

I am using VB6 to programmatly create excel files. I have a working crystal report. I can export to Excel (file) correctly for Crystal. When I try to have crystal creat the excel files from VB I get an error message: Run-time error'-2147417848 (80010108)': Method 'Action' of o...

Hi,<br/>I am needing to know as uninstall the Crystal Reports 9 and RAS 9 correctly.<br/>I am needing to know information as:<br/> which registers I must exclude.<br/> which values of register I must modify.<br/> which dll's I can exclude.<br/>Thanks.

Hello, I am using Crystal Report 8.5, Visual Basic 6.0 and Microsoft SQL Server 2000/2005 ( Database Server is on another machine in Network not on Local machine ). I have problem in Reports. There are two situations for this.1. If there is a machine in the network, that is not the part of domain an...

I have a windows app which uses the free version of Crystal Reports. The idea is that I should allow the users to choose their own font and colors (for example one might want to see the title green and arial). Do you happen to know how I can do that? I don't even know if it is possible given th...

Hi,<br/>I have newly joined a company, here t hey are using crystal reports 8.0<br/>Plz can any one send me the url to get help on crystal reports 8.0<br/>regds,<br/>nittu

Crystal Reports were designed using the Seagate Crystal Reports Developer Version 8.5.3.975.The reports does designed are published in the Seagate Crystal Enterprise 8.0.2.6725 across the web.When we try to the export these reports from the Crystal report viewer of the Crystal Enterprise it throws...

I have a VB6 package that uses CR 4.6 and has installed successfully on numerous PCs under all versions of Windows (97 to XP). Now I when I run the package on my new laptop and try to print a report, I get error error 2147417848 - disconnected from client. Moreover, although the CR report designer...

Is there some sort of Crystal Reports Standards Document?

My Subtotals/Totals are not working correctly. I have Crystal Reports 8.5.I have an invoice listing, and want a Subtotal of the Payment Amount (AR6-TransPaymentHistory.TransPaymentAmount). But, the automatic subtotal feature is doubling it. Any thoughts on why this happens. Only Transaction Types "P...

I have been tasked with taking over a Crystal XI Enterprise installation that uses the Everyone group to grant view access to all objects/folders. Where do I turn this off globally? In other words, I want the Everyone group to have no access rights to anything - so I can use created groups to admi...

Hello,I have VS 2005 and using the crystal reports that come with VS 2005."The type initilizer for 'CrystalDecisions.CrystalReports.Engine.CRPE' threw an exception"I have some reports that worked fine a few weeks ago. And now I am getting this error with I never used to.It can't be an...

Two questions:1) I want to display date in a date parameter field as 'YYYY-MMM-DD' format i.e '2007-JAN-20' .But its not letting it convert to desired format.As soon as i type this date in default value of parameter,it changed it to 2007-01-20.Any ideas?2) Another question reg...

Dear All,<br/> I am displaying the datas from sql database.It is asking username and password for each time.How can avoid this One?<br/>Thanks In Advance<br/>Dana