View previous topic :: View next topic |
Author |
Message |
frbo
Joined: 28 May 2009 Posts: 6
|
Posted: Thu Sep 17, 2009 7:49 am Post subject: Logging in mssql and reporting with ms Reporting Service |
|
|
Dear,
is there anyone who have already tried to log in to a mssql database and make reports with the ms reporting server.
Frederik |
|
Back to top |
|
|
violant
Joined: 25 Apr 2009 Posts: 51 Location: Ukraine
|
Posted: Mon Sep 21, 2009 6:09 am Post subject: |
|
|
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. |
|
Back to top |
|
|
frbo
Joined: 28 May 2009 Posts: 6
|
Posted: Thu Sep 24, 2009 2:22 am Post subject: |
|
|
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 |
|
Back to top |
|
|
violant
Joined: 25 Apr 2009 Posts: 51 Location: Ukraine
|
Posted: Thu Sep 24, 2009 6:32 am Post subject: |
|
|
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 |
|
Back to top |
|
|
|