Access database reported in Crystal Reports

[Guest]

I have 2 MS Access tables in the same database (stats & games)

I am trying to add columns to a report (Game Results) that will provide the
sum of each column (FTA, FTM, 2FGA, 2FGM, 3FGA, 3FGM) by game (gameID).

I have the table relationships defined, but can't seen to get this into the
Crystal Report correctly.

 

[Guest]

You might want to find a CR support group.
If you are creating wonderful reports with the fantastic Access reporting
tool then this is the place to ask.

 

[Larry Linson]

I have 2 MS Access tables in the same database (stats & games)

I am trying to add columns to a report (Game Results) that will provide the
sum of each column (FTA, FTM, 2FGA, 2FGM, 3FGA, 3FGM) by game (gameID).

I have the table relationships defined, but can't seen to get this into the
Crystal Report correctly.

You will likely have to find a newsgroup for Crystal Reports. Because
Access' own Reporting capabilities are so extensive, few users of Access
rely on Crystal for Reporting. Thus, we are not a good source of answers on
the subject. Because Crystal Reports is not a Microsoft product, you are
unlikely to find that newsgroup via the online interface you used to get
here. Start with Crystal's website, or use your news reader/server to search
for Crystal in USNET.

Larry Linson
Microsoft Access MVP

 

[Rob Parker]

Try the forums at the Crystal Reports (Business Objects) site:
http://support.businessobjects.com/forums/default.asp

My experience with them is somewhat less satisfactory than with these Access
newsgroups. And, if you are familiar with Access reports, you'll probably
find that it's easier to do what you want in Access, rather than in CR.

HTH,

Rob