Crystal Reports XI is the latest version of the report writer from Business Objects. Local reports guru David McAmis takes the new version for a spin.

Most developers might know Crystal Reports from versions included in Studio, Visual Studio.NET, and other popular developer IDE's such as BEA Workshop, C# Builder, Delphi 2005, JBuilder, WebSphere.

In this latest installment both report and application developers have something to be excited about as there are a host of new features for report design and integration. Here's a run-down of what you can expect in this release.

DETERMINE STRATEGY

Keep up to date with management and business issues in Strategy

Updated Report Designer
The first thing developers will notice when they first open the Crystal Reports XI designer is a new user interface. The changes to the UI are apparent from the start, with a new -Start Page" that features links to external resources, sample reports, a list of report wizards, and the most recent reports you have been working with.

The toolbars and icons have also been updated and developers who are familiar with Crystal Reports will notice that when you open multiple reports, a new tabbed interface has been included to allow you to switch quickly between open reports. The report designer also features a new -Project Workbench", shown below in Figure 1, that you can use to organise reports into projects and publish these reports en-masse to Crystal Reports Server (which we will look at a little later)



FIGURE 1: The new Project Workbench

The report designer still features the same tools you may have used before. You can use these to insert groups, summaries, charts, maps, running totals, and more into your report with ease. The one new feature that will have developers jumping for joy is the new dynamic parameter fields.

Previously in Crystal Reports, parameter fields were static. So if you wanted to display a parameter field with a list of employee names, for example, you could populate a pick list while you were designing the report. When the report was run, this same pick list would be displayed and the user could make their selection. The only problem with this is when a new employee was added, the list of values did not change. You would have to go back into the report and manually refresh the list yourself. This caused most application developers to create their own custom user interface for passing parameters to the report itself, which was often costly and time-consuming.

With the new dynamic parameter fields in Crystal Reports XI, this custom development should become a thing of the past. When you create a dynamic parameter field in Crystal Reports XI, you can specify a database table, view, etc. as the dynamic source for the pick-lists or you can use an SQL command that will retrieve the values, each time the report is run, as shown in Figure 2.


FIGURE 2: Dynamic parameters in action

In addition, this version introduces the concept of -cascading" parameters, where the values shown in a list of values are determined by your previous selection. For example, going back to our previous example, you could set up two parameters, -Manager" and -Employee". Whenever you selected a manager, the next parameter value list would be filtered to only show those employees who work for that manager.

This flexible approach to report parameters should mean less time coding custom application pages for reporting and more time spent getting on with the application development.

In terms of time-saving features, the updated charting components make it possible to simply insert a chart into your report and let Crystal Reports decide what data and chart type should be created. Often this will not be the final desired result, but it does make it easy to quick pull together visual, information-rich reports without having to click through multiple dialogs to get a simple chart.

This same concept has also been applied to cross-tabs, with a single click all that is required to place a cross-tab object in your report. Unlike charts, there isn't an easy way to automatically select the content for the cross-tab but just the creation of a blank cross-tab is enough of a time saver to make you want to use cross-tabs again.

New Developer Features
For developers, there is a grab-bag of new features regardless of whether you develop in .NET, COM or Java. To start, Crystal Reports XI now includes the ability to store images external to the report file itself. This may seem like a small thing, but it has been a sore point with developers for a while, especially with web developers who want to use Crystal Reports in Web applications but don't want to store the images in the report itself, which could increase the file size dramatically.

In addition, the use of CSS Style Sheets has been better documented in this version, making it a viable option for Web developers who want to integrate reports with the same look-and-feel into their web applications.

For application developers integrating reports into their .NET applications, the viewer components have been updated (Figure 3) and include all of the new features found in the report designer (dynamic parameters, new export formats, etc.). There is a setting to disable tool-tips, which was an annoying feature in previous versions, as most report developers would not enter tool-tips for each element on the report.


FIGURE 3: Updated report viewer

And at long last there is a single merge module you can use to deploy your application, which makes creating installation and setup packages much easier. There has been a renewed focus on this area with this release and it is now possible to setup packages that install right the first time.

On the Java side of things, the enhancements are along the same lines, with the exception of dynamic parameters which didn't make it in time for the first release. However, there are enough new features though to keep most Java developers happy, including a new JavaServer Faces(JSF) Viewer and set of custom JSF tags to cut down on development time.

There are a number of enhancements to the Java API itself, with additional methods that give more control over the data source and location. There is also an updated version of the Java Reporting Component that brings it closer to rough parity to with the other platform API's.

Updated Server Technology
This version of the product not only includes new features, both for report design and application development but also brings together the platform components from Crystal Decisions and Business Objects. Business Objects bought Crystal Decisions over a year ago and this version represents the first -combined" product featuring the tools and functionality from both product lines.

The first immediate benefit for application developers is Crystal Reports Server, which provides a subset of the features and functionality found in Business Objects Enterprise, which is an enterprise framework for publishing reports to the Web, as well as scheduling and distributing reports in a secure environment. And in addition to the subset of features, it is also a subset of the price, at around AU$12,000 for 5 concurrent users.

Crystal Reports Server brings the core report scheduling and distribution framework and functionality to application developers, which they can use to create scalable, multi-tier applications for small to medium-sized user bases. And when scalability to thousands of users is required, there are only minor changes required to use the same code with the full-strength Business Objects Enterprise.

It also bears mentioning that the licensing within both Crystal Reports and related products has been simplified and now is much more competitive with other products in the market. For most internal applications you won't need any additional licensing and if you are developing applications for commercial distribution, there is a free runtime for thick-client applications and simplified process for any components that are licensed and would require a software license.

Summary
So in the end, this release offers a little bit of something for everyone. Report developers will love the new look and feel and features found in the report designer itself, while application developers can look forward to an updated set of tools and technologies to help them easily integrate reports into their application.

Related links

Comments

1

Kelly Pittock - 24/06/05

I am using Crystal Reports Xi with Enterprise and coming from Crystal v10, I find the newer version and the "look" of Xi fabulous.
The dynamic prompts and List of Values is a great feature which I was definitely looking for working with v10 but just didn't have.
I am using LOV's in the actual Business Views which then filter down to the report once connected.
If you haven't upgraded to Xi, you should.

