This is a migrated thread and some comments may be shown as answers.

Parameters for trdx reports

1 Answer 311 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
Entegral
Top achievements
Rank 1
Entegral asked on 26 Feb 2013, 05:22 PM
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
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 = uriReportSource


And 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

Sort by
0
Stef
Telerik team
answered on 01 Mar 2013, 09:55 AM
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:
'@invoiceID is linked to InvoiceIDParameter
uriReportSource.Parameters.Add(New Telerik.Reporting.Parameter("InvoiceIDParameter", "20"))
For more details, check Using Report Parameters programmatically

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!

Tags
Report Designer (standalone)
Asked by
Entegral
Top achievements
Rank 1
Answers by
Stef
Telerik team
Share this question
or