Analysis of common problems in SQL Report Builder reports,
I
SQL reports often encounter division in tables. If the denominator is zero, an error number is usually displayed. We can do this: (A/B)
= A/iif (B = 0, 99999999999999, B)
But we cannot write it like this:
= Iif (B = 0, 0, A/B) // We cannot write this, it will generate A BUG. As for any BUG, you can try it by yourself.
II
Assume that the name of A grid in the report is A, and we need to reference the value of another grid B in A. In this case, we usually copy the formula in B again in A, which is very troublesome.
We can write this directly in:
ReportItems! Table B name. Value
In this way, you do not need to write the formula again.
3.
In the report curve, if we need to dynamically change the abscissa, we usually set the axis option to automatic at this time, but this often does not get the expected result, the following example shows how to dynamically change the style of the x-axis based on the interval of the parameter (Start Time and end time ).
Horizontal Axis attributes, numbers, custom
=IIf(Parameters!startime.Value=Parameters!endtime.Value,"",iif(DateAdd(DateInterval.day,-4,Parameters!endtime.Value)>=Parameters!startime.Value,"MM/dd","M/d H:mm"))
The preceding three sections show you the frequently asked questions in the SQL Report Builder Report.
Articles you may be interested in:
- JBuilderX + SQL Server development hibernate
- How to connect jbuilder2006 to sqlserver2000
- Application of asp.net Reporting Service in Web Application
- How to solve the problem of high proportion of change_db in Com _ displayed in mysqlreport
- Error_reporting (E_ALL ^ E_NOTICE) of PHP Functions
- Usage of the error_reporting () function in PHP (modifying PHP blocking errors)
- SQL Server 2008 + Reporting Services (SSRS) USER Logon Problems
- How to Implement batch update in SqlCommandBuilder
- SqlCommandBuilder batch update of excel or CSV data