Extracting and presenting data, normally from a database system.
6
votes
3answers
605 views
SQL Server 2008 mirrored Database with manual failover, need reporting database
Our current setup is a principal database used in production with a manual failover mirrored database for HA.
I need to setup a reporting database as well. What would be the best approach? Shall I ...
6
votes
3answers
155 views
How to handle reporting of an extreme amount of databases in SQL Server 2005?
I'm looking for some advice on how to handle reporting for our environment. We currently have 16 servers with 20 instances of SQL Server 2005. We have over 6,600 databases and growing across these ...
5
votes
2answers
194 views
Solutions for reporting off of an EAV structured database?
Existing setup SQL Server 2005 with standard EAV table that users want to slice and dice with a BI tool (Cognos).
Is there any hope that we can transform this data into a format that we can report ...
5
votes
2answers
119 views
querying a table of events for reporting
The background (masking a real-world problem behind a word problem)
Farmer Brown has a peach orchard in California and ships hundreds of
thousands of peaches all across the country. When a shipment ...
4
votes
2answers
224 views
Splitting a column in two and returning a summary of results
Lets take a very simple table
Department | Staff Name
---------------------|---------------
Web - Electronics | Matthew
Store - Electronics | Mark
Web - Home | Luke
Store - ...
3
votes
1answer
67 views
Reporting Table Design
I'm writing a system that allows users to store values against each week in October and November and each day in December - starting from the first Monday. I'm holding the raw data entered by the ...
3
votes
1answer
471 views
Data Collection reports fail because login is from an untrusted domain
I've set up a data warehouse and Data Collection according to BO. Reports are generated properly when running them in Management Studio running on the server but fail when they are run from Management ...
2
votes
2answers
303 views
What reason is there to create a physical table for a report output?
I've noticed that for Crystal Reports made by our organization and by some of our ERA software providers have a tendency to use physical tables for their reports' data sets, rather than using a view ...
2
votes
2answers
350 views
SSRS 2008 Report toggling between images for various field values
What is the best way for toggling between images on a SSRS report?
On the report I'm creating, there are lots of questions with Yes Or No answers and based on the value I've got for the question, ...
2
votes
2answers
1k views
Selecting two values from the same table but under different conditions
I want to grab a value from a table into two different columns for different values from the same table. Use this query as an example (notice how the select is on the same table aliased as 2 different ...
2
votes
2answers
85 views
Joining 4 tables and 2 counts
I have four tables.
UserMaster
----------
UserKey - PK
UserName
UserID - UNIQUE
UserLogTransaction
------------------
UserID - FK:UserMaster.UserID
LoginTime
LogoutTime
CallCenter
----------
...
2
votes
1answer
57 views
Should Crystal Report be allowed for certain employees for production database?
I am talking about production database. There are couple of people who use crystal on daily basis for various types of reports. Some use it to just peak at the data, other generate reports of it. ...
2
votes
1answer
107 views
Is there a name for a query that returns results which have sub headings?
I inhered a set of queries / macros from the previous employee in my position and one of the other people here showed me a query result (output from when the query worked correctly) which had ...
2
votes
1answer
206 views
Oracle Discoverer like app native for SQL Server?
Can someone point me at some web based apps that work like Oracle Discoverer but native for SQL Server. We already the SQL connector running to actually use disco, but was wondering what other ...
1
vote
2answers
213 views
Reporting Database Considerations
We have a very large database that we want to write almost real time. We want to take data and move it to another instance of the database on top of which will be a GUI and MI tool which will be able ...
1
vote
1answer
66 views
Reconciling dm_os_windows_info windows_sku values, gathering same info from pre SQL Server 2008 R2 instances
I'm developing an inventory system for RDBMS deployments. I'm starting with SQL Server, and later will be pulling in info for Oracle & other RDBMS deployments. When you query [dm_os_windows_info] ...
1
vote
1answer
111 views
MySQL replication risks for the master
I have a production MySQL server, fairly heavily loaded with an INSERT-only load on one of its databases. I'd like to attach a non-production (sitting on my desk, more or less) replication slave to ...
1
vote
0answers
130 views
SSRS Timeline Chart for each day / minute
I'm asked to make a Timeline Bar Chart with SSRS 2012.
There should be 1 chart per day/employee, and this chart should have a x-axis of 1440 minutes (or 24 hours).
The bar should have 2 different ...
0
votes
0answers
69 views
Evaluation of end user reporting tools and capabilities
I tried to find a reliable software review that compares the Reporting tools which provide end users to create their own reports. However couldn't find any. The reviews were either too old, or they ...
0
votes
1answer
107 views
Reporting tools for MySQL Enterprise Audit Log
Oracle recently came out with the MySQL Enterprise Audit plugin.
However, currently there is no integration with their Audit Vault or DB Firewall products for robust filtering, reporting, etc. But ...
