Question : I’m new here, and i have a situation. I need to alter one report that i created a […]
Tag: reporting
Replicating tables for reporting purpose
Question : We have 5 tables in a database on Server A that we would like to replicate to Server […]
How can I override the default values for a parameter in a report?
Question : I have a report with a parameter that usually gets its default values by running a query that […]
Joining 4 tables and 2 counts
Question : I have four tables. UserMaster ———- UserKey – PK UserName UserID – UNIQUE UserLogTransaction —————— UserID – FK:UserMaster.UserID […]
Should Crystal Report be allowed for certain employees for production database?
Question : I am talking about production database. There are couple of people who use crystal on daily basis for […]
Login report of Sysadmin
Question : We have got a requirement to provide login report from SQL Server for Sysadmin only – This would […]
Looking for advice on how to integrate data from 100+ client DB’s into a centralized reporting database
Question : I am a SQL Developer (not DBA or Architect) for a small (~50 employees) SaaS company. I am […]
Moving Transaction Data To Another Database For Reporting Purpose
Question : We got a requirement from our developer group, to do the followings: Frequently (every 30mins) move the transaction […]
SQl query to create a report based on multiple relational tables
Question : I have an e-commerce website and I’m in the process of creating a sales report. These reports need […]
Suitable way to record users requests for usage invoicing/billing in database?
Question : Is there more efficient way to keep a track of all requests made by each user with timestamp? […]