EOF (end of file)

Hi! Is there an equivalent EOF function in Crystal Reports 8.5.?
I want to use a Do While Loop, but dont know the number of records so
I want to use the EOF so it will terminate upon reaching the end of the
file.
Thanks.you can have RECORD COUNT so based on that number you can specify total number of loops you will require in report

Entities Disappear in Ad Hoc Reports

I have a single data source view which contains 3 tables. Each table is a
completely denormalized (like a spreadsheet) dataset from a particular
business system. The tables themselves don't contain any foreign key
relationships, but within the data source view editor I created primary keys
on each table and created relationships between each table. However, when I
try to create a report in report builder, as soon as add an entity from one
table to my report, the other 2 tables disappear. I have found a few other
posts about this problem and the resolutions offered were (1) add a "refer",
but I don't know what that is; and (2) create or add relationships, but I
believe I have done that. What do I have to do to prevent the tables from
disappearing? Thanks.
Also, is there a good resource for reading up on Ad-Hoc reporting? The
books I have seen only cover it briefly.I figured this out. I need to add a role to each table in the Report Model
Designer. It is all in Books Online.
"Bodhicitta" wrote:
> I have a single data source view which contains 3 tables. Each table is a
> completely denormalized (like a spreadsheet) dataset from a particular
> business system. The tables themselves don't contain any foreign key
> relationships, but within the data source view editor I created primary keys
> on each table and created relationships between each table. However, when I
> try to create a report in report builder, as soon as add an entity from one
> table to my report, the other 2 tables disappear. I have found a few other
> posts about this problem and the resolutions offered were (1) add a "refer",
> but I don't know what that is; and (2) create or add relationships, but I
> believe I have done that. What do I have to do to prevent the tables from
> disappearing? Thanks.
> Also, is there a good resource for reading up on Ad-Hoc reporting? The
> books I have seen only cover it briefly.
>

Entering parameters resets other parameters

I am having a problem with reports where, after a parameter is changed, it
will remove the currently displayed report (replacing it with white) and on
some occassions reset some of the other parameters (even though there are no
dependencies). Is there some way to disable the refresh so that only
clicking "View Report" will change the report displayed?Has anyone else experienced this? We see the same thing and I would really
like to get rid of this behavior.
Thank you!
Jon
"Kyle" <Kyle@.discussions.microsoft.com> wrote in message
news:53AAA6CD-0B51-4879-A641-C580CD9819D6@.microsoft.com...
>I am having a problem with reports where, after a parameter is changed, it
> will remove the currently displayed report (replacing it with white) and
> on
> some occassions reset some of the other parameters (even though there are
> no
> dependencies). Is there some way to disable the refresh so that only
> clicking "View Report" will change the report displayed?

Enter userid and password for the databse (Crystal Reports 10)

Hi,

I have updated crystal reports from version 8 to 10. Updated the datasource, using odbc connection to connect to SQL Server. Reports run fine on my machine. When I run reports on the server I get enter userid and password for the database. Looks like, when I run reports on the server it's caching Server name from my machine. I have clear cache on the server which did not help. I am sending userid and pwd in the URL to Crystal reports. Please let me know, if there is a work around. FYI, reports work fine in production.

Thanks in Advance,
BhavnaDon't check Trusted connection checkbox when setting Datasource location. Unchecking this check box resolved the issue.

-Bhavna