report parameters

Is it possible to set the properties of report parameters? I want to
show/hide parameters at run-time.
--
asharmaOn Apr 12, 4:10 am, asharma2004 <asha...@.harbingertechaxes.com> wrote:
> Is it possible to set the properties of report parameters? I want to
> show/hide parameters at run-time.
> --
> asharma
As far as I know, it is not. That said, you can allow for a default
blank value as part of your dataset that is sourcing your report
parameter. Also, if calling the report/RDL from w/i an ASP.NET or
WinForms application, you can have non-report drop-downs available to
the users and just pass hidden parameter values to the report based on
them. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Report parameter dropdown

I bound a report parameter to a combobox. I tried to configure default
parameter as null several ways
in report parameters properties dialog but could not.
How can i specify default value of null for a combobox parameter? thxOn Apr 17, 2:09 pm, "nkg" <x...@.yahoo.com> wrote:
> I bound a report parameter to a combobox. I tried to configure default
> parameter as null several ways
> in report parameters properties dialog but could not.
> How can i specify default value of null for a combobox parameter? thx
If the default value of null does not work in the Report Parameters
dialog, I would suggest unioning your dataset against an empty/null
record and then use a default of the dataset and make sure that the
empty/null value is listed first. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||thx!
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1176856481.241478.187380@.b58g2000hsg.googlegroups.com...
> On Apr 17, 2:09 pm, "nkg" <x...@.yahoo.com> wrote:
>> I bound a report parameter to a combobox. I tried to configure default
>> parameter as null several ways
>> in report parameters properties dialog but could not.
>> How can i specify default value of null for a combobox parameter? thx
>
> If the default value of null does not work in the Report Parameters
> dialog, I would suggest unioning your dataset against an empty/null
> record and then use a default of the dataset and make sure that the
> empty/null value is listed first. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Apr 18, 1:51 pm, "nkg" <x...@.yahoo.com> wrote:
> thx!"EMartinez" <emartinez...@.gmail.com> wrote in message
> news:1176856481.241478.187380@.b58g2000hsg.googlegroups.com...
> > On Apr 17, 2:09 pm, "nkg" <x...@.yahoo.com> wrote:
> >> I bound a report parameter to a combobox. I tried to configure default
> >> parameter as null several ways
> >> in report parameters properties dialog but could not.
> >> How can i specify default value of null for a combobox parameter? thx
> > If the default value of null does not work in the Report Parameters
> > dialog, I would suggest unioning your dataset against an empty/null
> > record and then use a default of the dataset and make sure that the
> > empty/null value is listed first. Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
You're welcome. Let me know if I can be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||"EMartinez" wrote:
> On Apr 18, 1:51 pm, "nkg" <x...@.yahoo.com> wrote:
> > thx!"EMartinez" <emartinez...@.gmail.com> wrote in message
> >
> > news:1176856481.241478.187380@.b58g2000hsg.googlegroups.com...
> >
> > > On Apr 17, 2:09 pm, "nkg" <x...@.yahoo.com> wrote:
> > >> I bound a report parameter to a combobox. I tried to configure default
> > >> parameter as null several ways
> > >> in report parameters properties dialog but could not.
> >
> > >> How can i specify default value of null for a combobox parameter? thx
> >
> > > If the default value of null does not work in the Report Parameters
> > > dialog, I would suggest unioning your dataset against an empty/null
> > > record and then use a default of the dataset and make sure that the
> > > empty/null value is listed first. Hope this helps.
> >
> > > Regards,
> >
> > > Enrique Martinez
> > > Sr. Software Consultant
>
> You're welcome. Let me know if I can be of further assistance.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>
Instead of modifying my datasource, I chose to change the parameter. A small
function injects the null value into the selected list before filtering my
data.
here's how :
http://pderop.blogspot.com/2007/05/ssrs-multivalue-and-nulls.html
cheers

Report Parameter Defaults not being used in deployed reports

