sql-servercrystal-reportsreport
SAP Reports(2013): Dynamic Page headers based from a parameter or database values
I am trying to figure out how to have a page header in SAP Reports 2013 which will automatically change based on the Month and Year of a parameter or date values from the database I'm linking it into (SQL Server 2008 R2), if possible.
I want the headers in bold below to be renamed based on a given Month and Year.
Solution
In your header take a formula field and write below code:
"Sales_Amt_"&table.Month&Table.Year
- collation conflict between "Hebrew_CI_AS" and "SQL_Latin1_General_CP1_CI_AS"
- Maintaining property order with get-member
- migrate data from MS SQL to PostgreSQL?
- Read Committed vs Read Uncommitted if both transactions do not rollback
- SQL YEAR(GETDATE())
- VIEW with NOLOCK but called without NOLOCK
- SQL Merge WHEN NOT MATCHED BY SOURCE THEN on filtered source and targed tables
- SQL obtain timestamps for end datetime row 1 and start timestamp row 2
- Tricky SQL update
- Remove Identity from a column in a table
- Return 1 if value is 0 without CASE statement
- Append string text based on pattern search SQL
- How to find Cyrillic font (russian characters)?
- Query Azure SQL Database using Rest-API
- DATENAME and DATEPART in SQL
- How do I connect Biostar V1.8 Suprema to MySQL?
- Query to find parent record
- Counting DISTINCT over multiple columns
- Multiple joins giving "The multi-part identifier could not be bound"
- How to mark identity column properly with Entity Framework 6.1?
- Copy SQL Server database from prod to local developer machine without Windows authentication
- How to select the last record of a table in SQL?
- SQL WHERE NOT EXISTS (skip duplicates)
- Search multiple occurrences of a word in a string
- Optimize/Shorten SQL Queries
- How to find out SQL Server ODBC driver version using code?
- Finding employees who are not managers
- Updating one column based on the value of another column
- Why is my SQL Server ORDER BY slow despite the ordered column being indexed?
- Delete a single record from Entity Framework?