I have a command line utility that generates one simple crystal report. I recently updated the project from .NET 1.1 to .NET 3.5 using the Visual Studio 2008 migrator and am now getting an error that I had never received before. The problem is in the work_order formula which is as follows: stringVar nvl_ship_wrk_id := "0"; stringVar n...
Hi, following Problem. I am generating my Reports with Crystal Reports from a Database, CR gets a DataSet as DataSource. I have a Table like this one in my DataSet: ... | Rank | Comment | ... ----+------+---------+----- ... | User | blabla | ... ... | VIP | blublu | ... so I have the same Rank and Comment field twice in my Report,...
I'm debugging issues from some CrystalReports documents through Visual Studio '08 (please, kill me now). In addition to the CrystalReports .NET libraries containing some of the worst interfaces I've ever seen, the web viewer for CrystalReports seems to behave strangely while debugging. Unlike regular .aspx pages, the CrystalReports docum...
Is there a function or any way I could print the username of the user taking the print out of a report in CR 8.5?? This could be the windows user name or user name pertaining to a system like IFS where the reports are being generated from. ...
I have Crystal Reports XI on my local machine and the server has version 10 I guess. When I tried to update the reports locally, before it saved, it warned me of the higher version overwrite. I said "continue" thinking that the server version would be upgraded as well to support the latest version. It turned out that the server version ...
How to open the sql data base in crystal report? Using VB 6, SQL server 2000, Crystal Report 8.5 My code. CR.DataFiles(0) = App.Path & "\Database\DUAL_ACS.mdf" CR.ReportFileName = App.Path & "\rpt_attendancereport.rpt" CR.Action = 1 But it showing “Cannot Open Sql Server” What wrong in my code. Need VB 6 code Help? ...
Hi All, I have a crystal report which when generated has a last page that is blank except for the page footer (which indicates the current page, as well as the report title). This only occurs when the data displayed on the second last page completely fills the page. Would anyone have any ideas as to why this might be? Thanks in adva...
I am using crystal reports (the version that comes with visual studio 2008) to generate a pdf in an asp.net which then gets pulled into a client's browser. Some of these reports are on legal size paper. This means that for these reports our clients have to manually change the paper size in the print dialog every time they print. Of co...
The following line in my crystal reports formula is giving the error: NumberVar sales0405 := Sum ({sp_YES_AccountSnapshot;1.ST0405_Ext}, {sp_YES_AccountSnapshot;1.Cust}) + Sum ({sp_YES_AccountSnapshot;1.DR0405_Ext}, {sp_YES_AccountSnapshot;1.Cust}); The error: "The ) is missing" The report was created using Crystal reports 11. Th...
I have a windows application project (C# and .NET 2.0) that used Crystal Report 2008. But I get error sometimes (it seems accidentally) in loading report. That error is: CrystalDecisions.Shared.CrystalReportsException: Load report failed. System.Runtime.InteropServices.COMException (0x8000020D): Unable to load report. at CrystalDec...
How can I connect to a Crystal Reports 4.6 report that connects to SQL Server 2005 as a data source, using Visual Basic? I don't want to specify the connection string in the report. I want to pass the connection from VB. Is there any way to do this? ...
I have some Crystal Reports that were created using Crystal (external to Visual Studio) and are now loaded in the VS project. Before the report is previewed I set up the report database information like this in the report and all subreports. var connectionInfo = new ConnectionInfo(); connectionInfo.ServerName = "192.168....
When I drag a field from my stored procedure onto a formula (Crystal Reports 11), I get something like this: {sp_YES_AccountSnapshot;1.ST0405_Ext} What does the "1." represent? I hope it refers to the table number... because I'd like to return two tables from the stored procedure and be able to access both from a report. Thanks ...
Hi im in the process of building a system that generates printed letters (around 1000 a day) that get sent to our customers and was wondering what are some good tools to use for this. So far i have looked into using Crystal reports and MS Fox pro reporting but find them frustrating to use. Anyone got any good suggestions? SQL repor...
I am working on CrystalReports for VS2005.I need to change the default printer to some other printer and no.of copies to 2 as compared to the default of 1. I have succeeded to change the default printer using below code. static int SetAsDefaultPrinter(string printerDevice) { int ret = 0; try { s...
How to integrate these two great tools? ...
Hi, I have a crystal report called BPCTaskReportV3. I have a subreport called totalworkflowsum, with formula called @wfssubmitted, which contains: WhilePrintingRecords; Shared NumberVar totalwfs; totalwfs := DistinctCount ({Reviewers_ALL_Table_BE.WorkflowID}) Another subreport is called NoReviewWorkflows, with a formula called @norevi...
Using VB 6 and Crystal Report 8.5, how can I hide the last row from each group? Do I need to use a Crystal Report formula? I don't want to display a last row from the each group. How can I write this formula, and where should I write it? ...
I am upgrading an application that was originally written in VS 2005 (.NET 3.0) and now I am upgrading that application to VS 2008 (.NET 3.5). I have Crystal .rpt files that I have created in VS 2005. The application is a Windows Forms app. What is needed to run the applications on the client for Crystal? Is there a installation I nee...
I'm essentially brand new to the reporting world, and I've been tasked with creating a series of reports, and I'm trying to figure out how to best start. Since we're a Microsoft shop, using VS 2005 right now, Crystal Reports and SSRS both look like possible candidates. But I'd like to improve my chances for picking a winner out of the ...