» Report offensive content

2

Shirley Mahendranath - 20/06/06

I just started using CrystalXI and am really struggling to create a dynamic value list that will be used by the users to select a single value. Does anyone have step-by-step information on how to do this. I'm am following the instuctions in the Help but My code is still not working. I would appreciate any help.

» Report offensive content

3

Nandi - 13/07/06

How do I add dynamic tables to crystal reports?

» Report offensive content

4

Deepak Agarwal - 14/07/06

Never seen such a good tool

» Report offensive content

5

Francine - 15/07/06

I do have a problem using crystal XI with an oracle 8i data base which included synonyms. It was working pretty well with crystal 9. Does any boby knows about a hot fix, patch or triCK?

More details:

Crystal Reports XI

Applies to:

Reported version only
ODBC
Oracle 8I

Synopsis

When the owner of an Oracle table opens the list of fields for that table, the fields may fail to appear.

This problem happens when another user, one who doesn't own the Oracle table, creates a private synonym in a schema based on that table. This problem happens only when a ODBC connection to Oracle is used.

» Report offensive content

6

Kevin Burton - 15/07/06

I have the attached VB code. It always throws an exception that no parameters are supplied. In the debugger I notices that there are current values before the SetDataSource and then after the method call the curent values dissapear. I just want to pass three strings as parameters (like a function call) but have not be able to do that yet.

Thank you.

Kevin


            Dim rpt As New QuoteDetail

            Dim disVal As New CrystalDecisions.Shared.ParameterDiscreteValue()



            disVal.Value = "Net 30"

            rpt.Parameter_Terms.CurrentValues.Add(disVal)



            disVal = New CrystalDecisions.Shared.ParameterDiscreteValue()

            disVal.Value = q.FileName

            rpt.Parameter_QuoteFile.CurrentValues.Add(disVal)



            disVal = New CrystalDecisions.Shared.ParameterDiscreteValue()

            disVal.Value = "Me"

            rpt.Parameter_PreparerName.CurrentValues.Add(disVal)



            rpt.SetDataSource(ds)



            rpt.PrintToPrinter(1, False, 0, 0)

            rpt.Dispose()

» Report offensive content

7

Manimaran - 19/07/06

I am new to Crystal Reports Server XI.

I designed reports in Crystal Report, but I need to publish the Report to the Web using Crystal Report Server. Does anyone know how to do this, or can you suggest a book that's good for beginners?

» Report offensive content

8

Neeraj - 04/08/06

I recently deployed a crystal server, but I got some existing business object reports. Is it possible that I can deploy them on crystal report server

» Report offensive content

9

Neeraj - 04/08/06

I recently deployed a crystal server, but I got some existing business object reports. Is it possible that I can deploy them on crystal report server

» Report offensive content

10

praveen - 10/08/06

i have a windows server 2003 machine and i recently started working on crystal reports ,i am trying to logon to Central management server in the repositiory explorer ,gives me an error that my system is accessible but port 6400 is not accessible ...WHAT DOES THAT MEAN..any leads...

D4Eb730

» Report offensive content

11

gopal pandey - 21/08/06

Hi
I am using Crystal reports integrated with .Net 2003 and password protected Access database, I am facing Logon problem and how to create dynamic reports through query or Datatable or Dataset.

I want to make report connection through code, i do not want connection from Database fields, how i will do this through code.

how to get fields dynamically on reports through code.

please any body give reply.

» Report offensive content

12

biljana - 28/08/06

hi
i'm working on an aplication.
i want to input data from other database not from the one i used to create the report.
i tried subreport but it does no good.
the data i need to display is from the inputed data in a form.
thanks in advance

» Report offensive content

13

Mahesh - 29/08/06

I am trying to use the Crystal Reports plug-in that comes with RAD. Need some code sample on how to invoke the crystal report, how to provide inputs to the report and how to export the report as pdf. Any help regarding this is greatly appreciated. Thanks.

» Report offensive content

14

Valentina - 07/09/06

In Crystal Report XI, I try to set DateTime parameter as default with specific time '23:59:59', but it does not accept it.
I was able to do that by using Crystal Report 9.
I appreciate your solution for this problem.
Thanks.

» Report offensive content

15

Ritu - 08/09/06

I have started using Crystal Reports XI. I am trying to display selected values of parameters in the reports. My problem is: If the user has selected multiple values for a parameter, only the first value is displayed. Is anyone aware how to display all the values in a single line?

» Report offensive content

16

anahita - 08/09/06

Hi...
I created a parameter report in Crystal Report 11.Now I want use it in visual basic 6.I want everytime the project runs,asks parameter from user, not with the same value for the parameter.How can I do this?I appreciate you to reply me.Thanks

» Report offensive content

17

G.Srinivasan - 09/09/06

Hai Sir,
I need full details about How to use Crystal Report in vb.net and How to use image in CR
How to pass parameter field

» Report offensive content

18

B.Edwards - 13/09/06

Similar to question 12

I have a report that was created using a Btrieve connection to test data on a local PC.(C:\TESTDATA) I'm "trying" to get the report to use a different path for the data at runtime (Z:\DATA\COMPANY).

Basically the software allows a user to select a database that they work in and I need to make the report read data from the selected location, NOT the location that was set when creating the report.

DOES ANYONE KNOW HOW TO DO THIS?

Thanks for any advice.

» Report offensive content

19

Joshy Ravindran - 14/09/06

Iam using Crystal Reports for Visual Studio .NET 2003. My reports are populated with the data from SQL Server 2000 using stored procedures with single / multiple parameters.

I am able get good reports while running the application on WinXP /SQL server 2000.

But when I am using the application on Win2K3 Stantard /SQL server 2005 , certtain reports are not getting displayed (but certain are working) only getting the ASH color screen (no errors also). I tested the procedures using SQL Server Management Studio and found procedures working fine returning values.

I am on roadblock for past few days , Would be great if any one could help me.

» Report offensive content

20

Rajesh Kumar Verma - 15/09/06

