Sunday, February 26, 2012
Hiding Tooltip text displayed when mouse is over a Crystal Report Field
which is displayed when mouse is over a
Crystal Report Field be it a parameter field
or database field in Crsytal Report with
VB.Net.
Thanks in adv.
RitamI am also facing the same problem is there any one available for help??|||I'm using CR 10. Under File -> Options -> Layout Tab there is a checkbox option for Tool tips both in design and preview. Hope that helps.|||You need to put a code in the tag fields... Sorry but thats the only way..
Put Chr(9) in every tag.
FredjeV|||Hi:
How can I put the tag fields with vb6 and crviewer?
Thanks
Hiding SOME parameters in the parameter toolbar
being displayed takes 2 parameters. One of these is programmatically set. I
would like the user to select values only for the other parameter. So when
displaying the report within the control, can I just show the second
parameter on the toolbar and hide the first one?
The Parameters toolbar property in the ReportViewer control corresponds to
the 'Parameters' URL access parameter, which hides/displays the entire
parameter toolbar
(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_urlaccess_959e.asp). Umm, is that bad news?OK I solved the problem...You just type in a blank string for the Prompt
value...
"Aparna" wrote:
> I am using the ReportViewer.dll in a ASP.NET web application. The report
> being displayed takes 2 parameters. One of these is programmatically set. I
> would like the user to select values only for the other parameter. So when
> displaying the report within the control, can I just show the second
> parameter on the toolbar and hide the first one?
> The Parameters toolbar property in the ReportViewer control corresponds to
> the 'Parameters' URL access parameter, which hides/displays the entire
> parameter toolbar
> (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_urlaccess_959e.asp). Umm, is that bad news?|||On Wed, 26 Jan 2005 12:21:03 -0800, Aparna
<Aparna@.discussions.microsoft.com> wrote:
>OK I solved the problem...You just type in a blank string for the Prompt
>value...
>
How exactly does one "type in" a blank string? :)))
>"Aparna" wrote:
>> I am using the ReportViewer.dll in a ASP.NET web application. The report
>> being displayed takes 2 parameters. One of these is programmatically set. I
>> would like the user to select values only for the other parameter. So when
>> displaying the report within the control, can I just show the second
>> parameter on the toolbar and hide the first one?
>> The Parameters toolbar property in the ReportViewer control corresponds to
>> the 'Parameters' URL access parameter, which hides/displays the entire
>> parameter toolbar
>> (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_urlaccess_959e.asp). Umm, is that bad news?|||haha...Not quite sure...However, it turns out my excitement was in vain...If
the prompt value is not specified, then the paratmeter becomes Read-only..So,
if you programatically want to assign values to it, you are out of luck! The
only way to set the value of that parameter is via the parameter property
page. So my orginal problem still stands...SOMEBODY HELLLP...
"Usenet User" wrote:
> On Wed, 26 Jan 2005 12:21:03 -0800, Aparna
> <Aparna@.discussions.microsoft.com> wrote:
> >OK I solved the problem...You just type in a blank string for the Prompt
> >value...
> >
> How exactly does one "type in" a blank string? :)))
>
> >"Aparna" wrote:
> >
> >> I am using the ReportViewer.dll in a ASP.NET web application. The report
> >> being displayed takes 2 parameters. One of these is programmatically set. I
> >> would like the user to select values only for the other parameter. So when
> >> displaying the report within the control, can I just show the second
> >> parameter on the toolbar and hide the first one?
> >>
> >> The Parameters toolbar property in the ReportViewer control corresponds to
> >> the 'Parameters' URL access parameter, which hides/displays the entire
> >> parameter toolbar
> >> (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_urlaccess_959e.asp). Umm, is that bad news?
>
Friday, February 24, 2012
Hiding Parameters in Report
We have installed SP1 on the server so I thought this issue had been fixed.
TIA for any help.
Dave
--
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.If you don't want any parameters displayed to the user, add
rc:Parameters=false to the URL.
If you want only some of the parameters displayed, then for those that
should be hidden, make sure "Prompt User" is checked and the prompt string
is empty.
--
This posting is provided "AS IS" with no warranties, and confers no rights
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:OA03nKUXEHA.2520@.TK2MSFTNGP12.phx.gbl...
> I'm using a URL to execute reports and I wish to have the parameters not
displayed to the user. However, when I either uncheck the Promt User box or
delete the prompt string, I get an error stating read only parameters can
not be changed.
> We have installed SP1 on the server so I thought this issue had been
fixed.
> TIA for any help.
> Dave
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.
Hiding Parameters
the parameter of the displayed report.
how can i hide the parameter list.
I am familiar with rc:ToolBar = false while invoking the report how can i
disable parameter from being changed
thxtry setting the parameter(s) to be "Hidden" in the report properties applet
"nkg" wrote:
> I have a popup window which shows the report. I don't want user to modify
> the parameter of the displayed report.
> how can i hide the parameter list.
> I am familiar with rc:ToolBar = false while invoking the report how can i
> disable parameter from being changed
> thx
>
>|||thx
"Carl Henthorn" <CarlHenthorn@.discussions.microsoft.com> wrote in message
news:41752B0A-DB95-4B08-A3E3-04F51EA97686@.microsoft.com...
> try setting the parameter(s) to be "Hidden" in the report properties
> applet
> "nkg" wrote:
>> I have a popup window which shows the report. I don't want user to modify
>> the parameter of the displayed report.
>> how can i hide the parameter list.
>> I am familiar with rc:ToolBar = false while invoking the report how can i
>> disable parameter from being changed
>> thx
>>
Hiding Missing Information
I'm designing a report, where an address will be displayed. There's also line for a P.O. Box, but most of the addresses don't have one, so this line is empty most of the time.
Like:
Name
Street
POBox
City
Phone
If there's no POBox it looks like:
Name
Street
City
Phone
Is there any tqchnique, so that I can get rid of this blank line? And it would look like:
Name
Street
City
Phone
As far as I know, there are no report items, that can hande such a problem. Probably dynamically generating the XML would work, but that's a effort, I want to avoid.
I was just enquiring if you managed to resolve this issue?
hiding link condtionally
i have a matrix report (rows&cols)and both are grouped
and the subtotal is displayed at the end of the
matrix,the problem is that i am making a jump link for
each data cell of the matrix and i dont want any links
for the totals cells(the ones on the edges of the matrix)
is there any expression to do this(hide links when the
cell is at totals(Hor,Ver)),please advize.Assuming the matrix column group has the name "ColumnGroup" and the matrix
row group has the name "RowGroup", you would use an expression like this on
the cell's hyperlink:
=iif(InScope("ColumnGroup") AND InScope("RowGroup"), "http:// some link",
Nothing)
A subtotal is not calculated in the scope of it's grouping, therefore
InScope will return false for subtotal cells for a certain grouping.
More information on the InScope function is available in BOL:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_expressions_v1_0jmt.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"teko" <anonymous@.discussions.microsoft.com> wrote in message
news:0abc01c498cf$589e5440$a301280a@.phx.gbl...
> hi all
> i have a matrix report (rows&cols)and both are grouped
> and the subtotal is displayed at the end of the
> matrix,the problem is that i am making a jump link for
> each data cell of the matrix and i dont want any links
> for the totals cells(the ones on the edges of the matrix)
> is there any expression to do this(hide links when the
> cell is at totals(Hor,Ver)),please advize.
>|||>--Original Message--
>Assuming the matrix column group has the
name "ColumnGroup" and the matrix
>row group has the name "RowGroup", you would use an
expression like this on
>the cell's hyperlink:
>=iif(InScope("ColumnGroup") AND InScope
("RowGroup"), "http:// some link",
>Nothing)
>A subtotal is not calculated in the scope of it's
grouping, therefore
>InScope will return false for subtotal cells for a
certain grouping.
>More information on the InScope function is available in
BOL:
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-
us/rscreate/htm/rcr_creating_expressions_v1_0jmt.asp
>--
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>
>"teko" <anonymous@.discussions.microsoft.com> wrote in
message
>news:0abc01c498cf$589e5440$a301280a@.phx.gbl...
>> hi all
>> i have a matrix report (rows&cols)and both are grouped
>> and the subtotal is displayed at the end of the
>> matrix,the problem is that i am making a jump link for
>> each data cell of the matrix and i dont want any links
>> for the totals cells(the ones on the edges of the
matrix)
>> is there any expression to do this(hide links when the
>> cell is at totals(Hor,Ver)),please advize.
>
>.
>many thanks..it works
Sunday, February 19, 2012
Hiding a subreport SSRS
Hi,
I'm a newbie inSSRS, kindly help!!
i have a subreport and it needs to be displayed only based on some selection criteria, in all other case it needs to be hidden.i made the visibility to hidden, but when i run the report,it gives me a blank page where it usually gets me the subreport.How can i remove this blank page from getting displayed ?
PS: this is the expression i have added :
=IIF(Parameters!strChoice.Value="Single",True,False)
Thanks in advance for any help..
Hello,
Is the subreport part of a table?
If it's in a table row, then you will need to set the visibility on the row itself, not the subreport.
Jarret
|||Thanx Jarret
I tried toggling the visibility of the row having the subreport.
i gave the same expression as well,but i'm still getting the blank page.
Thanx for any help.