Extracting and presenting data, normally from a database system.

learn more… | top users | synonyms

2
votes
2answers
27 views

Transactional replication subscriber vs AG secondary replica for reporting

I am trying to recommend my client a SQL server upgrade (from 2005-> 2014) which will allow the users to create record snapshot (via SSRS) from a read-only data source. Data latency should be kept to ...
4
votes
1answer
208 views

Reporting on a normalized Key-Value pivot

ERD & SQL Fiddle provided. We're trying to design a reporting tool for our stakeholders around a normalized Key-Value Pair model. We've tried to find a solution using Pivot Tables but can't seem ...
1
vote
1answer
16 views

Looking for a better way with Reporting Db server

I have a "reporting" db server which is basically a clone of production using backup and restore in a stored proc to handle restore , user , permission etc. Backups/restores happen 1x per day at a ...
0
votes
1answer
36 views

Best tool/approach to report on table contents over time

I've got a table in SQL Server full of data that is a working DB of data collection reports. This table only stores the current state (meaning it doesn't keep historic anything). There are a few key ...
0
votes
1answer
35 views

Suitable way to record users requests for usage invoicing/billing in database?

Is there more efficient way to keep a track of all requests made by each user with timestamp? And then filter the requests every fortnight to invoice the users? Example DB schema Table: user; ...
0
votes
1answer
82 views

Vertical data set to horizontal data set for many columns

I have read about pivot function but I am not sure if If it helps me in this situation. Essentially I have to produce my vertical data set horizontally. For instance the first table shows the vertical ...
1
vote
0answers
16 views

Server error in reports application

I have a server with SQL Server 2005 installed with the latest service packs. SQL Server 2012 express was been installed on same machine and seems to have broken the Reporting services service. When I ...
1
vote
0answers
37 views

Why won't my subscription parameter value stick?

I've set up an "Aggregate level" parameter on a SSRS report, so that I could easily schedule subscriptions for daily, weekly and monthly aggregates. The parameter has a Text datatype, and doesn't ...
1
vote
0answers
105 views

MS Access 2010 report - SQL pivot query WHERE criteria not working

I have created a report that has a list of actions which are populated from an "Actions" table. (See Below) However, each action will have multiple updates populated from an "Updates" tables and I ...
1
vote
0answers
61 views

Oracle Application Server Integration With APEX

This might not be directly related to DBA, if so kindly advise. I need to integrated some reports created via Oracle Reports Builder with APEX. Reports are in RDF format. Which version of Oracle ...
1
vote
0answers
46 views

Find repeating tickets with more than one criteria

Lets say I have 2 tables: atms & tickets each atm has many tickets. ATM table: ID | NAME ------------------------- A0109 | ATM 1 A0227 | ATM 2 etc. | etc. Ticket table: ID | ATM | ...
1
vote
0answers
1k views

SQLite Design: Better to have many tables with few columns or few tables with many columns?

I am struggling to figure out the best design for a Sqlite database that will hold data about Facebook pages so that I can calculate benchmarks for how the average Facebook page performs. I have an ...
1
vote
0answers
912 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
16 views

Grab value from the group SSRS

How can I grab a value for a particular month in SSRS if it's in a group? I have all 12 months as a group, in a column outside of the group I need to get the value for March that is in the group?
0
votes
0answers
27 views

mysql query to fetch records from multiple tables

I have 5 tables named: schools, candidates, candidate_subjects, subjects, lgas Each school belong to a lga, each candidate belong to a school, each candidate registers subjects Below is the table ...
0
votes
0answers
30 views

Is there a way to set the data source in Report Manager for whole folder rather than each report?

I have few reports under different folders in Report Manager. Is there a way to set the data source for the whole folder rather than each report individually? There is also a folder where reports ...
0
votes
0answers
122 views

FastReport / Report Query Help - How do i convert a integer value into a string?

I am using FastReport to create my reports and I have an issue. I am trying to make a form with the data in ProductMaster.ITEMBUYINGPRICE. The output of this column is a 6-digit value showing the ...
0
votes
0answers
57 views

Real time reporting on Mongo

I have my transactional data store as MongoDB cluster on which I need to setup real time reporting (maybe a lag of 2 hours will suffice). Data size - 300GB with 20,000,000 rows and 40 columns and ...
0
votes
0answers
398 views

Timeout occurred while waiting for latch: class 'ACCESS_METHODS_HOBT_COUNT'

We have a big reporting database on production server, and we have several SSIS jobs running against it. Yesterday almost all this-database-related SSIS jobs stuck and running forever. Also the ...
0
votes
0answers
200 views

Cohort analisis for gamers activity

I want to do some cohort analysis of gamer activity in my games. By cohort I mean some set of users who registered (or had first activity) on some particular date. For example: users registered on 16 ...