Hi, is it possible to create a temp table using llblgen? I have attendance table that keeps only the absent students. If a student is present he is not in there.

I need to create a report that lists all school days and the number of absents for each day. The easiest way i could think of is creating a temp table that holds the dates school was in session and left join it with the attendance table.

Would it be possible to accomplish this? thank you

-shane

It's not possible to create a temp table in the database using LLBLGen, however you can use Derived Table Definitions to accomplish the same results.

You could also create a view in the database which list the required data, and create a TypedView looking at that.

Matt