Search results for query: *

I am using Access 2000. This has been driving me crazy. I know there has to be a way to do it, I just don't know how. Here is the scenerio. We have thousands of accounts. Each account is owned by a sales officer. In January we re-assigned a bunch of accounts to different sales officers...

I am going nuts trying to figure this out and I am hoping someone here can help me. I am using Crytal 8 and am trying to make a report that shows balances in months. I have two years worth of data but I only want to base the average on this year. What I want to do is make a formulas that...

Hi all, I have a spreadsheet with a bunch of numbers. What I would like to do is put in some kind of formula that will divide each number by 1000. The end result would be my dollar amount of $1,000,000 would be $1,000. Which is the format I need for all the numbers in my report. I see that...

Hi all, I am using Access 2000. I am trying to add two fields together in a query. My query looks wrong because it doesn't want to to do the calculation on null values so this is what I have. The two fields are 1. OneTimeFees 2. OngoingFees My calculated field will be TotalFees. Here is...

Hi all, I will try and explain this as best I can so bear with me. I have a database I am creating. I have to create this database that shows monthly acitivity on our clients. Each month I get an Excel spreadsheet data dump that shows activity of our clients. It does not keep any other prior...

I am designing a report in 8.5. I have a formula that is dividing one value from another to show a percentage. The first value at times can be 0. I used this report as a sub report. Whenever I try and refresh the report I get a Dr. Watson error and then get booted out. Does anyone think...

Hi all, I am using Crystal 8.5 I am creating a report that will show the trends in a portfolio from one month to the next. I cannot use a crosstab for this because it is going to contain other complex formulas that a crosstab cannot handle. Right now I have created a formula that is susposed...

Hi, I am using Cr 8.5 I have a group and within that group I have a chart. What I would like to do is split the pane of the group so that both charts could be next to one another as opposed to below one another. I have seen this done before, but can't figure it out for the life of me! Any...

Hi All, This just started happening to me this morning. Whenever I open Excel, I get error message #13 "Type Mismatch". I don't understand why this is happening. I am wondering if it has something to do with some of my macros, but then why did it just happen now as opposed to when...

It's that time of the year again. Time to re-design my worksheet/workbooks because of the nightmare I created the year before. You see, I designed some workbooks with links to other workbooks. These workbooks would capture certain month end info (for month end reporting). I would capture...

Hi all, I have a field that is numeric (currency). What I would like to do is create a summary field to show the breakout depending on type. I cannot do this at the group level as I already have a group in my report and want my report to look as clean as posible without a lot of groups...

Okay, I have a field that is a text field but shows as a date ie DD/MM/YY. I need to convert this field to a date so I can group by the month. Here is the twist: There is also text some in some of the fields called -NA- instead of a day DD/MM/YY. I think this was used instead of null and...

Hi everyone, I have this report (with a paramter) and the table/query that feeds this report is located on my server. A group of us are testing our Crystal reports before we make them available to other users. What happens is when I send this report to someone (who does not have access to my...

Sorry to be so dramatic, but desperate times call for desperate matters. Okay, here's the situation. I currently have Crystal Reports Pro 8.5, and will be designing reports as SQL Server as my source. What I planned on doing was sending users these reports, and allow them to use the Crystal...

I have been brought up using Microsofts for the past 10 years. I bought my first PC when I was unemployed, unhappy, and uncertain what to do with the rest of my life. With my computer I found my answer!!!! This was in the early nineties when many people in Corporate America did not know the...

Hi everyone, I am using Crystal 8.5 and am having a HUGE problem. I am trying to link an Excel spreadsheet to use as the basis for my report. I tried doing this in a variety of ways. I try and create a new datasource, find my spreadsheet in Excel and than use it in the report, and nothing...

Hi, I have a report that shows our top customers total sales. In this report I have a grand total showing the total dollar value of our top customers. What I would like to do next is insert another total that would do a grand total of ALL of our customers. Essentially this would be used to...

Hi everyone, I would like to set up a form, that will show a report available for printing/previewing. What I would also like to have on this form is a "multi-select" list box to allow the user to pick certain info to filter this report. I have set up the list box as unbound, and...

Hi everyone. We currently have a database that is located on our intranet. We have set up the database to allow users to do "merges" with the table info from the database, and Word documents. What I am working on is a report that will show the end users all of the products used for...

I am not even sure if this is possible, but DESPERATE for a better solution than what we are using now. I have this spreadhsheet, that tracks accounts by type code. Example: D101-D177=Account Premium, S110-S453= Account Regualar. The problem is that the only info that the spreadsheets...