I created a report in the standalone report designer, I have added a report viewer to my page, linked the report but is unable to pass a parameter to the report, what am I doing wrong
Here is my VB code
And here is the report xml
Here is my VB code
Dim uriReportSource As New Telerik.Reporting.UriReportSource() ' Specifying an URL or a file path uriReportSource.Uri = Server.MapPath("FSBOInvoice.trdx") ' Adding the initial parameter values uriReportSource.Parameters.Add(New Telerik.Reporting.Parameter("@invoiceID", "20")) ReportViewer1.ReportSource = uriReportSourceAnd here is the report xml
<?xml version="1.0" encoding="utf-8"?><Report DataSourceName="ET_OMS_v4" Width="6.46in" Name="FSBOInvoice" SnapGridSize="0.1in" xmlns="http://schemas.telerik.com/reporting/2012/3"> <DataSources> <SqlDataSource ConnectionString="ETOMSv4" SelectCommand="dbo.ETSP_FSBO_GET_INVOICES_FOR_LISTING" SelectCommandType="StoredProcedure" Name="ET_OMS_v4"> <Parameters> <SqlDataSourceParameter DbType="Int64" Name="@invoiceID" /> </Parameters> <DefaultValues> <SqlDataSourceParameter DbType="Int64" Name="@invoiceID"> <Value> <String>21</String> </Value> </SqlDataSourceParameter> </DefaultValues> </SqlDataSource> <ObjectDataSource Name="objectDataSource1" /> <EntityDataSource Name="entityDataSource1" /> </DataSources> <Items> <PageHeaderSection Height="1.8in" Name="pageHeader"> <Items> <PictureBox Value="iVBORw0KGgoAAAANSUhEUgAAAL0AAABBCAIAAAAL5TIFAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADrwAAA68AZW8ckkAACT5SURBVHhe7Z0HkBzVtYa3XpXrVWEMthHSrnZ6NsyGmdmc4yju7CogkBBCgAAJSSgiQAgBApFzMjnnnMHknEyOBgzGgE00QRK2McaAMbbfd+/p7untNLOLUPBD1bU16nj73v+e859wT+f954d/P/TAwHsgb+CX/HDFDz3wn/8q3Hz55VefrFrz2utvPvzo49fdcMsZ51xw0OFHz99zn+kzZ/dOntre01fflYo3NJVW15RUxIti5dGSWCRaXBgtGm5EC43o8IhRGFF/za0wMrz/xlF1AmdyfrTIKC7hDkVl5aXxZEVNXaK5rSk1KjVu4lbb7bDz7guWLF9x1PEnX3Dx5bffcffTz7zwh7ff+8tnf/3mm3/+d4Buo8TNv//97z//5bPfvPq7O++6F3Dsc8DKqTNmdqbHJZuaQYPgQI29Y9QLI0bEiBYVFVfEymorKtrj8b6q5NSa5M61yfl1iaV1iQPq44c3xo9qrDy5qcJ3O7GpghMOa4jvWx9fUpeYXZvcoSa5VXVyTDLRUllZVV5RWhqLRosiClv9Hi04ixSXliarajs6e7aessvuCw8+8thLr7jm0ceefOfdD7744u8bHZg2DtwwU196+dWrr73xgEOPAiIto8eWVlUXRoud4GC0gEV1eUW6KrFLbXJFQ/yM5vJr24of6sx/sfvH76TyPh6Rt2p03uqxm6/p2XJNeuia9LA16YI1vQWf9g53/uW/srHTtbn3p/PXqI37DF099uerxvz4k1F5H43Iez2V92z3T+/uiFzeWnpSU8WedYlpNcmORBzIGggqG1X8MKJGSWm8vnHUhEmzF+110qln3nX3fW/94V0E5waOpA0UNwAF2X7uBZfOW7I01Te+NAlKimyURCJGeSw2MpnYvS6JbLixvejp7p++nwIWP1o9dgs1kHrIzbEHHGpohym49AxZ0zPU+sF/2bbw/JX9csi1+e6XndyZDUQqGCk8qTZY+FPwAls//Xhk3pupvIc7h13WWnpwQxyJ1VRZWVxc4gQTkinZ1DJh6rT9Vx5+w023/u7NP3z19T82NBhtQLh5/4OPbr3tTjqrZ6vJseoaBRStaOhTVABqZVl94rLW2FNdP/8opcWGwodzYAQZMoTOH/Jf5057j/OQc6cFAvM+NpJ897t2ht7HI+doG3D/fSrvvs7hpzVXzKxNNldWou9MJYt6LSqpae2YtstuJ5121uNPPPPXz/+2IWBoPeNm1epP77jznmUrDu5Kj4OaKCqgsVJSUjq+OgmZuK3doE9RAbYUMSd0Rh7IsIlgkB++/3XutE9znu/c6bynU+T47nftDLmP7+M0KMGTLSB7hqDvXuj+ySWtsUV1ijyh3UwYGdGK2vqtt9/pxFPOePa5X69HdbYecPPtt9+++tob6PIJ225fWpkQrCBUEmXlkE066xXEyZhNTaBoCW9pAXsIXVjZqHFjv4vjh4glIVg9W6LdftU19LimSuYSSs0Uw9Gi6pb2WQuXXH/jLz/+ZPU6FkLrDjf//Oe3TBEM49bRYwuLiuXlS0tiM2qT8Ee0vqImwkYVFwErXm5h73HyDNdvm694iYtc7qQ1a5HfONtmP8XFh0Ie52yY8xX0bwUjjaH0METRU11bHNtUiR2Hhai6MWLgVthm+ozzL7r8vfc/XDcAWhe4waFy+DEntI4y4YJoQYUf0Rh/pvtnSq7IrMrwVhdHEaYplkvw1o/tDpTfbOk1nb7TngxNDqI+Nt+SE1x8y8nGbMZtv5Sl0dJDkUN3dkTQZVhqJoDKKiZPn3H5Vdd9+qe/fK8A+h5xg02Ei6J3m20jlmjtTMRPba5AtNBTytjJYMVFOPpxlHdTec90b/5892bPWhu/7f/y47nuzelBhy4bEL8ZwrV3dUQwm+WvvfFf1yaHwndCbxUb6wcdp3p1kTAbN7Lf1XKbtHkp1BCEELLntVTeb1N5j3QOxeDH1LcsiWi8ph5T9P4HHn7h1688/+LLQRtjNDh4fS+4wXRcftChifpGsZyTZeVIF7waaB8HXGwjJfRH73CcMfo+wVvEuKq1ROk4t/mTwyN6C25tR9qH3n8gR5Gm7/Gm5pTIoQGDaLO+hJ48t6Us0zPi5qapDq9jJFqkHNwex7cilEZRtLgUl9gGgRsYzK67LywqVWITzyncBbfb6rE/05pIHCder4mXcDgUfG/BjjVJ7tY2euz4KdNkg1Czye/qphY6C4YkFNLhj8mN36Tzb+9Q4G5o75q1YA/nNnP+YufGoVF9E6samvjh2m/vicWTfrixxYb0gNB8u6mhr58hZE5/kombM5vLefe61g67TyZMmTaRzqGLpkxrHTGK9+oYNXb85O1kD5v85i8vwrVXXXPDesYNiNl+l92AMG2Nl5X/oqni41F5n/ZF9FZoO2Ez3liTkWSbkb3Dd0LeFBr33PuA7xtCtDl6pcLNIOWNxo2xx7L9s/bgJZdfveOsuSGnjegbz3THA9lP3ihKS9uGfDI6D52It4YppH2S/TdOG4js4Q7naNwcf/Jpvk3CzuLovfc96Ht0xaFHrVPcfP75F8eeeOohRx3n3HaeM18Qo02kUsI3xzdVEuvBAXNIQxzHKDbkCU2VhHhk4/eHSm05QRNgUFjyhuig//sfcuRakTcL9943K24wWJgbIad1pfvATUZPad8x3mH82jXlFcVFxchgDGl4HnTk6rYS1KtsyEuYk8NJ7ZYu/f3Xprw5S+PmmBNO8W0SOojhwD3me3S/lYdxdN3pqXff+6NRZLoQfBWn5goAyMkY7MCyvTNyfyeaK9+juez+sn5YuAl6/xUbLG56CwDQpGqlZBWfIKRaW59sbimrqrb6x9lLESJrDmo8ANwwjUNwQ+g3BDfEMbLOFt8TBsyLiQYgWqobmwke+W7HnXQqwFqw17LzLrzM94Smzm5QBe9RPgnTiAg2RC09ddvtdwXKm4itp+z7OI15707H43oLRE8t3me/rD1IUsT0XWeHnNbdOw4eip5CNRPaRPQifho7U6efff7rb/weUf2Pb74hkk+ax6RpO/ZM3GbfAw/BV47hgxhqqKj0REjst/Da88ogVXoqYhx53EnBuDGC5DTxHN4aMjq4wMWAcfPBHz8CFiP7JgR132d//byoJEZcN+iErbab7saN8rJb8WcdEdRml9b3vcMJJnM+vJWQuPeeSt5EDGQ+Q6X9Y/23fk4z4eb9/SUWbnB7fPTxqnDoMBOm7rRrmJ7q6QM3hMTxHZTgfYgYqD/g4r2EVBA7SoAxHNXZHT640V5jKzhvB+PUW7DzdI2biqqaG2++zfsIradUv2GKe48KbpB87aN74KZZ54zrhAHjhvwjJkcqPS7oSfi8wc3Nv7w96AS6PoMb3S/EKSG2sCKk+thkgigx3OiJriGre7YADfd2FJIuwyW7L1nqj5tCA4t09ZjN8Ge4NnHSP9o59JftUf4qN4/Lsust4JBo1WRdw9vvvB/U7GeefREbhEQthIf3HELWuB4MSF7EADQ4cxXX3veAXMYDvEZLy2pNPWVxPu3k/CCVd31bMRwR597iusTRjZV4j3hHNc3SBbg2Jio9aHT39AFE17MEN2xzF+/tjxsCxiUxFQ0sq8DTlktT7XMGhhvCkL2TptCUEb3jgx5Dxh24ueXWO4JOmLbzLMENphZTkx4xDMK/VpZdxglhtMbj93QUchqePcYD2e6DG+wCgsaRKDFkNnKz5K/86E4k+GF5NQz20PsKPbaKTOfjOSSBCydTuH2xZN8DJA9wq6nbe5tx2ZXXcjn3B/Ek/XBa19jer/+RU/6DiRunvOkteDWVt2NtUkUSMvmHJjtEkmFqYJ0xqcgo4gUJVHmfZeImYmzt129K3mg5jbJTSW1FxWQn5g6dAeAGQHSN7ROWR6eE4AYCFEK4pu08kzs82bXF411DFAMoNGKJqlnzF2PlPvKrJ5jWmNxwvRF9E+RZmGb4izltot+ALd3/IORfsqEp0dicaGqx/5L7F0tWkxW1w5x5p59zwVnnX7x42f6k2ym5UlZOjN3Ug8pBglVcyEjwrBB/BhpHpi8OEu+7i3lyXksZKNdc2LjplkCJ67pc4yaWkTfpoSggyciprK2fv9cyeuahhx+DFV17/c177ndgsrmV+8fLynCgI2WZdcG4UdR70nY7BOmpK1vR75E7OlQuJLAnCzFH6OSKm7/97YuxE7fmTQjrM7mhOAcedpT3Gf/617+gWgC5prkVr7H3BOhtrFIF5JiXOixnzFm81x8//NiXAVx59fWczDlCcSZOne49jfRh1Acc4suvvnZtULGXX3nNeQmUAquVzB6go6S95dWFK5AfGC5vFi3dT3ADP/M2Q0mjQoMBQDOSBELG8Z/+/Jn3NMJGZ557IWk0zkMOPUUwrgCtpAVkdK/9DvQNM8FkVxx2lJJu0aK7OwoRP9WtHYHypjBY3uD30352Xp9YIXfjnif84vRcoJMrbmbOWwRoxlcliS5JOkiqp8/7AEaOyIiSExHjmutu8p6AXOHQuKokzgxOy9rKhx95TLzPQQoC3NQ0tZCbkcvbyjkEWbnh3LqkdjHrwFBvgcZNuLxZHqKnFuy9nMvJFgKOiIqGrhFMIW+TZFJBkp546ln7KEFsiFEdeqq34HxCB7jao0XnXHBJ+BudfPrZnBkrjSEqagL1lOq3QHkTMa5QuFGdAHQQ/0oiFJcGme7O9uSEG0gTc5Sgq56jQ6FmtGbkuIneF4MeYqILn2BFgfeEOYv24pBCXsQ44OAjchnsw44+Xm7oO9EFNyRp5HIrOYep2ZwaieFDRFD7kJRtkpO8EX7jJ29mL1xCIwlqwtg4p9uP/0FdW7pHShTJyTlIKCb0S44ASdDCxo4+4Re5vA6AECjXh8ibUH6j5Y34qVUnXAczI55Y3wiRDW9Adtwgb1WEsjBC6pAkPODO+o64oWs6x6RxZuTSOzg8Kqtrw3DT3JrLfZznXHTpldwQTqNM3LWHm4c78wU3HQH8Tyk7jZtYRcK2z1HT4IZ06aX1Sin3bT3FV1Z53xF9h2RaW7gRrwdmCmOd1XueHTeEP7gRi0V0F6tsGEhlCG5Aq/AASJy/vNFHfV0OnO+1J9m5+x57B/E73rA8UeViDFlhhMskVlVtuWhVbPlAzSqIJARdG85vRN5gJCKSUURVLW2+xhTUBEcRZyLtsF8gvGx4SqH26CnSqLFrnnz6+aztlxOAFwYKdwuTNznwm4zXPj2MqCKECW6AwyWkGVlww3s2dyPSVZKvySJDcUNntY0cXVpeyeZriis9hUVT3/j3v3/pahaUedS4iR2je0476zzXIbxBXOUbGyIeyaGyeHL1mj953xNmjecaM817aPtZc3kvfC28F7jBNcJ9QlhFLrhRwZOeoSh0/DE41n37naV3mC1QHJld9iYmNzn53qvwy6HXIJSYmS4mp+24tYcbnZ6huyJC/HHwuLnwkiuYAdBYDRrJWRz2FvKmMDKyz4ffIC3Qa2hHRtF3wglucOG42vTGW2/j9dGdqGxvFjY4T4ABMEEx4L1vIrjhkueef8l11AqlGaUVca8vGIhw4U3tUQnRH6s7KwQ3CxXz1faUnztgtwV7cPkD2im1vbb+fMWt3UKggD5y4MaMVZ16xtmut0BNV9WrnAfpmbPPv9h5Av4ODtW1BvlvstjhmhejRhyJK+lhb6cUtfelaPajs8gbsvVoK+6EjOmRzodOBuEmq4AVXoxkdp2JYGA/yUSy0tYVLYIKYJD7+vgVbjRjwPHjuicrsMQQ46/XRuAozyI63RaP41zQnqRsuAn2+wluWLXZk0woJ2wAG3W2EMlB4AIlKy3kL81xOQ44/1ePPyXkV3DjYuUk8nGo1k8tSjw8R3vKkWqoODJBD1wJg5c3xaxNKYzg6dd2h8ibfNYbsDO9zbZZUeI9QeSNN7jNrHrxpd8QgeIv8RRcL64upmum7LBzsLzxwQ2OMt3XqsfPOu8i17VIIPzrGqzmku/suMkib9T6S3P1eCQKCB548JGsXfTb373VPnKMtDNR2+ANZrEHo50NDsdGsrbzniJTsSgD/DcDlzeKHRdMr0likA8eNyJIH+tS/iiTPaXzcYGzc7yf2zRrNwl/fOU3r2c903VCS2pUGG4ihjc4h4/VVgQY864bsiobM42FSExxNgYGdYZTLqhh4fyGOPm2O+4it2KbMXsej25o6/R1aboegSNe2eeFRkjUL6hVUAI4LD4zL1+041OBcQbL7+fKF0NrL6hLgPvB4yZE3oybMm2gY8/5WEaYji5xkst9YIXbbL/TgOSNxo0pb8hYcF0LP4UW2OSd/5Ynq6lSENSYcH6D+uDV7GspdSCQBe5e4uV9xGNPPI3S9B3g8M4R3DABAnAzSHlDaJlqG4PHjY5iKn5jGuFaT4XIG3Q2izCYtWzUi/A+GOJC9MrX9gnvIMy07yJvGHXX/TFim7tG2HE0+j0cN+HyhiFHBduP2HP5ClvUwfcxufGkh78gEyM8ScP3cvS7ljd1Xtzgd5U2DFTeIH6UU+C78Bv8GdhTLBO09BTLL8Jwg7+4sqpGNTdisJ45d9zw/szLoOUaHMIN7dutxDWFNnp5samnNGvGGnc1Bog3dnTbbiRCV1DUoFxdrjVddgH+Yi9umB6MKJtOjzSABVVLQqBDwi+uHe8JSBQ4DTTId3vwoUd5kC9uyNiSgQiJMzj9xRYPGYbbmoBDd3CqDI3MYk+RhNWU8d/odHyLF/vqKWaVjjMo8eh1w/A85A396F2XitWqKKpdtsgyO8WIkBv6+m9WHnGMMF8iWa5Od+opwhGuo0Ac+zaDm6++xgkUlKvLteF6irGZs2hP+xG8Ji4MSCsbLgZC6LSQASY0FuQLJpw3zs/UIOGBHrM3MR6tzbTeIdReeaNxo04Iui2HLmyJaU2SscNtl8R38t/QEfiaeDxESZviSt6IPZUFNxHj1DPP9acjEYOkSdchxs9pbTIMiFl7w6kK09puhk+uHSMtNioo8ceNPupdroDLGMVU39Y5ctwEcjbgpHgBQuSNwk2wHY5vCXHFeoYRfRPxbCF0ndKF9fAqb1+3BMvAN5qG5MD560UV6WDOngGRLFSQnmGyqdGJGMHyJtAOVw7DiHEOiR8mbvSSP72WT/zF+MwGz2+4klB+vK4BRxAJeDo+la/9foYvbpxxTd/gnFL8EZ/FGdjeprDRk8kVJ8dtTb/7+v0s3BgB8sZcjXbEsSe6egE/ujhtdaaLeRryIKizwvXUDjPniAyw7+ZyUqvsWOtBvslJUGOGHwHvagBUwcKNur/rNQlKcJRMEi9/svWUL79Rcjqi8iTtuKbEp8hrU2LCo9Zdrcoen+ICpjtOjkozHj6McmXaAeWTDUTrkZkiHn3HgOnCIW8qNWyDxTSiceg+V3AEpw6HfHkxt5KrAuWNPuoNzjMAXEi9GXIx30jlsVKH05avPDwIN+F5W+SUcfnN7VFyXlM6SdSFm7vvuV/ayV8Sa7xPYaETMweG5zoE89Mr6NS1CCSXg4dUBQ7BDbz+G3zu8jgW2nkfx0TiENks5H7IwhIEzw1tqu5Ooq4B10A4i88JN9xil7kLuCPZrNqYUqoau8l7a4YfFkKDcKn5rlzBqcAsHz1+K++1hMfxGuNQ8UbUeBZKxFfjsgRanAVe3EAnpeM44cOPPnE9EZObQxeh4FkZ2FtIQionz3XY0q7zlb7QEsULX966oTOFpKEUHHej6J8XN0RgMM7xQdAz3qbyLNZ+cBWv70uNybbBzvDaoWLww2C8ug/lKI5NJKX3nig7Wc8ExZHU96e6fkZ+C+b37QFLR5w3yRU3wHzU+K14TH1FJU3xDb/JfdEpJAl47V77qSh4us/XSg/COKIImzmIUeo8LB89xXBibTFHfSE+Y+58XoTVKlLm4sXuTbkJcZWgNtBgVvAQkUVyuM6B/JLoWVVeTiI9Y6ByxSNueSOX4BJ88/fv+D5CRSoiyuzyzQjwvYQzWcYLFwmKoaIo8D36ugC4VnIUL9EzhyRrZA+T0xsC8n10rrjhYp1fTNReWTe+FF0eQCuJJfmKYjlBNzdC5lvQCLn2Q7CIrodkwp9yxjm+8ibk/jiLqcZIT5HXLVlLpHmTKMkC75AKILya76KWCy++ImM69BZMCMZNUJO4LasphACFB0Sdd8D1wEgzS4PajLWBjgt6qOQ9XtNWQmZVkS7CyqKiHAdlALjhjtjPOsvY37QzcfPlVxi0TuepqymycgdV5wp6B7WYRGbOJ8Ui6AQEuK+8CekCjGQuYfltZlU5C0P1QnRXwDlrPzJxSX3kQrWSUNkNWt54+E34fVhbo/pEJ1wDoBzLHxHZ4PyKZA0cyPf+2PZEMIIEGHqfy0cnE2o9Q7TYazqEtHlguOFGKqkxWkwOQNBNUbTIG981O3KJXtGuaAeTO9wVxslgSy1KKoyMmTAp6IkY/AOSNyySqqypg6RRPMZKTccELSAMx4xnacSAig6p3KCIgYNV1QtTfgotbwaCGzQXKzoQfiBP0q5JQsoa2KLQnXQjwakgZzQkhkBH4Hwz7xCB/5EAyWmoUcwFX5nqusmAcSPrNVnoBe3y3YgvolbwtUBLvSewc7dFe/K2spSOWpAY0r6p/ziyECQ6KV0ZychbvMa+NyT2lLu8ue/+h/DZcD7ZSZYJmlnqpmrtFBo0PseEZYLqxKK5RFklkqhryRtn2h4t9xrYMhL0p46HGxQJkJViaqFnIakR7Zjrvqm0SBft1FGlkNnKkzXkEfj2DO4oYnBEkUP6jVRraSrCCfJAZ8Kjg1pro2fAuLGToeC2qiyPzphBAsl/pQC9mge8FUf1lskukP/qSj4UGCN3XyQzRep3mj0PUwICywI2ZhJ2TW1rB6fRL9SNzrhYrBr39m3VI/T6Cq+RAlskLo3/g0xCOgXlzfJk/XRDuTHNQiqOMjna60XyKCdQryRrLSpsNGgsJ+9WK3lt4joz5U3f5Kk8nffacfY8XIKsBnetUyaSSlS1pqWNO4BXsz5QOp/USnKNhUeSbAkdJE0HuQvvwaqiECTMjEuAF2Yz6xmUn11/LcD8YIDV4WbFZ11dW47KGKlPC0iek34EKhs00Bj0ACsFIBjor6CqMYPHDaYgOQOEpmXDg450kRYoAZuIb1uTJJ5FiiAVh2WjgLls8l859HLqR9h+rKqZV5e0yvWK+9yMKvCDS1haxljyA6cI5T9kYxUmm/ymixWnC7XDRZ7LncnhvQBnl1ooLlWM+pdXSheQ7UZlU85v6hoBr/TNWkQv4FCoVuvfIizpZfFbps5IuoAX1I9zRgPUo0k+Hz1hEhEPjGdqCbRoMcNG7rYqLWXWlVJ1u7HLMI9JnrJa7uwZqn5HKbyKowikTq5W9Y6pSUD9bLtzGAXZw1+OkpVGI+lDyU2TexKbI2jNhgAGDdiegAbo4K2lpBDJYuGEbMDyxns7GA82pNS/ocoLpVwoDK6dIro2gNrseo7yX6lgoiuG6vXhLLy9r2M4pf/4SALFrUnZZFE0vjgJh1l1yJ0FA3T9c11CgLWums/6yBvkM6IIhUiVuFm1SdafX99WhN0kVYz8Kn9JYloBbhi7/khj1wh8lVSiYP0lVIb8L2RhXTuaTg0ABcVWjdnESqKVulpDX0r9LwtiyDWWjVeDuNAGJRsyCFY4pm2sTs+8Y6Yos0qeAkzUgadbWGNAItWutUkWYFAcXiFGisC7yqOaNRWk/rfMB8W3uBWhyr3UemrNu+sbCR16ax9jneHbBDRAJ+t6tLWAG0EST912xq4Ez9WcLokd01ipXs+swGtXaHOVz7SKZeo6q86aXI4Ko1kKcnGVLuTm47+BbzLFSSUBxLolUuTWLpPmLEwhLbHbo7oe7CoS5owjWjX00JvIP9PTmrmhVXbELj1slkqV7zxQL3ITlkVe317MqmxWdkp9TAfHchYrsWCdzreKUTir9juragT0j062B8QUraVgmawarqiuJSV+zad/DpIlgCnryim5dq3hRm4Hw0Kj4wRTYtmI4sXHN/Cd6vtlqhh7Swkp+wVMMOl95Q1mUUmFktUO0TKQ+sU6NZYg7gUtMb4Bw3SfU5s8qCFOLrc55LYszMgJp9azR9SuJ+qoZu1f8NBTNiq4vp9DqDhLBZoCBhGOQ08bHyq0yWp5AjJrsTz2WsaNoIdMEVQ4a+IlAgzTRPUovSN17UwKmXthROl3L25UPfpfp37clVAskniyaxrhX24fk2aqPdf9Eyuv3tRE5nc3bF0pn+GwK1fKf6VSjpq4qj6hvqRfBRpL/1r1KDMVzrW0kErVdrVKXUnfeoQZIbaOWt8BMZO4fV82qAKXLeSUwKYeNDoR9mNSxmhRqnc8lkFW+yiczXiPfi+4kcdgXcPViUiI8lJLKxIJUgfVUqxM/WJbhQXU9wuRN+l84oiiR/BS+E4m6AgUB72pa+4p8Q6HJRRFqRHKbMmyZQDNahjcpnxuSDgTMQdohzrasyUjwdp9/dtJiYbgaL69PcJ9KGOrBGrPkCe7fn5xSwzlxSP47Ah34BDKTpZo0YBb2qPwDNCGBmc/J9zUXrRqzKbIBn5zqwfV8qugSeKLG6nYrSomI9cRinwmRwRMrKqGDxMRW83KVAaKmO9FT/k2Am8SalUtydaGDwBi6QnuE3wVyhLJWi/dLB9pD5vFQnoLGAn6CEM3aD7hKp2inao6tV59K4ox40NVVGfCjsXCR81BGPG2QZwl+Y0vSSlTnPyh5gpItz4/+kL3ZhZ7FVlCEtL/8CKYMyzO5RKsME7DU0zWAC4G3otVVNi6HfH4I51KYkkVZnYiFZ7v3pwe4L9bVyfh6cCLW6FtqdFhqVTPy2ZQq4STyD8AB0wxx0zGzYvFyqjacfFlVw0iE3dAAPoe5Y2rHbiwYD8Ye82pUfY3gspKY3AgBoyJKEFBXUnK/iKQk/QF4mZlaNUWHB7gRk1lbYOAg2i0GFMcAx4LC9ww8FQeIeZAQS49qJthr+IdwKylPaz3Zq0/WQCKXGc+MqWSZUmmpMAKhhKDzW1BDHDsrUpwH40/Vd/vuW5MS1XdiKHdWw8woos9FH8ArAgzfoN+MAd/Ijhv1cp0vqzjazHpglWjNyEWSzlS7GrzOzERo7isAriwaJCv5w1o+Ad98rrDjd1EXExIIOKufZO3g7cKB2LCEU9m6mDGs65PySGTc9jfg/EI6nQ++gVMHHTEMSHvr3FjlS9NDxX5gWuETqciE5KATCUKLqNiqM7EKK5siAMI3B5SwRqbnB84c/mwT6ZedXoYxjb7kZroFxAPvJAlDCdoAB+CFSqSI+fAItaTWN38RTexB/ucBigMkfXSrurTUsQaBWqRKgeD1t5IcMbN8Q44vwfD58345CIuzaxBiUHjI+jC9YAbZ1MgJXhCSQKkgANrqgVD4p0ji4VRgVvADzIwki+ACIFN56vSfBFj3p77UKOJ3FPnX/kv25Sd0FOswDXL3iLb8TqSq0WiFsYRwwYm8Ix1JVSRZeQEkobyylhMhJkYSIZ/VDLRWFkJLDSP0fBND0VA4l5jQzcxrlSzFhccYULGmPtgdfMKmGP8RuXhU+ZFwCg3Z88L3ZvSDFUDu7eA0mPch4Wey+qVhOMRKC9wieGGDkXs2Z8xQ05DXCZMnU56KAu+vDnFax0fGyhu7GZBRAgC41vDEONjk7Fk1XDH9+6ge/igKVFD+UikNJObIURxQAaVl91Qn9aFfbNRJti9aWeXKsJilkvurwIytbed/hs93TMF8W116aoH66wTqy7RX2mUaz3OocxXbcyPApmOGb53N2YTIIUmReTMrU0ilvhQqOnY1ZX3qG7BV0UJNuHGDQp9rzPErDtePIhXwvXCfMIawigghlqaSPb/vqZKWmW+9uLR17E9KAjBAcgmDnXc/IgKwh34AxESeFphIdqoUcUiXGsTLV+fExkW7/apeu+LG/ta+dar/DWr6YozU0gb9BnJBINGeUHpjmyMw4VBCexK/HJq48u/RcWJhiaUOMFLYlI4Ndbjd+02dHkTji1MehJvKdoIrZ68w85NqZEaScX2dxXFzYi9TVAGIwWehI67tDWGaYOLlkR6FJP+NsImpq6xhlZcMoPbpBispTeVhY9Sgw/haIBcE2oAHKc0VaB9QDD+ZZCtaujZENERR77CWlnXwIKKmfMXoX1IJmfdzHpUQDlO8vXMb3Jspes0fBIIJMg1gW6S/fjCO2BqG5MmUIwh6vv9cGAFsCCVUGBSXXEVoviQRlhze9Ql8Hwc2qDCWHwdmC+SsKEysLmI2LOd0mx+URwCRE4+FZb43jjQ5NvjcBrsGmQGgTlsQ/SL//fDeXpxCV+lo4Dj6Ilb41KnsCMpL8Twie5Rc3Nw/bAer9oocRPUX0xTEmIIZ+I7Jl4NpJBPcxbvDTkYO2lK+5jemo5OsMW3x4vLK8nsIUM+k+khS/784thWDFmXRJHTdGYCCQlqUWZZOYAora6JNzU3do+gbAxf9cGltHDpchIxyR4kGkodCaQIWM+xovF6BESOj/6vwk34O8u3EUjKAVg4UrHjSPchQZPADamrhIJZ4E2KCDWd2MgPISOWjTxDFjCwdIsNOUH+A0v4yDeApbICAXSSpg4Vw3ADsmTK5ViaL8fh2WBP+3+Emw12DDbGhv2Am41x1NZ/m3/Azfofg42xBf8Hny/nlKzPWBkAAAAASUVORK5CYII=" Width="5cm" Height="2cm" Left="0.02in" Top="0in" Sizing="ScaleProportional" MimeType="image/png" Name="PictureBox1" /> <TextBox Width="4.45in" Height="0.3in" Left="1.99in" Top="0in" Value="=Fields.sOffice_Name" Name="textBox1"> <Style> <Font Size="15pt" Bold="True" /> </Style> </TextBox> <TextBox Width="2.54cm" Height="0.5cm" Left="8.89cm" Top="2.55cm" Value="Invoice Nr: " Name="TextBox3"> <Style Visible="True"> <Font Bold="True" /> </Style> </TextBox> <TextBox Width="2.54cm" Height="0.5cm" Left="8.89cm" Top="3.05cm" Value="Invoice Date:" Name="TextBox4"> <Style> <Font Bold="True" /> </Style> </TextBox> <TextBox Width="1.84in" Height="0.2in" Left="4.5in" Top="1in" Value="=Fields.ET_FSBO_INVOICE_ID" Format="{0:#.}" Name="textBox2" /> <TextBox Width="1.84in" Height="0.2in" Left="4.5in" Top="1.2in" Value="=Fields.dDate" Format="{0:d}" Name="textBox5" /> <TextBox Width="3.09in" Height="0.2in" Left="1.99in" Top="0.3in" Value="=Fields.sPhy_Street" Name="textBox6" /> <TextBox Width="3.09in" Height="0.2in" Left="1.99in" Top="0.5in" Value="=Fields.City + ', ' + Fields.State + ', ' + Fields.Zip" Name="textBox7" /> <Shape Width="6.44in" Height="0.1in" Left="0in" Top="1.7in" Name="shape2"> <ShapeType> <LineShape Direction="EW" /> </ShapeType> </Shape> <TextBox Width="1.52cm" Height="0.5cm" Left="0.25cm" Top="2.55cm" Value="To" Name="textBox20"> <Style Visible="True" TextAlign="Left"> <Font Bold="True" /> </Style> </TextBox> <TextBox Width="2.7in" Height="0.2in" Left="0.1in" Top="1.2in" Value="=Fields.sName + ' ' + Fields.sLastName" Name="textBox21" /> <TextBox Width="2.7in" Height="0.2in" Left="0.1in" Top="1.4in" Value="=Fields.sEmail" Name="textBox22" /> </Items> </PageHeaderSection> <PageFooterSection Height="1in" Name="pageFooter"> <Items> <TextBox Width="6.86cm" Height="0.5cm" Left="0.25cm" Top="0.25cm" Value="Paypal Payment Details" Name="textBox16"> <Style Visible="True" TextAlign="Left"> <Font Bold="True" /> </Style> </TextBox> <TextBox Width="2.5in" Height="0.2in" Left="0.8in" Top="0.3in" Value="=Fields.dtPaypalDate" Name="textBox17" /> <TextBox Width="2.5in" Height="0.2in" Left="0.8in" Top="0.5in" Value="=Fields.nPayPalPaymentStatus" Name="textBox18" /> <TextBox Width="1.7in" Height="0.2in" Left="0.8in" Top="0.7in" Value="=Fields.dPayPalAmount" Format="{0:C2}" Name="textBox19" /> <Shape Width="6.44in" Height="0.1in" Left="0in" Top="0in" Name="shape1"> <ShapeType> <LineShape Direction="EW" /> </ShapeType> </Shape> <TextBox Width="1.52cm" Height="0.5cm" Left="0.25cm" Top="0.77cm" Value="Date:" Name="textBox23"> <Style Visible="True" TextAlign="Left"> <Font Bold="True" /> </Style> </TextBox> <TextBox Width="1.52cm" Height="0.5cm" Left="0.25cm" Top="1.28cm" Value="Status:" Name="textBox24"> <Style Visible="True" TextAlign="Left"> <Font Bold="True" /> </Style> </TextBox> <TextBox Width="1.52cm" Height="0.5cm" Left="0.25cm" Top="1.78cm" Value="Amount:" Name="textBox25"> <Style Visible="True" TextAlign="Left"> <Font Bold="True" /> </Style> </TextBox> </Items> </PageFooterSection> <DetailSection Height="0.2in" Name="detail"> <Items> <TextBox Width="0.6in" Height="0.18in" Left="0.1in" Top="0in" Value="=Fields.sQuantity" Name="textBox11"> <Style TextAlign="Center" /> </TextBox> <TextBox Width="4.54in" Height="0.18in" Left="0.8in" Top="0in" Value="=Fields.sItemName" Name="textBox12" /> <TextBox Width="1in" Height="0.2in" Left="5.34in" Top="0in" Value="=Fields.sItemPrice" Format="{0:C2}" Name="textBox13"> <Style TextAlign="Right" /> </TextBox> </Items> </DetailSection> </Items> <StyleSheet> <StyleRule> <Style Color="Black"> <Font Name="Tahoma" Size="18pt" Bold="True" Italic="False" Underline="False" Strikeout="False" /> </Style> <Selectors> <StyleSelector Type="ReportItemBase" StyleName="Title" /> </Selectors> </StyleRule> <StyleRule> <Style Color="Black" VerticalAlign="Middle"> <Font Name="Tahoma" Size="10pt" /> </Style> <Selectors> <StyleSelector Type="ReportItemBase" StyleName="Caption" /> </Selectors> </StyleRule> <StyleRule> <Style VerticalAlign="Middle"> <Font Name="Tahoma" Size="9pt" /> </Style> <Selectors> <StyleSelector Type="ReportItemBase" StyleName="Data" /> </Selectors> </StyleRule> <StyleRule> <Style VerticalAlign="Middle"> <Font Name="Tahoma" Size="8pt" /> </Style> <Selectors> <StyleSelector Type="ReportItemBase" StyleName="PageInfo" /> </Selectors> </StyleRule> </StyleSheet> <PageSettings> <PageSettings PaperKind="Letter" Landscape="False"> <Margins> <MarginsU Left="1in" Right="1in" Top="1in" Bottom="1in" /> </Margins> </PageSettings> </PageSettings> <Groups> <Group Name="labelsGroup"> <GroupHeader> <GroupHeaderSection PrintOnEveryPage="True" Height="0.2in" Name="labelsGroupHeaderSection"> <Items> <TextBox Width="1.52cm" Height="0.5cm" Left="0.25cm" Top="0in" Value="Quantity" Name="textBox8"> <Style Visible="True" TextAlign="Center"> <Font Bold="True" /> </Style> </TextBox> <TextBox Width="11.53cm" Height="0.5cm" Left="2.03cm" Top="0in" Value="Item" Name="textBox9"> <Style Visible="True"> <Font Bold="True" /> </Style> </TextBox> <TextBox Width="2.54cm" Height="0.5cm" Left="13.56cm" Top="0in" Value="Price" Name="textBox10"> <Style Visible="True" TextAlign="Right"> <Font Bold="True" /> </Style> </TextBox> </Items> </GroupHeaderSection> </GroupHeader> <GroupFooter> <GroupFooterSection Height="0.3in" Name="labelsGroupFooterSection"> <Style Visible="True" /> <Items> <TextBox Width="1.52cm" Height="0.51cm" Left="12.04cm" Top="0.26cm" Value="Total" Name="textBox14"> <Style Visible="True" TextAlign="Left"> <Font Bold="True" /> </Style> </TextBox> <TextBox Width="1in" Height="0.2in" Left="5.34in" Top="0.1in" Value="=Fields.dTotal" Format="{0:C2}" Name="textBox15"> <Style TextAlign="Right"> <Font Bold="True" /> </Style> </TextBox> <Shape Width="1.7in" Height="0.1in" Left="4.74in" Top="0in" Name="shape3"> <ShapeType> <LineShape Direction="EW" /> </ShapeType> </Shape> </Items> </GroupFooterSection> </GroupFooter> </Group> </Groups></Report>1 Answer, 1 is accepted
0
Hi Adriaan,
The ReportSource.Parameters collection features passing values to the report parameters, not the data source parameters. When you configure the sqlDataSource component you will be prompt to set the data source parameters. Create new report parameter and set the data source parameter value to be the report parameter value. For design time parameter just set value to preview the result of your query. Finally in code you need to pass value to the report parameter which will be passed to the data source:
For more details, check Using Report Parameters programmatically
I hope this helps.
Kind regards,
Stef
the Telerik team
The ReportSource.Parameters collection features passing values to the report parameters, not the data source parameters. When you configure the sqlDataSource component you will be prompt to set the data source parameters. Create new report parameter and set the data source parameter value to be the report parameter value. For design time parameter just set value to preview the result of your query. Finally in code you need to pass value to the report parameter which will be passed to the data source:
'@invoiceID is linked to InvoiceIDParameteruriReportSource.Parameters.Add(New Telerik.Reporting.Parameter("InvoiceIDParameter", "20"))I hope this helps.
Kind regards,
Stef
the Telerik team
See what's new in Telerik Reporting Q1 2013. Register for the March 4 webinar to witness the impressive new visualizations in Telerik Reporting. Just for fun, 10 webinar attendees will be randomly selected to win a Telerik T-shirt and a $50 Gift Certificate to ThinkGeek. Register now! Seats are limited!