Changing Report

[theif68]

I have a report that I need to create that is going to be a data dump of 25 selected records from "tblImport", but my issue is the fields are going to change in this table daily.

This will select my records and fields, but need a report to be displayed off of this query without having to modify if for the different fields.

Query:

SELECT TOP 25 tblImport.*
FROM tblImport
WHERE randomizer()=0
ORDER BY rnd(isnull([tblImport].[ID])*0+1);

 

[AlexCuse]

If you really must you could probably standardize your field names in import table (field1, field2, field3) and change your report source query to something like

select field1 AS FieldName

but I am not really sure where you are going with this.

How much will your field names be changing?
Is there a set number of field combinations for import table?

I think that multiple reports is probably the way to go, and decide which one to generate based on some conditional logic.

HTH,

Alex


It's a magical time of year in Philadelphia. Eagles training camp marks the end of another brutal season of complaining about the Phillies.