Extracting and presenting data, normally from a database system.

learn more… | top users | synonyms

4
votes
1answer
187 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 ...
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
32 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
74 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 ...
0
votes
1answer
101 views

Stored Procedure Performance Issue in Sharepoint Report

We have a report stored procedure that runs in about 1 minute in production; however, when executed from the Sharepoint it populates, it rus for over 20 minutes, with exactly the same parameters. ...
1
vote
0answers
23 views

Reporting services database was NATIVE, now it's UNKNOWN

After migrating a database from Sql Server 2012 to Sql Server 2014, we found a little problem. It was told me that the reporting server was not used, so I just installed the SQL Server 2014 and ...
1
vote
0answers
21 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
83 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
48 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
825 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
23 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
86 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
46 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
340 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
19 views

Creating a Views on an non-relational table, can't rotate

I have a table that is set up similar to this. id | key | value1 | value2 | value 3 01 | fname | "john" | null | null 01 | lname | "doe" | null | null 01 | bday | null | YYYY-MM | ...
0
votes
0answers
62 views

Report not pulling records

Stored procedure working fine. Procedure contains 5 parameters and 30 columns. I am using this stored procedure in my SSRS report. When I click preview, it is asking for parameter values I just ...
0
votes
0answers
174 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 ...