Questions tagged [crystal-reports]

1

votes
1

answer
1.4k

Views

Crystal Report Crosstab String Data

I have a datatable that looks like this (all columns have string datatype) firstCol secondCol thirdCol 1_str1 1_str2 5,1 2_str1 2_str2 5 3_str1 3_str2 .... .... .... note that on the thirdCol, some fields are blank. as for the crystal report, I have used th...
Codemunkeee
1

votes
0

answer
5

Views

Download Large PDF Files (Bigger Than 150 MB) With Crystal Report

I have .net mvc project. This web project has a screen which can download report file with specified credentials. This screen use Crystal Report. User specifies inputs and then click the download button after that stored procedure is executed to fetch data. User can download pdf files which's size...
John
1

votes
6

answer
28.4k

Views

Crystal Reports :Database Logon Failed

I am trying to print crystal report in PDF format , and on my local machine it’s working fine. But when I publish application to the server, it’s giving me the following error on Print button . I am using VS2012 , SQl Server 2012, IIS 7.5 and CR version 13.5 Note: I am using integrated security...
user3235068
1

votes
1

answer
2.3k

Views

How to open field explorer in visual studio

I am working on Crystal Reports in VS 2010. I unexpectedly closed Field Explorer from left side of Visual Studio and now I don't know how to open it again. I searched it in Edit and View menu but didn't find it. Can you please guide me how to open field explorer in Visual studio.
0

votes
2

answer
109

Views

How to use impersonation to access a network resource from IIS?

I have a WebApi app that needs to access a network share on a different machine and open Crystal Reports files. I'm using LogonUser and WindowsIdentity.Impersonate to impersonate a user that has rights to the network share using this code (not complete): SafeTokenHandle safeTokenHandle; const int LO...
Ivan-Mark Debono
0

votes
0

answer
9

Views

Where is app pool located in visual studio?

I'm having trouble finding the app pool, I need to set my app pool to allow my crystal report to run properly. On my computer where I develop the application, it works properly but when I try to run the program on another computer it won't run, I've read similar articles about it here, but I can't f...
Noah James
1

votes
0

answer
9

Views

How to remove html tags from crystal report

I did use htmltexteditor now the problem is when i creating the crystal report & try to fetched data from database within dataset it shows data with html tags. & its also not showing complete data & not goto second page as well. i'll try to use regex.replace but cant find where should i use this? u...
A.Aleem K Solution
1

votes
2

answer
347

Views

Vertical & Horizontal data arrangement in same page of Crystal Reports

I am importing data from a single data set in my crystal reports. I have just a single column table in my report. I want to arrange some data vertically say 10 rows of the table (In two vertical lines) and some data horizontally say next 10 rows of the same table (In two horizontal lines). I have ma...
Rizwan606
1

votes
4

answer
1.2k

Views

What would be an alternative to Crystal Report on WPF Applications [closed]

From what I understand, CrystalReport is somewhat of deprecated. What would be a suitable replacement for it on WPF Apps?
Shamim Hafiz
1

votes
1

answer
7k

Views

Open Crystal Report in Winform

I've created a crystal report then after creating it, I've created a winform where I've import crystal report library (shown in code) and used a report viewer to view the report but i not able to view the report, the code, i am new with Crytal Reports, the code I've done is : Code: using System; usi...
Jack Frost
1

votes
1

answer
5.6k

Views

How to print reports to the chosen printer using .NET, SAP Crystal reports Engine 64 bit on a 64 bit server (Win2k8)?

We have a windows application that is built on .NET remoting. It’s a 32 bit application built using .NET Framework 2.0. We are using SAP Crystal reports run time engine for .NET Framework 4 (32-bit – Version 13.0.3) for reports functionality. There is a printing functionality also which prints t...
Sri7
1

votes
5

answer
16.8k

Views

Crystal report asking username and password

Every time I open my form that has a crystal report it always ask for username and password but i did not even use a username and password in my web application. I use integrated security in my web.config. How can I fix this problem? This is code: using System; using System.Collections.Generic; usin...
anonymizer
1

votes
2

answer
731

Views

how to send value of query string in an array

I am making a Crystal-Report from data of GridView. The GridView has three columns in which two columns are filled with values coming from DataBase in a label and third column has a CheckBox which on check sends the value of these two columns as query string to the .cs page of Crystal-Report. The co...
user1947927
1

votes
2

answer
2.2k

Views

