FAQ Database Discussion Community


crystal report to pdf without report viewer

c#,pdf,crystal-reports
I would like to know how to export crystal report to pdf format file without pointing to crystal report viewer in code. Below is my working code with report viewer but I would want to do so without it. private void getReportDocument() { using (connection = new MySqlConnection(strPigen_Deposit_Conn)) if (this.OpenConnection()...

SQL Server query - Fill Missing Dates In a Date-Sequenced in SQL using Tally Table

sql,asp.net,sql-server,crystal-reports
I have a table in database with numbers of tenants, each tenant lists a record of their sales per date. There are instance where in a tenant has NO SALES in particular date/s, therefore the date with no sales has NO RECORD in the table breaking a proper date sequence....

crystal report formula to filter between dates for bar chart

c#,crystal-reports
I get an error when I try to add parameters to filter between dates in a crystal report selection record formula. This is the formula I used: if {tblFaultyDevice.date} >= {?dateFrom} and {tblFaultyDevice.date} <= {?dateTo} then true Error: A string is Required Here ...

Blank dates float to the top on refresh: Crystal Reports 2008

crystal-reports
I have a report that I have been working on and have determined that Crystal Reports is playing games with me. Looking to display most recent survey for a customer in the group header, but on refresh blank dates float to the top of the details section giving me blank...

Crystal Report formula if-else statement Date condition

crystal-reports,formula
I would like to ask about how to use if-else statement in the crystal report formula. I want something like If Date = "01/01/1900" Then //Display "-" Else //Display Date But i always faced that the field is require number, currency and date error. I am still new with crystal...

Export from to PDF throws Internal Error: The export doesn't support one of the functionalities in this report

vb.net,pdf,crystal-reports,crystal-reports-xi
I'm trying to export a report into a pdf file with vb.net but i get an "Internal exception: The export select doesn't supports one of the functionalities used on the report:" I'm using a very simple code: cr.ExportToDisk(ExportFormatType.PortableDocFormat, stringPath) I've already check if the path exists and permissions of the...

Formatting the layout of data in a cell, Crystal Reports

sql-server,crystal-reports,crystal-reports-2008
I am trying to format the output of my data in crystal reports 2008. Currently, you can see in the picture that the data is in the top left of the cell. I am trying to have the data appear on the bottom left hand spacing of the cell, instead...

Using Subreport in Crystal Report and ASP.NET C#

c#,asp.net,crystal-reports,crystal-reports-2008,subreport
My main Report and SubReport is very similar to each other, using same parameters and formula the only difference is their order in the derails section. Now When I load the subreport in the report and run it, ASP.NET keeps on asking to enter values for the parameters used. I...

Crystal Formula field - Splitting a string array of numbers, summing them, and returning the total returns a boolean instead of a number

sql,crystal-reports,crystal-reports-2008
This is in Crystal reports 2008, all service packs installed. I'm trying to use a formula field to take a string field of space delimited numbers, sum them and return the total. Code below. Always displays true on the report in preview and printed. Not entirely sure if I'm formatting...

View last transaction made by sales rep at the end of every day during last week

crystal-reports
I'm familiar to SQL but new to crystal report. I have a table which contains all the transaction made by every sales rep in a store, the fields are as follows: RepName, transactionDateTime, transactionAmount This table contains data that contains every transaction detail made by every sales rep for the...

No preview data - how to edit sql?

crystal-reports
I am editing a crystal report (using version 14.1.1) report that came with a system we are using. I cannot see any data in the preview but when I go to "Database -> show sql query" it is clear that it doesn't work because the query wants some values that...

Crystal Reports 2013 Referencing multi-value parameter in command

parameters,crystal-reports
I have a multi-value parameter called Category, listing out all the different procedure categories that can be queried. How does one reference this parameter in the command. The following code does not appear to work 1. and (i.PROC_CAT_ID in ({?Category})) 2. and (i.PROC_CAT_ID = ({?Category})) Any suggestions for making this...

Crystal Reports - Changing Table Locations No working

sql,.net,crystal-reports
I have an application developed in VB6 which I am migrating to .Net Framework 4.0. There is a report that works correctly in the original application but the migrated application does not work on the original application. As a special feature, this report changed at runtime attribute "location" in two...

How can I export a query result from MySQL to PowerPoint through my Java aplication? [closed]

java,mysql,crystal-reports,powerpoint
I have built a GUI in Java so that the users from my office can search through our database, and the users need to be able to print reports in PowerPoint slides (one slide per register of the database), is there a good library I can use to make the...

Crystal Report's 3 Way Formula is not working with a Two-Page Report

crystal-reports,crystal-reports-2008,crystal-reports-2010,crystal-reports-xi
I am using this 3 way formula below to get record/s from details section and display in group footer for each group in a report. It is working pretty well BUT NOT WITH A GROUP REPORT CONTAINING OR EXTENDING WITH more than 1 page. Formula 1: In Group Header (Initialise)...

Converting row into column in Crystal Report

c#,sql-server,visual-studio-2013,crystal-reports
My crystal report data source has rows like |---------+--------+----------+----------| | SubName | TMarks | ObtMarks | ExamType | |---------+--------+----------+----------| | ABC | 100 | 70 | 1st | |---------+--------+----------+----------| | DEF | 100 | 70 | 1st | |---------+--------+----------+----------| | ABC | 100 | 90 | 2nd | |---------+--------+----------+----------| |...

crystal report how to display date in boxes of Bank Check Book

crystal-reports,sap,sapb1
I want to print check from SAP Business one. I do all setting except the bank check Date have issue. in bank check the date is in boxes and having spacing. can any one help me to how can i do it? ...

crystal report got error when copy to datatable

c#,asp.net,datatable,crystal-reports,dataset
i got problem about reporting using crystal report here is my code protected void Page_Load(object sender, EventArgs e) { string Judul, Peminjam, Pinjam, Kembali; DataTable dtReturn = new DataTable(); SqlConnection con = data.getKoneksi(); con.Open(); SqlCommand Perintah = new SqlCommand(); Perintah.Connection = con; Perintah.CommandText = "SELECT DISTINCT Peminjaman.Katalog, Peminjaman.Pinjam, Peminjaman.Kembali, Pengguna.Nama,...

Insert Line Split after the first group in Crystal Reports

crystal-reports
I need to display line separator above the group headers but not on the first groupheader for eg. Name Course DateJoined SummerCamp Class A 1 2 3 _____________________________________________________________ Class B 1 2 3 ____________________________________________________________ Class C ...

How to view data on crystal report using LINQ to SQL

c#,linq,crystal-reports
I have Form.cs on which there is "crystal report viewer" and "button" when i press button the following code is executed. But when i run this code the following error occurs "Application has stopped working". Why? private void button1_Click(object sender, EventArgs e) { DateTime dt = DateTime.ParseExact("2012/11/11", "yyyy/MM/dd", CultureInfo.InvariantCulture); DataClasses1DataContext...

Crystal Reports shows barcode ONLY locally

asp.net,crystal-reports,barcode
I use Crystal Reports to show an .rpt file in an asp.net page. When I run both at server, the CR's preview on design software and the WebPage(IE) where the CR viewer is embedded, the reports shows the barcode and can be printed. (the barcode is a function Bar128AB( *BarTextIn*,...

Trying to convert total minutes from a datediff to days, remaining hours, & minutes in Crystal Reports

crystal-reports,datediff
I am using Crystal Reports 2013 SP5 on Windows 7 Pro pulling from an Oracle db. I am trying to write a formula(s) in crystal reports that returns the total number of days the remaining hours if less than 24, and the remaining minutes if less than 60 from a...

Custom SQL Query Overrides All Other Report Data in Crystal Reports

crystal-reports
I have written a custom sql query to get some specific data I need to use in my report. I added it through database expert and when I try to insert one of the columns from the custom query it replaces all of my other data and just pulls in...

How to add a word file content to a crystal report?

c#,visual-studio,crystal-reports,ms-word,converter
I am working on a web application project in visual studio Ultimate 2013. In this project, I am using crystal report templates where I need to design a template for a long word file (15 pages long). My question is: (Is there any possible way to add the word file...

Adding 2 additional pages to the end of a crystal Report

crystal-reports
I have a report for orders and i would like to add 2 pages at the end of the order. My order is most of the time 1 page, sometimes it will be 2 pages. So I want to add my terms & conditions to the end of it. This...

Add Number for Every X line

crystal-reports,report,crystal-reports-2008
I've a stupid issue but I can't solve it. I need to add number beside every x records as the following: 1 123123 material1 1 123543 material2 2 123332 material3 2 123432 material4 as you see the first column is a number for every two rows.. I need to do...

save crystal report document type to database and retrieve it later

c#,asp.net,vb.net,oracle11g,crystal-reports
i have a variable which is Dim UCRpt As New CrystalDecisions.CrystalReport.Engine.ReportDocument i can do this with session variable like session("Test") = UCRpt and then retrieve it later. This help with paging, exporting, printing. If i don't the report will query the database all over again everytime user go to next...

Is it possible to convert three row in section details of a crystal report to three column

crystal-reports,report
Is it possible to convert three row of section details in crystal report to three column?

how to print textbox value in crystal report header section using vb.net?

vb.net,crystal-reports,ms-access-2007
i am having crystal report! on that i want to print entered value of textbox in crystal report my code is, Dim report As New CrystalDecisions.CrystalReports.Engine.ReportDocument Dim xs As String xs = salfdte2.Text Dim cmd1 As OleDbCommand = New OleDbCommand("SELECT * from product",con) myDA = New OleDbDataAdapter(cmd1) myDataSet = New...

crystal report line break with line

c#,crystal-reports
Here's my formula in crystal report StringVar ReplaceString; ReplaceString := Replace ({command.ExtraPersons}, ",", Chr(10)); ReplaceString Output: Sample One Sample Two Expected Output must have underline <u>Sample One</u> <u>Sample Two</u> Thank you,...

display parameter value within formula crystal reports

parameters,crystal-reports,report,formula,value
I'm using Crystal Reports 14. I have a formula which based on two parameters (from month, to month) display different text AND different parameters My code is as follows IF ({parameter1}) = 1 AND ({parameter 2})=14 THEN 'text {?parameter3} text' My problem is that instead of the value of paramter3,...

Crystal report converting DateTime to string Too many arguments have been given to this function

c#,datetime,crystal-reports
I have a simple formula like below in crystal report: iif(isnull({employ.createdDate}),"", ToText({employ.createdDate}, "dd-MMM-yyyy")) The {employ.createdDate} is in below format: 02/09/2015 10:48:25 It works fine when {employ.createdDate} is null, but when it's not null, the below error message shows: Too many arguments have been given to this function Error in File...

Individual Character Boxing Crystal Reports

c#,sql,crystal-reports
I am pulling a string from a database (SQL) and it is being put into a Crystal Report, C# is handling the connection strings. I need get each character of the string (between 6 and 16) in it's own box. Similar to those of Direct Debit forms where they show...

Show particular record from database in crystal report

visual-studio-2010,crystal-reports
I need to show last saved record in crystal report. I know I can do it with recordSelectionFormula , I tried too, on report Preview form load event if (ReportName == "Bill Receipt") { Report.RecordSelectionFormula = String.Format("{0} == (BillNo) AND {0} == (BillNO) ","{BILLH.Bh_no}" , BillNo); } BillNo is the...

Dynamic sort group in crystal reports

c#,.net,crystal-reports
I have a sales report grouped by city and country. I need to change the order, some times the groups will be sorted by the total of sales and another times will be sorted by name (alphabetic). How can I do it? I'm using VS2013 C# and the tools of...

Year and month in a crystal report

date,crystal-reports
I have designed student ID Card using crystal report version 13_0_9 for visual studio 2013. There 2 fields on student ID card that reflect year and month. For the field year I need to show it as 2015 - 2016. And for month it need show as June To May....

(Answered) Gaps and Islands: gap in enrollment, evaluate first record

sql,crystal-reports,crystal-reports-2008
data: 'student#' 'enrollment date' 'removal date' 1 1/1/2014 1/4/2015 1 1/15/2015 null 2 1/1/2015 1/4/2015 ... I'm looking to show a lapse in enrollment. And created the formula below, which works for all but the first record. :) :( Is there a way to evaluate something that's not there? //...

Crystal Reports and Null fields

crystal-reports,null
I'm using formula by grouping records in my report like this: field1 + field2 + field3 But when a field inside the formula is null (for example field2) Crystal Reports not groups records properly; So I have to insert in the formula a condition like: field1 + (if isnull(field2) then...

In-report comments for other designers in Crystal Reports

crystal-reports
What would be the best ways to comment/document a report in Crystal reports for other designers? I can think of the following ways: File > Summary Info... comments with // in Formulas Suppressed sections with information only for designers Comments in SQL commands The more complex reports would be easier...

How to sum filed based on day type in crystal report

crystal-reports,crystal-reports-server
The table has two columns named dayType and total, total column already has value and only want to sum records that have the same dayType. I coded this if{EB_Tam_DailyMv.dmv_daytype}= "R" then sum({EB_Tam_DailyMv.dmv_totalot}) else if {EB_Tam_DailyMv.dmv_daytype} = "P" then sum ({EB_Tam_DailyMv.dmv_totalot}) it suppose to print the total of R days but...

right to left string in crystal report

sql,sql-server,crystal-reports
Consider Below Query in SQL Server below picture is result of this query in Crystal Reports. as you can see the right part is exactly same as query result in sql server and left part is converted by a locked function to meet right to left property of Persian language....

Crystal reports suppression formula with multiple OR operators not working

crystal-reports,formula,crystal-reports-xi,suppress
I am trying to add a very simple suppression formula to my Crystal Report (XI) field but it is not working as expected. I would like a text box to be visible if certain conditions are met, otherwise suppress. With the suppress box ticked my current formula is below: {table1.field1}...

Crystaldecisions ReportSDKIllegalArgumentException

crystal-reports,business-objects
I am currently working on a migration of BO 4.1 related tool. The tool is used to deploy the crystal reports from drop location to BO Server. The tool was developed using BO XI 3.1 Java SDK code and will be migrated to BI 4.1. In the code it is...

Crystal Reports GetAttributes

crystal-reports
I've been asked to go through over 1000 Crystal Reports to find the Store Procedures and/or Table names used in each report. I would like to do this programmatically, but I don't see much in the way of reading such values from the CR object model. There is a GetAttributes...

How to printing crystal report directly to network printer in C# .Net Windows

c#,crystal-reports
i read This Link Answer Given is - report.PrintOptions.PrinterName = "\network\printer" Please Give me e.g.What is Network(ip Address or PC Name) My Printer Name Shows in Property is "EPSON TX121 Series on DRAGONFRUIT-PC"...

Crystal Reports extracting text within delimiters

string,crystal-reports
The software we use is limited to only allowing one manufactures code per product, and this causes problems when we have multiple suppliers for one product. What I'm trying to do is have all the codes in one field and separate them with Crystal Reports on purchase orders. The field...

Searching by date criteria OR Logic

crystal-reports,crystal-reports-2008
Here is what I am looking to do: I currently have a report that I need to be able to search on either the post date or the admit date and the location. So for this logic I have something like this. The problem I get right now is that...

How to set max height of a picture in crystal report?

crystal-reports
Is it possible to set maximal height of a picture in crystal report and preserve original ratio of a picture? If can grow is disabled, every picture is streched or shrinked to default picture object size, if is enabled, I'm losing limits of picture size. I'm using crystal reports for...

published reports don't work - Database logon failed Error

c#,iis,visual-studio-2013,crystal-reports,db2
I am developing a simple web app that has 3 reports created on VS 2013, for some reason those reports run fine from developer mode, but when I publish the website they give me "Database logon failed" Error. What could be causing this? VS is installed on the same server...

how to deploy crystal report on client machine, in vb.net

vb.net,crystal-reports,report
I am working on VB.net project with Crystal report. My problem is that, on the client's machine Crystal report forms are failing with the following error; Error-> "Either the crystal report registry key permissions are insufficient,or the crystal reports run time is not installed correctly" Any idea how to solve...

ISeries Tables/Views not showing up in Crystal Reports 2013

crystal-reports,ibm-midrange,iseries-navigator
I have an iSeries server running v5r4. I have several tables and views that I have created over the past couple of years on the server. I have used them with no problem in the past, yet suddenly most of the tables and views in a Schema that I created...

Crystal Formula to display the latest

crystal-reports,crystal-reports-2008
A table has workout columns starting from workout1 till workout7. I want to create formula to check the latest workout (higher) and display it in crystal report. For example, check if workout7 have value then display it before any other workout columns else check workout6, If it value, display it...

Crystal reports messing up data base connections

crystal-reports
I am doing some data base development work in which Crystal Reports v. 14 is used as the reporting engine (Not my choise!). In the work, I am switching CRs database connection back and forth between my development and test databases (using database Set Database location) when thing started to...

ORA-00907 missing right parenthesis In Crystal - Works in Oracle Developer

sql,oracle,oracle11g,crystal-reports,oracle-sqldeveloper
I have an issue with a query, it works fine in Oracle Developer with {?Month} replaced with '2015-01-01' but in Crystal it is giving me the error ORA-00907 missing right parenthesis when using the query below. Parameter Parameter Name: Month Prompting text: Enter Month Value Type: String (also tried date)...

Crystal reports group selection sorting

parameters,crystal-reports,report,group
I am working on a report that has two parameters that gives the user the ability to sort the records. One being the salesman and the other being the company code which is just the first three letters of the company name. They want the ability to sort these records...

Creating frequency interval in Crystal Report

oracle,plsql,oracle11g,crystal-reports
I am trying to create a dataset of frequency interval in crystal report something like below. First column is rowid, second is start interval , third column is end interval and fourth column is interval name. 1 0 29 0 - 29 2 30 59 30 - 59 3 60...

store the value on crystal report c#

c#,crystal-reports
I am Facing an issue with crystal report. i have generated a custom formula to calculate total attendance hours. the formula code is : if({Atendances.Status} = "OUT") then DateDiff("h",Previous({Atendances.Time}),{Atendances.Time}); and result i am getting 1/5/2015 ___________________________ Time || Status 1/5/2015 11:06:00AM || IN 1/5/2015 3:06:00PM || OUT 1/5/2015 4:06:00PM ||...

How do i count unique dates in crystal report?

c#,crystal-reports,report,grouping
i have a crystal report of sales and its grouped by sale date. this add a grouped by header on report. Is it possible to count how many of this headers are on the report? the reason is i need to count unique number of sale dates! thanks...

crystal report from dataset in c# has a lot of spaces on string fields

crystal-reports
when creating crystal report from dataset in c# , some times the data in string fields appears not aligned and it seems have a lot of spaces before the text value . please how can I remove all this spaces ?

Crystal Reports not selecting any records when I add a parameter to the report

c#,asp.net,crystal-reports
I'm using Crystal Reports inside of Visual Studio 2010 with ASP.NET. I've got a DataSet that pulls data from a database, and it seems to load into the report just fine. When I view the report in my browser, all records load correctly. I have to add a parameter for...

Suppress on condition on crystal reports

crystal-reports
Good day I have little understanding of crystal reports so please bare with me. I have multiple Images on my reports(image1, image2...), but I want to show image1 when I am doing report 1a. All other data on the report remains the same, it is just the image that needs...

Create a temp table with data range using startdate and enddate from different records in SQL Server

sql,sql-server,sql-server-2008,crystal-reports
I've got to write a command in Crystal Reports which should create some sort of temporary table to be used on the report itself. I basicaly need: VATDates: +------------+------------+----------+---------+ | StartDate | EndDate | VATCode | Rate | +------------+------------+----------+---------+ | 01/12/2008 | 31/12/2009 | GB001 | 15 | | 01/01/2010...

Crystal report - Group Towns by Countries

sql-server,vb.net,crystal-reports
I have two tables With this query i got the results select countries.id, countries.name, Towns.id,Towns.TownName from Countries left outer join Towns on countries.id = towns.countryID Now i want to group results by country to get something like this on my CrystalReport. Is it even possible to make it ? ...

Using Date range parameter in the command

sql-server,parameters,crystal-reports
I have a crystal report that contains a date range parameter (2 values). I want to use this parameter in the SQL command. Is there a way to achieve this : Here is how I want to use it : --Query Where ( MyTable.Date between Min({?Period_Filter})//Incorrect and Max({?Period_Filter})//Incorrect ) ...

Attempting to connect to SQL Server through Crystal Reports

sql-server,crystal-reports
I am attempting to connect Crystal reports to a SQL Server database. Here is what I have done so far. File > Log On or Off Server Create New Connection > OLE DB (ADO) Under provider I selected Microsoft OLE DB Provider for SQL Server and click next. I select...

Export Crystal Report to PDF in a Loop only works with first

asp.net,vb.net,pdf,crystal-reports,export
i'm trying to generate a report and export it to pdf in a loop, the report will receive a new parameter in each loop and prompt the client to download a PDF, in other words, the client may need to download 2 or 3 (or more) PDFs at the same...

Crystal Reports - Compounding Total in For Loop - Unexpected Results

loops,for-loop,crystal-reports,integer
I've been coding for 15 years, know many languages, C#, C++, PHP, PAWN, SMALL, ETC ETC. Crystal syntax is probably the most inconsistent and nonsensical I have ever seen. Anyhow, I am trying to do something simple here. I have a string formatted like this in my db: "1-DESC, 2-OTHER,...

Convert Crystal Reports string to Date format yyyy-MM-dd

crystal-reports
I have a Crystal Reports formula field that returns a string in the format dd.MM.yy. How do I create a CR formula to convert this to a Date in the format yyyy-MM-dd? All dates are form the year 2000 and later. I have tried this so far: Date(2000 + right({@formula},...

How do I convert a decimal number representing time to actual time in Crystal Reports 2008? Ex: “1.5” represents 1:30

crystal-reports
I'm trying to edit an existing Crystal Report that shows time allowances for work orders. Budgeted Time / Actual Time / Remaining Time type deal. These fields show up as not properly converting time from the data field for the report. The person who made the report has some formula...

How to do conditional sum in formula fields on crystal report?

c#,asp.net,crystal-reports
I am trying add a list of part amounts. I want to add only the amounts with ID as aa. I am using the below formuls: shared numbervar aTotal; if lcase({ID}) = 'aa' then aTotal := aTotal + CDBL({Amount}); But it add up all datas. Help me on this...

How can I get this output in Crystal Reports?

crystal-reports
I have been using SQL for around 2 years but I have recently started using Crystal Reports 2013. I need to convert the below SQL to a Crystal Report: SELECT COUNT(orders.order_no), reason_codes.reason_desc FROM orders, reason_codes WHERE orders.reason_code = reason_codes.reason_code AND orders_reason.code IS NOT NULL GROUP BY reason_codes.reason_desc I'm lost as...

PercentOfSum(fld, condfld) SSRS Equivalent

function,reporting-services,crystal-reports,ssrs-2008,ssrs-2008-r2
Crystal Reports has a built-in function PercentOfSum(fld, condfld) (documentation here). How can I achieve the same functionality in SSRS?

Add totals to the groups

crystal-reports,sum,grouping
I am recently new working with Crystal Report and I am a bit confused how I can implement my sum on the groups. I group my tasks with taskID: 20422 416.46 Project01 20422 788.73 Project03 20422 361.85 Project04 20422 4,414.37 Project01 20423 806.26 Project08 20423 6787.67 Project09 How can I...

Crystal Reports only shows the last column

vb.net,datagridview,crystal-reports
since i am new to crystal report i have search for 3 hours still couldn't find the right answer to my problem. please check my code. Dim rptsumrep As CrystalDecisions.CrystalReports.Engine.ReportDocument Dim sda As New MySqlDataAdapter Dim bsource As New BindingSource Dim dtincom As New DataTable dtincom.Clear() conn.Open() Dim queryIncom As...

Dashboard Design : Should go for Crystal Reports or Charts in WPF

wpf,crystal-reports,dashboard
I am developing an dashboard application which will give insights of the data of an organisation. I am confused as to what will be the best approach in developing the Dashboard: a. Should i go for Crystal Reports b. Should i Use WPF Charts and display Data Any suggestions please...

multiple columns crosstab layout

crystal-reports
how can I achieve below layout using a crosstab? Month in the top of the columns and columns below with their own names. thanks...

Crystal Reports will not allow me to select database

asp.net,visual-studio-2010,crystal-reports,sap,crystal-reports-2010
Hi I'm trying to create a report and link it to be my database within Visual Studio 2010 but when I try to make the OLE DB (ADO) connection the database does not appear within the Connection Information (Server, UserID, Password and Database) and then when I manually try to...

How to retrieve Crystal page setting programmatically in C#?

c#,crystal-reports
I created a Crystal report (.rpt file) in Crystal Designer. I configured Page Setup. I want to retrieve e.g. page orientation, page width, page high programmatically in C#. How to do it? Note that I want to retrieve page settings, no print settings. I don't want to edit page settings,...

Reduce SQL query execution time

sql-server,sql-server-2005,crystal-reports
I have a situation where our web application generates a Crystal Report based on the query result which takes almost 1 hr to execute. I know this is crazy but, can anyone suggest any optimization or changes in the following giant query. Thanks. Note: I have shorten some of the...

What is a unit of PrintOptions.PageContentHeight in CrystalDecisions.CrystalReports.Engine

c#,crystal-reports
What is a unit of PrintOptions.PageContentHeight? I thought that it is hundredths of an inch but it seems that it is not. Following figure shows my page setup: But following code return different result: ReportDocument rp = new ReportDocument(); rp.Load(path_to_my_report_file); Console.WriteLine(rp.PrintOptions.PageContentHeight); Console.WriteLine(rp.PrintOptions.PageContentWidth); Output: 8392 5670 where ReportDocument is from CrystalDecisions.CrystalReports.Engine...

how to create sorting using hyperlink header text in crystal report?

crystal-reports,crystal-reports-2008,crystal-reports-2010
i have a report, when clicked on the header text will automatically sort by Asc, when I click on it again it will automatically sort by desc. how to make it in crystal report?

Do a running total of a field with the exception of the description contains a certain text string

crystal-reports
I'm trying to run this report where it does a running total with the exception if the "description" field contains "FUND TRANSFER" I have the group suppressed int he report itself, but it still goes into the running total. Here is a screenshot of the report screen and a brief...