Hello All,
I need to create a custom SSRS report which gives Quotation to customer.
1. I want all the products associated with this quote.
2. On running this custom report from the single quote it should display the current record values only.
3. I have tried this by using enable filtering .
4. but how to use filtering for more than two entities such as Quote and Quoteline.
Below is my fetchxml which gives all the records with all quotes.
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
<entity name="quotedetail">
<attribute name="quantity" />
<attribute name="quotedetailid" />
<attribute name="quoteid" />
<attribute name="wa_modelyear" />
<attribute name="wa_country" />
<attribute name="wa_color" />
<attribute name="baseamount" />
<attribute name="priceperunit" />
<order attribute="quantity" descending="false" />
<link-entity name="lead" from="leadid" to="wa_leadquotelineid" visible="false" link-type="outer" alias="a_cbccfd48dd4fe61180f2c4346bdc5eb1">
<attribute name="wa_variant" />
<attribute name="wa_model" />
<attribute name="wa_brand" />
</link-entity>
<link-entity name="quote" from="quoteid" to="quoteid" visible="false" link-type="outer" alias="a_ff5a49bd001a45f7a14dd99a28f37f91" enableprefiltering="1" prefilterparametername="QuoteFilter" >
<attribute name="wa_window" />
<attribute name="wa_tyre" />
<attribute name="wa_suspension" />
<attribute name="wa_steering" />
<attribute name="wa_sidetrim" />
<attribute name="wa_seats" />
<attribute name="wa_seatingcapacity" />
<attribute name="wa_safetyone" />
<attribute name="wa_safety" />
<attribute name="wa_reverse" />
<attribute name="wa_retarder" />
<attribute name="quotenumber" />
<attribute name="wa_panel" />
<attribute name="wa_otherone" />
<attribute name="wa_othertwo" />
<attribute name="wa_otherthree" />
<attribute name="wa_otherfour" />
<attribute name="wa_other" />
<attribute name="wa_mirror" />
<attribute name="wa_maxspeed" />
<attribute name="wa_luggage" />
<attribute name="wa_lcddvd" />
<attribute name="wa_hp" />
<attribute name="wa_gearbox" />
<attribute name="wa_fueltank" />
<attribute name="wa_engine" />
<attribute name="wa_driverseat" />
<attribute name="wa_door" />
<attribute name="wa_dimensioninmm" />
<attribute name="wa_colour" />
<attribute name="wa_clutch" />
<attribute name="wa_clock" />
<attribute name="wa_axles" />
<attribute name="wa_aircondition" />
</link-entity>
</entity>
</fetch>
although i have use enablefiltering and filterparametername but none of use.
can anybody let me know if this is possible.