Hide Parameters passed to drillthrough report

hi,
Is it possible to hide parameters passed to drillthrough report?
If yes, How?
regards,
SAchin.yes using rc:parameters=false, when you click on the link the parametes wont
be visible but one small problem (rather big:-) is that it will be visible on
the "address box" in the IE. so if some one goes and removes it then the
parameters will be visile.
Amarnath
"sachin laddha" wrote:
> hi,
> Is it possible to hide parameters passed to drillthrough report?
> If yes, How?
> regards,
> SAchin.
>|||Hi,
Where to set rc:parameters=false so that it appears by defualt in the
report URL?
Can I set it while designing the drillthrough report ?
I am using RS's report manger to view and manager reports.
regards,
Sachin.
Amarnath wrote:
> yes using rc:parameters=false, when you click on the link the parametes wont
> be visible but one small problem (rather big:-) is that it will be visible on
> the "address box" in the IE. so if some one goes and removes it then the
> parameters will be visile.
> Amarnath
> "sachin laddha" wrote:
> > hi,
> >
> > Is it possible to hide parameters passed to drillthrough report?
> > If yes, How?
> >
> > regards,
> > SAchin.
> >
> >|||When you jump to report the parameters section of the report you are jumping
to is not shown. Are you seeing different behavior than this?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"sachin laddha" <sachinladdha@.gmail.com> wrote in message
news:1146816702.039630.18710@.e56g2000cwe.googlegroups.com...
> Hi,
> Where to set rc:parameters=false so that it appears by defualt in the
> report URL?
> Can I set it while designing the drillthrough report ?
> I am using RS's report manger to view and manager reports.
> regards,
> Sachin.
>
> Amarnath wrote:
>> yes using rc:parameters=false, when you click on the link the parametes
>> wont
>> be visible but one small problem (rather big:-) is that it will be
>> visible on
>> the "address box" in the IE. so if some one goes and removes it then the
>> parameters will be visile.
>> Amarnath
>> "sachin laddha" wrote:
>> > hi,
>> >
>> > Is it possible to hide parameters passed to drillthrough report?
>> > If yes, How?
>> >
>> > regards,
>> > SAchin.
>> >
>> >
>|||Sorry; I meant for "Jump to URL". A small confusion,
You dont want the parameter section? or the parameters which are passed
through the URL?. Because I meant when you use in the URL
rc:parameters=false the parameter section will not be visible. So let me know
which one you are looking out for.
Amarnath
"sachin laddha" wrote:
> Hi,
> Where to set rc:parameters=false so that it appears by defualt in the
> report URL?
> Can I set it while designing the drillthrough report ?
> I am using RS's report manger to view and manager reports.
> regards,
> Sachin.
>
> Amarnath wrote:
> > yes using rc:parameters=false, when you click on the link the parametes wont
> > be visible but one small problem (rather big:-) is that it will be visible on
> > the "address box" in the IE. so if some one goes and removes it then the
> > parameters will be visile.
> >
> > Amarnath
> >
> > "sachin laddha" wrote:
> >
> > > hi,
> > >
> > > Is it possible to hide parameters passed to drillthrough report?
> > > If yes, How?
> > >
> > > regards,
> > > SAchin.
> > >
> > >
>|||I am using 'Jump to report' option and not 'jump to url' for
navigation.|||Hi Bruce,
Yes, i m seeing the paramters section of the report I am jumping to.
I have set the report to jump and the parameters it take.
Please note that I am seeing the report in VS preview pane and the
reports are not yet deployed on the report server
Please help me out.
regards,
Sachin.|||Problem solved. You are seeing a difference between the development
environment and deployed reports. Jump to Reports with deployed reports does
not show the parameters BUT the user can unhide them. To not have the option
at all to see the parameters you can make the parameters hidden OR you can
use Jump to URL and control the parameter section not to show.
Books Online: hiding parameters
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"sachin laddha" <sachinladdha@.gmail.com> wrote in message
news:1147070062.912289.317660@.u72g2000cwu.googlegroups.com...
> Hi Bruce,
> Yes, i m seeing the paramters section of the report I am jumping to.
> I have set the report to jump and the parameters it take.
> Please note that I am seeing the report in VS preview pane and the
> reports are not yet deployed on the report server
> Please help me out.
> regards,
> Sachin.
>

hide parameter field

