I am grouping on a date field. The tree explorer for the report when data is displayed shows the date as 3 days before the date that is in the records. The detail in the report lists the correct date. I have verified the field shown in the report and the Group field are pointing to the same database-table-field. I have also set the forma...
This question is a follow-up to a question I asked the other day ("Need to find duplicate records but exclude reversed transactions"). I have a Crystal Report which displays customers' fuel transactions. There are occasions when a duplicate transaction will be imported erroneously. If/when this error is discovered, the admin will reve...
I have a crystal report in my Visual Studio 2008 ASP.NET project, and when I choose "Group Expert" from the Crystal Reports -> Report menu, Visual Studio crashes / hangs and I have to use Task Manager to close the program. This happens no matter how many times I try, and oddly enough it seems to work fine on another computer with the sa...
Hello All; Iam using crystal report 10.IN the report i have twp prompts. How can i give this report to users such that they can enter the poarametrs thru web? Thx in advance, S.Gyazuddin ...
Hi, I want to pass some parameters to a Crystal Report like this: ReportDocument.DataDefinition.FormulaFields[parameterName].Text = 'Text'; This workes fine unless I want to pass a multiline textbox from ASPX (containing \n and \r chars.) The reportviewer reports that "The matching ' for this string is missing.". Is there any ex...
Any advise anyone>? ...
Hi Folks, im using Crystal Repots in vs2008, so im using datasets with procedures to get the data from the db, my escenario is the following: In the same Crystal Report, i have to show two reports, basically using the sames datasets, and the same database, but they are diferents querys (have grouping and summing instead) is this possi...
We're creating a metamodel of our report definitions within our central metadata repository. We know how to "harvest" SSRS reports since they are XML. IS there any easy way to do the same for Crystal Reports. We're interested in getting to anything CR understands about the report (similar in concept to the SSRS RDL Model) TIA, Paolo ...
I have a WinForms app (written in VB.NET if that detail matters) which has an embedded Crystal Report for tracking application utilization (let's call it utr310.rpt). Our reporting guy made a minor tweak to the report that has been in production and I'm trying to test with it (let's call the new one utr311.rpt) except that I'm getting th...
I need to know how to iterate through records in CR2008 and when it reaches a record that is NOT NULL, record that in a variable. I have a formula called "frmAccum" that I drop in the details section and suppress it. I use this to gather information for each record that's processed. I also have a formula called frmReset where I rest t...
I'm developing an ASP.NET 2.0 application that includes Crystal Reports (version 10, included with VS 2005). Originally, the reports were working properly, both when run from my machine using the ASP.NET development web server, and also when deployed to an IIS server. I made some changes to the reports and re-deployed the app to the II...
Using Crystal Reports Developer XI I have a crosstab report. The crosstab can span many pages horizontally. For a report 10 pages wide and 3 pages long, I display page numbers as '1-1 of 3' through '3-10 of 3' but I'd like to be able to display them as '1 of 30' through '30 of 30'. Unfortunately the Page N of M field only displays the ...
I know the use of server-side controls is a no-no in ASP.NET MVC, however we have a long list of crystal reports that the company has already produced for a previous application that I would like to utilize for our new ASP.NET MVC application. Is there an appropriate way to use crystal reports in ASP.NET MVC? If so, how? ...
I am trying to display a pie chart that shows sales by company. However there are a lot of companies that only have a tiny sales which makes the pie chart look rubbish. Is there a way to group companies like this into a single "Other" category? ...
I am using Crystal Reports 10. The reports are obtaining data from an Oracle 10G database. We have some data in Arabic. When I try to display the Arabic data it is showing as ?. Any ideas on what I can do to display this correctly? ...
I'm using Crystal Reports 11 (and VB6) to open a report file, load the data from an Access database and either print the report to a printer or export the report to another .rpt file (for later printing without the database) Even for small amounts of data the process is somewhat slow. Profiling showed about 1.5 seconds for three records...
How to use crystal Reports with ASP.Net 2.0. Any Samples/Tutorials/Examples which shows how to deploy Crystal Reports on a production Server. ...
Using Visual Studio 2005 with default install of Crystal Reports. When I create a report, Crystal asks for the database, and I give it my development db. In the app, I create a DataTable and pass it to the report, which is then handed to the CR Viewer. At runtime, neither the report object, nor the viewer need to see the db since I have...
Is it possible to have a report which has grouping on the underlying data but for which you can disable the grouping via a button or something on the report? Basically I want to have a "Summary Report" which is grouped, but then be able to view the detail beneath when required without having a separate report for it. ...
For example I have a value of 103.33 I want to put 100 to one variable and 33 to another variable. How can I do this? Thanks. ...