Hi, I've got CRW 8.5 Professional and i would like to generate reports from an Access 97 database. i know i need Developer to incorporate the reports in Access 97 but what about just changing the datasource of pre-built reports.I've noticed there are Refferences to CRW Libraries in Access so i'm guessing there must be some functionality there!
in Access i've got 2 simple tables 1)CRWMaster 2)CRWChild
Fields for CRWMaster:-
[GraphID]
[GraphHeader]
[GraphType]
Fields for CRWChild:-
[GraphID]
[DataHeader]
[DataCount]
These Tables are link with a 1 -Many Relationship.
Example...
[GraphID]=1
[GraphHeader]="No of cups of tea per day"
[GraphType]= Pie Chart
.....
[GraphID]=1
[DataHeader] = "Mon","Tues","Weds","Thurs","Fri","Sat","Sun"
[DataCount] = 5,3,3,3,2,1,3
Thats the sort of data set out that i need to produce charts from.
so can i do one of these two solution, or both
1. Using the Object Libraries, create the whole report using vba code. (if someone has got time, i would appreciate a sample as a starting point)
2. Create a generic report using different Chart Types. Then just change the datasource of the report using VBA. (Please give exapmle).
If i'm way off track please set me straight!
Thanks in advance
Jado
in Access i've got 2 simple tables 1)CRWMaster 2)CRWChild
Fields for CRWMaster:-
[GraphID]
[GraphHeader]
[GraphType]
Fields for CRWChild:-
[GraphID]
[DataHeader]
[DataCount]
These Tables are link with a 1 -Many Relationship.
Example...
[GraphID]=1
[GraphHeader]="No of cups of tea per day"
[GraphType]= Pie Chart
.....
[GraphID]=1
[DataHeader] = "Mon","Tues","Weds","Thurs","Fri","Sat","Sun"
[DataCount] = 5,3,3,3,2,1,3
Thats the sort of data set out that i need to produce charts from.
so can i do one of these two solution, or both
1. Using the Object Libraries, create the whole report using vba code. (if someone has got time, i would appreciate a sample as a starting point)
2. Create a generic report using different Chart Types. Then just change the datasource of the report using VBA. (Please give exapmle).
If i'm way off track please set me straight!
Thanks in advance
Jado