Questions tagged [crystal-reports]

1

votes
1

answer
85

Views

Can't figuring out what library is missing

I have an application with Crystal Reports in it. It has issues where it doesn't run on some computers. I haven't had this issue in a while so i tried to install all i remembered i needed. First i made a simple console application that has an empty Crystal Report and all it does is instantiate the r...
Franck
1

votes
0

answer
68

Views

Arabic characters displays tangled incorrectly in crystal reports

I am using Crystal Reports for VisualStudio v13.0.23 for Visual Studio 2017 and I am creating a report that is in Arabic language Here is a screenshot of the right display (that’s when activating – in focus - the textbox for editing) However, this wrong display appears when textbox loses focus...
Ahmed Nazmy
1

votes
0

answer
33

Views

How to add Seconds to existing Crystral report formula?

I need help adding seconds to a time stamp on a crystal report RPT file. The current formula is converting the time and stripping away seconds. In CR, i can adjust the formatting to display 'seconds' but they always show as 00 instead of the actual. We have clients in multiple time zones but our...
1

votes
0

answer
93

Views

Crystal Report Webform_initcallback is not defined

Crystal report does not load at runtime. Please see the attached image. I am done routing in global.asmx my project.
Navnit
1

votes
1

answer
94

Views

c# - Print the winform in high quality?

This question may sound familiar but i have searched internet and couldn't find a solution to it. I know for printing we can use Crystal Report but i am discarding that idea because of it's certain disadvantages. Here are some of the disadvantages:- Needs installation on PC and if the Visual Studio...
Agent_Spock
1

votes
1

answer
43

Views

How do I set a Range Parameter on the web form that will be applied on the crystal report?

I have just recently created a WebForm which consists of 2 forms, the first form consists of just a button to redirect to the second form which then opens up the Crystal Report. All this is working fine and properly but now I would want to insert a Parameter(filtering a range) on the first WebForm s...
Yuen oon
1

votes
0

answer
132

Views

How to use a dynamic parameter with a command in crystal reports?

The problem I'm running into is quite easy to recreate. In Crystal Reports Developer I add two different tables: The full table 'Users' A Command containing SELECT * FROM Users In the Field Explorer I add a new parameter and set this to dynamic. I have this parameter pull it's data from any field in...
Maarten H
1

votes
0

answer
35

Views

How Can Formatting Arabic Name of Date ar-AR or en-EN in SAP Crystal report

How can I display Arabic name of day ar-AR from a date in Formula sap crystal report in C#? like this code from C# get Hijri Date and Name In arabic ar-AR: Hejra_label.Text = HijraDate.ToString('dd/MM/yyyy' + ' ' + 'MMMM', new System.Globalization.CultureInfo('ar-SA'));
Eng Alnahdi
1

votes
1

answer
268

Views

Crystal Reports running on a Client Computer (without CRRuntime)

Good day. I have this desktop application that was installed in our server. Currently, the users are just mapped to the application's EXE. The application is working fine but when I view Crystal Report in the client computer, it gives me this error: An error has occurred while attempting to load the...
Allen Binuya
1

votes
0

answer
209

Views

Crystal report or other alternative for Visual Studio Code

Is it true that Crystal Report no longer works with Visual Studio Code? If yes, is there any other alternative that is compatible with the VS Code? Many thanks.
Timothy Ho
1

votes
0

answer
31

Views

How to run my Crystal Report in Crystal Report runtime 13.2.469

I am using Visual Studio 2015 to develop a small application. That application needs Crystal Report runtime 13.0.22 to run the report. My client PC has already installed Crystal Report runtime 13.2.469 to load another application report. But my report is not run through the installed Crystal Report...
Mithila Das
1

votes
0

answer
51

Views

Visual Studio tab's detached on their own as a separate window

I have a problem when using Crystal reports in visual studio (2015). When I work on a report (doc.rpt) in a Visual studio tab, if I exit this first tab without saving my work for a second tab of source code (like code.cs, code.vb,etc)or another report (.rpt) the second tab will detach, in an unexpct...
Damocles49
1

votes
1

answer
83

Views

Crystal Reports - report can't connect with database

I have issue with my report. I install my app on two PCs. On first one I have SQL Server (MS SQL). On first PC reports works. On second PC which is in same LAN report prompts me a window to set connection (which has empty, not editable database name box). Report was created in Visual Studio 2017 wi...
tomek-a
1

votes
1

answer
13

Views

How do I store each detail section value in a separate Variable?

