I have a report that is grouped by location, so I have created a 'Locations' group header and footer. The header contains some titles, and a couple of graphs and the footer contains a row of totals - pretty standard stuff.
The header page containing the graphs have a TextBox with the content =Fields.Location, so for each location, this title represents the location and this works as expected.
The graph on the header page has multiple series (for all locations) and I have applied a filter so the chart data to show only the series for that location: The filter contains the expression: "= Fields.Location = =ReportItem.DataObject.Location". and this works as expected, great.
The problem I have is with the graph title. I need the chart title to show the name of the location, so in the Graph Title Text I've put "=Fields.Location" - however - this only picks up the first location, and then uses that throughout each location???
How can I get the graph titles to reflect the location properly?
Hello,
I have created a report which gets data from SQL Server using SP. in my sp i have created few logical date fields.
Example:
DATEADD(Day,-6,'2017-02-17') As [Mon Date],
DATEADD(Day,-5,'2017-02-17') As [Tue Date],
DATEADD(Day,-4,'2017-02-17') As [Wed Date],
DATEADD(Day,-3,'2017-02-17') As [Thu Date],
DATEADD(Day,-2,'2017-02-17') As [Fri Date],
DATEADD(Day,-1,'2017-02-17') As [Sat Date]
this SP is having few parameters so in report i have created same report parameters to map them with parameters of SP. i executed the SP in SQL Server and it displays all data properly but when i run the report, the logical date fields are showing null value. i don't understand why it is showing null value.
Round (12.500) gives 12. Ideally it should be 13.
Please suggest.
Hello
I have a report that uses a custom font (ttf). The font is installed on the computer.
In Report Designer, the font is rendered correctly, however when I load the report (from a local file) into our wpf application (report viewer) the font is not displayed correctly, i.e. it shows a different font.
When exporting the report to PDF or Excel etc the report is once again correct.
We are not using report server - everything is generated locally.
Any hints on what might cause this?
Hi,
Can you please support our company about an error rendering Report? t really big problem exiled my system .Please see error in my attachment , It seems that DeleteItem function process so slow and cache locking problem is exposed. we need you explain more about this function and give me some prediction about this exception. Thanks
I'm trying to set my parameters trough my WPF application and after print my report. The printing works but the parameters are empty.
var report =
new
Badge();
report.ReportParameters[
"VisitId"
].Value = code;
report.ReportParameters[
"VisitorName"
].Value = visitorName;
report.ReportParameters[
"CompanyName"
].Value = companyName;
report.ReportParameters[
"RegularVisitor"
].Value = regularVisitor ?
"REGULAR"
:
"VISITOR"
;
PrinterSettings printerSettings =
new
PrinterSettings();
printerSettings.PrinterName = ConfigurationManager.AppSettings[
"PrinterNameLabel"
]);
PrintController standardPrintController =
new
StandardPrintController();
ReportProcessor reportProcessor =
new
ReportProcessor();
reportProcessor.PrintController = standardPrintController;
TypeReportSource typeReportSource =
new
TypeReportSource();
typeReportSource.TypeName = report.GetType().AssemblyQualifiedName;
reportProcessor.PrintReport(typeReportSource, printerSettings);
As attached file my parameter settings. Any ideas? Thanks for the help
Hi,
I am trying to execute a sub report from my master report. My master report has a datasource which return multiple rows. For each row I want to execute my sub report. So I have a sub report in detail section of my master report. However, when I select sub report source and pass ReceiptGUID parameter as = Fields.ReceiptGUID I am getting following error while trying to preview it:
"An error occurred while processing the report. Processing cancelled. Check the InnerException for more details. Invalid value of report parameter "ReceipGUID".
Can someone help me with this? I tried checking in forum and existing solutions are not fixing it.
When I pass a constant string as report parameter, it works fine. I have checked the result set from the master report datasource and it returns ReceiptGUID as expected for each row.