Maximum Number of Input Parameters

We created a report with 42 parameters in it. While in VS, it
previewed fine. Then in our preferred browser Firefox, it rendered
fine as well. Only after we had to test different platforms did we
realize that it did not work in IE 6 or 7, using our interface, or
even the MS Report web interface. This seemed really odd as we are
able to run this report through Firefox.
We then created a test report with nothing in it and just started
adding parameters to it, uploading it, and used the MS Report web
interface to view it. At 36 parameters, it stopped working...
We removed shortened up the length of the names of the parameters to
see if it was a GET/POST issue, but the same limit happened.
Anyone else with this issue? Any suggestions?On Mar 1, 12:12 pm, "dmcnamer" <dmcna...@.gmail.com> wrote:
> We created a report with 42 parameters in it. While in VS, it
> previewed fine. Then in our preferred browser Firefox, it rendered
> fine as well. Only after we had to test different platforms did we
> realize that it did not work in IE 6 or 7, using our interface, or
> even the MS Report web interface. This seemed really odd as we are
> able to run this report through Firefox.
> We then created a test report with nothing in it and just started
> adding parameters to it, uploading it, and used the MS Report web
> interface to view it. At 36 parameters, it stopped working...
> We removed shortened up the length of the names of the parameters to
> see if it was a GET/POST issue, but the same limit happened.
> Anyone else with this issue? Any suggestions?
I've never used this many parameters; however, it sounds like it is
related to a limitation in IE 6/7 page rendering. Is there not a way
that this report can be split up into more than one report?
Enrique Martinez
Sr. SQL Server Developer|||On Mar 1, 10:05 pm, "EMartinez" <emartinez...@.gmail.com> wrote:
> On Mar 1, 12:12 pm, "dmcnamer" <dmcna...@.gmail.com> wrote:
> > We created a report with 42 parameters in it. While in VS, it
> > previewed fine. Then in our preferred browser Firefox, it rendered
> > fine as well. Only after we had to test different platforms did we
> > realize that it did not work in IE 6 or 7, using our interface, or
> > even the MS Report web interface. This seemed really odd as we are
> > able to run this report through Firefox.
> > We then created a test report with nothing in it and just started
> > adding parameters to it, uploading it, and used the MS Report web
> > interface to view it. At 36 parameters, it stopped working...
> > We removed shortened up the length of the names of the parameters to
> > see if it was a GET/POST issue, but the same limit happened.
> > Anyone else with this issue? Any suggestions?
> I've never used this many parameters; however, it sounds like it is
> related to a limitation in IE 6/7 page rendering. Is there not a way
> that this report can be split up into more than one report?
> Enrique Martinez
> Sr. SQL Server Developer
we are not able to split up the report, as it is a summary report
which requires all of the input parameters. we contacted MS tech
support and, for some reason, they were able to get this to work.
however, we gave them access to our machines and it did not work for
them. they spent a while trying to figure it out with IE and SQL RS
people on the line and were not able to figure out which setting
combination made this not work. our guy got tired from staying on the
line. instead, we created a bit string to represent all of the binary
options get around this limitation and then parse the bit string in
the report.