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...
Very new to Business Objects, but I have a .NET background and PL/SQL background. I've been able to make the most basic reports, but I wanted to know if there were any good books or resources online that explain in detail how to design reports the way I'd like to such as grouping with sections, having two sections and segmenting only one...
I am trying to format a number field to display in this particular way 0001234, i can do it in VB using the Format(right command, but crystal basic doesn't recognise 'Format' ...
I'm writing a fairly light-weight .Net application that queries an Access database and generates a Crystal Report based on the result-set. The Dataset fill method is a little slow, but manageable. The issue is when I load the crystal report. If the dataset being passed to Crystal is sizeable, at all, it takes forever to load, and the u...
I've got an .rpt file that I did not write and can find no documentation about. I want to be able to review the SQL that is generated from this report so that I can figure out, well, what data it was pulling and what WHERE clause parameters were used. I can open it up and see the report layout. But when I select Database|Show SQL Query...
Hi everyone, This is a pretty straight forward question but I can't seem to figure out how to do it! I am making a stacked bar chart in Crystal Reports. The x-axis any date in order in the range: 04/01/2010 --> 31/12/2010. The y-axis value is an integer value. Basically I have a field called CalenderDate and a field called WeekNo. Is ...
I need to suppress a label and image if certain data is encountered. Is this possible in Crystal Reports with a formula, or by some other means? Thanks ...
I had a local application in Visual Studio 2010 with Crystal Reports, after install the app in another computer when I want to show a report it throws the following message: System.TypeInitializationException: The type initializer for 'CrystalDecisions.CrystalReports.Engine.ReportDocument' threw an exception. ---> CrystalDecisions.Crys...
"Problem": When doing reports, I have to manually export like 50 reports based on some dates depending on the kind of report (monthly, quarterly). Question: Is there any way to make this automatic? Like I press a button or run a script that generates the reports on their given dates, then automatically exports this to some folder as an...
I use Crystal Reports 10 Pro but I need a scheduler that can connect to my report services using OLEDB connections for my parameters. Thanks for any suggestions! ...
Can the Microsoft Report Viewer control render and display Crystal reports or is it just intended to render SSRS reports? Thanks. ...
hi, am doing a report for showing catogory-sub-category wise sales report. i made to group headers with category and sub-category What i want to do is.. Hide subcategory(Group-Header) --> if user didn't specify or select any subcategory. ..?? ...
In my project I want to use data source for a crystal report as collection of business layer object. How do I do this? I have 3 projects together in my solution one of them is business object layer. In grid and comboboxes or other controls I am able to bind these objects to the collection directly. I know how to bind crystal report to t...
Hello - Problem Definition I have a performance problem displaying large/huge resultset of data on a crystal report. The report takes about 4 minutes or more depending on the resultset size. How do you handle large resultsets in Crystal Reports without a performance issue? Environment Crystal Reports XI Apache WebSvr 2.X Jboss 4...
Hi: I need to modify a static text (few words) in 3 rpt files. But I dont have Crystal Reports. How i can do it? existes some free editor or software to be able to modify a simple text of the report? ...
I've written a formula as follows whileprintingrecords; shared numbervar level1; level1:=level1+1; ToText(level1,0); And placed it into a report as so: Report Header a | {formula} {Text:Introduction} Report Header b | {formula} {Text: Scope} Report Header c | {formula} {Text: Overview} Group Header a | {formula} {Grou...
Hi, I'm using crystal reports 10 and have an issue with a duplex printer. Basically I've a report that used to print to a printer in non-duplex mode. This report prints a list of new users created on a particular day. Previously this report would print 1 user per sheet. We've had a change of printer which only prints duplex and now...
Hi, I have a table in ms-sql obm_FeeTable FeeId int, FranchieId int, Amount Money, ChequeNo int, BankName nvarchar(200), PaymentDate DateTime when I want to display all collection in crystal report it don't show Amount / PaymentDate when creating report, don't know why its doing like this. Please help why is it doing like this. also ...
I am having issues with Crystal Reports for Visual Studio 2008. I am tasked with creating a report that displays data in a grid, from testing scores.. I would like the data to be displayed like the following Results for Exam <Exam Title> <Question Name 1><Question Name 2><Question Name 3><...> <Candidate 1> <Score> ...
i am working on crystal reports in asp.net using c#. i am using reportdocument object rpt for load crystal report. i am using following code ConnectionInfo connectionInfo = new ConnectionInfo(); connectionInfo.ServerName = @"servername"; connectionInfo.DatabaseName = "databasename"; connectionInfo.Use...