Logging in mssql and reporting with ms Reporting Service

frbo · Post by **frbo** » Thu Sep 17, 2009 7:49 am

Dear,

is there anyone who have already tried to log in to a mssql database and make reports with the ms reporting server.

Frederik

violant · Post by **violant** » Mon Sep 21, 2009 6:09 am

I login to MYSQL (by ODBC). Use PHP+IIS to generate report. Daily report sorting by test name and time (colored), and form with checkbox-testname and report period (start-end date). Very simple select to DB. For backup use mysqldump.
There is some problem:
1)When I change testname I need see log by old and new name separetly. I must rename old entries in table for old log.
2)List of all test that running now without old testname. I use log midnight and when status change. So I need everyday to generate list of all actual testname by select all midnight testname to another table. That all for create checkbox-list.

frbo · Post by **frbo** » Thu Sep 24, 2009 2:22 am

do you use odbc as a primary log our do you have a alert profile with a sql satement.

How many data do you generate in your database

violant · Post by **violant** » Thu Sep 24, 2009 6:32 am

I use it as primary log.
If I dont want see some row in log html I dont select it, but insert in log table in DB.
about 200 test
450 row in a day (only change status and midnight login)
mysql dump = 2,5 Mb/month