1. I am using Crystal Report XI and I want to add dynamically color.
How to add dynamically color.

2. How to print tree list sub report, means I want in sub report
values should come like tree list and when I want to click on a particular heading, it should populate.

» Report offensive content

21

Ferdinand Ephrem - 26/09/06

Hi,
I created a Crystal Report XI report file that uses several parameters to retrieve data, when i run it using Crystal Report Designer it asks for the parameters on one form. But using it embeded into VB.Net 2003 application will ask each parameter on seperate form due to the VB.net Crystal reports assemblies 1.1, anybody has a solution.

» Report offensive content

22

bobo - 07/10/06

Hi,
I am like the rest of the MORONS above who can't seem to do anything on there own, LIKE READ A BOOK.

» Report offensive content

23

mr - 07/10/06

I am using Crystal Reports XI version (stand alone). I have a mainreport with 30+ subreports. Each subreport will be using a stored procedure. Here are my questions:

1. How to display each subreport on a different page?
2. Some of the subreports takes as much as 10mins to run, in such cases the crystal reports seems to hang. why?
thanks

» Report offensive content

24

Som - 10/10/06

How do I pass parameters from JAVA (Swing) to Crystal Report (.rpt) reporting file ...plzz help me

» Report offensive content

25

aman - 12/10/06

hi. I had taken 2 parameter fields in crystal report 8.5. now i want to pass runtime value to these crystal report throungh VB Form. Please tell me how to pass the value to parameter field. thanks

» Report offensive content

26

Maryl - 13/10/06

i have Crystal Reports XI and it's nice but i have not been able to run my reports from VB.NET (2003).
I have not found a way to make this work.
I need to send a selection formula from the VB application, since there are many ways to select the data.

If I use the CR that comes with .NET then it works (unless i have a logon failed) when i run it in the localhost. Once i put it to the web site, the selection criteria is ignored.

Please HELP!!!!

I would like to be able to use the CRXI to develop the report outside my .net application and just pass the commands needed to run it.

Thanks for your help
Maryl

» Report offensive content

27

Rajesh Kumar - 16/10/06

I have created one .rpt report in Crystal Report 8.0 but I want to run the report thru VB form. Please advise me about the code which will run .rpt file from VB form.

» Report offensive content

28

Dee - 25/10/06

it really frustrates me that I can't find a way in crystal report to add subreports to my group tree so user can pick whatever subreport he want to view instead of going through whole report sections to locate it. How come a great tool like crystal report missed such an important feature for user? They should hire me as a business analyst to design and develop the report tools.

» Report offensive content

29

Phil - 31/10/06

I have bought a few copies of Crystal XI Developer edition. Does this entitle me to use Crystal 8.5 which is no longer available but is the only version that works with my erp software

» Report offensive content

30

Sadaqat - 31/10/06

I want to know how we can pass parameters to sub report using VB.net.

» Report offensive content

31

virender - 02/11/06

search in crystalreport using vb.net

» Report offensive content

32

manamohana - 07/11/06

I have to create Pareto chart and waterfall chart in ASP.net application using crystal report. i tried to find out the charts available in crystal report.i could not able to findout.

if any one knows how to create paretochart using crystal report in asp.net please let me know. i am using vs.net 2005.
if any body having idea can mail me at manamohana.ys@capgemini.com

» Report offensive content

33

sreek - 17/11/06

is there a way to bind HTML tags in Crystal reports

» Report offensive content

34

sudhir - 28/11/06

dear sir

i m student and do project i use aps.net 2005 , oracle 8.0,crystal report XI. pl help me how cn i do the hyper link of my rport in my home page.

what is the code of hpyer liknk of all report

i have no t more idea . pls help me
or send me ebook on asp.net for crystal reportXI
i m eagerly waiting for you.

» Report offensive content

35

ashok - 30/11/06

*i created main report and i need insert a sub report in to this main report please suggest me on this

» Report offensive content

36

monique - 01/12/06

Hello,
What's the difference between Crystal Reports XI and Business Objects XI...(know they merged)...are they different products or is it assumed that when one says "BO XI" they're also referring to CR XI?

» Report offensive content

37

shraddha - 07/12/06

can u tell me how to view only some fields of the crystal report after calling it in vb? at present im able to select parameters but how to select only one particualr field from entire report in vb.

» Report offensive content

38

sadath - 07/12/06

no comments

after ward i will share my code

» Report offensive content

39

smitha - 08/12/06

Hi ALL,
I am using CR 11 DEVELOPER EDITION.Can any one tell me how to use metadata concept in crystal report.Metadata will decide to which data base my report sholud get connected to and what all are the table and fields the report should use.Infact i would ilke to go for a dyanamic report than than static one.
Thanks in advance.
Regards
Smitha

» Report offensive content

40

Uday - 26/12/06

Hi all,

I am a php developer, i want to learn how to generation report using crstal report from php- back end -sql. Any one help me to do that?? i want to learn it step by step.

» Report offensive content

41

Milin - 30/12/06

hi
i m using cr 8
can anyone tell me how to open rpt file from vb code without using crviewer.

» Report offensive content

42

murugan - 03/01/07

hi i want to generate crystayl report by using php and mysql
i don't know how to invoke crystareport from php pls help me
then what code needed for that pls reply me

» Report offensive content

43

murugan - 04/01/07

hi i what to open crstal report from php i am using mysql database in my project so what code need for that pls help me any one know about above things

» Report offensive content

44

Shannon - 06/01/07

Praveen - receiving same port 6400 message on user pc. Did you ever find a resolution to your problem?

» Report offensive content

45

seenivasan - 10/01/07

hi,
i am new to crystal report.
i need some basic knowledge about this.
can u please provide me the materials and documents to know about crystal report.
thanks in advance.

» Report offensive content

46

meiling - 16/01/07

I have install the crystal reports XI to my pc. But after installed the CRIX, my coldfusion server 4.5 cannot run. who have been face this problem before and how to solve it ? Please share it with me.

Thanks.

» Report offensive content

47

mohan - 16/01/07