Is it possible to hide or disable some fileds of parameters on report?
Thanks.You could always call the report from a URL and NOT show the parameter
bar... and in SP1 you may hide individual parameters.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
<AG>; "NLB d.d." <AGNLBdd@.discussions.microsoft.com> wrote in message
news:E55FF6A7-3BDD-411B-87FB-AE4EF548E053@.microsoft.com...
> Is it possible to hide or disable some fileds of parameters on report?
> Thanks.
>|||Hi AG:
Make sure you have SP1 for reporting services:
http://www.microsoft.com/downloads/details.aspx?familyid=580febf7-2972-40e7-bccf-6cd90ac2f464&displaylang=en
From the SP1 readme:
"Previously, the only way to hide a parameter value was to clear the
Prompt User check box in the Parameters properties page. However, a
side effect of clearing the check box was that you could no longer
specify a parameter value for the report at run time. This limitation
has been removed. In SP1, you can clear the Prompt User check box to
hide the parameter fields and values in the report. Doing so does not
introduce restrictions on how you subsequently set the parameter value
externally at run time."
HTH,
--
Scott
http://www.OdeToCode.com
On Mon, 2 Aug 2004 02:15:03 -0700, AG, NLB d.d.
<AGNLBdd@.discussions.microsoft.com> wrote:
>Is it possible to hide or disable some fileds of parameters on report?
>Thanks.
>

Hide only export dropdown list and "Export" link button from report toolbar in sql rep

Hi All

I want to hide export dropdown list and "Export" link button from reportviewer toolbar . because i create my own export function so ,

Please help me in this

Thanks

Alpesh

I think that this url can be helpuff:

http://blogs.msdn.com/bimusings/archive/2005/07/08/436887.aspx

Hide only export dropdown list and "Export" link button from report toolbar in sql

Hi All

I want to hide export dropdown list and "Export" link button from reportviewer toolbar . because i create my own export function so ,

Please help me in this

Thanks

Alpesh

I think that this url can be helpuff:

http://blogs.msdn.com/bimusings/archive/2005/07/08/436887.aspx

sql

Hide one Table section and change location of 2 table

I have two table sections in my report. I make one table section invisible if
i dont have data for the section. I want to change the location of below
table section which has data to the location of first table section. How to
do it?
Thanks in Advance,
Parimal.If I am not mistaken, we put each item in a rectangle and hide the
rectangle... It removes most of the space, but not all(if I remember
correctly.)
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Parimal" <Parimal@.discussions.microsoft.com> wrote in message
news:EB291698-744F-45B5-A7BF-BAC12F16B19F@.microsoft.com...
>I have two table sections in my report. I make one table section invisible
>if
> i dont have data for the section. I want to change the location of below
> table section which has data to the location of first table section. How
> to
> do it?
> Thanks in Advance,
> Parimal.

hide my report toolbar

Hi.

i would like to configure my reports to hide the Toolbar. I'm not using any aspx page to contain my report, I'm just opening it from the server with IE.

is there a way to configure the report thet he does't have any tool bar?

Thanks,

Roy.

Look in the BOL for ULR parametrization, the rc:Toolbar=no should do the job.

HTH, Jens SUessmeyer.

http://www.sqlserver2005.de
|||

Thanks :)

i don't know what is "BOL for ULR ".

but the code was good (i used rc:toolbar=false).

thanks!

|||Just to add, BOL means Books Online which is actually the help of SQL Server. look for the URL access there.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Hide my parameter

Hi,
When i run my report i don't want to see the parameters that i have given it.
How can i hide the parameters?
Greetings,
Mike KlaarhamerIf you are passing the parameters via URL then go to Report Manger and select
the parameters options under properties for that particular report. now, for
the parameter that you wish to hide, check the Prompt User to yes, and empty
the Prompt string.
Cheers
Priya
"Mike Klaarhamer" wrote:
> Hi,
> When i run my report i don't want to see the parameters that i have given it.
> How can i hide the parameters?
> Greetings,
> Mike Klaarhamer

hide in list view when deploying

Is it possbile to set an attribute to hide the report in the list view when it is intially deployed?

Are you asking if this can be done through the VS Report Project? This is not supported.

You can do this through the SOAP API or Report Manager after the report is deployed.

-- Robert

|||What you could do is create a folder for "staging" or "deploying" and set it to not be visible in list view, always deploy to that folder and then move the report to a visible folder once you are ready to.

Hide in list view