Please check this image for details Formula - @B If {Command.Dept} in ['AAA','BBB','CCC','DDD'] and {@TOT}>0 Then {@TOT} So this should give me only values as follow 190 170 190 220 Formula - @C If {Command.Dept} in ['AAA-Bud','BBB-Bud','CCC-Bud','DDD-Bud'] and {@TOT}>0 Then {@TOT} So this shoul...
Dax
1

votes
0

answer
117

Views

How to view a crystal report from a VS2017 C++ application

I have a VS2017 C++ application that currently includes a large number of Crystal reports which are viewed through an external exe file built using the Crystal Reports XI developer edition. This included a C++ class, CCrystalReportViewer11, which can be used to view and access reports from a Visual...
SmacL
1

votes
0

answer
27

Views

cyystal reports- setting currency symbol via globalisation (C# winforms)

I have more that 50 reports in my project hence i cannot opt to pass currency symbol to each and every report individually hence i am exploring an alternative to it, i have already set culture symbol to what i need but i am unable to set my crystal reports to accept that symbol. for your better unde...
user3555836
1

votes
1

answer
114

Views

strikeout/strikethrough specific text within the same column and rows in crystal reports

I have this problem where I want to strikeout a specific text in crystal reports. I mean I do not want to strikeout the entire string in that column I am using crystal reports in visual studio. Here is the image: I format the encumbrances column and check the strikeout as shown in the image below: T...
Rak
0

votes
0

answer
7

Views

How to export crystal report into Excel 8.0?

I want to export crystal report into excel, but when it exported some of excel column is merged. when i tried exported using the designer with export option is Excel 8.0 it look good. is there any parameter on .Net that i can used to export crystal report to certain excel version? ExportOptions expo...
patrixx
1

votes
0

answer
31

Views

Creating a dataset that indicates what areas to show in a Crystal Report

CR for VS 13_0_22 - I'm creating a report with the data in a group header and footer to then be exported to PDF. I create a dataset using a xml file with sql query, and then adding it to the report in VS2017. The goal here is for some areas of the report to be shown depending on configuration. I was...
TheOne__
1

votes
1

answer
19

Views

Crystal Report sum by column

The Problem This is the problem with my crystal report, I need to sum values from different columns with the same name.
Thinesh
1

votes
1

answer
84

Views

C# and Crystal Reports Deployment Issue

I have developed an application in C# framework 4.5 and designed the reports in crystal report, I am having severe issue of deployment on client machine. I have already performed these things, but type intializer issue raises every time:- Compiled application with Any CPU settings and Install framew...
Hashim Ali
1

votes
0

answer
158

Views

Deploy C# Windows Application with Crystal Report

I really need to help my client which wants a complete application within this week. But I am stuck with a Crystal Report error. If you need more details from me, I can provide them for you. The program is working fine on my PC after excuting the setup, but when I put it on my other PC, it shows th...
Saad Ahmad
1

votes
1

answer
46

Views

Return all possible index parameters

I am working with C# and Crystal Reports library. I have a method that gets the SQL query for a specified parameters as shown below; pi.GetIndexParameters()))[0].CommandText; My issue is that once a report has more than one query - how can I find the number of indexes (queries) the report has and re...
Aleksandar Zoric
1

votes
1

answer
39

Views

Show formatted WYSIWYG field in Crystal Report

I am working on an application where it is necessary that the text that a user enters be formatted, be it bold, italic, point forms etc. For this reason I have elected to use a https://summernote.org/ Everything is fine and gets saved to my database. The problem is, when pulling up a crystal reports...
Niana
1

votes
1

answer
161

Views

How to use jquery datatable custom button to export crystal report pdf

Exporting Crystal Reports to PDF is working fine if that is done via form submission to the controller method, but not working when the method is called from a jquery datatable custom button. Please go through my codes and help how to download the pdf by clicking a jquery datatable custom button. Co...
shuvo
1

votes
0

answer
22

Views

May I know what will be the correct architecture for display Crystal Report in .Net MVC?

Let me tell you my architecture first. There are 3 layers in our application architecture. Repository layer(Database interaction layer) Service layer(Business layer) Presentation layer Current implementation of our architecture is: a. We have created models and viewmodels. eg. public class Employe...
Rikhav Shah
1

votes
1

answer
172

Views

How to collapse or expand data in details section of crystal report 2011?

Is it possible to collapse or expand data in details section of crystal report 2011? I tried to use Hide (Drill-down OK) but it doesn't bring + or - signs of to expand or collapse, it works like subreport. Please anyone can help me
Schadrack Rurangwa
1

votes
0

answer
89

Views

How to use service account for crystal report to connect to sql server datasouce?

we use the service account to log in SQL Server (i.e domain\accountName, account password or window authentication). There's a service account dedicated for running a report. I need to change the data source for crystal report to use the service account (or using impersonation) but seem like CR can'...
p4era
1

votes
1

answer
28

Views

How to pass selected data shown from datagridview pass to CrystalReportViewer

I want to create a print button to show a datagridview values with some labels in form to crystalReportviewer this's what i did i've created a report.rdlc that contains dataset from a class This's how i show my table to dgv private void btnSelectAll_Click(object sender, EventArgs e) { if (cmbCategor...
eSooner
1

votes
0

answer
63

Views

Parameter Field current value exception was Unhandled

I'm having a problem in my program that when i click the print button it always show up this error Sample error and i don't know what to do now. this is the code, this is my parameters sample parameters Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase...
Baron Munggo
1

votes
0

answer
136

Views

Passing parameter to crystal report and link it to database fields to get specific record and show it

I have build crystal report with vs 2013 and I did the following add the database fields for the tables I need. I am calling the report from form1 and it display the data so it is good but what I need to is get an ID from textbox in the form1 and pass it as parameter to report so it display a spe...
sam
1

votes
1

answer
14

Views

Crystal reports 2008 database table currencies could not be found

I'm new to crystal reports and have been having an issue. The report is able to print properly on my system and on their host server however they have another server where everyone connects in through in and whenever we try to print from that server this error code pops up. Any advice for a resoluti...
FraserM
1

votes
1

answer
94

Views

SQL Query for Crystal Reports

I'm having difficulty getting information from an SQL database via Crystal reports. Because I can't get the SQL query to return the data I need, I'm looking at constructing the query directly instead of having Crystal Reports construct it. The tables I am working with look something like this: Table...
jbh006
1

votes
0

answer
112

Views

Reporting template is missing in visual studio 2017

Reporting template got missed in visual studio 2017, I installed crystal report still version 13_0_18, Existing reports are working while running but i cant able edit that reports, How do install Reporting template in visual studio 2017. when am trying to open any .rpt file it is showing like binary...
1

votes
0

answer
27

Views

Crystal Reports - Dynamic Grouping depending on Summary field

Trying to group dynamically depending on the field I sum using Summary. Example: table looks like Person | Date 1 | Category 1 | Date 2 | Category 2 | John | 1/1/2010 | minor | 1/1/2015 | major | Paul | 1/1/2010 | minor | 1/1/2015 | minor | I want to group...
user10512944
1

votes
1

answer
44

Views

SQL Image to Crystal Report

I want to pull image data from SQL Server 2008 Express and display it directly in a Crystal Report. I am using Visual Studio 2012 along with Crystal Reports for Visual Studio (also a full version of SAP Crystal Reports 2013). I have attempted to use samples from Google/SO searches but I seem to be...
ctmcklowe96
1

votes
1

answer
30

Views

Why am I getting failed to open connection in Crystal Reports method ExportToDisk

I have a report that users say was working. This application is new to me and Crystal Reports is new to me. The database was backed up and restored to a new SqlServer. The orphaned users were relinked and the report code (shown below) changed to point to the new server. Now it get's failed to conn...
billpennock
1

votes
1

answer
31

Views

Crystal Reports 2016 crosstab supress rows based on value of specified columns that are conditionally available

I have a crosstab like this Col1 Col2 Col3 Row1 1 0 1 Row2 0 1 1 Row3 1 0 0 Row4 0 0 1 This is meant for moving stock between warehouse and outlets. So If Col1 shows stock of the Warehouse and Col2 and Col3 are outlets then products from Row2 and Row4 are not availabl...
Mariusz Graszek
1

votes
0

answer
38

Views

Passing counter variable between page footer

TL;DR I need to pass a counter variable between page footer. Situation Each row in the picture is one footer in my report As you can see the 1 : ... at the Kinder column on the right it's my index and I can't figure out how to count it up on each footer. Code I declare the variable in my header with...
Daniel
1

votes
0

answer
123

Views

Sending data from datagridview to crystal report using VB.Net

Hy guys I have one problem. I have 3 important column, they are: Nama,Hasil, and Satuan. Nama and Satuan column is getting from database But not for Hasil column Value for Hasil column is entered manual, so How can I get that value in crystal repotrt? Would you like to see and help me? Thank you ver...

View additional questions