Hi, all. I am doing a financial report needs to show last 10 yrs history data. The end year is the last year of the current year. How can I set the minumum and maximun with Year(Now) fucntion for the x-axis, to represent the years Is there any way to use Fields value for the chart minumum and maximun
How to use Fields or ReportItems value in charts
Hot Topic
- remove specific string from text field
- Restoring just a table from a full backup
- Isqlw for sql server mobile edition (sql ce 3)
- Restore Master Key
- Installation of SQL Server 2005 Express Edition
- "Slipt" rows based on datetime
- Default OLAP store directory
- How to maximun the Pie Chart Area.
- Is it possible to use T-SQL to create a user in Active Directory?
- SQL Express Family CTP Now Available
SQL Server
- ROW_NUMBER() and projected row count.
- To Boost Performance
- Query problem with subtraction
- Cannot open database "eBayTrader" requested by the login. The login failed.
- Scheduled Jobs & emails ( Sql 2k)
- Can't precompile script
- Problem with <Select a value> in report parameters
- CTE in a DSV named query
- Grouping by custom datepart for shift patterns
- How to setup a dataflow which validates before writing to a destination ?
How to use Fields or ReportItems value in charts
Jay Hickerson MS
Yes this is possible in RS 2005 (but not in RS 2000). Axis settings such as min/max/crossat/major interval/minor interval can be expression-based. Just type in the expression as e.g. =Year(Now)
-- Robert
JasonChris
Derek Dabeach
This should work fine if the x-axis is set to use "numeric / time-scale values" and the category grouping expression evaluates to either integer values or DateTime objects.
-- Robert