crystal-reports

Crystal Report Custom Paper Size?

I need custom paper size in crystal reports like widt 5" and heght 7". Is it possible. ...

Include formula field in cross tab.

Hi i have a long formula field which I would like to include as the cross tab report summary field. However after I define the formula field I don't see it in my crosstab screen. How to include it ? Here is my formula field WhilePrintingRecords; numberVar rt; numberVar layMdp; numberVar totMdp; rt=Round(({Command.GENGNPIAMT}/{Comma...

PrintDocument on Crystal Report Viewer C#

I have a PrintDocument, in which data is printed on PrintDocument.Print() method. This method calls an Event Handler called PrintDocument_PrintPage(object sener, PrintPageEventArgs e). Currently I am printing the PrintDocument using a PrintDialog(), but now I want user to view the PrintDocument on Crystal Report Viewer. So, how can I s...

Crystal Reports Viewer Component - Royalty Free?

Does anyone know if the Crystal Reports Viewer that comes with Visual Studio 2008 is a royalty free distribution for C# apps? Thanks. ...

Display Image from Windows Folder in Crystal Reports 8.5 or 9

I am Storing unique Picture name in database. In Picture folder same name is applying for picture also. I need to load picture from the picture folder with respect to the name stored in database. Is it possible? ...

CrystalReport and Stored Procedures using C# Question

Hello everyone, I have an application which needs to generate a report. However, I do not know how to generate a report using CrystalReport which is based on a query. Let's say I just need to generate report from my database which shows the values returned by my select query. I've never used Crystal Reports before so I'm new to this. ...

Crystal 2008 - Can I access the SQL statement programatically at runtime?

We've created a Crystal Report viewer application to house all of our company reports. It's built in such a way that any time we add, modify or delete a report, the viewer application itself does not need to change. The viewer app is completely driven by an XML configure file that tells it what reports are available, where they are, conn...

Fetch Cross-tab grandtotal ?

Hello fellows, Good day. I have a cross tab inside a subreport. I need to fetch the grandtotal of cross tab and display it in a textobject under the cross tab. Any clue how this can be achieved ? ...

.NET app with CR Viewer getting 401 unauthorized on toolbar resources

Hi - I just migrated my .NET MVC 3.5 sp1 app to a VPS running 2008x64 and IIS7. My app uses a Crystal Report Viewer to dynamically display reports. I was able to get the reports to display properly after installing the CR runtime CRRedist2008_x64.exe. From past experience I also copied the aspnet_client folder to the root of my app on th...

Crystal Reports Localization

We're developing an existing application with C# 2.0 and Crystal Reports for Visual Studio 2005. The problem is we want to localize the report dynamically. How to achieve it in Crystal Reports 2005? So if the current culture is "id-ID", I want my report to display "Rp" instead of "$" , and the date format in in Indonesian format. ...

how to get print button over here in website reportviewer in asp.net

in Report viewver in website im not getting the print option. i have used ReportViewer1.ShowPrintButton =true; but still no print option came. how to get print button over here in website reportviewer in asp.net ...

Field explorer is not updating in crystal report

My field explorer in vs2008 is not updating my dataset. So there any suggestions to this issue are welcome. I am using Crystal Reports Basic for Visual Studio 2008. ...

SUM still includes suppressed values

I've got a report that includes some limited duplicate information, there are multiple dates possible, but I want the dollar values to display on only the first item. IE: Item 1 - Aug 3, 2010 - Cost $1000 Item 1 - Aug 4, 2010 - (Cost suppressed) Item 2 - Aug 3, 2010 - $100 Item 3 - Aug 4, 2010 - $200 When this is summed, it ...

How to avoid CR viewer in asp.net from requesting log on?

I have an asp.net app upgraded from vs05 - vs08 that has reports using the cr report viewer. When I run a report it displays data fine. When I click on an option of the tool bar like next page or export it presents the log on page. This is happening in development running inside vs08. It used to run fine in development in vs05. Could s...

VS/2005 Crystal Reports - How to repeat a field multiple times in the details section

hello Im trying to duplicate/display a field that is in the details section of a crystal report, an amount of times based on a value that is calculated in a seperate function. Does anyone have any idea how I could go about doing this? ...

Previous function, but for two (or more) rows previous

I'd like to get the value of a cell, two rows previous, is that possible? I know I can do the row previous, but I'd like two (or more) rows previous Previous({myTable.myColumn}) ...

CrystalDecisions.CrystalReports.Engine, Version=11.5.3700.0..

i have CrystalDecisions.CrystalReports.Engine, Version=11.5.3700.0.. i need to open aprogram with Version=11.5.3300.0.. How should i proceed.... thanks in advance ...

how to add columns dynamically in crystal reports(vs 2008)

Please explain how to add columns dynamically in crystal reports(vs 2008). The columns will change based on customer needs. ...

Crystal Reports 8 - 2 machines, only 1 exporting

Hi, i'm working on an old VB6 project, using CR 8. At the development machine, with Crystal Reports installed, i can export to excel, for example, without problems. Not so at a client machine. I've copied all the CRs dlls and used modules to compare what is different. The only thing different about the two machines is that the developmen...

Preview data from Access tables in crystal report through vb.net code

Greetings, How I can retrieve data from Access database and preview them in crystal report in vb.net?. To be more clear: I have Access tables I want to retrieve data from them through vb.net Then I want to preview this data in crystal report created on desktop through vb.net. Please help me... Thanks all. ...