Web Development

General discussion


Crystal Report - VB (Table Change)

By shibup ·
Situation.: Data of each day is stored on seprate tables, with the same field names.
The table are saved as myData_01Jan04, myData_02Jan04, myData_03Jan04...
1,I have designed a report for a perticular table. Now I want to change the name of the table throught VB. So that I can use the same report to view the data in the archive files.
2,Does the solution change it I use Access instead of SQL Server.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by Miss Kitty In reply to Crystal Report - VB (Tabl ...

You can work around this by having vb create a work table which can be generic and then have the Crystal report pull in the generic work table. I do this in an Access database. The user's work table is created from the information that they ask for.

Related Discussions

Related Forums