Hi guys, I'm trying to run Java_JRC_Desktop_View_Report_and_set_database_logon downloaded from here but at runtime my java desktop application throws this Exception: com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: org/apache/log4j/Logger---- Error code:-2147467259 Error code name:failed From what depends? thx all. ...
I am working on VS 2005 / Crystal Reports. In the Sub report, i need to limit to 18 records per page. I need to do paging for the Crystal Sub Report ? I am not able to do paging for crystal sub reports ..! ...
Hi, I have a simple application in C# (Visual Studio 2005) that display a Crystal Reports report (Crystal Reports X1 R2). When I compiled the application it appears the following message: The report you requested requires further information. I want to set the connection info in the code so the application doesn't ask the user for the da...
I have a dll build with target framework 3.5 that manage reports; this dll use the version 10.5.3700.0 of CrystalDecisions.CrystalReports.Engine Now, I have created a new wpf application based on .NET framework 4.0 and I added the report dll reference to project. I had to install the Crystal Reports for Visual Studio 2010 library (http...
Is anyone aware of how to access Crystal Reports chart control axes via C#? I have been able to access some chart values but none that I need (The axes labels need to be localized from code). ...
So I have a simple crosstab report that calculates number of sales in the columns, and the rows are each office. The last column on the right is a total column, which contains a summary field (via a count of the identity field) that adds up the total number of sales per office. How can I sort the crosstab data so the office with the mos...
Hi expert, I want to know how can I identify if the user CLICKED the PRINT button from the Toolbar of report viewer in Crystal Report, maybe some sort of a return value? btw Im using C#.Net. thanks in advance. ...
I have a crystal report that shows sales volumes called week to date volume. It shows current week, previous week, and average week. The report prompts for a date parameter and I extract the week number to get current week and previous week volumes. Did it this way because Mngmt wants to be able to run report whenever. My problem is for ...
I have a crystal report, which takes data from an XML template. For a particular field of report, say 'Cost' the database stored procedure send data to XSD file in decimal format , but when the crystal report displays data picking from XSD, it is rounded off. When i right click on other data fields of report, I can see 'Field:table1.col...
We want to show an image in a Crystal Report 2008 report, and the URL of the image depends on a field in our database, eg: "https://images.somewhere.com/" & {Data.Field} & ".jpg" This is supposedly possible using a 'picture location' formula on the Picture object (as described here and suggested here), but we can't get it to work - it ...
Assalamoalaikum I am having problem in generating report in visual studio 2008 Problem: In CustomerList Report I want to pass the parameter i.e. CompanyID which is Sesson variable. I am passing but not getting the customers of the logged in company. Please see the code and help me. Jaza milegii. :) using System; using System.Collec...
I have a large SQL database. MOST of the data in each table is regular text, but there are some fields/columns within certain tables that is in XML. I need a way to parse the data so that what I see in my report is just the "useful" data and not all the XML tags. I should also mention that I am an extreme newbie to CR, so responses need...
What is the best method for pulling a report from a Crystal Report Server that is public facing. I only have public access to the server but need to pull a report form it on a daily basis. You log on here with the user id of public and no password. In the past, I've screen scraped sites for the info I needed. The report server here m...
Hi: I have problem with Crystal reports with .NET in generating a report. I have a report that gets data from a stored procedure ( sp_get_data(IN Claim_period)). The IN parameter that goes to the stored procedure comes from a table in database. It grows dynamically over period of time. I need to add parameter claim_period to the r...
I'm receiving an error in my crystal report: The reminaing text does not appear to be part of the formula. the highlighted area in question is between the 2 **'s when the error is thrown. Here is my formula in Crystal Syntax. numbervar pos; stringvar cpu; if (Length ({_v_hardware.CpuDesc}) >2) then ( pos := instr({_v_hardware.CpuD...
Hi, We are using crystal report 11.5 in vs. 2008 to display report in one of my projects, when I try to display a report in crystal report viewer reports are displayed properly but the toolbar icons (First, Prev, Next, print, etc..) images are not getting displayed and on click of any of these buttons the report vanishes giving a blank ...
I've written a vb.net application to populate a Crystal report and output it to PDF. The problem is that every text box in which I have the letter "t" is being printed out to the PDF as "tt". eg, instead of "customer", it prints "custtomer". The design time layout is perfect. And this only happens with text boxes on the report; value...
I've got a crystal reports formula that displays a string based on an input Simplified: if (a=1) then "Abc" else "Abcdefghijkl" The problem is that I want this field right aligned. In the "Format Editor" I have set the "Horizontal Alignment" to be "Right", but it hasn't changed the formatting when I run the report. Any idea'...
I am wondering if it's possible to use a view to get the top 5 lines from a table. I am finding that Crystal reports doesn't seem to have anything built in to do this, or I'd do it there. When I query the view Select * from qryTranHistory, it returns the first 5 items, but if I try to select a specific type Select * from qryTranHistory ...
We have localized Crystal Reports for each of the three languages we support in our web application. I am in the process of minimizing the amount of reports that we ship with our software by setting the localized report text in the code behind (C# 3.5). Everything seems to be working out fine (for the most part) but there is one interes...