Within Report Manager you can check the 'Hide in list view' box for any
report within a folder, but then that report can still be viewed within that
folder if you select the 'Show Details' button on the folder header. I
expected the Show Details button not to be available for report users, but it
is. Is there another way of hiding a report within a folder?DKN,
You can modify the role assignments to prevent a user from navigating
the folder hierarchy.
Andy Potter

Hide Header and Footer when no data returned on report

Any suggestions on how to hide the header and footer information if there isn't any data returned on the report?

Hi Kimberly,

There may be a better suggestion, but this is what I came up with.

Place a textbox in the body of the report. Set the visibility of this textbox to hidden = true. Set the value of this textbox to the expression = countrows("datasetname"). For each item in the header and footer you would like to hide, add the following expression to the visibility - hidden property: =iif(reportitems!textbox.Value = "0",true,false).

This should hide all items when there are no records in the dataset.

Good luck,

Simone

|||You can use an expression to determine visibility. For example.

=IIF(Countrows("Scope") = 0, True, False)

HTH...

Joe|||This would generate an error when placed in the header or the footer. CountRows cannot be used in page headers or footers.|||Agreed. I didn't read the original posting as page header/footer. Perhaps I misunderstood.|||I may have misunderstood as well. I made the assumption that it was referencing the page header/footer. If this is not the case, then Joe's explanation is the way to go.|||Thank you Simone and Joe. I appreciate all of your help. Adding the text box and then referencing it to determine the visibility sounds like it should do the trick.

Hide Header and Footer when no data returned on report

Any suggestions on how to hide the header and footer information if there isn't any data returned on the report?

Hi Kimberly,

There may be a better suggestion, but this is what I came up with.

Place a textbox in the body of the report. Set the visibility of this textbox to hidden = true. Set the value of this textbox to the expression = countrows("datasetname"). For each item in the header and footer you would like to hide, add the following expression to the visibility - hidden property: =iif(reportitems!textbox.Value = "0",true,false).

This should hide all items when there are no records in the dataset.

Good luck,

Simone

|||You can use an expression to determine visibility. For example.

=IIF(Countrows("Scope") = 0, True, False)

HTH...

Joe|||This would generate an error when placed in the header or the footer. CountRows cannot be used in page headers or footers.|||Agreed. I didn't read the original posting as page header/footer. Perhaps I misunderstood.|||I may have misunderstood as well. I made the assumption that it was referencing the page header/footer. If this is not the case, then Joe's explanation is the way to go.|||Thank you Simone and Joe. I appreciate all of your help. Adding the text box and then referencing it to determine the visibility sounds like it should do the trick.

Hide folder in Report Manager

Hi All,

How to hide a folder in Report Manager? For Example, I don't want to show the DataSource Folder in the Report Manager.

TIA

Hi TIA,

You can hide the datasource folder by going to properties(general tab) of the folder and check "Hide in list view".

- Kranthi

|||

Thank you Kranthi,

But I still can see that folder, is that because I am an Administrator?

Hide Find/Next, View report and some export formats in report view

