parameter length limitation

Hi,
I am using sql reporting services 2000, i am trying to pass a parameter with
the length of 3000 character and since the URL limitation is 2040 i used the
post method as follow
<FORM name=Form1 method="post" target="_self" >
<input name="rc:LinkTarget" value="_self" type="hidden" ID="Hidden1">
<input name="rs:Format" value="HTML4.0" type="hidden" ID="Hidden2">
<input name="rc:Toolbar" value="true" type="hidden" ID="Hidden3"/>
<input name="rs:ClearSession" value="true" type="hidden" ID="Hidden4"/>
<input name="rc:Parameters" value="Collapsed" type="hidden" ID="Hidden5"/>
<input name="PIN" type=hidden value="" ID=""/>
<input name="EnvIds" type=hidden value="<%=request.form("envids") %>"
ID="Text2"/>
<input name="RegionId" type=hidden value="<%=request.form("regions") %>"
ID="Text3"/>
<input name="PhaseIds" type=hidden value="<%=request.form("phaseids") %>"
ID="Text4"/>
<input name="CommStatus" type=hidden value="" ID="Text5"/>
<input name="WIN" type=hidden value="" ID="Text6"/>
<input name="WorkOrder" type=hidden value="" ID="Text7"/>
<input name="County" type=hidden value="" ID="Text8"/>
<input name="StateRoute" type=hidden value="" ID="Text9"/>
<input name="CommitmentIds" type=hidden value=" <%=request.form("CommIds")
%> " ID="Text10"/>
<input name="SearchParameter" type=hidden value="" ID="Text11"/>
<input name="CommitmentDescription" type=hidden value="" ID="Text12"/>
<script>
document.Form1.action= "<% response.write request.form("formaction") %>"; //
form action which will be the url to the reporting server
document.Form1.submit();
</script>
even after i used this method i still have parameter length limitation. is
there any way to go around this problem?
Thanks
</form>Robert,
What kind of parameter are you passing that it has to be 3,000 chars?!
Are you passing SQL into a report through a parameter?
-Josh
Robert wrote:
> Hi,
> I am using sql reporting services 2000, i am trying to pass a parameter with
> the length of 3000 character and since the URL limitation is 2040 i used the
> post method as follow
>
> <FORM name=Form1 method="post" target="_self" >
>
> <input name="rc:LinkTarget" value="_self" type="hidden" ID="Hidden1">
> <input name="rs:Format" value="HTML4.0" type="hidden" ID="Hidden2">
> <input name="rc:Toolbar" value="true" type="hidden" ID="Hidden3"/>
> <input name="rs:ClearSession" value="true" type="hidden" ID="Hidden4"/>
> <input name="rc:Parameters" value="Collapsed" type="hidden" ID="Hidden5"/>
>
> <input name="PIN" type=hidden value="" ID=""/>
> <input name="EnvIds" type=hidden value="<%=request.form("envids") %>"
> ID="Text2"/>
> <input name="RegionId" type=hidden value="<%=request.form("regions") %>"
> ID="Text3"/>
> <input name="PhaseIds" type=hidden value="<%=request.form("phaseids") %>"
> ID="Text4"/>
> <input name="CommStatus" type=hidden value="" ID="Text5"/>
> <input name="WIN" type=hidden value="" ID="Text6"/>
> <input name="WorkOrder" type=hidden value="" ID="Text7"/>
> <input name="County" type=hidden value="" ID="Text8"/>
> <input name="StateRoute" type=hidden value="" ID="Text9"/>
> <input name="CommitmentIds" type=hidden value=" <%=request.form("CommIds")
> %> " ID="Text10"/>
> <input name="SearchParameter" type=hidden value="" ID="Text11"/>
> <input name="CommitmentDescription" type=hidden value="" ID="Text12"/>
> <script>
> document.Form1.action= "<% response.write request.form("formaction") %>"; //
> form action which will be the url to the reporting server
> document.Form1.submit();
> </script>
> even after i used this method i still have parameter length limitation. is
> there any way to go around this problem?
> Thanks
> </form>|||Josh
user can choose different documents and then i send the documentid(s) to
report server and stored procedure on the back is going to do some processing
on it and then return it.
so some times may this documentid have length of 3000 or more because these
documentids are commas seprated.
do you have any suggestion that may help me?
Thanks
"Josh" wrote:
> Robert,
> What kind of parameter are you passing that it has to be 3,000 chars?!
> Are you passing SQL into a report through a parameter?
> -Josh
>
> Robert wrote:
> > Hi,
> > I am using sql reporting services 2000, i am trying to pass a parameter with
> > the length of 3000 character and since the URL limitation is 2040 i used the
> > post method as follow
> >
> >
> > <FORM name=Form1 method="post" target="_self" >
> >
> >
> > <input name="rc:LinkTarget" value="_self" type="hidden" ID="Hidden1">
> > <input name="rs:Format" value="HTML4.0" type="hidden" ID="Hidden2">
> > <input name="rc:Toolbar" value="true" type="hidden" ID="Hidden3"/>
> > <input name="rs:ClearSession" value="true" type="hidden" ID="Hidden4"/>
> > <input name="rc:Parameters" value="Collapsed" type="hidden" ID="Hidden5"/>
> >
> >
> > <input name="PIN" type=hidden value="" ID=""/>
> > <input name="EnvIds" type=hidden value="<%=request.form("envids") %>"
> > ID="Text2"/>
> > <input name="RegionId" type=hidden value="<%=request.form("regions") %>"
> > ID="Text3"/>
> > <input name="PhaseIds" type=hidden value="<%=request.form("phaseids") %>"
> > ID="Text4"/>
> > <input name="CommStatus" type=hidden value="" ID="Text5"/>
> > <input name="WIN" type=hidden value="" ID="Text6"/>
> > <input name="WorkOrder" type=hidden value="" ID="Text7"/>
> > <input name="County" type=hidden value="" ID="Text8"/>
> > <input name="StateRoute" type=hidden value="" ID="Text9"/>
> > <input name="CommitmentIds" type=hidden value=" <%=request.form("CommIds")
> > %> " ID="Text10"/>
> > <input name="SearchParameter" type=hidden value="" ID="Text11"/>
> > <input name="CommitmentDescription" type=hidden value="" ID="Text12"/>
> >
> > <script>
> > document.Form1.action= "<% response.write request.form("formaction") %>"; //
> > form action which will be the url to the reporting server
> >
> > document.Form1.submit();
> > </script>
> >
> > even after i used this method i still have parameter length limitation. is
> > there any way to go around this problem?
> >
> > Thanks
> > </form>
>|||OK... this suggestion will only work with SSRS 2005, so I will also
recommend an upgrade.
One of the enhancements offered in SSRS 2005 is multi-valued
parameters. With the introduction of this option, they also added a
JOIN function that will convert a parameter array into a character
delimited string. Sooo...
You create a docID parm (probably string would be best) that is
multi-value. Then, whatever you are using to call the report and pass
that huge string can build the URL like this:
http://serverName/ReportServer/Pages/ReportViewer.aspx?/Folder1/Folder2/ReportName&docID=abc1&docID=abc2&docID=abc3
Create another parameter called docIDstring and mark it as hidden or
internal. (If you want to be able to pass the string already formatted
as CSV, use hidden so that you can pass it in the URL. If you are ONLY
going to use the approach that I am suggesting, mark it as internal.)
Set the default value of the internal/hidden parm to:
=JOIN(Parameters!docID.Value,","). Multi-value parameters are treated
as an array, and this JOIN function will convert the array to CSV.
If you used this expression with the URL that is listed above,
docIDstring would = "abc1,abc2,abc3".
Sorry it only works with SSRS 2005, but you probably need to upgrade
sometime anyway.
Hope this helps!
-Josh
Robert wrote:
> Josh
> user can choose different documents and then i send the documentid(s) to
> report server and stored procedure on the back is going to do some processing
> on it and then return it.
> so some times may this documentid have length of 3000 or more because these
> documentids are commas seprated.
> do you have any suggestion that may help me?
> Thanks
> "Josh" wrote:
> >
> > Robert,
> >
> > What kind of parameter are you passing that it has to be 3,000 chars?!
> > Are you passing SQL into a report through a parameter?
> >
> > -Josh
> >
> >
> > Robert wrote:
> > > Hi,
> > > I am using sql reporting services 2000, i am trying to pass a parameter with
> > > the length of 3000 character and since the URL limitation is 2040 i used the
> > > post method as follow
> > >
> > >
> > > <FORM name=Form1 method="post" target="_self" >
> > >
> > >
> > > <input name="rc:LinkTarget" value="_self" type="hidden" ID="Hidden1">
> > > <input name="rs:Format" value="HTML4.0" type="hidden" ID="Hidden2">
> > > <input name="rc:Toolbar" value="true" type="hidden" ID="Hidden3"/>
> > > <input name="rs:ClearSession" value="true" type="hidden" ID="Hidden4"/>
> > > <input name="rc:Parameters" value="Collapsed" type="hidden" ID="Hidden5"/>
> > >
> > >
> > > <input name="PIN" type=hidden value="" ID=""/>
> > > <input name="EnvIds" type=hidden value="<%=request.form("envids") %>"
> > > ID="Text2"/>
> > > <input name="RegionId" type=hidden value="<%=request.form("regions") %>"
> > > ID="Text3"/>
> > > <input name="PhaseIds" type=hidden value="<%=request.form("phaseids") %>"
> > > ID="Text4"/>
> > > <input name="CommStatus" type=hidden value="" ID="Text5"/>
> > > <input name="WIN" type=hidden value="" ID="Text6"/>
> > > <input name="WorkOrder" type=hidden value="" ID="Text7"/>
> > > <input name="County" type=hidden value="" ID="Text8"/>
> > > <input name="StateRoute" type=hidden value="" ID="Text9"/>
> > > <input name="CommitmentIds" type=hidden value=" <%=request.form("CommIds")
> > > %> " ID="Text10"/>
> > > <input name="SearchParameter" type=hidden value="" ID="Text11"/>
> > > <input name="CommitmentDescription" type=hidden value="" ID="Text12"/>
> > >
> > > <script>
> > > document.Form1.action= "<% response.write request.form("formaction") %>"; //
> > > form action which will be the url to the reporting server
> > >
> > > document.Form1.submit();
> > > </script>
> > >
> > > even after i used this method i still have parameter length limitation. is
> > > there any way to go around this problem?
> > >
> > > Thanks
> > > </form>
> >
> >|||the problem with this approach is that the url can only be 2040 character and
mine for sure will be more.
Thanks
"Josh" wrote:
> OK... this suggestion will only work with SSRS 2005, so I will also
> recommend an upgrade.
> One of the enhancements offered in SSRS 2005 is multi-valued
> parameters. With the introduction of this option, they also added a
> JOIN function that will convert a parameter array into a character
> delimited string. Sooo...
> You create a docID parm (probably string would be best) that is
> multi-value. Then, whatever you are using to call the report and pass
> that huge string can build the URL like this:
> http://serverName/ReportServer/Pages/ReportViewer.aspx?/Folder1/Folder2/ReportName&docID=abc1&docID=abc2&docID=abc3
> Create another parameter called docIDstring and mark it as hidden or
> internal. (If you want to be able to pass the string already formatted
> as CSV, use hidden so that you can pass it in the URL. If you are ONLY
> going to use the approach that I am suggesting, mark it as internal.)
> Set the default value of the internal/hidden parm to:
> =JOIN(Parameters!docID.Value,","). Multi-value parameters are treated
> as an array, and this JOIN function will convert the array to CSV.
> If you used this expression with the URL that is listed above,
> docIDstring would = "abc1,abc2,abc3".
> Sorry it only works with SSRS 2005, but you probably need to upgrade
> sometime anyway.
> Hope this helps!
> -Josh
>
> Robert wrote:
> > Josh
> >
> > user can choose different documents and then i send the documentid(s) to
> > report server and stored procedure on the back is going to do some processing
> > on it and then return it.
> >
> > so some times may this documentid have length of 3000 or more because these
> > documentids are commas seprated.
> > do you have any suggestion that may help me?
> > Thanks
> >
> > "Josh" wrote:
> >
> > >
> > > Robert,
> > >
> > > What kind of parameter are you passing that it has to be 3,000 chars?!
> > > Are you passing SQL into a report through a parameter?
> > >
> > > -Josh
> > >
> > >
> > > Robert wrote:
> > > > Hi,
> > > > I am using sql reporting services 2000, i am trying to pass a parameter with
> > > > the length of 3000 character and since the URL limitation is 2040 i used the
> > > > post method as follow
> > > >
> > > >
> > > > <FORM name=Form1 method="post" target="_self" >
> > > >
> > > >
> > > > <input name="rc:LinkTarget" value="_self" type="hidden" ID="Hidden1">
> > > > <input name="rs:Format" value="HTML4.0" type="hidden" ID="Hidden2">
> > > > <input name="rc:Toolbar" value="true" type="hidden" ID="Hidden3"/>
> > > > <input name="rs:ClearSession" value="true" type="hidden" ID="Hidden4"/>
> > > > <input name="rc:Parameters" value="Collapsed" type="hidden" ID="Hidden5"/>
> > > >
> > > >
> > > > <input name="PIN" type=hidden value="" ID=""/>
> > > > <input name="EnvIds" type=hidden value="<%=request.form("envids") %>"
> > > > ID="Text2"/>
> > > > <input name="RegionId" type=hidden value="<%=request.form("regions") %>"
> > > > ID="Text3"/>
> > > > <input name="PhaseIds" type=hidden value="<%=request.form("phaseids") %>"
> > > > ID="Text4"/>
> > > > <input name="CommStatus" type=hidden value="" ID="Text5"/>
> > > > <input name="WIN" type=hidden value="" ID="Text6"/>
> > > > <input name="WorkOrder" type=hidden value="" ID="Text7"/>
> > > > <input name="County" type=hidden value="" ID="Text8"/>
> > > > <input name="StateRoute" type=hidden value="" ID="Text9"/>
> > > > <input name="CommitmentIds" type=hidden value=" <%=request.form("CommIds")
> > > > %> " ID="Text10"/>
> > > > <input name="SearchParameter" type=hidden value="" ID="Text11"/>
> > > > <input name="CommitmentDescription" type=hidden value="" ID="Text12"/>
> > > >
> > > > <script>
> > > > document.Form1.action= "<% response.write request.form("formaction") %>"; //
> > > > form action which will be the url to the reporting server
> > > >
> > > > document.Form1.submit();
> > > > </script>
> > > >
> > > > even after i used this method i still have parameter length limitation. is
> > > > there any way to go around this problem?
> > > >
> > > > Thanks
> > > > </form>
> > >
> > >
>|||I see.
How many chars is each document ID?
-Josh
Robert wrote:
> the problem with this approach is that the url can only be 2040 character and
> mine for sure will be more.
> Thanks
>
> "Josh" wrote:
> >
> > OK... this suggestion will only work with SSRS 2005, so I will also
> > recommend an upgrade.
> >
> > One of the enhancements offered in SSRS 2005 is multi-valued
> > parameters. With the introduction of this option, they also added a
> > JOIN function that will convert a parameter array into a character
> > delimited string. Sooo...
> >
> > You create a docID parm (probably string would be best) that is
> > multi-value. Then, whatever you are using to call the report and pass
> > that huge string can build the URL like this:
> >
> > http://serverName/ReportServer/Pages/ReportViewer.aspx?/Folder1/Folder2/ReportName&docID=abc1&docID=abc2&docID=abc3
> >
> > Create another parameter called docIDstring and mark it as hidden or
> > internal. (If you want to be able to pass the string already formatted
> > as CSV, use hidden so that you can pass it in the URL. If you are ONLY
> > going to use the approach that I am suggesting, mark it as internal.)
> >
> > Set the default value of the internal/hidden parm to:
> > =JOIN(Parameters!docID.Value,","). Multi-value parameters are treated
> > as an array, and this JOIN function will convert the array to CSV.
> >
> > If you used this expression with the URL that is listed above,
> > docIDstring would = "abc1,abc2,abc3".
> >
> > Sorry it only works with SSRS 2005, but you probably need to upgrade
> > sometime anyway.
> >
> > Hope this helps!
> >
> > -Josh
> >
> >
> >
> > Robert wrote:
> > > Josh
> > >
> > > user can choose different documents and then i send the documentid(s) to
> > > report server and stored procedure on the back is going to do some processing
> > > on it and then return it.
> > >
> > > so some times may this documentid have length of 3000 or more because these
> > > documentids are commas seprated.
> > > do you have any suggestion that may help me?
> > > Thanks
> > >
> > > "Josh" wrote:
> > >
> > > >
> > > > Robert,
> > > >
> > > > What kind of parameter are you passing that it has to be 3,000 chars?!
> > > > Are you passing SQL into a report through a parameter?
> > > >
> > > > -Josh
> > > >
> > > >
> > > > Robert wrote:
> > > > > Hi,
> > > > > I am using sql reporting services 2000, i am trying to pass a parameter with
> > > > > the length of 3000 character and since the URL limitation is 2040 i used the
> > > > > post method as follow
> > > > >
> > > > >
> > > > > <FORM name=Form1 method="post" target="_self" >
> > > > >
> > > > >
> > > > > <input name="rc:LinkTarget" value="_self" type="hidden" ID="Hidden1">
> > > > > <input name="rs:Format" value="HTML4.0" type="hidden" ID="Hidden2">
> > > > > <input name="rc:Toolbar" value="true" type="hidden" ID="Hidden3"/>
> > > > > <input name="rs:ClearSession" value="true" type="hidden" ID="Hidden4"/>
> > > > > <input name="rc:Parameters" value="Collapsed" type="hidden" ID="Hidden5"/>
> > > > >
> > > > >
> > > > > <input name="PIN" type=hidden value="" ID=""/>
> > > > > <input name="EnvIds" type=hidden value="<%=request.form("envids") %>"
> > > > > ID="Text2"/>
> > > > > <input name="RegionId" type=hidden value="<%=request.form("regions") %>"
> > > > > ID="Text3"/>
> > > > > <input name="PhaseIds" type=hidden value="<%=request.form("phaseids") %>"
> > > > > ID="Text4"/>
> > > > > <input name="CommStatus" type=hidden value="" ID="Text5"/>
> > > > > <input name="WIN" type=hidden value="" ID="Text6"/>
> > > > > <input name="WorkOrder" type=hidden value="" ID="Text7"/>
> > > > > <input name="County" type=hidden value="" ID="Text8"/>
> > > > > <input name="StateRoute" type=hidden value="" ID="Text9"/>
> > > > > <input name="CommitmentIds" type=hidden value=" <%=request.form("CommIds")
> > > > > %> " ID="Text10"/>
> > > > > <input name="SearchParameter" type=hidden value="" ID="Text11"/>
> > > > > <input name="CommitmentDescription" type=hidden value="" ID="Text12"/>
> > > > >
> > > > > <script>
> > > > > document.Form1.action= "<% response.write request.form("formaction") %>"; //
> > > > > form action which will be the url to the reporting server
> > > > >
> > > > > document.Form1.submit();
> > > > > </script>
> > > > >
> > > > > even after i used this method i still have parameter length limitation. is
> > > > > there any way to go around this problem?
> > > > >
> > > > > Thanks
> > > > > </form>
> > > >
> > > >
> >
> >sql

