Please help! I need to produce a Crystal Report with multiple data columns, but need to show row headers as well. e.g. (Fieldname) (DataColumn1) (DataColumn2) (DataColumn3) Animalname Elephant Dog Mouse Animalsize Large Medium Small I have su...
I have a report that is currently separated into two reports, and I'd like to merge them. Basically it boils down to this: I ask the user if they want to have a page break for each Property, if they answer yes, I sort/group by Property and then I sort by X If the user answers no, I want to just sort/group by X I've tried suppressing t...
Hi, I have encountered an error while debugging a VB.Net application in Visual Studio 2008. While debugging the console application in Visual Studio, when the application instantiates a Crystal Reports 'ReportDocument' object, VS2008 hangs. Even when the devenv.exe process has been killed, I am unable to kill the still running vshost...
I am getting the following error using Crystal Reports 10.5 on my development machine. The report was working fine this morning in my testing and now I get this error Error in File C:\DOCUME~1\UserNameHere\LOCALS~1\Temp\BarLabel {052E0DE7-59FA-4C55-B293-316F7DFE8531}.rpt: The request could not be submitted for background processing I ...
Hello, I have a number of reports that need to be both run separately and also as a group. I've created these reports and was hoping I could just create a form where I could just append report1, report2, report3... together without creating a different report and making all of those reports subreports. Is this possible? Thanks, Ed...
I have a crystal report that I have to add a Bar Code to. I have downloaded some free and demo TrueType fonts Code 39, Code 128 and UPC from various sources. When I print out the report I can see the bar code but it will not scan with my scanner(the scanner works as I have tested it on multiple other bar codes). Do I need to use some...
Hi there, I have a dataset with some numbers for each month. For example: 1/1/2009 param1 param2 2/1/2009 param1 param2 3/1/2009 param1 param2 What I need is to show 4 lines of summary: last 6 months this year (last 12 months) last year (12 to 24 months ago) total I was thinking of adding a parameter for each record that ...
I have a report field where its value is "2". I need to display in report as "True" if report field value is 2.How do i do this in Formula editor crystal reports ? Please help me. EDIT :Here is my code in formual Editor: if( {emp.company_id}=2) Then CStr ({emp.company_id}) ="ABC pvt ltd" As emp.company_id is integer value i...
Hi friends, I have a report with the same table twice. One with the original name (Company) and the second with alias (Company_A). This report wants to show a "tree" of companies. With code I get a Dataset and I fill the report with it. This Dataset have two tables the original and the alias table with one and two rows expletively. The ...
I have several groupings in my report, and based on a formula, sometimes there are no rows displayed for the parent grouping. How can I hide the parent grouping if there are no rows displayed? I have SupressIfBlank set to true but that doesn't seem to do anything. ...
have an application written in Visual Basic, .NET 3.5 (VS2008)... and have reports created in Crystal Reports 2008 .... everything works fine... I pass the parameter values with code like this... Dim SParams as new hashtable SParams.add(paramname1,paramvalue1) SParams.add(paramname2,paramvalue2) SParams.add(paramname3,paramvalue3) .... ...
I am generating a barcode label and sending it to the user as a .pdf (this is a web app). The user has already purchased barcode labels that are only 2 inches wide. I want to use an image so that I don't have to install fonts on all of the users machines that will be using the web site. I am able to get the barcodes small enough if I...
Hi, I am using the crystal report integrated in visual studio 2008 to create my reports. My report design is that its has 3 sections Section header where Section detail Section Footer However I am having a problem with displaying vertical lines on the detail section when there are no records. The section footer is always displayed at the...
Hello, I want to know the minimum value of the Crystal Reports datetime datatype. I know .NET's, I know SQLServer's, but I cannot find anywhere on the internet Crystal reports. Thanks, ...
I am having a minor issue playing with my exported Crystal Report, I can generate the reports just fine on our website, however when I attempt to export them to Word documents I don't quite get a document I can do much with. i.e.: I can't position the generated text anywhere in the document, it is almost 'frozen' in place. I would ex...
Hi friends, I am triying to fill a report with datatables. The report has two tables which are he same but with diferent alias. In c# I create a datatable for one of them with the records that must be shown and another datatable with the other table info. Crystal only gets info from the first datatable to fill the two tables so the sh...
I'm looking for experiences with deploying Crystal reports (the basic version, bundled with VS2008) into a production environment. Are there any restrictions? Does it limit the number of concurrent users? Other than downloading and installing the CRRedist2008_x86.msi on the production server, anything to worry about? (And judging fro...
Hi, Is there a way to convince Crystal Reports to export a page / group / whatever to separate worksheets when exporting to Excel (Data Only)? I'm using the CR that came with VS2008 (version 10.5) Thanks. ...
I have a Crystal Reports 2008 report that has fields e.g Sector,Branch, Department and a bunch of other fields.The requirement is that the same report should be able to allow grouping by Sector,Branch or Department.I'm trying to avoid creating the same report 3 times with the only difference being the Group Header field.My question is if...
I have a formula @InitVars in the page header which includes the following, and similar lines: shared numbervar runWaste:=0; In Details v, I have a sub-report, which has a formula @SetRunWaste: shared numbervar runWaste; if (OnFirstRecord) then ( if not(isnull({x.x-or})) and not(isnull({x.y-override})) and {x.y-override} = true the...