accessing previous record fields in crystal reports

I'm displaying grades for student records. They sit a lower year (AS ...), then choose to continue certain courses to the upper year (A ...). This means that I have the following dataset for each student: +----------------------+-------+-----------+-----+ | Name | Grade | End...
pluke
1

votes
2

answer
2.4k

Views

Crystal Report not working in IIS 7

I have a web application developed on ASP.NET 4.0, SQL SERVER 2008 and Crystal Report 2008. When running on VS2010 it works fine but when i deploy it on IIS 7 reports are not working. Application logins successfully. Database is Correct. Connection on reports are correct. I gave full permission to...
syed mohsin
1

votes
2

answer
7.5k

Views

Change Crystal Report Text Object Text at Run time

I'm using a Crystal Report on my project. It's working very well but I just want to make it more flexible. I have text objects with text in them. They are not bound since they are just additional information on my report. How can I make those text objects editable during runtime? Something like on m...
Lethugs
1

votes
1

answer
690

Views

Why Crystal Reports not showing int, DateTime, double, money fields etc?

I have set the objct of a class as the datasource of the CR. All the string fields appear in the Fields Explorer in the design alright. But what happen to the numeric or datetime fields? How do I bring them? public class ClsOutDocket { public string RegistrationNo { get; set; } public double...
sony
1

votes
1

answer
3.6k

Views

crystal report Text object overlap

i am creating crystal report for win-forms. I have crystal report shown in image.The top text object overlapping the other text object.I have set both text object property of can grow to zero.i have tried keep together option but not working.What could be done here?I want to set space between these...
sharad
1

votes
1

answer
2.1k

Views

Programatically append Crystal Reports without using subreports

My task is to create an "app" that will allow the following: given a list of Crystal Reports on the server, the user can select any number of them to combine into one long report (just appended together). They must be able to set the parameters for each report. I've gathered that the usual method wo...
Jason Costabile
1

votes
3

answer
5.6k

Views

Crystal Report for VS2008 error: “The request could not be submitted for background processing”

I'm developing with VS2008 and Crystal Report for VS2008. There is a report that includes an image object, which shows a JPG file stored as a blob field in Oracle database. Most of the times that report exports to PDF correctly, but some times returns error:"The request could not be submitted for ba...
Jorge
1

votes
3

answer
4.5k

Views

Left Outer Join on Multiple Tables hides data with selection expert- Crystal Reports

I'm having trouble with crystal reports in reporting on two tables in a one to many relationship. Example Tables: dbo.stock Barcode Qty 12345 3 11111 5 22222 6 dbo.sales Barcode SalesDate QtySold 12345 1/1/2013 1 12345 1/1/2012 1 1234...
Bryn
1

votes
1

answer
13.1k

Views

Concatenate string and numeric field in crystal report

I want to concatenate city and pincode field in crystal report. I have tried: {datafield1.city}&"-"&{datafield2.pin} It is displaying ex: Mangalore-568,757.00 But I want mangalore-568757
user2218469
1

votes
2

answer
3.5k

Views

How to obtain number of pages in a Crystal Reports .NET report

I have a web application in which I render one or more Crystal Reports and then merge them into one PDF. What I'd like to do is obtain the number of pages from one CrystalDecisions.CrystalReports.Engine.ReportDocument object then then set that value as a parameter in the subsequent ReportDocuments i...
RoastBeast
1

votes
2

answer
2k

Views

Change values displayed in Crystal Reports Group Tree

Is there a way to configure or change the values displayed in the Group Tree displayed on the left in the crystal report viewer? I ask because in the report I am grouping id numbers, but I display the names associated with the id. I want to display this name in the group tree as well.
Nick
1

votes
1

answer
1k

Views

How to clear Recently Used Reports in Crystal Reports 2011

Is there a stackoverflow forum, which could answer Crystal Reports 2011 queries? I'm looking for instructions on how to clear the Recently Used Reports list on the first page. Thank you.
Mark
1

votes
2

answer
10.4k

Views

asp.net Crystal Reports, Database Logon Failed

I can't get this report exported as a pdf. I've done this many times before, but now I hit a brick wall. any help would be appreciated. This is on a windows 7 64 bit machine. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace f...
boruchsiper
1

votes
1

answer
3.2k

Views

Crystal Reports / concatenating rows based on change in repeated field value

I have been pulling my hair out on this one. I'm not very adept at coding formulas. I have a two column database that looks like this: USERID1 1/1/2000 USERID1 2/1/2000 USERID1 3/3/2001 USERID2 1/5/2000 USERID2 2/7/2001 USERID2 3/30/2009 USERID2 3/10/2013 USERID3 2/5...
user2544132
1

votes
2

answer
365

Views

Where in the database can I get the country name that matches addr_countrycode

I am using Sage CRM and creating reports in Crystal Reports 2011 I would like to display the country name that is in Addr table but it only has a code IE for Ireland. So my question is, where do I get the value Ireland (instead of IE)
Rachsherry
1

votes
1

answer
203

Views

AS/400 View not displaying correctly in Crystal Reports

I finally got Views that are created on AS/400 to show up in Crystal Reports. It may have been a space issue. We added disk. The issue now is when looking at the data, if you look at the view on AS/400 you will see normal data, as here: Part# PCK 22 01 A01 CRCUP7...
Pinchas K
1

votes
1

answer
1.3k

Views

Does Crystal Report internally re-size the images?

I am using crystal report for Preview purpose. I need to include image in the report. I am passing this image by dataset in the form of byte[]. I have set XScaling = 1.917 and YScaling = 1.917. Still I am getting images in the preview with not same aspect ratio as the original image. What I am doing...
1

votes
2

answer
4k

Views

passing parameter to crystal report asks for parameter value

I have a crystal report in which I am trying to pass label's text to crystal report. But whenever I try to do it asks or parameter value. I have another form in which done same thing but it works fine. Heres my code that I have tried : crystalReportViewer1.RefreshReport(); ParameterFields paramField...
user2454135
1

votes
2

answer
260

Views

Show MessageBox if no records for report

I already asked a Question Here. My this question is just a step ahead to same problem. I have a delphi code which works perfectly for calling report. But, now I wanted to show a MessageBox before opening rpt file. I tried to query it separately for record count and then decide for MessageBox. But,...
Romesh
1

votes
3

answer
1.8k

Views

Selecting * from max id when grouping by parentid (MySQL)

I have a big problem that I've been trying to tackle. Reading older similar issues hasn't been fruitful. My table has columns [id], [parentid], [data1], [data2] etc. There are some cases where only one record has same [parentid] and others have 2-10. I would like to group by [parentid] and print out...
ParoniAnttila
1

votes
1

answer
1.8k

Views

How does select formula in C# work using reports

I would like to ask a question about the following function related to reports in C#. crystalReportViewer1.SelectionFormula = "{Cars.CarCode} = " + CarCode; Does this formula add a filter condition to the current query code that is used in the report, or does it create a whole new query? If not is t...
user2342875
1

votes
2

answer
21.7k

Views

Crystal Reports : Insert an image in the Report Header section

I need to insert a report homepage on an existing RPT file. The existing RPT file works fine, it displays results from a stored procedure. It's ok. The homepage must contain an image from the database. So first, I added a new SQL command (through the window "Database Expert") with a new SQL query in...
Nico
1

votes
4

answer
2.9k

Views

Crystal reports keep sections together on same row

Is it possible to show two groups and details in the same row? My crystal report has two groups that I keep together. The current output is: LocName Date un1 un2 ------------------------------- LocNAme Date compl compl compl compl LocName and Date are grouped. I would like the out...
user2878851
1

votes
2

answer
1.7k

Views

Error reading resource file 'C:\..Report.rpt' — 'The system cannot find the file specified. '

Continuing working from previous thread here. What I have done is copied and paste the .rpt files from where the .cs files are located and moved in the \bin\Debug folder. It works but when I deleted the .rpt files where the .cs files are I get the error... Error reading resource file 'C:..Report.rpt...
bucketblast
1

votes
1

answer
2.5k

Views

Zoom Page only in Crystal Report Viewer

I am facing a problem while I want to zoom in or out a report on a asp page. I have added the crystal report viewer in panel and added scroll bars to it but when I zoom in the whole viewer zooms in and when I zoom out whole viewer zooms out
Rafay
1

votes
1

answer
2.3k

Views

How to change the bar colors of a chart in a crystal report

How to change the bar colors of a chart in a crystal report?
Samar
1

votes
1

answer
699

Views

Is the IN operator in Crystal Reports case sensitive?

I have a long list of strings that I need to compare a column against and I am wondering if doing this {table.column} IN ['ABC'] is the same as this {table.column} IN ['abc'].
Casey

View additional questions