Hi,
1. As Chris G asked 9/7/2006 it is not possible to change text on "view
report" and "Find/Next", but is it possible to hide those fields (or at least
find/next) for all users. (this a language issue, better for us to hide
fields than show them in english).
2. Is it possible to hide som export formats to alla users, we only use PDF
and excel, and also change text "Select a format" ?
/JeromeYou only need to change in one place, rsreportserver.config (Save a copy of
the file before making any changes). Reboot after the change. The below
shows commenting out the existing CSV export.
<!--
<Extension Name="CSV"
Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/>
-->
The above shows how you comment out a section. If you do the above then CSV
would not be available. However, you might want to leave CSV in. Sometimes
for a large amout of data CSV is faster than Excel. If you comment out like
above and put this in:
<Extension Name="CSV"
Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
<Configuration>
<DeviceInfo>
<Encoding>ASCII</Encoding>
</DeviceInfo>
</Configuration>
</Extension>
It will change CSV export so it uses ASCII instead of Unicode. This allows
Excel to automatically open up properly for the CSV. With Unicode it all
gets put into one column and then you have to split the data.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"/jerome k" <jeromek@.discussions.microsoft.com> wrote in message
news:C1F26C7C-C276-4CD7-B9FD-D7D8B134DC80@.microsoft.com...
> Hi,
> 1. As Chris G asked 9/7/2006 it is not possible to change text on "view
> report" and "Find/Next", but is it possible to hide those fields (or at
> least
> find/next) for all users. (this a language issue, better for us to hide
> fields than show them in english).
> 2. Is it possible to hide som export formats to alla users, we only use
> PDF
> and excel, and also change text "Select a format" ?
> /Jerome|||Great, thank you...
Any ideas how to hide (or translate) the "View Report"-button,
"Find/Next"-fields and "Select a format"-text ? The Refresh icon or the
"Enter"-key is enough for refreshing, and Find/Next is a standard feature in
the browser menue.
/J
"Bruce L-C [MVP]" wrote:
> You only need to change in one place, rsreportserver.config (Save a copy of
> the file before making any changes). Reboot after the change. The below
> shows commenting out the existing CSV export.
> <!--
> <Extension Name="CSV"
> Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/>
> -->
> The above shows how you comment out a section. If you do the above then CSV
> would not be available. However, you might want to leave CSV in. Sometimes
> for a large amout of data CSV is faster than Excel. If you comment out like
> above and put this in:
> <Extension Name="CSV"
> Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
> <Configuration>
> <DeviceInfo>
> <Encoding>ASCII</Encoding>
> </DeviceInfo>
> </Configuration>
> </Extension>
> It will change CSV export so it uses ASCII instead of Unicode. This allows
> Excel to automatically open up properly for the CSV. With Unicode it all
> gets put into one column and then you have to split the data.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "/jerome k" <jeromek@.discussions.microsoft.com> wrote in message
> news:C1F26C7C-C276-4CD7-B9FD-D7D8B134DC80@.microsoft.com...
> > Hi,
> >
> > 1. As Chris G asked 9/7/2006 it is not possible to change text on "view
> > report" and "Find/Next", but is it possible to hide those fields (or at
> > least
> > find/next) for all users. (this a language issue, better for us to hide
> > fields than show them in english).
> > 2. Is it possible to hide som export formats to alla users, we only use
> > PDF
> > and excel, and also change text "Select a format" ?
> >
> > /Jerome
>
>|||Sorry, no.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"/jerome k" <jeromek@.discussions.microsoft.com> wrote in message
news:83377ADE-3AF9-4614-AB2D-9D9CDF9B747F@.microsoft.com...
> Great, thank you...
> Any ideas how to hide (or translate) the "View Report"-button,
> "Find/Next"-fields and "Select a format"-text ? The Refresh icon or the
> "Enter"-key is enough for refreshing, and Find/Next is a standard feature
> in
> the browser menue.
> /J
> "Bruce L-C [MVP]" wrote:
>> You only need to change in one place, rsreportserver.config (Save a copy
>> of
>> the file before making any changes). Reboot after the change. The below
>> shows commenting out the existing CSV export.
>> <!--
>> <Extension Name="CSV"
>> Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/>
>> -->
>> The above shows how you comment out a section. If you do the above then
>> CSV
>> would not be available. However, you might want to leave CSV in.
>> Sometimes
>> for a large amout of data CSV is faster than Excel. If you comment out
>> like
>> above and put this in:
>> <Extension Name="CSV"
>> Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
>> <Configuration>
>> <DeviceInfo>
>> <Encoding>ASCII</Encoding>
>> </DeviceInfo>
>> </Configuration>
>> </Extension>
>> It will change CSV export so it uses ASCII instead of Unicode. This
>> allows
>> Excel to automatically open up properly for the CSV. With Unicode it all
>> gets put into one column and then you have to split the data.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "/jerome k" <jeromek@.discussions.microsoft.com> wrote in message
>> news:C1F26C7C-C276-4CD7-B9FD-D7D8B134DC80@.microsoft.com...
>> > Hi,
>> >
>> > 1. As Chris G asked 9/7/2006 it is not possible to change text on
>> > "view
>> > report" and "Find/Next", but is it possible to hide those fields (or at
>> > least
>> > find/next) for all users. (this a language issue, better for us to hide
>> > fields than show them in english).
>> > 2. Is it possible to hide som export formats to alla users, we only use
>> > PDF
>> > and excel, and also change text "Select a format" ?
>> >
>> > /Jerome
>>

Hide fields with blank value

I am creataing a report with a Local Mode report and ReportViewer. Part of the report has an address:

[FName] [LName]
[Address1]
[Address2]
[City] [State] [ZIP]
[Phone]

So the data might come out on the report:

John Doe
123 Fake Street
Suite 32
Somewhere USA 00101
(800) 555-1212