I want to export pdf data. I m using stored procedure for that.
I have set rpt file to destination .but now its throwing an error "failed to export the pdf data" 

SET @SQL = "select * from dbo '

SET @RPT = '.....\RISK_FACTORS.RPT'

SET @FILENAME = @SOURCE   '.PDF'



EXEC @hr = sp_OACreate 'ExpPDF.File', @object OUT

IF @hr <> 0

BEGIN

EXEC sp_OAGetErrorInfo @object, @src OUT, @desc OUT 

SELECT @hr , 'Error in Creating PDFExport Object...'

EXEC @hr = sp_OADestroy @object

end



SET @PATH = @PATH    '\'   @FILENAME



EXEC @hr = sp_OAMethod @object, 'ExportPDF',null,@sql,@RPT,@PATH,'dsn','username','pwd'

IF @hr <> 0

BEGIN

EXEC sp_OAGetErrorInfo @object, @src OUT, @desc OUT 

SELECT @hr ,@src,@desc, 'Error in Exporting PDF Data...'

EXEC @hr = sp_OADestroy @object

RETURN

END



EXEC @hr = sp_OADestroy @object

SELECT @hr,@FILENAME, @status

RETURN

» Report offensive content

48

Ron Sorrell - 17/01/07

I am working with parameters and allowing mulitple values. Sometimes they work and sometimes they don't. When I run each value separately it works. When I put 2, 3, 4 or more values it doesn't. Any suggestions as to why it does this? I appreciate your suggestions.

» Report offensive content

49

Milan Sompura - 17/01/07

can u tell me how to show crystal report in web form in ASP.NET 1.1

» Report offensive content

50

Ari - 21/01/07

I am a php developer, i want to learn how to generation report using crstal report from php- back end -sql. Any one help me to do that?? i want to learn it step by step.

» Report offensive content

51

herman - 22/01/07

can u tell me how to show cystal report in web using ajax(php)

» Report offensive content

52

Mike K. - 26/01/07

I was interested to know if there is a newer version of Crystal Reports on the immediate horizon? I believe version XI has been out since 2005 and was curious whether or not to expect an updated version anytime soon.

» Report offensive content

53

aysha - 28/01/07

dear sir,

i have a simple report, i need to diplay the list of data in the report with one line as white and the other line in grey. please help me how to do this.

Thanks
Aysha

» Report offensive content

54

Vipul M. Chaudhari - 31/01/07

How would i use Crystal reports in JAVA ???

» Report offensive content

55

chandan kumar - 01/02/07

how to generate crystal report on the system where .net is not installed? i hv a project containing crystl reports. wana to show the crystal report on system where .net is not installed. m failing to do that.

» Report offensive content

56

H&Atilde;&copy;lder Arruda - 06/02/07

hello... i'm new in crystal reports... i mked reports using crystal reports XI. however when i publish this reports in the web using crystal reports server, the dynamic parameters do not work correctlly. if I use infoview configured for java everithing work corectlly except the dynamic parameters that don't show the list of values that i need. if i use the other configurations for infoview the reports don't work. in crystal reports XI the preview show me the reports working corecttly. somene can help-me? please a need urgentlly help. thanks...

» Report offensive content

57

Shiraz Ahmad - 08/02/07

Hi, i m shiraz, i m looking for code for Crystal Report 8.0 or newer Using CreateFieldDef Windows API in VB.net. but i m unlucky to hav it.
Could u plz send me Code Written in VB.net or C#
Thanks,

» Report offensive content

58

Vikas Singh - 14/02/07

I'm Purchase Crystel Report 11, But it Allow Us to Work only on ASP.Net 1.1

Which for ASP.Net 2 , 2005 Edition.

CD Containing SONY Vegas 6

» Report offensive content

59

Zach - 14/02/07

I have also installed the crystal reports XI to my web server. But after installing the program, my coldfusion server 4.5 application server service quits and cannot be restarted until the application is uninstalled. What could be causing this?

» Report offensive content

60

s.lenin - 15/02/07

hi,
i am new to crystal report.
i need some basic knowledge about this.
can u please provide me the materials and documents to know about crystal report.
thanks in advance.

» Report offensive content

61

S.lenin - 15/02/07

hi,
i am new to crystal report.
i need some basic knowledge about this.
can u please provide me the materials and documents to know about crystal report.
thanks in advance

» Report offensive content

62

Christopher David Ward - 22/02/07

Version XI is a 'leap' forward in so many ways. Dynamic tables, functionality and so on. However if you are using barcodes the drop down fonts menu is not 'Human Readable' which means it is a tedious process to find the required barcode. IDAUTOMATION have a native barcode generator and are in touch with B O to remedy problem

» Report offensive content

63

jeni - 28/02/07

Here is an easy guide for deploying a Crystal asp.net web app:
http://www.instantcrystal.net/instantguide.aspx

» Report offensive content

64

jeni - 28/02/07

Here is an easy guide for deploying crystal asp.net web apps:
http://www.instantcrystal.net/instantguide.aspx

» Report offensive content

65

sharat - 01/03/07

Hi,

I have multiple subreports in a report where I want to run only some of the reports at a time based on some conditions. I am using VB code to launch the main report. What should I do to solve this problem? Is it possible to execute only some of the subreports out of all subreport? If yes, can anyone tell me how? Any help would be much appreciated.

» Report offensive content

66

sharat - 01/03/07

Hi,

I have multiple subreports in a report where I want to run only some of the reports at a time based on some conditions. I am using VB code to launch the main report. What should I do to solve this problem? Is it possible to execute only some of the subreports out of all subreport? If yes, can anyone tell me how? Any help would be much appreciated.

» Report offensive content

67

sharat - 01/03/07

Hi,

I have multiple subreports in a report where I want to run only some of the reports at a time based on some conditions. I am using VB code to launch the main report. What should I do to solve this problem? Is it possible to execute only some of the subreports out of all subreport? If yes, can anyone tell me how? Any help would be much appreciated.

» Report offensive content

68

jeni - 02/03/07

50. Ari - If you run PHP on Windows, use Crystal Reports RDC.
Business objects should have some documentation for the rdc.

