Search results for query: *

I have an employee table that has numerous many to one relationships. i.e. Dependents, ContinuingEducation, Evaluations, etc. I would like to display the report like this: First Name Jose Last Name Deleon Address XXX Street Dependents Sally DeLeon Victor DeLeon...

I am getting an error ('CrystalDecisions.CrystalReports.Engine.ReportDocument' threw an exception.) when I try to add a Crystal Report Source Control onto one of my aspx pages. This worked about a month ago, when I creating the application, but now the page that has the report source control on...

I have a Generic List of Invoices (Custom class). Each Invoice has a header class and a list of lineitems, which is also a class. How can i sort the List of invoices by a value that is found in the header class? Invoice 1 HeaderInfo - InvoiceID DateCreated CreatedBy LineItemInfo -...

I have a VB.NET application that uses Crystal Reports. There is an issue with the parameter prompt showing up even if the parameter value is being passed to the report. I have addressed this issue with a Crystal Hotfix. My problem is that I don't know how to incorporate this hotfix into my...

I have created a VB.NET application for a client and need to create an msi so that they can install the application on client machines. My question is, I have a few Crystal reports that will be saved locally on each machine. First, how do I ensure that these files are included in the setup (I...

I created a VB.NET application that has a main crystal report (8.5) that has one subreport. Both reports use stored procedures to gain data from my SQL Server database. I created the reports pointing to Server "dev" with database named "devDB". Now that the system is live it needs to point to...

I have a formatting issue that I can't quite get to work. I am trying to create a report that will display expenses vertically, then I need the amounts displayed horizontally. My data looks like this: Year Quarter Expense Cost 2006 1 Food 200 2006 1...

I have a list of months and quarters with sales data for each month and quarter. I need a total at the end...how do I sum but exclude records that are quarters? My Data looks like this: Company Month Sales 1 Jan 120 1 Feb 150 1 Mar 100 1...

I have a view that returns data like this: CompanyID Month Sales Accounts Year 1 1 120 10 2006 1 2 150 12 2006 1 3 90 8 2006 1 1 50 9 2005 1 2 60 6 2005 1 3 80 9 2005...

I have a situation where I have one main report and about 20 sub reports. The main report has 4 tables. All but two of the subreports use staright tables to access data. The two reports in question are big reports with a lot of data and calculations that I decided to do within Stored Procedures...

I already have a dynamic sql resolution for this, but I want to get away from using dynamic sql. I have a search page (aspx) where you can enter a first name, last name, ssn and select a department from a drop down. I am using a stored procedure to return the results. Here is my code and it...

I have an asp.net application that tracks our clients. I have an add client and edit client page that both use a client user control. I am seeing some odd behavior with the edit client form. If I search for a client (Different form) and select one, it takes me to the edit client form. Now if I...

I have a datagrid on an asp.net page, the end user can add records to it. The grid has paging enabled...10 items per page. The grid is sorted by date. If I am displaying the first page of the grid, entering the eleventh record, that has the maximum date (Out of all list thus far), when the...

I have a customer who wants a VB.Net application. I am developing it in Visual Studio.Net 2005. The application code will be turned over to the client upon completion, but the don't want top purchase the entire studio. They only want to purchase VB.Net 2005 Express edition. I planned on creating...

I must be losing my mind because this is a very simple procedure, but it is kicking my butt. I have a report that gets it's data from a Stored Procedure. One of the fields within the SP is: FirstName + ' ' + LastName This field is called Employee. So I am trying to format the field so that if...

I have an asp.net application (VB) that allows users to enter client information. Each user has different clients and each user shouldn't be allowed to see other user's clients. The application uses windows authentication. Our Active Directory contains a field that I am querying to find out...

I need to round down within a cell. Not only round down, but round down to the nearest quarter. Any advice would be greatly appreciated.

Does anyone know where I can find a list of what can and cannot be defined within a css? I am trying to define my RequiredFieldValidator(asp.net) colors and am wondering if it is even possible. Thanks in advance for your help.

I have created an ASP.NET application that uses cystal reports for reporting purposes. I have created a form that gives the user the ability to choose a report, report format(xls,pdf,doc), etc. The report runs fine on my development machine, which is always the case, but errors out when I...

I created a Crystal report within Visual Studio 2003 for my asp.net application. I am using the Crystal Report Viewer, accessing my data through a stored procedure with two parameters. Everything works fine except that there are three pages to the report. The Crystal viewer has the paging...