Search results for query: *

groggle, Thanks...I was afraid of the sub report answer. It works though. Madawc, I appreciate the time you spent and the ideas you offered. Speed is always a priority, if I find that the sub reports are causing speed issues, I will reevaluate the situation. Thanks again to both of you.

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...

They are the same. Now, I did notice that I have several version in my registry that share the same PublicKeyToken. That shouldn't cause a problem, seeings how the web.config specifies the version as well as the PublicKeyToken right?

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...

Change the ValidateEmptyText property of the custom validator to True

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...

Try changing your formula to look at the {Group.Date} rather than the {table.Date}

Thanks for sharing your knowledge. You have saved me a lot of time and frustration.

That did the trick...Thanks a million. One question though...why dos the cross tab need to be in the report footer?

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...

BarbaraFuhrmann, That solution sounds really promising. However, I have taken a different approach and calculated everythin on the SQL end. I will try your solution in future reports (They are coming) where I run into a situation like this. Thanks

pmk16, I fave two groups in my report for displaying purposes. Your formula works if I put the formula within the second group footer, which I can't do because it repeats after each month(which I can't have). How can I tweak the formula to allow me to place it within the company group footer?

Madawc, So I could have a Running Total but exclude certain records?

I have since had to change the sales value to a formula. Does the same formula that you provided still work?

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...

OK, I found out that if I group by the Company and then the Month I can place the headers within the Company Group Header and it only shows the header once.

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...