Questions tagged [crystal-reports]

1

votes
2

answer
5.5k

Views

Crystal Report Displaying only one row in each page

I am using Crystal Reports with Visual Studio 2012. I am totally new to crystal reports. I just added my data fields to the details section, but instead of showing all the rows in one page, a new page is created for each row. I did not use any grouping or change the section paging settings. Even i c...
Santosh
0

votes
1

answer
15

Views

How to fix sql order by issue with crystal report

I am facing sorting (order by) issue while binding data table with crystal report. This is my query 'SELECT * FROM Payments WHERE (PayDate BETWEEN @startdate and @enddate) order by Id', Query returns sorted record in datatable but when I bind this result to crystal report it gets unsorted. Please su...
Pritam
2

votes
1

answer
51

Views

Docker Container with support for Crystal Reports

I am trying create a Docker image to host my asp.net MVC app that has a dependency on Crystal Reports. My dockerfile looks like this FROM microsoft/iis COPY ./bin/Release/Publish/ c:\\inetpub\\wwwroot RUN ['powershell.exe', 'Install-WindowsFeature NET-Framework-45-ASPNET'] RUN ['powershell.exe', '...
Rob Davey
0

votes
0

answer
3

Views

Crystal Report how to eliminate duplicate data in details section?

I created a report that has fields from 2 tables but CR automatically duplicates the data in the details section which is a pain in the a**. Is there any way to eliminate this kind of behavior? Here is my code so far: Dim reportsfolder As String = Application.StartupPath + '\PrintArea\' Dim comand A...
Jeffrey Oliveras
0

votes
0

answer
4

Views

How can i fix thisnin crystal report

https://ibb.co/x1tR4RJ I have this error when i try to run the report. I already install crystal report runtime 64 and 32 bit but still not working, how can i fix that?
Newb
1

votes
2

answer
853

Views

Crystal report not working Azure web apps

We are using crystal reports in asp.net application (https://kegxchange.azurewebsites.net/) However when we publish the application we are getting the error “Could not load file or assembly 'CrystalDecisions.Web”. Is it possible to install crystal reports runtime for this site or is there any w...
Mohamed Aarif
1

votes
0

answer
689

Views

Unable to cast object of type 'FileStreamDeleteOnClose' to type 'System.IO.MemoryStream'.

Issue while generating crystal report. It was working fine when hosted on Sql Server SP 2008. Shows error on sql server 2012. I cant change the code right now. What can I do other than that? I have installed Crystal Report version 13.0.2000
Samsam
1

votes
0

answer
1.2k

Views

Crystal Report Error on Server - Unable to cast COM object of type

Project: ASP.NET with C# Visual Studio: 2017 Crystal Report: SAP CR for VS 13.0.21 Crystal Report Data Source: List Working fine on Visual Studio. But not on the server. I have changed the properties of .rpt file to, .# Build Action: Content. .# Copy To Output Directory: Copy Always. Error D...
East Wind
1

votes
0

answer
162

Views

Crystal Reports integration with Hadoop/Hive/HPLSQL

We are migrating data from Oracle to Hadoop and there is a requirement to continue use the existing reporting tool(Crystal Report) to generate reports from Hadoop (instead of Oracle) In the current scenario we are using an Oracle Stored PROC to do few aggregations /logic. Now with the above requir...
Nina A
1

votes
0

answer
1k

Views

Crystal Report Installation in Windows Server 2016

How to install crystal report in Windows Server 2016 64bit? i tried a lot but still didn't succeed. A screenshot of the error:
Mohammed Sufiyan
1

votes
0

answer
44

Views

Crystal Report viewer always keeps asking me to login

I have this problem: Crystal Report viewer always keeps asking me to login but i don't know how to change the server name and database so that I can Login. This is my code : using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using S...
mhalditaCpunk
1

votes
0

answer
210

Views

CrystalReport and SQL Server : connection error

We have an inhouse system that creates a report with Cyrstal Report using data from SQL Server. Unfortunately the person who created the software already left. The new user of the computer installed another version of Crystal Report on that computer and after that he can not generate reports. We ar...
Kiko
1

votes
1

answer
363

Views

Crystal Reports cut of string

I'm new to Crystal Reports and I'm looking for a way to cut off a string if the string is too long and replace the end with ... So I'm using Crystal Reports to generate Word or PDF Files. The Problem now is that I have a textfield that is too small for long strings. The thing I want to do is check...
Philippe Hebeisen
1

votes
0

answer
1.2k

Views

Crystal Reports with Java

I am using Java to generate crystal reports locally -not on report application server- and trying to export to XLSX format. but so far, I was only able to export to xls format. does the java library for crystal reports support xlsx format? Edit 2018-02-02 if possible, I want the file to be saved dir...
ahmad alzamer
1

votes
0

answer
117

Views

Update Browser Title When Open Crystal Report in PDF Format

I am developing a web application using MVC 4. For reporting I am using Crystal Report. My client wants all reports in PDF format and reports should open in a new tab of browser. But after I generate the report in a new tab the tab title is the controller name. I want to set the report name as the b...
Ahmed All Razi
1

votes
0

answer
27

Views

Column headers disappear when printing report

My report looks exactly as intended when I Preview it. But after I printing it out, all column headings are removed. How can I ensure the column headings appear even after printing?
user2755525
1

votes
1

answer
297

Views

Crystal report viewer losing parameter on refresh

I have set some report parameters programatically and it workds fine but when user hits refresh , crystal report prompts for those parameter values too. I am trying to reset those parameters by handling crystal viewer refresh but unable to do so. any ideas?
H.Ahmed
1

votes
0

answer
73

Views

Can't refresh crystal report in VB for reports without parameters

I have a legacy VB6 application where I am able to open all reports and even refresh them (with their existing parameter entries). However, when I refresh reports that don't have any parameters I get error -2147483638/Automation error. This happens when I try to re-set the report source. It seems...
user3750023
1

votes
1

answer
287

Views

Error code 20545 Crystal Reports when printing

I'm printing a report, created in Crystal Reports 6.0 from VB6 application. Sometimes the users get an error 20545 ('request was cancelled by the user'). They do not click 'Cancel' button and printer exists on the machine (it's a network printer and it's working properly). Can anybody suggest, what'...
Laura Vélez
1

votes
0

answer
141

Views

Columns missing when viewing db table in the field explorer

I am connecting a SQL database to a crystal report. There is a specific column from a table that I need to pull data from. When I go to the field explorer, the column does not appear. I checked to make sure it didn't have any funky properties and it is identical to some other fields that do appear...
Jen S
1

votes
1

answer
79

Views

SQL query generated by Crystal Reports works in SSMS but pulls no records in Crystal

As the title says, I've built a Crystal Report to pull data from a SQL server. The SQL query that Crystal Reports generates pulls the data as expected when copied into SSMS but pulls no records when the report is run from Crystal Reports. My record selection: ({PRECEIPTD.CREDAT_0} >= {?startDate} AN...
z-combs
1

votes
1

answer
166

Views

ExportToHttpResponse is not working for Itemtemplate button inside update panel in ASP.net

I have a Gridview inside an UpdatePanel. I want to download file by clicking on the itemtemplate button inside the gridview. Every thing is working fine when the update panel is removed.the file is downloading smoothly but inside updatepanel file is not downloading. i want to download the file withi...
Yahya Hussaini
1

votes
1

answer
816

Views

The document has not been opened - Crystal report

I have some crystal reports on a website. They are working fine on my local machine. I'm using Crystal Reports version 13.0.3500.0 The test environment it is on another server, Windows 2008 R2, 64 bit operating system. The problem is that when on the test environment I want to use a crsytal report...
Kar
1

votes
0

answer
129

Views

crystal reports Summarising field in group header has duplicated value

I am trying to summarise (sum) a field in a group header and the value is being multiplied by the number of details lines within the group. The structure of my data is the following tables- Branch Job Invoice InvoiceLineItem and my report groups follow the same pattern, with the invoice line item be...
Thed
1

votes
0

answer
83

Views

Duplicating data in crystal report with MySQL and C#

I have a problem in displaying the data in crystal report using left join. When i use 'where no_barang = 2' in Phpmyadmin is working. But in crystalreport not working (the data is duplicate, and showing all data). table 'barang' no_barang | nama_barang | harga_barang 1 | sepatu...
1

votes
0

answer
95

Views

Crystal Reports 2008- distinct count based on condition

I have a table that has a column with unique call numbers and another column that has seconds between events. I want to do a distinct count of the call numbers if the seconds between events is greater than 0. I do not see any nulls in this column. I tried to do a simple Running Total, but it is not...
LiveWire
1

votes
0

answer
37

Views

Upgrading Visual Studio 2013 to 2017, how to deploy Crystal Report reports

I developed a WinForm application with Visual Studio 2013 that uses a lot of Crystal Report report created with CrystalReport for Visual Studio 2013 (CRforVS_13_0_12). Now I would like to update my IDE to Visual Studio 2017 with the new CrystalReport for Visual Studio 2017 (CRforVS_13_0_12) since th...
SilentRage47
1

votes
1

answer
533

Views

Arabic number in crystal report

i can't display arabic number in crystal report, Arabic number apear in Report preview(design). Arabic number converted to english in runtime mandatory,I need to dispaly it in arabic not english. I try to change in windows language sitting not work note : this problem occur when using win 10 but whe...
Mustafa ShazLy
1

votes
0

answer
23

Views

In crystal report main report view print one page but system prints two pages

In CrystalReport main report view print one page but system prints two pages ReportDocument myDataReport = new ReportDocument(); myDataReport.Load(@'C:***\WindowsFormsApplication_Test\CrystalReport1.rpt'); crystalReportViewer1.ReportSource = myDataReport; crystalReportViewer1.Refresh();
1

votes
1

answer
47

Views

Prompts not working correctly in Crystal Reports

I have a report which I would like to create prompts for both VENUE and DATE RANGE, and after having these prompts bring back the incorrect data, I have deleted both and tried to start again from the beginning. To begin with, I have a Crystal Report based upon the below SQL: To summarise the code -...
Asher
1

votes
0

answer
76

Views

Crystal Report application not able to run on Windows 7

Created application using VS2015 on Windows 10 64 bit system, on this system it works fine, but when i run same application on Windows 7 64 bit machine get an assembly reference exception. Tried installing CRforVS runtime installer or redist packages but no use. Can anybody tell me how to resolve t...
Your's P
1

votes
0

answer
43

Views

how to convert xml to crystal reports, using c#

it´s my first question here so tell me if any additional data is needed. I´m using c# (visual studio community 2017) to read an xml file, and I´m trying to convert the xml into a crystal report format. When I drag and drop a field from the 'database fields section' to the crystal report in the he...
1

votes
0

answer
42

Views

Rendering 300k records in crystal report shows only 1 record

I'm new in Crystal Reports and I'm trying to render rows from database. When I try less than 100k rows, the reports works fine, but when I try it with more records, the report only shows one row. If I look at the rows of the data-source, it has 300k rows: But the output of this reports has only one...
Julius Morcilla
1

votes
1

answer
40

Views

Conditional formatting for dates in Crystal Reports

Relatively new to Crystal Reports. I'm trying to get a date to populate normally if it is after today's date, but with a leading and following asterisk if it's prior to today's date. What I tried: if {V_ORD_DTL_AVALIABILITY.MUST_SHIP_DATE}>CurrentDate then {V_ORD_DTL_AVALIABILITY.MUST_SHIP_DATE} els...
A. Sullivan
1

votes
0

answer
200

Views

Microsoft Framework Update (KB4054981) Causing Issues With Crystal Reports 13 Not Displaying

Per the title, I am having issues getting a Crystal Report to display on my website. Here are the necessary details: Microsoft security and quality update for framework 4.6/4.7 was applied to a server the night prior. We know that this is the culprit because once the update was rolled back, with no...
PhoenixFly
1

votes
1

answer
72

Views

Publish over file system fails for ASP.NET site when “copy always” selected for Copy to Output Directory

I've got an ASP.NET web application in which I recently added a Crystal Report. I have my build action set to 'None'. When Copy to Output Directory is set to 'Do Not Copy' the project builds and publishes fine. When I change the copy option to 'Copy Always' the publish action always fails every t...
Jeff Balcerzak
1

votes
1

answer
319

Views

How to insert a page break after n records in a group?

configuration (Please don't laught ) : the technologies in use are : Crystal Report 6.0.1.135 VB6 Question : I have a report with a subreport. I am facing an issue on the subreport : when the subreport reaches the bottom of the page, the last 2 lines (records) are 'hidden' by the main report Foot...
sandwood
1

votes
2

answer
46

Views

C# with crystal reports columns from different tables

I think this was simple for some C# masters here.. Language: VS 2010 C# Windows Application Database: MySQL Workbench CE Reporting: Crystal Reports I can generate a report from a single table but when I add a columns from the other table, the data of my report was becoming blank.. only the column na...
1

votes
1

answer
70

Views

Crystal Reports Selection Formula If No Match Then

I currently have a Crystal Report with a selection formula that looks like this {dbo.CustomerName}={?CustomerName} AND {dbo.Opportunity}={?Opportunity} An issue that I'm finding is that sometimes there isn't a matching customer name, but the report still needs ran on the subsequent selection formula...
scedsh8919
1

votes
1

answer
37

Views

Error in deploying clickonce windows app with crystal reports when deploying

I have and error in launching my crystal report viewer and loading the reports from my database after I deploy my windows based click once app into other computer I think the problem is that my .rpt files path file is hard coded like this thats why it cannot find the .rpt file when deployed to other...
DDD

View additional questions