HELP, I don't know where to start

[enak]

I have been given the task of creating a rather large report. It contains tables and graphs of stock portfolios for each account. All of the data is contained in an Access db.

I have never done CR before. I do not have to use CR but I thought that it would be the best way to do the report. I am using MS Visual Studio .net and the CR that is contained within VS.NET.

I don't know where to start. I can add a new report to my project and make the connection to the database.

I don't know how to loop through the database creating a mulipage report for each record.

I can write queries that will do that but I don't know how to link it in to CR.

PLEASE HELP!!!!

Thanks,
enak

 

[synapsevampire]

More clarification will be needed, looping through a database is generally a bad idea from any tool/language as it's an iterative (expensive) operation.

You can use an Access query in Crystal, you need to turn on the Report->Options-Database-Views to see them. Not sure how one does so from the VS.NET version.

-k

 

[enak]

This report is fairly complex. I may need to find someone to do it for me.

 

[Madawc]

If you have just one record per account, do a collection of detail sections for each function. Right-click on the first such section and choose Section Expert. Then choose [New Page Before].

In Crystal, you select a 'table' and the software reads it for you. As synapsevampire says, you are not supposed to go looping through it on your own account.

I suggest you start by getting some of the functions working correctly. Then add on more, using <Save As> to keep back-up copies at each stage in case one goes wrong.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[enak]

I will look at that. Thanks and please stay tuned.