49. Milan - In ASP.NET 1.1 I would look at Brian Bischof's book here:
http://www.crystalreportsbook.com/
as I recall, it is missing some features like print and some aesthetics.

If you decide to use asp.net 2.0 try this easy guide:
http://www.instantcrystal.net/instantguide.aspx

48. Could it be as simple as using "in" instead of "=" on your report criteria?

» Report offensive content

69

jeni - 02/03/07

48. Ron, Did you change your report criteria from = to in?

» Report offensive content

70

Santanu Bhunia - 02/03/07

How can I pass parameter in Crystal Report From VB.NET 2003?
I want a details procedure, because I am a vovice in this case...

» Report offensive content

71

P.Elangovan - 02/03/07

Private Sub Command18_Click()
Dim mopt1 As Variant
mopt1 = MsgBox("Do you want to Report. ", vbExclamation vbOKCancel)
If mopt1 = vbOK Then
CrystalReport1.WindowShowRefreshBtn = True
CrystalReport1.PrinterSelect
CrystalReport1.Connect = vlogin.vCRcon
CrystalReport1.ReportFileName = App.Path 

a3f6b8

» Report offensive content

72

mitul - 05/03/07

trouble in crystal report, no error but no result found in the report in asp.net, my code is below pls help in this, i want to insert records from sql server and display in crystal report

 Dim dt As New DataTable

        Dim com As New SqlCommand

        com.Connection = con

        com.CommandText = "select distinct r.rid,r.hid,r.rmodule,r.rcompldt,r.rdevid,r.rtransreqno,r.rstatus,r.rcreatedt,r.rlscape,r.rcreateby from tran_reqhdr r,tran_reqhist rh,activity_role a,usr_act_role u,module_auth m,users_data ur where r.rid = rh.rid and r.hid= rh.hid and a.role_id = u.role_id and ur.essid = '"

» Report offensive content

73

sparedes - 08/03/07

I'm complety new in Crystal Reports, need to use existing and new reports in a web app developed with C# 2005 and asp.net 2.0. Can somebody tell me what to do step by step (in my pc during development and in the web server during production) and installations I have to do (if any) in order to show the report in my web app??

I really appreciate any help, comments and suggestions.

Thanks in advance.

» Report offensive content

74

sparedes - 08/03/07

I'm complety new in Crystal Reports, need to use existing and new reports in a web app developed with C# 2005 and asp.net 2.0. Can somebody tell me what to do step by step (in my pc during development and in the web server during production) and installations I have to do (if any) in order to show the report in my web app??

I really appreciate any help, comments and suggestions.

Thanks in advance.

» Report offensive content

75

sparedes - 08/03/07

I'm complety new in Crystal Reports, need to use existing and new reports in a web app developed with C# 2005 and asp.net 2.0. Can somebody tell me what to do step by step (in my pc during development and in the web server during production) and installations I have to do (if any) in order to show the report in my web app??

I really appreciate any help, comments and suggestions.

Thanks in advance.

» Report offensive content

76

suresh - 08/03/07

Hi I have crystal XI, with BO server premium, I have developed a report in which i create table by executing stored procedure which takes two parameters both datetime. I my report I have created three others parameters which are dynamic. Now when I run reports it takes the datetime parameters two time..Please help me to solve this problem.

» Report offensive content

77

vijay - 10/03/07

dear sir
tell me how i can pass parameter in crystal report 8.0 using vb6.0

» Report offensive content

78

Thajul Hussain. J - 10/03/07

I am new to crystal report. is there is any option for incrementing the horizontal pages

» Report offensive content

79

Nas - 13/03/07

Hi,

I have an existing VB.Net application which loads selected Crystal XI reports and passes parameter values to the report from controls on the User's GUI. The code looks at the properties of each parameter field and determines its type, current values, default values etc and presents the appropriate interface to the user for parameter input. I am having trouble accessing or even identifying dynamic parameter lists which I want to refresh and present to the user for selection in a ComboBox or similar. I have several static lists which work fine. Is this a version issue? Are Dynamic ( and cascading ) parameters supported in .NET?

» Report offensive content

80

shamee_banu - 21/03/07

i want to add the SQL in my crystal report how to i do that
please help me

» Report offensive content

81

dubes - 24/03/07

Hi,
I have a situation which requires me to add atleast 45 subreports. Though in all possible scenarios, at most only 20 would be called. Problem i face is, the moment i add these many subreports to a main report, the application crashes.
I read mr's post that he has added 30 sub reports. I have a question, how did you do that... i have not been able to add more than 13 subreports. I know subreports kill the performance, but thats the most i could reduce it to...
Any help is appreciated...

Thanks in advance!

» Report offensive content

82

Apple - 12/04/07

I am a having problem in printing crystal report online.

The web app has been tested on the default website (wwwroot) in IIS - we can view, export and print the report.

Then we create new web site on the IIS and run the web app under a new virtual directory created in the new website. At this point the default site service has been stopped.

Since then, we can view the report but cannot export and print. We can see only the dialog box if we click ok to print / export nothing happen then.

Strange enough, we create another virtual directory on the new site and it lets you print for 2-3 times on some machines. On other machines it does not print then it crashed. Since then, nobody can print any more.

Can any one help? Thanks.

» Report offensive content

83

Pankaj jain - 23/04/07

how can i pass paramter to crystal report control in s 2005 in asp.net at runtime.I have somecombo box in aspx page i want to passs that to crystal report how can i pass at runtime please provide me the code

» Report offensive content

84

Pankaj jain - 23/04/07

how can i pass paramter to crystal report control in s 2005 in asp.net at runtime.I have somecombo box in aspx page i want to passs that to crystal report how can i pass at runtime please provide me the code

» Report offensive content

85

Pankaj jain - 23/04/07

how can i pass paramter to crystal report control in s 2005 in asp.net at runtime.I have somecombo box in aspx page i want to passs that to crystal report how can i pass at runtime please provide me the code

» Report offensive content

86

siva - 24/04/07

Hi I am developing a small project in which i need to generate crystal reports based on fromDate and toDtae in asp.net(2003).

» Report offensive content

87

swat - 03/05/07