When I set the default properties under Report Parameters in some
reports, it works perfectly, in other reports, the parameters specified
in Visual Studio under Report Parameters seem to have no effect when
the report is deployed to the ReportServer. The toolbar for the
parameters displays, and that is OK, but the default values don't
appear in the toolbar like they do in the other reports, and the report
doesn't run until the parameters are selected with the dropdowns. What
is causing the parameters to behave differently from one report to the
other?I have found that although you may change 'defaults' in the Report Designer,
they sometimes do not seem to take when I 'deploy' the modified report. I
don't understand why, bu my solution thus far has been to delete the report
off the report server and then redeploy it. The new/modified default values
appear.
"Kelly Gross" wrote:
> When I set the default properties under Report Parameters in some
> reports, it works perfectly, in other reports, the parameters specified
> in Visual Studio under Report Parameters seem to have no effect when
> the report is deployed to the ReportServer. The toolbar for the
> parameters displays, and that is OK, but the default values don't
> appear in the toolbar like they do in the other reports, and the report
> doesn't run until the parameters are selected with the dropdowns. What
> is causing the parameters to behave differently from one report to the
> other?
>|||Make sure your default value is your available value, otherwise it is
not working.
Kelly Gross wrote:
> When I set the default properties under Report Parameters in some
> reports, it works perfectly, in other reports, the parameters
specified
> in Visual Studio under Report Parameters seem to have no effect when
> the report is deployed to the ReportServer. The toolbar for the
> parameters displays, and that is OK, but the default values don't
> appear in the toolbar like they do in the other reports, and the
report
> doesn't run until the parameters are selected with the dropdowns.
What
> is causing the parameters to behave differently from one report to
the
> other?

Report Navigation and jump url

Hi all,

I have got a report with external hyperlink.

When I put this link in TextBox properties >> Navigation >> Jump URL of my gridView : http://www.micheldegremont.com it works.

However, if I put "http://www.micheldegremont.com?id=" + Fields!ID.Value it doesn't work. I haven't not link in my report.

And if I put http://www.micheldegremont.com?id=Fields!ID.Value my report create a hyperlink to http://www.micheldegremont.com?id=Fields!ID.Value and no http://www.micheldegremont.com?id=1

Thanks for you help.

Degremont wrote:

However, if I put "http://www.micheldegremont.com?id=" + Fields!ID.Value it doesn't work. I haven't not link in my report.

Instead use "http://www.micheldegremont.com?id=" & Fields!ID.Value

HTH|||

Now it works with ="http://www.micheldegremont.com?id=" & Fields!ID.Value but only on 1 report.

Howerver, I have the same XML

Report 1 (it's work)

<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="AddressID">
<rd:DefaultName>AddressID</rd:DefaultName>
<ZIndex>1</ZIndex>
<Action>
<Hyperlink>="http://www.micheldegremont.com?id=" &amp; Fields!ID.Value</Hyperlink>
</Action>
<CanGrow>true</CanGrow>
<Value>=Fields!AddressID.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>

But on report 2 , it doesn't work

<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="noteFraisID">
<rd:DefaultName>noteFraisID</rd:DefaultName>
<ZIndex>7</ZIndex>
<Action>
<Hyperlink>="http://www.micheldegremont.com?id=" &amp; Fields!ID.Value</Hyperlink>
</Action>
<CanGrow>true</CanGrow>
<Value>=Fields!noteFraisID.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
....

sql

Report Layout... TextBox Issue

I have two TextBoxes, they are next to each other and they touch.
According to their properties they are the same height, they are also the
same distance from the top.
Preview: they line up perfectly
After Deployment: one appears as though it is a slightly different height
Export To PDF: suddenly they're the same again
Why is this happening and how can I fix it?There are various properties on the text box you can set to specify where
it is located. If they have the same properties, that means they actually
want to be located in the same space. But the HTML viewer will position
them differently because it does not support overlay.
<Height></Height>
<Width></Width>
<Top></Top>
<Left></Left>
--
| Thread-Topic: Report Layout... TextBox Issue
| thread-index: AcS6nZhfn6F0qzGsTYehI9XjssWUhg==| X-WBNR-Posting-Host: 64.86.141.134
| From: "=?Utf-8?B?TUVSNzg=?=" <MER78@.discussions.microsoft.com>
| Subject: Report Layout... TextBox Issue
| Date: Mon, 25 Oct 2004 07:19:10 -0700
| Lines: 10
| Message-ID: <4592BB8A-993A-4A7A-98F1-2690E2E5658E@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:33048
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I have two TextBoxes, they are next to each other and they touch.
|
| According to their properties they are the same height, they are also the
| same distance from the top.
|
| Preview: they line up perfectly
| After Deployment: one appears as though it is a slightly different height
| Export To PDF: suddenly they're the same again
|
| Why is this happening and how can I fix it?
||||I think I mis-worded my question... I've had endless problems with text boxes
that touch... at least according to their properties they don't overlap... it
looks ok in one format... in another boxes get pushed onto other lines etc...
especially in excel...
I've started using a table for text boxes that touch whenever I can...
though it took me awhile to notice that you can use a table without having it
connected to a data source... if you put all of your stuff in header rows.
""Brad Syputa - MS"" wrote:
> There are various properties on the text box you can set to specify where
> it is located. If they have the same properties, that means they actually
> want to be located in the same space. But the HTML viewer will position
> them differently because it does not support overlay.
> <Height></Height>
> <Width></Width>
> <Top></Top>
> <Left></Left>