Parameter in the Report Url to Print

Hi all!

Is there any parameter that we can pass in the report Url to directly print a report?

As we give Format=Excel for exporting the report to excel, is there any parameter to Print.

What are you trying to accomplish? That doesn't really make sense to me.

|||Hi!

I have a Print Button in my aspx page, which if clicked must print the report.

I will give the Report Url in the Click event of the button.

My Question is as we have a parameter in the report url to export to excel, is there any parameter to print a report, i.e The Print Dialog will open.

I hope i am clear now.

Parameter = "Select All"

Hi,

I am trying to pass an url to my report. In that url I want to pass my multivalue parameter with "Select All" as the parameter value. The probelm is, I don't know what value should I pass in the url which will be equal to selecting "select all" in the reporting services. I hope I am making my self clear, I case you have any doubts please ask me.

Thanks,

-Rohit

Thanks Robert I got your reply. Now I have an Idea what to do.

Pagination does not work after Table Visiblity false.? Help : Urgent ? Please

Hi,
You know I was trying to create new report and found that works fine with
Pagining- URL Access.
But I want to hide report when there is not data return. In that case my
pagining does not work.
For hiding my table when no data return i do following steps:-
Table -> Properties-> Visiblity Tag-> Expression ->
IIF(count(Fields!FormName.Value)=0,True,False)
Which hide my table when no data return, but paginition also does not work.
Please Help me. What shall i proceed with these things..
Waiting for Response.
Thanks
Labhesh S
Bangalore

In This.

1. I want to hide my details table which return data , when there is no data returned.

2. I want pagination should work when there is data. But is it not happening. ?

3. Pagination is not happening because i have written code in expression for Hiding the table when there is no data.

But i need Pagination also.

Please help..

Labhesh Shrimali

Bangalore

|||

HTML renderer and Preview (which are soft page break renderers) will ignore page breaks of conditionally hidden items and their children.

PrintPreview , Image and PDF renderers (which are physical page break renderers) will respect these page breaks.

If there is no data for the table, than we will render:

NoRowsMessage property if you defined one

or

table header and footer

What is the case for you? What are trying to achieve by hidden the table?

If you are in case 2 and you don't want the header and footer, you can set their visibility instead of the table.

Thank you,

Nico