Hi,

Am trying to develope an excel report,where in i need to add a cross tab.But as the report is exported in excel fromat all the fields present in the crosstab occupy different cells in the report.So need to find a place holder/container for the cross tab in oredr to restrict the crosstab fileds.....

Any soluiton and suggestion will be of gr8 Help.
Thanks

» Report offensive content

88

Priya - 04/05/07

Hi,
I have a VB application which is used to refresh the reports in BO 6.5. Now I would want to modify that application to refresh the reports in BOXI.
I feel there is some problem with the API.
Can anyone please help?
Please find below the code for the VB application in BO6.5

Option Explicit

Dim temp_system_date As String

'Dim objBusvar As New busobj.Application



Private Const FATAL_ERROR        As Integer = 1



Public Function Refresh(strReportName As String, strRepSource As String, strRepDir As String, Param1 As String, Param2 As String, ctrParams As Integer) As Integer

On Error GoTo error_handler

Dim oBoDoc As Document

Dim strLog As String

Dim boolval As String

Dim t_date As String

Dim p_date As Integer

Static objBusvar   As Object



'Dim objBusvar As Object



App.LogEvent "Reporter called for "

» Report offensive content

89

Rinku Bose - 09/05/07

Hi,
Is it possible to have more than 1 cross tab on single report?
i need to prepare report in which i ve couple of tables, n i think its possible usnig multiple cross tab only, so can u tell me wt to do in this situation?

» Report offensive content

90

pradeep - 09/05/07

How to connect crystal report to vb. Pl, send me the vb code.

» Report offensive content

91

Satya - 11/05/07

Can anyone plz send me some documents regarding ,how to use the crystal report tool in kronos WFC 5

» Report offensive content

92

Madeline Jsvier - 11/05/07

How create PDF report in Crystal reports 8.0 For Visual Basic 6

» Report offensive content

93

Ishmael - 24/05/07

I too am looking for information regarding the use of Crystal Reports within a PHP app. Any help would be welcomed

» Report offensive content

94

Ranjan Kumar Dey - 24/05/07

I am a D2k developer. I have some existing Crystal Report. I want to know how do I call .RPT file from D2k Form.

Please Help me in this regards. If any solution or any code that can run the crystal report from D2k 6 Form than it will save my almost two months of work. Please, if possible help me out.

» Report offensive content

95

hargeet - 03/06/07

I am doing job and I am looking the difference between the standard and professional crystal reports, can somebody suggest me that for a hardware super store which software will be the best plz help?????

» Report offensive content

96

ashokreddy - 19/06/07

I hava a smll problem regarding to the Crystal reports xi.
How can i pass group by(fields) as a parameter(field explorer).
Please give me proper guidelines to solve my problem.

» Report offensive content

97

Somay - 28/06/07

I was using Crystal 9 . My reports was wrking perfectly in Crystal 9 but whebn i migrated to Crystal XI my reports generated exception "Missing parameter values.". Any body has any good idea????

Thanks

» Report offensive content

98

gandu - 29/06/07

sala

» Report offensive content

99

Siddheshwar Nagul - 03/07/07

hello to every one, I have one problem can any one help to get out of this problem. I am not able to call a crystal report through Visual Basic 6.0
I have done it successfully by using Crystal Report 7, but i am facing a difficulty in using Crystal Report XI.
My problem is- when I am trying to add a crystal report control on a form, i am getting an error as "Class not registered".
Could any one help me plz.

» Report offensive content

100

ramesh nakka - 04/07/07

using IIS server we need to generate the reports file and save through cristral report XI . We are able to generate the generate fiel locally in the developer environment. but in client environment the reprot file generated is on 0 bytes. this may be due to some permitions ? can any bady help me.

» Report offensive content

101

Joy Nandi - 19/07/07

can u please tell me how can i show apic into a ole object in crystal report from sql database

» Report offensive content

102

vikram Singh Kandari - 01/08/07

I have problem regarding the deployment of crystal reports in vb.net applications. I used CR 10(default with vs.net 2005).
when I install my app. by setup and try to display/load reports it gives a message like 'report load faied' or 'token key'. pls help me out

» Report offensive content

103

vikram Singh Kandari - 01/08/07

I have problem regarding the deployment of crystal reports in vb.net applications. I used CR 10(default with vs.net 2005).
when I install my app. by setup and try to display/load reports it gives a message like 'report load faied' or 'token key'. pls help me out

» Report offensive content

104

vikram Singh Kandari - 01/08/07

I have problem regarding the deployment of crystal reports in vb.net applications. I used CR 10(default with vs.net 2005).
when I install my app. by setup and try to display/load reports it gives a message like 'report load faied' or 'token key'. pls help me out

» Report offensive content

105

vikram Singh Kandari - 01/08/07

I have problem regarding the deployment of crystal reports in vb.net applications. I used CR 10(default with vs.net 2005).
when I install my app. by setup and try to display/load reports it gives a message like 'report load faied' or 'token key'. pls help me out

» Report offensive content

106

Kam - 09/08/07

I am having problems opening out embedded links for the .pdf file (these files are being generated by the software- Crystal Reports XI). Sometimes the Internet Explorer does not open the links on the first click. Often times clicking repeated on the links produces no outcome either. And at other times it seems to work okay. The client companies are complaining about this issue and wants the problem resolved. I am not sure if this problem is related to Crystal Reports / Adobe/ IE. Is anybody experiencing similar problems or if there is anybody who has a solution to this problem please let me know. I would greatly appreciate your help.

» Report offensive content

107

Kam - 09/08/07

I am having problems opening out embedded links for the .pdf file (these files are being generated by the software- Crystal Reports XI). Sometimes the Internet Explorer does not open the links on the first click. Often times clicking repeated on the links produces no outcome either. And at other times it seems to work okay. The client companies are complaining about this issue and wants the problem resolved. I am not sure if this problem is related to Crystal Reports / Adobe/ IE. Is anybody experiencing similar problems or if there is anybody who has a solution to this problem please let me know. I would greatly appreciate your help.

» Report offensive content

108

Kam - 09/08/07