Which is great, except if address2 is blank (as in most cases it is) it comes out:

John Doe
123 Fake Street

Somewhere USA 00101
(800) 555-1212

How can I make it Hide the [Address2] Field if it is blank, so that extrat line space is taken out?

Thanks

UPDATE** - As soon as i posted this site i realized when you use the expression for this, it should be =Field(Value) = "". I had =Field(Value) <> "". I was backwards. Sorry for the uncecessary post.

In the visibility property of textbox give the expression as

IIF(Len(Fields.Address2.value)>0,True,False)

Thanks

Subbu

Hide empty tables

Hi,

I've just creates a report with about 20 Tables. To my suprise, it almost runs as intended ;-)
But there is one flaw - Is there any way of hiding an empyt table?
I want to hide all tables that are not filled with data. But wich one is empty differs from the entered parameter.

So long
Sven
(Germany)YOu could set the NoRows property to an empty string, this would hide the tables and the header.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||Well, I think i figured it out myself. But nonetheless. Thanks

##############################

Hey,
thanks for the fast answer.
But I'm quiet a noob regarding ReportingServices. How do I have to use "NoRows" ?
Is that a VB Code and if so, how do i use it ?

Mfg
Sven

Hide empty rows on drill down report

Is there any way to hide the expand button (the plus sign) for rows that have
no containing rows on a drill-down report? What is happening now is that the
plus signs are populated for all rows and only a small subset of them
actually have data in the to drill into.Jason,
You can go into the toggle item's Properties and under the Visibility
Tab, set the "Initial appearance of the toggle image for this report
item:" to Expression and use a variation of the following:
=IIf(Fields!Determing_Factor.Value = "Determining_Value",true,false)
for example:
=IIf(Fields!Item_Name.Value = "",true,false)
This makes it so that if my next rows Item_Name field is blank, the
toggle will be automatically set the the - symbol so that the user
knows there is nothing past this point.
Hope that helps. If I didn't make myself understandable, let me know
and I can try again.|||That's pretty good. Is there any way to make it so that the "-" symbol cannot
be expanded? It looks weird to have a "-" symbol change to a "+" symbol and
then expand with an empty line under it.
"Mal" wrote:
> Jason,
> You can go into the toggle item's Properties and under the Visibility
> Tab, set the "Initial appearance of the toggle image for this report
> item:" to Expression and use a variation of the following:
> =IIf(Fields!Determing_Factor.Value = "Determining_Value",true,false)
> for example:
> =IIf(Fields!Item_Name.Value = "",true,false)
> This makes it so that if my next rows Item_Name field is blank, the
> toggle will be automatically set the the - symbol so that the user
> knows there is nothing past this point.
> Hope that helps. If I didn't make myself understandable, let me know
> and I can try again.
>|||Jason,
To remove the additional row, you will need to set the Hidden value, of
the Visibility properties for the row, to the same as what is in the
toggle item's Initial Appearance value.
for example:
=IIf(Fields!Item_Name.Value = "",true,false)
And here is an example of a 6 level report, that may or may not have
data at all levels:
=IIf(Fields!lev1_Name.Value="",IIf(Fields!lev2_Name.Value="",IIf(Fields!lev3_Name.Value="",IIf(Fields!lev4_Name.Value="",IIf(Fields!lev5_Name.Value
= "",IIf(Fields!lev6_Name.Value ="",true,false),false),false),false),false),false)
This would be inserted into the Hidden property of Group 1 in said
report. And would need to be placed in that property value for each of
the following groups, removing the previous row from the equation each
time. So for next row, the expression would start at lev2_Name, and the
Group 3 row would start at lev3_name, etc.
Does that help?|||Jason,
You will need to place an Expression into the Hidden field for the
Row's Visibility Properties. If you are using the above Expression on
the Initial Apperance, the Expression for the Hidden property would be
the same.
So, if it is a 3 level report and level 2 is a toggle for level 3, the
Expression would go in the toggle item on row 2 and in the Hidden
Property for Row3.

Hide empty detail sections

Hi,
I'm building a report that displays a tree structure with the content
of some nodes of the tree (as detail). Some nodes don't contain any
info, thus the detail section is empty. How can I hide the empty
detail section in the report ? Now it displays always an empty row,
but I want to shrink this row because it contains no data. How can I
accomplish this ?
Franc.Never mind, found it already. For some reason you have to use the
expression editor. Just typing the expression in the text box of the
group visibility doesn't work.
Franc.
>Hi,
>I'm building a report that displays a tree structure with the content
>of some nodes of the tree (as detail). Some nodes don't contain any
>info, thus the detail section is empty. How can I hide the empty
>detail section in the report ? Now it displays always an empty row,
>but I want to shrink this row because it contains no data. How can I
>accomplish this ?
>Franc.

