Showing User-related Content in a Report
In cases where you want the data or content in a report to be different for each user,
there are a...
2010-03-11
541 reads
SQL Server BI Blog
How to Script Report Deployment, Move Reports or Change Properties
On the MSDN forums I see a lot of questions about how to use program code or command
line script to...
2010-03-11
511 reads
Oracle .NET Data Provider not Supported but Necessary for Cube Design
I've decided that from now on, consulting project estimates will be padded for an
additional week to get Oracle connectivity working...
2010-03-11
455 reads
Format Date as Week of Month
You can define a calculated field for the datset outside of the query using a Visual
Basic.NET expression. In the Data...
2010-03-11
674 reads
Report Parameter Date Range
A forum poster wanted to use a StartDate parameter to limit the range of dates available
in a second parameter to...
2010-03-11
547 reads
Alternate Row Colors in an SSRS 2000 or 2005 Matrix
To create a "greenbar" report in a table with alternating row colors, you can simply
use the RowNumber function to determine...
2010-03-11
1,693 reads
Navigating to a Report in a Pop-up Window
When using the Jump to Report action int he web browser, the target report is displayed
in the same browser window...
2010-03-11
437 reads
Creating a Business Scorecard
Report Recipes
This is the second in a series of three articles highlighting the Report Solution
Patterns and Recipes from Chapter 7...
2010-03-11
919 reads
Column Chart with Goal Threshold Line
Chart reports are an effective way to visualize data to show trends and comparisons
in a way that can help the...
2010-03-11
2,029 reads
Parameterized Top Values Report
Top ranked lists are a common type of report. In many cases business users may want
to see only a specific...
2010-03-11
669 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
Alamat BCA KCP Cilandak KKO I Telp/Wa:0821-8200-233
Telp/Wa 62 821-8200-233 Jl. Raya Cilandak KKO No.9, RT.1/RW.5, Ragunan, Ps. Minggu, Kota Jakarta...
Alamat BCA KCP Arkadia Telp/Wa:0821-8200-203
Telp/Wa 62 821-8200-203 Gedung Perkantoran Hijau Arkadia, Tower C - Ground Floor, unit C103,...
BCA KCU KUNINGAN Telp/Wa:0821-8200-174
Telp/Wa 62 821-8200-174 Menara Karya, Jl. H. R. Rasuna Said Ground floor, RT.1/RW.2, Kuningan,...
Question of the Day
Adding new column with DEFAULT
Which number will the COUNT() return after executing the following statements:
DROP TABLE IF EXISTS #test; CREATE TABLE #test (id INT) INSERT INTO #test (id) SELECT * FROM GENERATE_SERIES(1, 3) AS gs ; ALTER TABLE #test ADD flag BIT CONSTRAINT DF_#test_flag DEFAULT 0; go UPDATE #test SET flag = 0 WHERE id = 1 UPDATE #test SET flag = 1 WHERE id = 2 INSERT INTO #test (id) VALUES (4) SELECT COUNT(*) FROM #test AS t WHERE flag = 0See possible answers