I am having problems opening out embedded links for the .pdf file (these files are being generated by the software- Crystal Reports XI). Sometimes the Internet Explorer does not open the links on the first click. Often times clicking repeated on the links produces no outcome either. And at other times it seems to work okay. The client companies are complaining about this issue and wants the problem resolved. I am not sure if this problem is related to Crystal Reports / Adobe/ IE. Is anybody experiencing similar problems or if there is anybody who has a solution to this problem please let me know. I would greatly appreciate your help.

» Report offensive content

109

Kam - 09/08/07

I am having problems opening out embedded links for the .pdf file (these files are being generated by the software- Crystal Reports XI). Sometimes the Internet Explorer does not open the links on the first click. Often times clicking repeated on the links produces no outcome either. And at other times it seems to work okay. The client companies are complaining about this issue and wants the problem resolved. I am not sure if this problem is related to Crystal Reports / Adobe/ IE. Is anybody experiencing similar problems or if there is anybody who has a solution to this problem please let me know. I would greatly appreciate your help.

» Report offensive content

110

Kam - 09/08/07

I am having problems opening out embedded links for the .pdf file (these files are being generated by the software- Crystal Reports XI). Sometimes the Internet Explorer does not open the links on the first click. Often times clicking repeated on the links produces no outcome either. And at other times it seems to work okay. The client companies are complaining about this issue and wants the problem resolved. I am not sure if this problem is related to Crystal Reports / Adobe/ IE. Is anybody experiencing similar problems or if there is anybody who has a solution to this problem please let me know. I would greatly appreciate your help.

» Report offensive content

111

Kam - 09/08/07

I am having problems opening out embedded links for the .pdf file (these files are being generated by the software- Crystal Reports XI). Sometimes the Internet Explorer does not open the links on the first click. Often times clicking repeated on the links produces no outcome either. And at other times it seems to work okay. The client companies are complaining about this issue and wants the problem resolved. I am not sure if this problem is related to Crystal Reports / Adobe/ IE. Is anybody experiencing similar problems or if there is anybody who has a solution to this problem please let me know. I would greatly appreciate your help.

» Report offensive content

112

Kam - 09/08/07

I am having problems opening out embedded links for the .pdf file (these files are being generated by the software- Crystal Reports XI). Sometimes the Internet Explorer does not open the links on the first click. Often times clicking repeated on the links produces no outcome either. And at other times it seems to work okay. The client companies are complaining about this issue and wants the problem resolved. I am not sure if this problem is related to Crystal Reports / Adobe/ IE. Is anybody experiencing similar problems or if there is anybody who has a solution to this problem please let me know. I would greatly appreciate your help.

» Report offensive content

113

Kam - 09/08/07

I am having problems opening out embedded links for the .pdf file (these files are being generated by the software- Crystal Reports XI). Sometimes the Internet Explorer does not open the links on the first click. Often times clicking repeated on the links produces no outcome either. And at other times it seems to work okay. The client companies are complaining about this issue and wants the problem resolved. I am not sure if this problem is related to Crystal Reports / Adobe/ IE. Is anybody experiencing similar problems or if there is anybody who has a solution to this problem please let me know. I would greatly appreciate your help.

» Report offensive content

114

Kam - 09/08/07

I am having problems opening out embedded links for the .pdf file (these files are being generated by the software- Crystal Reports XI). Sometimes the Internet Explorer does not open the links on the first click. Often times clicking repeated on the links produces no outcome either. And at other times it seems to work okay. The client companies are complaining about this issue and wants the problem resolved. I am not sure if this problem is related to Crystal Reports / Adobe/ IE. Is anybody experiencing similar problems or if there is anybody who has a solution to this problem please let me know. I would greatly appreciate your help.

» Report offensive content

115

Kam - 09/08/07

I am having problems opening out embedded links for the .pdf file (these files are being generated by the software- Crystal Reports XI). Sometimes the Internet Explorer does not open the links on the first click. Often times clicking repeated on the links produces no outcome either. And at other times it seems to work okay. The client companies are complaining about this issue and wants the problem resolved. I am not sure if this problem is related to Crystal Reports / Adobe/ IE. Is anybody experiencing similar problems or if there is anybody who has a solution to this problem please let me know. I would greatly appreciate your help.

» Report offensive content

116

Kam - 09/08/07

I am having problems opening out embedded links for the .pdf file (these files are being generated by the software- Crystal Reports XI). Sometimes the Internet Explorer does not open the links on the first click. Often times clicking repeated on the links produces no outcome either. And at other times it seems to work okay. The client companies are complaining about this issue and wants the problem resolved. I am not sure if this problem is related to Crystal Reports / Adobe/ IE. Is anybody experiencing similar problems or if there is anybody who has a solution to this problem please let me know. I would greatly appreciate your help.

» Report offensive content

117

Kam - 09/08/07

I am having problems opening out embedded links for the .pdf file (these files are being generated by the software- Crystal Reports XI). Sometimes the Internet Explorer does not open the links on the first click. Often times clicking repeated on the links produces no outcome either. And at other times it seems to work okay. The client companies are complaining about this issue and wants the problem resolved. I am not sure if this problem is related to Crystal Reports / Adobe/ IE. Is anybody experiencing similar problems or if there is anybody who has a solution to this problem please let me know. I would greatly appreciate your help.

» Report offensive content

118

Kam - 09/08/07

I am having problems opening out embedded links for the .pdf file (these files are being generated by the software- Crystal Reports XI). Sometimes the Internet Explorer does not open the links on the first click. Often times clicking repeated on the links produces no outcome either. And at other times it seems to work okay. The client companies are complaining about this issue and wants the problem resolved. I am not sure if this problem is related to Crystal Reports / Adobe/ IE. Is anybody experiencing similar problems or if there is anybody who has a solution to this problem please let me know. I would greatly appreciate your help.

» Report offensive content

119

kam - 09/08/07

