How to show empty groups in crystal?
I have a report that shows items by goups. Lets say he groups are: In Inventory In Process When there is no data In Inventory, that row is not shown. any idea how to show a row with 0 inventory? ...
crystal-reports
Can we suppress the Main report records, If the Subreport returns No Data in Crystal report?
I am Using Remedy AR ODBC DataSource, where We can not use Joins, as AR ODBC does not support join, So I am Using SubReport in Detail section(Used Proper Link) when I am running the Report: i.e., Main Report has 3000 Records and Maching Records in SubReport has 1000 records when I am running the Report, It shows all 3000Records and Blan...
crystal reports : record selection formula not picking up all domain names
I put the following in the record formula which strips down the domain name to just the name. For example, if the domain is mit.edu, it returns mit. if it the domain is pluto.mit.edu, it returns mit. if count > 1 c := mid(left({?domainname}, instrrev({?domainname},".")-1, instr(left({?domainname}, instrrev({?domainname},...
Building a .NET assembly which uses Crystal Reports on a build server
I'm trying to Build a .NET assembly which uses Crystal Reports on a build server without installing Visual Studio or the Crystal Reports Runtime. The version of Crystal Reports we are targeting in our code is the one that came along with Visual Studio 2008 and we are using MSBuild to build this project. I've copied what seems to be all...
Failed to open Crystal Reports
When I try to run crystal reports the following Error is appears: Transaction (Process ID 159) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction Note: Report is connect directly to stored procedure. ...
Crystal report printing with Dot Matrix Printer
Hi friends, I am facing problem with printing crystal report on Dot Matrix Printer. if I use ,Epson Printing then Speed is too much slow. if I use Generic Mode, Problem with alignment. replay asap. Thanks. ...
Does crystall X1 run with SQL server 2008?
Does crystall X1 run with SQL server 2008? ...
how deploy asp.net project which use Crystal Report 2008
i have created asp.net web application which use Crystal report 2008. Now i want to publish this project. i have installed full version of Crystal report 2008 on server. And all works good. But my bosh does not want Full Crystal Report 2008 to be installed on server. now my question: what i can do? Thanks ...
crystalreports copy paste from report viewer
Using c#, vs2008, crystal reports .net that comes with vs2008. I can create reports ok. I notice when i show a report that if i click on a field on the visible report it highlights the field with a dotted border. Is there 1. a Way to change this border highlight to a custom one 2. a way to right click context select/high light the fiel...
Multilingual report in Crystal Report for VS 2008
We are creating some reports using Crystal report for VS 2008. The reports are not in English Language but are in "Marathi" language - Unicode. The application is a web application. When the report is opend using the Report Viewer control the report looks proper. But, when the print button is clicked, Report Viewer opens up the PDF vers...
System.OutOfMemory exception while exporting large result set to crystal report in ASP.Net
I get System.OutOfMemory exception while exporting large result set containing 1 million records to crystal report in ASP.Net. I get the datasource perfectly from database the problem occurs only when i set datasource for the report and load the report. The exception comes after sometime of setting datasource to the report. The error pag...
Creating a Crystal Reports rpt file using Visual Studio 2010
We upgraded from 2008 to 2010 Visual Studio and I am trying to create a .rpt file and everytime I create the .rpt file it is renamed to a .mht file and I get the Crystal Reports for Visual Studio 2010 download information on the .mht file. How do I create a .rpt file and not have it do this? We are not looking to upgrade crystal at thi...
crystal reports- asp.net- load more than one report into the viewer
i have the below code that dynamically loads a .rpt file. the report is pulling from my proj management application and i want it to show multiple projects based on input from the user... on the webform UI i have controls that will allow me to eitehr get a list of project id values or i can generate a dataset or stored proc to get the d...
How do I make a Pie Chart in Crystal Reports that is JOINed?
I'm pretty new to Crystal Reports and I can create Pie Charts just fine, but I can't figure out how to chart a JOIN. For example, I have two tables "A" and "B". In the "link" tab of the Database Expert I've drug a line so that A.FK goes to B.PK. Table A Table B -------- -------- PK | FK PK | FK 0 | 1 1 | Gizmos 1 |...
Crystal Reports Check All dependencies of a report
Problem: As you may know report wizards and reports inside crystal reports have a Many to Many relationship. This makes reporting tricky as one report relies on: 1 or more reportwizards 0 or more subreports and these main reports can rely on multiple sub reports and those sub reports rely on multiple report wizards. So is there...
Crystal report tutorials
Can any one give me a link for studying crystal reporting provided by visual studio 2008. ...
hide "groups" based on formulae In Crystalreports ..?/
hi, am doing a report for showing catogory-sub-category wise sales report. i made to group headers with category and sub-category What i want to do is.. Hide subcategory(Group-Header) --> if user didn't specify or select any subcategory. ..?? ...
getting grouped records into separate view columns
I have a crystal report with a subgrouping on a field. The output is shown each group-details vertically stacked as follows: Group Header Value 1 Detail 1a Detail 1b .... Group Header Value 2 Detail 2a Detail 2b ..... and so on. What I need to see is the detail values in table columns as follows: Group Head...
Comparision of Java Reporting tools
I was trying to prepare a comparision sheet covering available Reporting toos available in Java and their pros and cons. There are lot of Open Source tools available: JCCKit, JasperReports, BIRT, jCharts, DataVision, OpenReports etc.. though I could not find comparative study for these tools. Would like to know, if you could throw som...
bind field at run time Crystal report
I want to create a column on a crystal report. I am binding crystal report to .net class object collection at run time. Now one of the columns I need to bind to the object collection property which is another object to it’s property. How do I do this ? ...