skip to main
|
skip to sidebar
Wednesday, March 28, 2012
put default number in a data cell of a matrix
Hi,
If there is no match in the matrix - it displays an empty cell. Is there a way to display some default number instead?
Thanks,
Igor
have you tried the following (as an expression):
iif(field = nothing,some#,field)
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Sql Public Role
Blog Archive
▼
2012
(502)
▼
March
(409)
Q Statistics & Query Performance
Q on joining tables with nullable fields
Q on Clustered and Nonclustered Index files to be ...
Q on Clustered and Nonclustered Index files to be ...
Q any group or freeze function
Q : Does MSDE have an evaluation Period
Q - Adding a database file
Q - Adding a database file
Q - Add file to a Publisher or subscriber database
q
q
pwdencrypt vs sql server 2005
pwdencrypt and Case sensitive
pwdencrypt and Case sensitive
pwdencrypt and Case sensitive
Pwdcompare()
Puzzling Primary Key Problem
Puzzling "NOT EXISTS" behavior
Puzzled by Query Plan
Puzzled by installation error.
Puzzled by installation error.
Puzzled by duplicates
Puzzled by Config files
Puzzled by concurrent update
Puzzle: dateadd workdays only
putting Word docs, etc in DB
putting Word docs, etc in DB
putting user accounts on the database
Putting System Variables in a Send Mail Task
putting subscriptions and other SSRS things in Sou...
Putting SqlDataSource code in code-behind
Putting SQL Server 05 database on GoDaddy server. ...
Putting SQL Artifacts Into Source Code Control
Putting reusable code into SSIS components....
Putting reusable code into SSIS components....
Putting Reports in Folders
Putting Report Services inside DotNetNuke 3.1+
putting names of objects to control-flow loop crea...
Putting 'NA' in a Money Datatype Column
putting multiple xml files data into database in a...
Putting Multiple Field data in a report table cell
putting mdx query in sql job and emailing the resu...
putting image on Crystal Report
putting error lines in new table or file
Putting entire DB in memory?
Putting entire DB in memory?
Putting entire DB in memory?
Putting encypted values in a database
Putting different reports in the Document Map
Putting DDL statemnets (CREATE SCHEMA), in a trans...
putting dbo explicitly in select staetement
Putting dates into varchar
Putting Date into SQL Server
Putting Data In Report Footer
Putting Data In A Heading?
Putting Data From DataTable/DataSet into SQL Serve...
Putting data from a store procedure into a cursor
Putting CSS and web settings in the DataBase expen...
Putting commas between select statement values
Putting calculated value into excel
Putting calculated value into excel
Putting calculated value into excel
Putting attribute on root node using FOR XML PATH
putting a field into the pageheader section - how?
Putting a DB into Single User Mode...
Putting a DB into Single User Mode...
Putting a db field in report header
Putting @Parameters in Stored Procedures
Puting huge chunk of data into database? workable?
Put Windows Logs into SQL
Put Windows Logs into SQL
Put Windows Logs into SQL
put tempdb in memory
Put SUM in the last row
put results from sp to another sp
put report totals in front of matrix - how to?
Put record in database.
put queries together
Put multiple results in one field
put inserted value into a parameter in a trigger
Put first 10 rows in a table and then group by eac...
put delimited data in unconventional format in dat...
put default number in a data cell of a matrix
Put database in warm standby after changing it fro...
Put database in warm standby after changing it fro...
Put database in warm standby after changing it fro...
Put data on Windows Storage 2003
Put data on Windows Storage 2003
Put constraint on this
Put .PDF file into SQL Database
Puslishing New Article Fail B/C Relationship Exist...
Pushy Matrix
Pushy Matrix
Pushy Matrix
Push-Replication with Internet-Connection
Pushing Recordset into MSRS
Pushing IMAGE from SQL CE onto SQL Server 2000
Pushing Data to Another SQL Server
Pushing data from Excel to a SQL server
Pushing a publication for just one subscriber?
►
February
(93)
About Me
subordermqwa
View my complete profile
loan
sql
sql server
sql
sql server
sql
imwebhost
No comments:
Post a Comment