crystal-reports

Crystal Report DB authentication in java

Dear All, I'm facing a problem in Crystal Report with Eclipse. I am using a servlet to render the crystal report viewer by writing the viewer object to the response like: public class ReportViewer extends HttpServlet { @SuppressWarnings("deprecation") public void doGet(HttpServletRequest request, HttpServletResponse response) ...

Trying to pass Parameters to Crystal Reports

I am trying to pass parameters from Visual Studio using VB.net to a Crystal report. I am using the following code: Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click If IsDate(MaskedTextBox1.Text) Then Dim report As New invoice4 report.SetParameterValue(0, gC...

How to redistribute Crystal Reports for VS2005 to Vista?

I have a WinForms app built using Visual Studio 2005, including the crystal reports that comes with VS2005 to run and view reports. My installer uses the merge module CrystalDecisionsRedist2005_x86 to install Crystal. This all works well until I try installing on Vista, when I get errors registering the Crystal dlls. It seems this is a w...

Crystal XI R2 Server SP5...which msi file?

Since the support for BO and Crystal pretty much stinks when it comes to finding an answer I thought I'd try to post this here. We are having some issues with Crystal Reports on the server and I wanted to patch it up to SP5. I finally found a download (and even then I'm confused whether to use the SP5 or FP 5.2, so I guess I'll put SP5 o...

How can I call a stored procedure from Crystal Reports?

I have a stored procedure that takes a user ID and calculates their balance with a really simple query and returns it. I want to add this to a crystal report in my application. The only problem is, Crystal Reports wants me to set a value for the procedure, and setting a single value for it would be useless to me. I have everything group...

How can I use more than one Stored Procedure in a crystal report?

I have two stored procedures I wish to use in my stored procedure, but once I do that it fails to load with the error: "Invalid Argument provided, no rowset retrieved." If I remove either one of them it starts working again. I have the crystal report set up something like this: Report: Group By Tenant.ReferedBy stored proc here t...

How do we properly configure local dev boxes using Visual Studio 2008 to deploy onto a server running Crystal Reports XI Release 2 .Net 2005 Server?

In our scenario, a developer builds the web app locally and then we place it out on the application server. Recently, projects have been upgraded to Visual Studio 2008. We have been having issues (such as the print control not functioning properly) and I want to see if they are related to the merge modules (or whatever else). My first ...

Multi targeting in vs2008 with crystal reports

Is there a way to make VS2008 work with the old (vs2005 crystal reports) assemblies and not require any updates to be installed in the client machines? We have upgraded a Visual Studio 2005 .net 2.0 solution to Visual Studio 2008. The purpose is to take advantage of the IDE improvements and because it supports multi targeting. The sol...

Localized Crystal Reports

What is a good method to localize labels (column headings, field labels, headers/footers, etc) on Crystal Reports? We are currently on XI R2 SP4 but are looking to migrate to 2008. It looks like 2008 offers better localization of the viewer UI. Does it have a content localization story? ...

Database login prompt when clicked on subreports

I have a report and when clicked on link subreport i get Database login form.I have given all the necessary connection strings but still it asks for login info.sub reports opens in my local system but when installed in Client system i get this problem. what am i missing or what should i do ? ...

What version of Crystal Reports is distributed with VS2008?

I'm trying to figure out what version of Crystal Reports I have. It's the one that comes in Visual Studio 2008. Does anyone know what it is or how can I check? ...

Using the old CrystalReports ActiveX control 'Crystl32.ocx'

I'm working on an application that is about 8 years old, and it uses version 8.0.0.4 of the Crystl32.ocx file for viewing reports. The issue is, when I go to view the report, it shows a parameter screen, that the user can CANCEL from. But, if you click CANCEL, the report window STILL opens, and shows a report with no data... (Or data ...

How can I convert an Access Report to a Crystal Report?

I have Access 2003, and Crystal Reports 10 (the one that comes with VS2008 Pro). How can I convert the access reports into Crystal Reports? It doesn't have to be perfect, just anything to lessen the load on me. ...

Load report failed in Windows server 2003

I have an asp.net application,in which crystal reports is used.When i click on show button i get an error stating "Load report Failed".Application works fine in my local system.i also tried using report.close() and report.Dispose() but no luck.have also set permissions but still same problem.Can any one help me out. ...

Removing Brackets and Text in Crystal

I am using this following text to delete brackets and text inside the brackets; I need to go threw the entire memo field and it stops after it finds and deletes the first set of brackets and text. if right({table.col},1) = "]" then left({table.col},instr({table.col},"[")-1) else {table.col} Any suggestions... ...

Is there a way to nest one of these (Crystal Reports)

I need to use these two formulas for one field. Can someone help me combine them? stringvar input := {tbl.col}; stringvar output := ''; numbervar i; input := Trim(input); for i := 1 to Length(input) Step 1 do if not(input[i] in [Chr(13),Chr(10)]) then output := output + input[i];output; if right({tbl.col},1) = "]" then le...

How can show amount in words in crystal report !

Hello, I m working on windows form application. I need to show amount in words in crystal report. How can show amount in words in crystal report ? ...

How to find the version of a Crystal Report rpt file?

I have a Crystal Report file from an old version (unfortunately I don't know and cannot find out easily which version was used) and I need to do changes in that RPT file. I would like to find out which version is the RPT file so I can install the proper version of the editor. If I install the all new and latest version, when I save the ...

ReportViewer vs CrystalReport .NET

Hi, I am looking for some comparisons between CrystalReport and ReportViewer. Pros and Cons, and why I should use one over the other. Has anyone stumbled upon such an article? Or have some experience with both? Thanks. ...

crystal report database

I am storing my database in the APP_DATA Folder of my application. I added crystal report to my application. I mentioned .\SQLEXPRESS as my server. In database drop down i see only these databases -Master, Model, msdb, tempdb My dabase's name is "Database.mdf" . Why i am not able to see it ? My connection string is : Data Source=.\SQ...