Our client has a custom entity called purchase order and a child called purchase order product (not linked to the standard product entity in Dynamics). I have written a few easy quote templates in my time, but i am slightly stuck writing a custom report
template (apologies in advance if this is something simple i have missed..).
I have created 2 rdl files, one called 'order', one called 'sub'.
On the 'Sub' report i have done the following:
1. created a dataset called sub with the following query
SELECT dhc_purchaseorderid, dhc_total1, dhc_quantity1, dhc_unitcost1, dhc_name
WHERE (dhc_purchaseorderid = @dhc_purchaseorderid)
2. Created a parameter called 'dhc_purchaseorderid', with a prompt called 'report_parameter_0' and a datatype of Text. Allow blank values and remain hidden.
On the 'order' report i have done the following:
1. Created a dataset called CRM with the following query
select dhc_purchaseorderid from filtereddhc_purchaseorder
2. Added the 'sub' report to the order report and called it details, and chose my sub report. Then added a parameter
When i try running or displaying the report i get the following error:
------ Build started: Project: Report Project5, Configuration: Debug ------
[rsCompilerErrorInCode] There is an error on line 0 of custom code: [BC30037] Character is not valid.
Build complete -- 1 errors, 0 warnings
========== Build: 0 succeeded or up-to-date, 1 failed, 0 skipped ==========
I am fairly new to SSRS - so i am likely to be missing something obvious...
Any help appreciated.
Matt Read more...