skip to main | skip to sidebar
sipario pianca
conditioning grains
audi automatic transmission cvt
аренда яхты в средиземном море
hack casino adrenaline i win
aluminum carrying case manufacturers worldwide
sabong world cup live
cyber security user awareness training
лікування грибка на нігтях
buy somatropin online australia
adwokat łódź
bitcoin casino australia
submit my url to search engines
casino
娛樂城
new scratchcard sites no deposit
skill-online betting online-freerolls
gran turismo 7 ps5 geant casino
賭場
betclic match interrompu
casino en ligne

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)

Posted by subordermqwa at 7:18 AM
Email This BlogThis! Share to X Share to Facebook
Labels: cell, database, default, display, displays, empty, igor, insteadthanks, match, matrix, microsoft, mysql, number, oracle, server, sql

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
 
sipario pianca
conditioning grains
audi automatic transmission cvt
аренда яхты в средиземном море
hack casino adrenaline i win
aluminum carrying case manufacturers worldwide
sabong world cup live
cyber security user awareness training
лікування грибка на нігтях
buy somatropin online australia
adwokat łódź
bitcoin casino australia
submit my url to search engines
casino
娛樂城
new scratchcard sites no deposit
skill-online betting online-freerolls
gran turismo 7 ps5 geant casino
賭場
betclic match interrompu
casino en ligne