Hi guys,
We have a dataset that consists of projects and hours invested in those projects. These projects are primarily owned by individual groups inside a department, but all the project data is stored in the same table. In ASPRunner 6.3 tables, we can pass a StrWhereAdd before the SQL query is run using a response or session variable:
if Request("Group") <> "" then
Session("Group") = Request("Group")
end if
if Session("Group") <> "" then
strWhereClause = whereAdd(strWhereClause, "dbo.tblITStaff.[Group] = '" & Session("Group") & "'")
end if
However, if we try and use the same code to generate a chart before the sql query is processed, it fails. Any ideas?
