Search results for query: *

What you want to use is an IIF for the control souce for the text fields on the report. It should read something like the following: This is taken from the Access Help IIf(expr, truepart, falsepart) So yours should say: IIF(Field, "Field", "NO DATA") You might not need the quotes, I forget.

I have the Years/Quarter/Month/Day listed along the X axis and the quanitity along the left side. The graph is giving me one line with the years broken into 5 days along the bottom. So the bottom of the graph has the years 2002 and 2003 along with the 5 days I am asking, but I do not have a...

I have heard you can merge two pivot tables to a pivot chart. How do you do this? Or is this not possible. I have a pivot table that has a year dimension where I am trying to measure quantity compared from this year to last year. I cannot get a two line graph, I only get one line that has...

What does the F8 key do? I cannot find documentation on it. Greg

We use Crystal Reports to access our JDEdwards database. We are using Xe SP 17. To access the cryptic JDE data you need to use the ODA driver. When a Fat Client is installed on the PC in the System DSN, you will see an entry for OneWorld ODA. If you use the settings you can select to view...

I have an Access form that is displayed in datasheet view after the recordsource(table) is populated. In this datasheet view after everthing has loaded, I have the focus set to the first record (triangle appears beside the record). I also have the Double Click property to open another form...

I had a problem this morning with Crystal Reports 8.5 running a JDE report going through the ODA driver. The particular field had null dates and was displaying as 12/31/1899. I checked the check box in Report/Options for Null fields with no avail. What I had to do was create a formula that...

In order to configure your ODA settings so you will not see the long table/field name you go into the System DSN tab, choose OneWorld ODA and hit Configure. There are 4 choices for Fields and Table names. I believe if you choose Use Long Column names, it will fix your problem. You might have...

I have an Excel spreadsheet where everytime I print it comes out on the printer small. So small I need a magnifying glass to read it. I know how to fix the problem in printing (100%) but this has never happened before. Is there some setting to prevent me from having to do this everytime

I have a Microsoft Excel spreadsheet that whenever I schedule a job from Seagate Info and print the spreadsheet the type is very small. I know how to fix it in Excel before I print it, but is there a setting in Crystal Reports that will fix this?

Does anyone use Seagate Crystal Reports 7 and Seagate Info 7 on a Win2000 Professional workstation. I am thinking about putting it on a workstation and I wanted to know if it will work. Thanks, Greg

Does anyone know how to make a trendline for a single line in a line graph. Meaning that there will be 2 lines 1 the actual count and the other the trend. I am using Crystal Reports 7.

I have a line chart which displays 2 lines. The value for one of the lines at the end is 0. I want the line to stop when it contains a value. The chart is displaying totals for months and 2 months at the end do not have any totals, so the line will go from point to point and then at the end...

I believe there is a store and fetch function. I have version 7 and they have replaced this with shared variables, I do remember I found something on the Seagate Knowledge Base about this, but it was for earlier versions. This probably did not help but I know for sure there is something on the...

Has anyone using Crystal Reports written reports against JDEdwards database. I have a question about a Business View and and ODA driver. I have a Business View with 4 tables. 2 of the 4 tables have fields with the same name but with different data. If I write a Seagate Crystal report using...