Virtual Dataset, When and how to use?

I am looking for documentation on when and how to use a "Virtual Dataset" on a report band.

Specifically I am looking for a way of specifiying field names on a report where the underlying data component could change.

I am using Codebase for my database. My datasource started as a Codebase table, but later on I changed it to a query. All of the field names remained the same, but I had to change the prefix of every single field from cbTable."Blah" to cbQuery."Blah".

I am looking for a way to reference my fields without having to hard code the component. This way if the component changes, but the fieldname remains the same, I don't have to change all the fields.

I am hoping a Virtual Dataset will hold some answers, but I can't find any documentation. Any help would be greatly appreciated.

Regards,

Erik

Comments

  • gordkgordk St.Catherines On. Canada.
    edited 12:46AM
    Hi that won't solve your problem
    when a band's data source is set to virtual with a record count. all it realy does is control the number of times the band appears.
    regards ;)
  • edited 12:46AM
    Is there another way of solving the problem where I have to rename all of my field references if the data component changes?

    -Erik
  • edited 12:46AM
    You can use the frUserDataset, to control manually the information. Other way is use only ???TQuery???, because, I think, it???s better and faster that ???TTable???.

    Luciano Cargnelutti

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.