Parameters for trdx reports

2 posts, 0 answers
  1. Entegral
    Entegral avatar
    13 posts
    Member since:
    Nov 2006

    Posted 26 Feb 2013 Link to this post

    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>

  2. Stef
    Admin
    Stef avatar
    3036 posts

    Posted 01 Mar 2013 Link to this post

    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!

  3. DevCraft banner
Back to Top