What I have is a vendor performance report and I have a column that calculates early/late days, Example: -7 22 3 -14 2 -1 I need a formula that will tell me how many line where 1 to 7 days early 8 to 14 days early +15 days And also opposite how many days where late in the same format. ...
I am using VS 2005. I need to create a report which shows result of the following sql query select count(*) from Student order by group_name I have created data connection to Student. How do I create report for this query? ...
I can't seem to find any information about localizing reports created with Crystal Report that ships with Visual Studio 2008. How do you change the reports to be localized? Do they use resx files? Any links to where to find out more information about how localization using Crystal Reports in Visual Studio 2008 would be very helpful. ...
Using Crystal Reports I'm trying to display the running total of a database field in the header where all the labels are. I've attempted to do this by placing the running total (RTversion) into a formula field with the following: Shared stringvar CurrentVers; CurrentVers := {#CurrentVers}; and then in the page header section I hav...
Hi, I'm using Visual Studio 2008 and SqlExpress to develop a windows application. I have created a database and trying to create a Crystal report using it. But when I use the Wizard to create the Report( as I use OLE DB Provider for Sql Server) I get the following Error message: Title of the error message: Crystal Reports ActiveX De...
Hello All; I have got a task regarding parameter passing to Crystal Report via Crystal Report, I would like to find best way to achieve it. Imagine that I have got parameterized and non reports-parameterized. I am developing a report manager that will enable users to subscribe to the reports and schedule them with their parameters. I h...
hi i have C# program, i have DataSet that i want to bind to crystal report. how to do it ? thank's in advance ...
maybe I am being obtuse. My second select I am trying to get the first 6 letters of the field in order to cut out the text "Spouse First X" select {vwAddressLinksTableView.DESCRIPTION} case "Cellular":{vwEA7RecordsTableView.FIRSTNAME}&'-Cell '&{vwAddressLinksTableView.NUM} case left({vwAddressLinksTableView.DESCRIPTION},6)='Spouse': ''...
Hi guys, This might be a bit of stupid question but i need some clarification. I have Reportwriter dll that uses crystals reports. It is written in VB6. I have to add this dll to my asp.net project, where it creates an interop dll. To my understanding, the interop dll is there as a intermediatary so that my .net code can speak to the r...
Hi, Has anyone tried installing Crystal reports XI on Windows 7? Would be very grateful if anyone has any experience on installation. Many thanks. Milan G ...
Hello There; I am trying to view my report files on CrystalReport viewer in ASP.NET programmatically. by using the code blow; CrystalReportSource reportsource = new CrystalReportSource(); CrystalDecisions.Web.Report report = new CrystalDecisions.Web.Report(); Guid reportid = new Guid...
I need to create a provider Name group which is based on any or all of three fields that contain service provider codes. Each Service Provider Code links to its own SP_Program_Location table to optain that providers Provider ID which is then linked to a provider table to obtain the Providers Name. If no providers have been assigned for...
The environment I'm working in is a Crystal Reports Server 2008 talking to a MySQL Server 5.1 database using JDBC. The problem is that I get a database logon screen every time I try to access a report from Crystal Reports Server. I've setup a JDBC connection using the MySQL Connector/J driver. When I create a .rpt file I provide the l...
Using CR 11.5 R2, .NET 2.0. Report displays fine in Internet Explorer but in Firefox it is blank. Appreciate any suggestions, this has me stumped. <CR:CrystalReportViewer ID="crViewer" EnableViewState="true" runat="server" BestFitPage="False" ClientTarget="Auto" AutoDataBind="true" DisplayGroupTree="False" Left="0" Height="430px" Wi...
I am working on VS 2005. I am using 2 databases called student and group. student (student_id,group_id(int)) group (group_id(int),group_name(varchar)) I have created a connection to the database. Now I have to create the following report Group Name Count Biology 14 Computer Scie...
I'm still new to Crystal Reports so I'm not sure how to ask this question, but I'll try: my report is set by job #'s I added a table for serive operations. I only want the description of these services to print on my report (some of these services have descriptions some do not). Right now if there are 4 blank lines and 1 with data, the...
I'm developing a crystal reports on java. I can now view my report, but it is still limited to one .jsp I don't know what will I tweak. my error looks like this. The viewer was unable to find the resources required to render the report. Please check the following to resolve the issue. Verify that ../crystal...
Hi, I believe the conventional way to deploy Crystal Report with a .NET program is to set it as a prerequisite in the publish settings and then a .msi will be packaged with the ClickOnce files on the web/network/CD/wtv. When the user runs setup.exe, it will check whether Crystal Report is on the client computer. If not, it runs the Cry...
hi expert my question is how to call store procedure and set parameter in c# application for crystal report show. e.g. i have table of invoice and field is as below companyID (int) invno(varchar) 1 101/2009-2010 2 101/2009-2010 now suppose i have create store procedure store proc sel_inv @c...
I have this error Failed to open the connection. Details: [Database Vendor Code: 17 ]Failed to open the connection. C:........ {87308A98-7846-48F0-8644-243722C74368}.rpt Details: [Database Vendor Code: 17 ] some help please ...