hide duplicates.. another pdf bug?

I'm getting different views where I run the report from the Report Manager
and then after its exported to pdf. The results are the same when the report
is viewed from the Preview Mode in the Report Deisigner.
The Report has 3 groupings on data and I'm hiding some column values using
"Hide Duplicates". As menioned above, the "hide duplicates" functionality
works well in the Report Designer & Report Manager before exporting to pdf.
Is this a bug in the export functionality? How do I take care of this
discrepancy?
ThanksWhat is more exactlly the discrepancy? Are the textboxes still visible in
pdf? Could you send us the report and data to repro, please?
--
Nico Cristache [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"newmem" <""> wrote in message news:u9OR7jTXEHA.3640@.TK2MSFTNGP11.phx.gbl...
> I'm getting different views where I run the report from the Report Manager
> and then after its exported to pdf. The results are the same when the
report
> is viewed from the Preview Mode in the Report Deisigner.
> The Report has 3 groupings on data and I'm hiding some column values using
> "Hide Duplicates". As menioned above, the "hide duplicates" functionality
> works well in the Report Designer & Report Manager before exporting to
pdf.
> Is this a bug in the export functionality? How do I take care of this
> discrepancy?
> Thanks
>

Hide Duplicates help needed

I have a report with 3 cols. All 3 cols have hide duplicates checked.
Here is hat I currently get:
AAA BBB CCC
DDD
BBB
FFF FFF FFF
Here is what I would like to see:
AAA BBB CCC
DDD CCC
BBB DDD CCC
FFF FFF FFF
If something to the left changes the values to the right of the col will
print.
If anybody has any ideas they would be greatly appreciated.
Thank You
JohnI may be missing something but it appears you only want to hide
duplicates in the first column and show the duplicates in the second
and third columns. So instead of hiding duplicates for all three
columns, just hide duplicates for the first column.
John A Kushwarra wrote:
> I have a report with 3 cols. All 3 cols have hide duplicates checked.
> Here is hat I currently get:
> AAA BBB CCC
> DDD
> BBB
> FFF FFF FFF
>
> Here is what I would like to see:
> AAA BBB CCC
> DDD CCC
> BBB DDD CCC
> FFF FFF FFF
>
> If something to the left changes the values to the right of the col will
> print.
> If anybody has any ideas they would be greatly appreciated.
> Thank You
> Johnsql

Hide Duplicates Attribute Not working

We are creating a matrix report with multiple row headers. There are
duplicate values in the first column. The duplicate values are hidden but we
would like them to be displayed. The â'HideDuplicatesâ' attribute is
unchecked. Ultimately, this report will be exported to Excel and we will be
using these column values to filter the data so I need values in every column
for every row. Is there another attribute that we are missing?
Thanks,
TylerHi Tyler
Did you find a solution to this problem? We have the exact same requirement
- need to output a matrix report to Excel with all cells showing.
Thanks
"Tyler Allbritton" wrote:
> We are creating a matrix report with multiple row headers. There are
> duplicate values in the first column. The duplicate values are hidden but we
> would like them to be displayed. The â'HideDuplicatesâ' attribute is
> unchecked. Ultimately, this report will be exported to Excel and we will be
> using these column values to filter the data so I need values in every column
> for every row. Is there another attribute that we are missing?
> Thanks,
> Tyler|||No - I'm an MSDN subscriber, so I expected a response from MS, but nothing.
"Phil Jeffrey" wrote:
> Hi Tyler
> Did you find a solution to this problem? We have the exact same requirement
> - need to output a matrix report to Excel with all cells showing.
> Thanks
>
> "Tyler Allbritton" wrote:
> > We are creating a matrix report with multiple row headers. There are
> > duplicate values in the first column. The duplicate values are hidden but we
> > would like them to be displayed. The â'HideDuplicatesâ' attribute is
> > unchecked. Ultimately, this report will be exported to Excel and we will be
> > using these column values to filter the data so I need values in every column
> > for every row. Is there another attribute that we are missing?
> >
> > Thanks,
> > Tyler