Please Help! I asked my Q in many Forums but i did'nt recieve any clear answer. This is my Q: I created a table in a Details Section and I have a Title Col and Point Col in this table how can I write code to find Title of max point in my table??? this is my .rpt overview: you see i have 3 cols in Details Section. Point,BitParagonTitle...
Hi, I want to remove an item from the grouptree in crystal report. Actually I have 5 groups, when I group records using all these 5 groups then all the groups are shown in the GroupTree, its fine. But when I group records using suppose 3 groups then it should show only 3 groups in the GroupTree not all the 5 items. How can I remove such ...
Hi, Is there a built in crystal method to detect whether the a table in a crystal report has any rows? I have created a sub report which has some Title text in the header and a detail line with the table info. I want to be able to supress the title text from printing if there is nothing to print. Also, is there any way to pass this t...
Hi All, I have embedded some crystal reports in my C# application. The problem is, compiling the project creates dlls for the reports also, which means in future any change in report will need re-installation of the application. Is there any way that I can keep them as .rpt files and they can be changed any time by just copying the .rpt...
Is it possible to programmatically iterate through a table within a formula in crystal reports? E.G. If I have a master table and a detail table can I iterate through the detail table e.g. ( psuedo code ) local numberVar Total := 0 While not EOF() IF Type = "+" Total = Total + Quantity ELSE IF Type = "-" Total = Total - Quan...
I have 3 tables. 1 Master and 2 detail tables both with a different amount of rows. I want the total of the qty in detail1 and the total of the qty in detail2 but show them on the same detail line e.g. (What I Expect) Total Detail1: 13 Total Detail2: 45 What happens is, it multiplies the total of detail1 by the number of rows in de...
Hello, I have been struggling with that for 4 days now. I have a very very simple crystal report(I am using it just for a proof of concept). The report is bound to a database and I display only one field from one table in the database.No subreports.It was created with Crystal Reports 2008. I need to display this report in my .Net MVC we...
I use Crystal Report Basic to create report for my application, my problem is when I view my report in report viewer and click print (without preview) it produce different output (page margin is different) as I preview and print the same report. I want to know how to solving this problem? ...
I am using C#2.0 and crystal report XI in my windows application project. I know the Crystal report XI support sub report facility to drill down by clicking on report content. I want to modify this facility to navigate to the particular voucher (or corresponding form). When clicking on the report content I want to pop up the wind...
We currently have a set of crystal reports used for winforms projects embedded into a dll. This has been working well for us as the dll exposes a simple constructor for each report to pass needed parameters. A property can then be retrieved which is the: CrystalDecisions.CrystalReports.Engine.ReportClass object which you send to the r...
Hi I'm using Crystal reports 8 and I need to change the stored procedure associated with a sub report, is it even possible? or I'm going have to redo it? ...
In the Crystal Reports editor that comes with Visual Studio (2008) is it possible to align text to the center of a text box rather than to the top? I can't find the option anywhere and a Google search is not encouraging but I just can't bring myself to believe that they would not include such an obvious feature. ...
Hi, I am using crystal reports 2008. We want to convert actuate reports into crystal reports. In actaute reports we are passing datasource, username and password as parameters and in each section we are using these parameters and will create connection. So that we can connect dev, test and prod database whenever we want. Like that is t...
Hi, I am using crystal reports 2008, I want to use multiple data sources in one report. One is connecting informix and another is connecting redbrick data source. Both are independent data source and doesnt have any common value to co -relate them. Can we have that option? Pleae advice? ...
Hello, I am using Crystal Reports in Visual Studio 2008. I have about 5 pages worth of static text that needs to appear at the top of my report, so I put it in the report header section. I have a page footer section on the page that shows the page number. This does not show, and I suspect it has something to do with the long report he...
Hi, My CrystalReportViewer won't display the charts in my Crystal Report. I get a red X. I am using C# and MVC. I've read somewehre that I might need a virtual path to the image folder but I am not really sure what that means as my chart is embedded in the report....Maybe I am missing something. Plz can anyone elaborate. Thanks Susan ...
I'm starting to look at reporting tools for use with my projects. For economic reasons, Crystal Reports (the version included with VS2008) will be my "choice." I've been told this is not the best reporting tool out there but it's what I have right now. Are there any free training videos for Crystal Reports? I found the "How Do I..." vid...
I have a winforms application, when a user runs a report there may be no data to display. I'd like to intercept the fact that there is no data an instead of showing the blank report, display an error message using .NET. Is there a property I can check before the report displays? ...
Would it be possible to suppress a filed when printing CR. Basically I have a report with a field that I would like to have displayed when viewing trough Infoview (DHTML viewer) and have it suppressed when printing the report. Crystal Reports XI R2 Enterprise. Thanks. ...
I am using Crystal Reports 2008. I want to create a report where I will get the value from one SQL and that value field I have to pass on another SQL and will get the result. Is that possible to do that? ...