Search results for query: *

lbass...WORKED LIKE A CHARM!!!!!!! You're my hero!! Thank you![ponytails2]

I have the following formula but I want the text 'NO CITY LISTED' to show in red. How do I do this when it's already in an IF-THEN-ELSE statement? I've looked everywhere, but no luck. [hairpull] IF ISNULL ({tblProjects.CityName}) THEN {tblProjects.ProjectName} & chr(13) & 'NO CITY LISTED, '...

OK...I applied the service pack and that didn't help so I then imported the .xls to an access db and used that as my datasource. IT WORKED!!! Thanks for all your help!!! [rofl]

Unfortunately, I haven't heard Excel is a horrible data source. I guess that figures. The data I'm getting is sporadic...I get part of the data. I don't get all the data in Crystal even though it's all showing in Excel. The data in Excel is row and column based and I don't have any merged...

Hello all! I'm using CR10 with an Excel spreadsheet and some of my data is missing from my results in the product string field. Here's what I have.. I have 3 groups, Territory, Project# and Order#. In the details I want to see the qty, product and series that pertain to the order. I get all the...

OK...it kinda worked this time but there are still some showing even when there's no project showing. Here's what it looks like now. ABC Company Main Street Elementary 123 Water Street 555 Main Street Anywhere, NY 10000 Everywhere...

Well, it looked like a good idea but it didn't work.

I have a report where on the left is company information and on the right lists all projects related to that company. I would like to put a line in between my projects to seperate them but I don't want the line to show on the last record because I have a solid line showing between each company...

Voila! There is a way around this!!! I grouped on the customer name first and designated a new page after in the report expert it worked. By doing this, the report viewer will use the data tree drill-down function to display each customer on their own page. I just had to make sure that the...

The users sync data based upon their territoryID automatically. I wrote the parameter and clicked Distinct Values/Browse table (tblCustomers)/Browse field (CustomerName). The list that comes up includes all customer names no matter what territory they belong to instead of just the users...

Hello. Using CR10 & SQL Server 2000. Users sync data down to their machines based upon their TerritoryID. I need to write a report that will allow the user to choose a customer (parameter) from the list and view that customers data. Now this should be easy enough to do but the problem occurs...

Thanks so much!

Well...so much for an easy fix. I'm so green with all this stuff I'll have to find a different way to go about it. What about this...my users actually synchronize data pertaining to their territory from our server and run reports remotely on their own machines. Unfortunately when they sync...

Hi all! Using CR10 & SQL Server 2000. I have a parameter where the user will choose a customer from the default values from the customer name field from the customer table. The problem is that when I go into set the default values it only lists customers A-C instead of all the customers A-Z...

PERFECT!!!!! Thank you so much!!!!!! [rofl]

Hi all! I'm using CR10/SQL/ODBC and have a number field which is actually being used as a percentage. Some values are whole numbers but occationally I have a percentage of 45.5. On my report all the numbers are printing out as whole numbers but when it gets to the 45.5 type number, it rounds...

Thanks lbass! I knew the values were being eliminated by checking each record for the data being calculated. Once I found it, I noticed it had 2 entries for a dollar value of $90.00 but the report only calculated one of them. I added the ID field as you suggested and it worked. Thanks so much...

I've been trouble-shooting for 3 days and now I'm throwing in the towel. But not before posting to "Crystal Gods"! [dazed] I use CR10 and my report includes several fields where I need to use the Select Distinct Records option but I have a value field that I'm summarizing. The problem is that...

Happy Friday everyone! (Using CR 8.5)I have a report with a subreport. In the subreport I have a group which groups together addresses, phone numbers, etc. for each related group. Currently, it will only print the groups if there is data there which is good. But if all groups are empty, not...

OK, thanks. I'll try that this morning. Thanks again for all your help. I'm so new I know just enough to get myself into trouble with this stuff. Have a great Friday! [wavey2]