From: Cubaman on
On Jul 16, 2:14 am, "Alan T" <alan_NO_SPAM_pl...(a)yahoo.com.au> wrote:
> Hi,
>
> Unlucky, as we are using MySQL as backend.
>
> Also a question in my situation:
> - we got 80 reports
> - each report have different parameters (filters, may be 4 or 5 filters)
> - for my second option (write a Windows service scanning through the table)
> - if I store each type of report request in its own table, there will be 80
> tables with one master table(the queue) which points to each possible report
> table (one of those 80 tables)
> - if I use 1 big table as request queue, there will be about 30 fields
> storing the parameters (many of the parameter fields will be empty, first
> normalisation, but I don't mind this)
>
> "Cubaman" <oscar.acostamonte...(a)googlemail.com> wrote in message
>
> news:12f888e5-3dd0-44a9-a3c7-8f37c40e3528(a)s9g2000yqd.googlegroups.com...
> On Jul 13, 2:36 am, "Alan T" <alan_NO_SPAM_pl...(a)yahoo.com.au> wrote:
>
> > Just wanted to know if I can do this:
>
> > 1) User click a button on a page
> > 2) It creates a thread
> > 3) The thread will generate a report
> > 4) This process may take up to a couple of minutes. eg. 5 minutes
> > 5) Before the process finish the client exit and close the browser
> > 6) The process will still keep doing its job until the report/file is
> > generated
>
> > Do you think it is possible?
>
> > The reason I am think of this way is the user does not need to wait for
> > the
> > 5 minutes keep the browser opening in blank mode.
>
> I think that you should try Sql Reporting Services. It comes with Sql
> 2005 for free, and can generate reports in push or pull mode.http://technet.microsoft.com/en-us/library/cc917530.aspx
> Best regards.

Dont store reports in ddbb, but in file system. Just save the path an
other relative data in ddbb. Is the most common aproach.
Best regards.
From: Alan T on
> Also a question in my situation:
> - we got 80 reports
> - each report have different parameters (filters, may be 4 or 5 filters)
> - for my second option (write a Windows service scanning through the
> table)
> - if I store each type of report request in its own table, there will be
> 80
> tables with one master table(the queue) which points to each possible
> report
> table (one of those 80 tables)
> - if I use 1 big table as request queue, there will be about 30 fields
> storing the parameters (many of the parameter fields will be empty, first
> normalisation, but I don't mind this)

Dont store reports in ddbb, but in file system. Just save the path an
other relative data in ddbb. Is the most common aproach.
Best regards.


Hi,

Yes, I saved the exported reports in file system in .pdf format.
What I will save the report requests in table.

eg.
Master table:
ID
RequestUser
RequestDate
RequestReport ID
HasSaved
HasStarted

Detail report request table:
ReportID
ReportName
EmployeeID
Start Date
End Date
.......
.......
Filter30

So as each report will have about 4 filters (eg. DateFrom, DateTo,
EmployeeID, ...etc)
Most of the Filters fields will be empty.

My service will scan through the master table to see if any of the requests
had started and saved., set a flag if yes.
Then look for the details table for the filters and generated the report.

eg.
Generate Employee report, will take the EmployeeID, Start Date and End Date
for the report filters.