I am having problems opening out embedded links for the .pdf file (these files are being generated by the software- Crystal Reports XI). Sometimes the Internet Explorer does not open the links on the first click. Often times clicking repeated on the links produces no outcome either. And at other times it seems to work okay. The client companies are complaining about this issue and wants the problem resolved. I am not sure if this problem is related to Crystal Reports / Adobe/ IE. Is anybody experiencing similar problems or if there is anybody who has a solution to this problem please let me know. I would greatly appreciate your help.

» Report offensive content

120

David Ward - 21/08/07

*
Crystal XI Bar Codes
Formatting Bar Code Fields. When using the pull down menu in XI the bar codes, of which I have about 60 are not 'human readable'. The only way to interpret the bar codes is to start a report in an earlier version (say 9 or 10) and format until scan successful then open the report in XI and continue. Surely there is a better way???
Posted to Crystal Reports (Forum) by wardroom on August 16, 2007

» Report offensive content

121

David Ward - 21/08/07

*
Crystal XI Bar Codes
Formatting Bar Code Fields. When using the pull down menu in XI the bar codes, of which I have about 60 are not 'human readable'. The only way to interpret the bar codes is to start a report in an earlier version (say 9 or 10) and format until scan successful then open the report in XI and continue. Surely there is a better way???
Posted to Crystal Reports (Forum) by wardroom on August 16, 2007

» Report offensive content

122

David Ward - 21/08/07

*
Crystal XI Bar Codes
Formatting Bar Code Fields. When using the pull down menu in XI the bar codes, of which I have about 60 are not 'human readable'. The only way to interpret the bar codes is to start a report in an earlier version (say 9 or 10) and format until scan successful then open the report in XI and continue. Surely there is a better way???
Posted to Crystal Reports (Forum) by wardroom on August 16, 2007

» Report offensive content

123

David Ward - 21/08/07

*
Crystal XI Bar Codes
Formatting Bar Code Fields. When using the pull down menu in XI the bar codes, of which I have about 60 are not 'human readable'. The only way to interpret the bar codes is to start a report in an earlier version (say 9 or 10) and format until scan successful then open the report in XI and continue. Surely there is a better way???
Posted to Crystal Reports (Forum) by wardroom on August 16, 2007

» Report offensive content

124

David Ward - 21/08/07

*
Crystal XI Bar Codes
Formatting Bar Code Fields. When using the pull down menu in XI the bar codes, of which I have about 60 are not 'human readable'. The only way to interpret the bar codes is to start a report in an earlier version (say 9 or 10) and format until scan successful then open the report in XI and continue. Surely there is a better way???
Posted to Crystal Reports (Forum) by wardroom on August 16, 2007

» Report offensive content

125

DAVID WARD - 21/08/07

*
Crystal XI Bar Codes
Formatting Bar Code Fields. When using the pull down menu in XI the bar codes, of which I have about 60 are not 'human readable'. The only way to interpret the bar codes is to start a report in an earlier version (say 9 or 10) and format until scan successful then open the report in XI and continue. Surely there is a better way???
Posted to Crystal Reports (Forum) by wardroom on August 16, 2007

» Report offensive content

126

DAVID WARD - 21/08/07

*
Crystal XI Bar Codes
Formatting Bar Code Fields. When using the pull down menu in XI the bar codes, of which I have about 60 are not 'human readable'. The only way to interpret the bar codes is to start a report in an earlier version (say 9 or 10) and format until scan successful then open the report in XI and continue. Surely there is a better way???
Posted to Crystal Reports (Forum) by wardroom on August 16, 2007

» Report offensive content

127

Selvaraj - 06/10/07

I am using Crystal Report Desgined in CRXI and using in VB.NET VS 2005. I want to Export Report to Text File (ASCII) from Front End (VB.NET), I need Crystal Decisions.Shared.dll for CRXI, but i am getting only dll for 10.2, where can i get this dll ? / any other suggestions for this problem.

» Report offensive content

128

Jeeva - 10/10/07

Pls Suggest me can i use cr xi effeciently and effectvely with asp.net 2005 with out any error, prefer me which is best cr 10 or cr 11.

waitng for the suggestion.

with regards,
Jeeva.

» Report offensive content

129

chitra - 02/11/07

I have some 3000 crystal reports. I want to prepare a report catalogue for these reports...Is there any APIs to extract the metadata information. or can anyone tell me the location of metadata.

» Report offensive content

130

Amit Srivastava - 06/11/07

I have a problem.. I have created a crosstab report and now i want to merge cells that have same value.... Could anyone give me some idea.?

Thanks in Advance

» Report offensive content

131

santhosh - 14/11/07

hi i m santhosh i have been worked in crystal report 9 and i have passed the parameter in codebehiend but the record has not displayed anybody help me

» Report offensive content

132

chitra - 19/11/07

Is there any complex functionality difference we will face when migrating CR9 report to CRXI

» Report offensive content

133

Sonali - 13/12/07

I need to know what is to be done for deployment of crystal reports 11 when using Visual Studio 2005

» Report offensive content

134

Tommy - 14/12/07

I'm trying to create a single piped output lind that contains multiple order lines. There are multiple order lines, but I need for them to display all on the single line for exporting into another app.
example:
John|Doe|9983|6271|0933|
Mary|Smith|8922|8211|2231|

» Report offensive content

135

Sankar Mishra - 29/12/07

Hi,
I want to connect my sybase stored procedure to crystal report so that the output must come in a .rpt file.How this thing can be done??????? If anybody can help me then it would very helpful for me
Sankar

» Report offensive content

136

PD721 - 29/12/07

I want to use 2 or more crosstabs in Crystal report. Can i do that. Also I want to add table in details section (not the header or footer). How can I add a table (or a list as in Cognos) in design view. Any help will be appreciated.

» Report offensive content

137

Jay - 04/01/08

Hi,

I have created a report using the bundle crystal report in VB2005. In my report, i used stored procedure as my data source and it's directly accessed by crystal report via ODBC. Now, i have a field w/c is an Image data type that i want to display in my report but it display only two character and not the image i was expecting. I already tried searching the web but can't find a solution. Most of the solution is using ado.net then they populate the image to array and stored to dataset. I don't want to use a dataset for this. Is't posible or is there any other solution so i can display the image in my report w/o using the dataset?

» Report offensive content

<