Any Help would be appreciated.
I am trying to create a report via runtime using Report Generator(not very versatile) I have The connection gets set at runtime, because the user can open anydatabase of the choosing.
The Problem is creating the Group Header information. I want group the runtime information as the header and then the componets tested in that run to be in the details. I have tried a group by sql but it failed. My runtimeid records are unique. ex.
SELECT [RunTime].[InstrumentID], [RunTime].[StreamID], [RunTime].[injDateTime], [RunTime].[MethFile], [RunTime].[AlarmFlag], [RptQry].[Name], [RptQry].[RetentionTime], [RptQry].[Area], [RptQry].[Concentration], [RptQry].[Out-Of-Spec-Flag], [RptQry].[ResponseFactor]
FROM RptQry, RunTime
GROUP BY [RunTime].[RunTimeID];
SELECT [RunTime].[InstrumentID], [RunTime].[StreamID], [RunTime].[injDateTime], [RunTime].[MethFile], [RunTime].[AlarmFlag], [RptQry].[Name], [RptQry].[RetentionTime], [RptQry].[Area], [RptQry].[Concentration], [RptQry].[Out-Of-Spec-Flag], [RptQry].[ResponseFactor]
FROM RptQry, RunTime
GROUP BY [RunTime].[RunTimeID];
How do I transfer it to the report? Any examples would be helpful.
Thanks
I am trying to create a report via runtime using Report Generator(not very versatile) I have The connection gets set at runtime, because the user can open anydatabase of the choosing.
The Problem is creating the Group Header information. I want group the runtime information as the header and then the componets tested in that run to be in the details. I have tried a group by sql but it failed. My runtimeid records are unique. ex.
SELECT [RunTime].[InstrumentID], [RunTime].[StreamID], [RunTime].[injDateTime], [RunTime].[MethFile], [RunTime].[AlarmFlag], [RptQry].[Name], [RptQry].[RetentionTime], [RptQry].[Area], [RptQry].[Concentration], [RptQry].[Out-Of-Spec-Flag], [RptQry].[ResponseFactor]
FROM RptQry, RunTime
GROUP BY [RunTime].[RunTimeID];
SELECT [RunTime].[InstrumentID], [RunTime].[StreamID], [RunTime].[injDateTime], [RunTime].[MethFile], [RunTime].[AlarmFlag], [RptQry].[Name], [RptQry].[RetentionTime], [RptQry].[Area], [RptQry].[Concentration], [RptQry].[Out-Of-Spec-Flag], [RptQry].[ResponseFactor]
FROM RptQry, RunTime
GROUP BY [RunTime].[RunTimeID];
How do I transfer it to the report? Any examples would be helpful.
Thanks