crystal-reports

Crystal report create connection to OLE DB database

I am working with VS 2005 and using visual basic for coding. How do I set up the connection object for my crystal report using vb code. I have written some code Dim strcon As String = ConfigurationManager.AppSettings("PhdConnectionString") Dim getconn As SqlConnection = New SqlConnection(strcon) Dim rpt As ReportDocument = New Report...

ASP.NET Crystal Reports Export PDF to IE6 issue

Thank you for taking the time to read my post. All works fine in FireFox 3.5. I'm having a problem with my ASP.NET 3.5 web application. When I use the ReportDocument.ExportToHTTPResponse IE6 shows the following: %PDF-1.7 %âãÏÓ 1 0 obj << /Type /Catalog /Pages 2 0 R /PageMode /UseNone /ViewerPreferences << /FitWindow true ...

Transferring Crystal report

I have created a crystal report in VS 2005 using the wizard. In the report I have created an OLE DB connection to a server which has a database 'student'. Now I need to run this report on another computer which has the same database but a different server name. How do I change the connection settings for this? Please help. ...

How can I insert page breaks between groups in Crystal Reports with two-sided printing?

In group expert options I have set Keep Group Together, which makes sure a new page is set. With two-sided printing enabled, how can I make sure that a new group always forms on a new sheet of paper? Can this be done in the formula expert? Is there some way of checking if the page I'm on is even or odd and insert a page from there? Just...

Performance Issue when setting connection information Crystal Reports

I have developed a method that sets the Crystal Reports Connection. This method first grabs the connection string from the config file creates a Crystal Reports ConnectionInfo object. The following code then takes over 5 seconds to run: Dim myTables As Tables = report.Database.Tables Dim myTableLogonInfo As TableLogOnInfo = New TableL...

Crystal reports and stored procedures

I'm new at Crystal Reports and still learning so I'm wondering how I should do this. I have the following stored procedure: CREATE PROCEDURE GetSurveyAnswerDetail (@Question VARCHAR(255) = NULL, @AllowReportFlag CHAR(1) = NULL) AS SET NOCOUNT ON DECLARE @rc INT SET @rc = 1 IF (@Question IS NULL OR DATALENGTH(@Question)...

Crystal Reports: How to hide a group in a grouped report?

I have a report grouped by Class1, Class2, Class3, ShortDesc, CreateDate. It looks like this: Class1 Class2 Class3 <- This is GroupHeader1 (I did it this, way to save space) ShortDesc - test1 <- This is GroupHeader4 27.07.2009 10:00 <- This is GroupHeader5 Ticket-ID AssignedGroup 1 <- this is Detail 2 3 27.07.2009 ...

Crystal Reports.NET problems accessing FieldObject for page count

Hi, We're using Crystal Reports.NET that was bundled with VS2005. We have a confirmation booking form letter report that we want to batch print. Generally this prints one page per person on letterhead paper, however occasionally if they've booked lots of courses the letter rolls over to two pages. The second page should not be printe...

Crystal Report XI trouble with big XML data file

I have a big xml file (65 Mo) that I need to feed to a Crystal Report XI. My problem is that I tried running the report and it takes forever to display a single page (about 15 minutes a page). I still cannot see the end result since I am not patient enough to wait 15 days to get the full report. My total report should be around 1500 pag...

Crystal Report Sum()?

hi, This is Ramesh I have to crystal report, in my report i need to make Add and Sum, two field Using Add done it that field created ad Add,i want this Add field sum end of row what should i do? anybody help me.. ...

Problem with Crystal Reports

Hi I have a problem with Sum fields in Crystal Reports, under VS 2003. I am using VS 2003 and Crystal Reports to generate a report with data retrieved from a SQL Server 2000 database and kept during runtime inside a strongly typed dataset. The dataset contains several tables, one of which, the orders table, receives the results of a SQ...

How to Hyperlink to a Business Objects Report in Infoview

Is there a way to craft a hyperlink that connects to a Crystal Report or Webi within Infoview? Ideally, unauthenticated users would be challenged with Infoview security and then redirected to the report. Thanks! ...

Crystal Report SQL Statement Generation for MS SQL

If you create a Crystal Report using the built in wizard, tables are linked, etc. What determines whether a parameter makes it into the actual SQL statement? Also, why does it enclose everything in double quotes? For example: Here would be my base SQL Statement as generated by CR: SELECT "poitem"."fpono" , "pomast"."fcompany" ...

Crystal Report TextBox

Hi, I am working on crystal report, i need to pass value(from Winforms) to crystal report Textbox control's like Period:10-11-2009 To 13-11-20009 this value I want pass for crystal report textbox control advance wishes... ...

Doubt in using crystal report in VB6.0

Hi, I'm using Crystal Reports in my VB6 project, but I'm facing error while loading the report in crystalreport1.action=1; Please give me some solution for this problem. It is showing the error as Error in 20728-F. I am attaching the code below. So please reply to my query... cryStockReport.ReportTitle = "Total Stock Report" cryStockRe...

show total number of records at the end of the page

Hi, I would like to show total number of records of at the end of the page using crystal report. Could you please help? If there are no records I would like to display the count as 0. Thanks, ...

How To use a stored procedure in a crystal reports 8.5?

Hi all.... I have to make a new report using crystal report8.5 . I have created a stored procedure in SQL Server 2005. The stored procedure has one input parameter. Now I wanna to know that how I can add that stored procedure and show its result in my report while designing that report? thank you ...

Adding Crystal Reports support into LAMP product

We have a newly documented feature request, from sales and support, to integrate Crystal Reports into our LAMP product. (It's more like LAPP, really, with Postgres and PHP.) I have to admit, although I've heard about it from time to time, I've never even seen Crystal Reports in the wild. But the buzz is that it will help sales tremend...

How to split a Crystal Reports subreport across a page break?

I'm using Visual Studio 2005 and writing in VB.NET. I have a subreport in a Crystal Reports report consisting of a list of log entries. Sometimes the list of log entries is long enough that it would extend onto the next page. What I see happening is that the list appears on the next page, leaving a big blank space at the bottom of the...

1099r IRS form in Crystal Report

Hi, we need to generate 1099r IRS report from the application and we have decided to develop this with crystal reports. i am just curious to know that anyone did this crystal report and if so, could somebody pass your report templates. http://docs.google.com/gview?a=v&amp;q=cache:vzIPLclgiugJ:www.irs.gov/pub/irs-pdf/f1099r.pdf+1099r&am...