Hi, I am trying to group my data based on age. I use the following database select: select * from ( select 0 range_start, 11 range_end, '0-10 days' date_description from dual union select 11, 21, '11-20 days' from dual union select 21, 31, '21-30 days' from dual union select 31, 99999, '31+ days' from dual) date_helper left outer jo...
I'm not sure which is the way to go for choosing a report type with my current setup. In the past I was using MS Server 2008 R2, MS SQL Server, MS.NET C# 3.5. Now I'm using something similar except my Database is IBM Informix and I'm using MS.NET C# 4.0. I'd prefer to use RDLCs since I'm used to them, but I didn't wanna jump down that a...
Hello Friends, I am working with crystal report 2008 I have a Parameter Field named HeaderColumn1, whose value I want to pass programmatically. I set the parameter field value with following code: ReportDocument reportDocument = new ReportDocument(); ParameterFields paramFields = new ParameterFields; ParameterField paramField; Parame...
Hi all I have a number of report viewers set up, each of which can open a number of crystal reports. This all works fine. I am wanting to streamline how i dispose of the reports in the DisposeOfReports() event. At the minute i do the following: If (_rpt1 IsNot Nothing) Then _rpt1.Close() _rpt1.Dispose() End If If (_rpt2...
I ahve a web app that is deployed currently and everything works fine. The Crystal reports are fine on the deployed website on the server. On my development machine I HAVE NOT CHANGED ANY REPORTS so they should all be the exact same as on the server. When I upgraded my PC, I installed VS2010 without installing 2008. Now I have errors...
First of all, I am new to Crystal Reports so maybe what I am asking might say is stupid. I added some tables and I want to count the appearance of a field depending on another field in the same table. If the other field has a certain value, I have to increase the counter. I have to use the returned value of the counter as a custom field...
Hello - I've been trying to build a simple vb.net app that basically displays already built .rpt reports in a crystalreportviewer. No matter how many times I try to code it, I run into problems. Some reports have worked, others have thrown errors such as load report failed, invalid path, etc.. All of the reports work when I run them i...
HI , I am having Y [yes] and N [No] in PDF and i need to circle anyone based on the boolean value in Crystal report.Any suggestions pls...... ...
Hello Friends, I am working with crystal report 2008 I have a Parameter Field named HeaderColumn1, whose value I want to pass programmatically. I set the parameter field value with following code: ReportDocument reportDocument = new ReportDocument(); ParameterFields paramFields = new ParameterFields; ParameterField paramField; Paramet...
Hi, I just uploaded my crystal report which is working fine on development PC, but as soon I uploaded it on server it just not displaying. No error / no bar nothing. Please help Regards ...
I just upgraded to the beta 2 of Crystal Reports for Visual Studio 2010 and I'm not able to print, export, zoom, or change pages while using the web control in an ASP.NET MVC application. I can get the report to run and display just fine on the webpage. All of the buttons have images, and the report data looks exactly as it should on t...
I am using Crystal Report 10.2 version. I have applied paging, and when I open the 3rd page, the following error is raised: Error in File C:\WINDOWS\TEMP\StatReportNewV {94692B41-40A2-4F6A-9551-110BA7D78A37}.rpt: The request could not be submitted for background processing. Please help how to resolve this. ...
I have the connection string like this: connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" How do I give the new data source connection to this ASPNETDB.MDF (the database created with asp.net userlogin) file?? Wh...
For several years now, I've built up a more-or-less reliable system of emailing static PDFs and Excel files to our non-technical clients. I'd like to upgrade this process to 2010 technology, preferrably in the form of a website than can both act as a file-server for these reports as well as present the data in html. After some asking a...
I'm looking for a tool that will assist in the conversion from SSRS to Crystal. I've found numerous tools that will go the other way (From Crystal to SSRS), but none that will work for my specific need. ...
How do we call Crystal Reports from Delphi XE? What version of Crystal Reports does Delphi XE support? ...
I have a datagrid and i want to insert those value to crystal report How? ...
Hi, The website that I have been working on for sometime is about to be deployed now. However, after deployment the reports are not opening in one of the two machines that I have deployed. All other pages seem to be working fine except reports not opening with the error : Invalid Class String COM Exception: 0x80004005 (on the line :-...
I added 2 additional databases to my report(Emp and Unemp). I verified all the links and they were correct. The problem is "when I add the new fields (from the new databases) to the report, all of the fields in my report disappear." This disappearing occurs in while in preview. Also, when I remove the newly added fields all of the fiel...
I am using Crystal Report2008.I have user table, this table is linked with other table such as devises, photos, videos, emails, notes, texts by its Uid and users have record in all different tables. I want a report which shows that how many record each user has in each table. I am also getting this error: "More than one data source or a...