Integrated Security: sort

Showing posts with label sort. Show all posts

Monday, March 19, 2012

Interactive Sorting/Execution of query

Does clicking interactive sort button in a column reporting services 2005 result re-execution of the query.

Or will it just re-print the rendered data in the layout and so perform better in comparison to the implementation which can be done using drill down to same report with the help of some extra parameters

Priyank

If the user session hasn't expired, interactive sorting doesn't result in re-executing of the query. The server simply re-uses the cached report.

|||I'd definately prefer the cache over generating another report. But if you feel so inclined, try both and time them to see which one is faster.

|||

Thanks, I tried this, rendered data got re-printed without execution of query.

Interactive Sorting -prevent group from collapsing

is there a way to configure interactive sorting so that a group that has
been expanded does not get hidden again when the sort arrow in a column
heading is clicked?
TIA
DeanHi Dean,
Have you got any resolution? If yes please share...I am also facing same
problem.
Thanks
-Shailesh
"Dean" wrote:
> is there a way to configure interactive sorting so that a group that has
> been expanded does not get hidden again when the sort arrow in a column
> heading is clicked?
> TIA
> Dean
>
>|||I'm looking for the answer to the same question.
--
FionaDM
"Shailesh K" wrote:
> Hi Dean,
> Have you got any resolution? If yes please share...I am also facing same
> problem.
> Thanks
> -Shailesh
> "Dean" wrote:
> > is there a way to configure interactive sorting so that a group that has
> > been expanded does not get hidden again when the sort arrow in a column
> > heading is clicked?
> >
> > TIA
> > Dean
> >
> >
> >|||I guess this is a flaw since there has been no MSFT replies since the post
started. MSFT, any solution or workaround to this?

Interactive sorting of a list

I have a list data region that has column headings outside the list. I would like to be able to click a column heading and sort the list. However I cannot do this because the scope of the header can't access the list. Has anyone sorted a list by clicking textbox column headings? Please help.

Hi Patrick-

In general, when applying a user sort, you can sort items that are at the same scope, or are in a child scope. You might try setting the textbox to sort on the data set wihch the list is using, and then set the sort expression scope to details. If you are using RS 2005, I've included a sample RDL below. Just copy the text to a file, rename the extension to .rdl and open it in report designer.

-Jon

<?xml version="1.0" encoding="utf-8"?>

</ConnectionProperties>

<rd:DataSourceID>8d7185f8-cc23-497e-a4a0-cb6c5ec79844</rd:DataSourceID>

</DataSource>

</DataSources>

<rd:DrawGrid>true</rd:DrawGrid>

<rd:SnapToGrid>true</rd:SnapToGrid>

<Body>

<rd:DefaultName>textbox1</rd:DefaultName>

<Style>

</Style>

<SortTarget>DataSet1</SortTarget>

<SortExpression>=Count(Fields!Col.Value, "DataSet1")</SortExpression>

</UserSort>

</Textbox>

<rd:DefaultName>Col</rd:DefaultName>

<Style>

</Style>

<Value>=Fields!Col.Value</Value>

</Textbox>

</ReportItems>

<DataSetName>DataSet1</DataSetName>

</List>

</ReportItems>

</Body>

<rd:ReportID>50318574-728b-4b7c-a2f9-82ab09948b39</rd:ReportID>

<Query>

<DataSourceName>DataSource1</DataSourceName>

</Query>

<rd:TypeName>System.String</rd:TypeName>

</Field>

</Fields>

</DataSet>

</DataSets>

</Report>

Interactive Sorting

I know this is not available now, but is it plan in the near future:

I want to be able to set the initial sort order on the interactive sort.

for example, I have a report sorted Asc by Rank. If I click on the interactive sort button on the Rank column, it resorts ascending... totally pointless, and my customers point this out on a weekly basis...

Any plans to add this feature? If not, I will go to connect and suggest it.

Also, does anyone else find this annoying?

Thanks!

BobP

So you are saying that when you click the sort button on a report that is already sorted ascending, you want it to sort descending and vice versa?

Right click the field you want to interactively sort. Click Properties. Go to the interactive sort tab.

Is this not what you want?

By the way, how does this work? I'm trying to get one of my drilldowns to interactively sort by transaction amount. It won't seem to sort it. I think I just don't have it set up properly.

|||

It is exactly what i want, and it works great EXCEPT... If the report is sorted by default on Column A ascending, and I click on the sort button on column A, it tries to sort it asc first. I have to push it twice to sort desc.

To get it to sort, you have to select the correct grouping to sort, and the correct grouping for the sort expression.

Generally, if I have 1 group, I can sort on the table level, and leave the bottom selection default.

BobP

|||

BobP - BIM wrote:

It is exactly what i want, and it works great EXCEPT... If the report is sorted by default on Column A ascending, and I click on the sort button on column A, it tries to sort it asc first. I have to push it twice to sort desc.
To get it to sort, you have to select the correct grouping to sort, and the correct grouping for the sort expression.
Generally, if I have 1 group, I can sort on the table level, and leave the bottom selection default.

BobP

I got it to sort for me. But I see what you're talking about now. That is somewhat annoying. Especially when you go sort happy.

|||Is there any way to change the default order of the button? I need a report to display descending first, then ascending if clicked a second time. However, I am unable to find any setting in the report designer that allows me to change this.|||

That's what this thread is about. No, it does not exist now.

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=249537

BobP

Interactive sort, forcing a row to remain at the end still cant get it to work

Hi,

Im trying to do an interactive sort , one of the rows returned from my datasource called 'Total' i wish to display at the bottom always. is there a way i can do this?

I've tried the below on the column header but the total is either at the bottom or the top how can i check the ordering if Ascending or Descending? Then i cld swop the 1 and the 2 around.

=iif(Fields!Item.Value <> "Total", 1 ,2) & Fields!Item.Value

Otherwise doesnt anyone know how to palce a row from the detail section into the footer?

Many thanks

Dave

This approach should work fine. Maybe the item value contains blanks. You may want to try to just add another detail textbox that shows the result of =(Trim(Fields!Item.Value) <> "Total").

Once you get the expected results, modify the sort expression for the interactive sort accordingly.

-- Robert

|||

Hi All

I'm Climbing the walls here, does anyone know how to do an interactive sort but keep one of the returned rows pinned at the end of the result set?

I've tried =(Trim(Fields!Item.Value) <> "Total") & Fields!Item.Value but the Total ends ups either at the top or bottom of the result set.

E.g

Results

Sort would return

with c remaining at the bottom

i get the above when ascending sort which is fine but descending i get

Thanks in advance

Dave

|||Anyone?

Interactive sort, forcing a row to remain at the end

Hi,

Im trying to do an interactive sort , one of the rows returned from my datasource called 'Total' i wish to display at the bottom always. is there a way i can do this?

I've tried the below on the column header but the total is either at the bottom or the top how can i check the ordering if Ascending or Descending? Then i cld swop the 1 and the 2 around.

=iif(Fields!Item.Value <> "Total", 1 ,2) & Fields!Item.Value

Otherwise doesnt anyone know how to palce a row from the detail section into the footer?

Many thanks

Dave

This approach should work fine. Maybe the item value contains blanks. You may want to try to just add another detail textbox that shows the result of =(Trim(Fields!Item.Value) <> "Total").

Once you get the expected results, modify the sort expression for the interactive sort accordingly.

-- Robert

|||

Hi All

I'm Climbing the walls here, does anyone know how to do an interactive sort but keep one of the returned rows pinned at the end of the result set?

I've tried =(Trim(Fields!Item.Value) <> "Total") & Fields!Item.Value but the Total ends ups either at the top or bottom of the result set.

E.g

Results

Sort would return

with c remaining at the bottom

i get the above when ascending sort which is fine but descending i get

Thanks in advance

Dave

|||Anyone?

Interactive sort, forcing a row to remain at the end

Hi,

Im trying to do an interactive sort , one of the rows returned from my datasource called 'Total' i wish to display at the bottom always. is there a way i can do this?

I've tried the below on the column header but the total is either at the bottom or the top how can i check the ordering if Ascending or Descending? Then i cld swop the 1 and the 2 around.

=iif(Fields!Item.Value <> "Total", 1 ,2) & Fields!Item.Value

Otherwise doesnt anyone know how to palce a row from the detail section into the footer?

Many thanks

Dave

This approach should work fine. Maybe the item value contains blanks. You may want to try to just add another detail textbox that shows the result of =(Trim(Fields!Item.Value) <> "Total").

Once you get the expected results, modify the sort expression for the interactive sort accordingly.

-- Robert

|||

Hi All

I'm Climbing the walls here, does anyone know how to do an interactive sort but keep one of the returned rows pinned at the end of the result set?

I've tried =(Trim(Fields!Item.Value) <> "Total") & Fields!Item.Value but the Total ends ups either at the top or bottom of the result set.

E.g

Results

Sort would return

with c remaining at the bottom

i get the above when ascending sort which is fine but descending i get

Thanks in advance

Dave

|||Anyone?

Interactive Sort within a Matrix

Can't seem to make any kind of interactive sort work within a Matrix. Is it possible? I've got the interactive sort to work in a Table.

In a Matrix, the sort buttons come up, but they don't have any affect on the presentation of the data (columns). In the matrix, I think I've used every possible combination of Current Scope, Choose Data Region or Grouping, Detail Scope and the second Choose Data Region or Grouping.

Any help or suggestions would be most appreciated.

I'm wondering - how did you make the interactive sort work within a table? Perhaps my problem is that my table is a drill-down. I can't find an interactive sort feature or property.|||Please Ddisregard my post, I found the Interactive Sort property. Interstingly, Interactive Sort is not in the help file. I love this product, it's so great that I think 2.0 will be a true firestorm.|||

I've also noted that the "Subtotal" feature in a Matrix does not appear to work logically. It seems when you have a variable amount of columns returned in your query, the "Subtotal" does not sum the columns, only the first column is sum'd (which is worthless).

There is an open ticket with Microsoft on the "Matrix / Interactive Sort" issue (SRX060307603449). Been waiting a week now...

|||Interactive sort may not work for Matrix report.

Interactive Sort within a Matrix

Can't seem to make any kind of interactive sort work within a Matrix. Is it possible? I've got the interactive sort to work in a Table.

Any help or suggestions would be most appreciated.

There is an open ticket with Microsoft on the "Matrix / Interactive Sort" issue (SRX060307603449). Been waiting a week now...

|||Interactive sort may not work for Matrix report.

Monday, March 12, 2012

Interactive Sort on Drillthrough reports

I have an issue with the use of interactive sorts on a table that has a field with a drill through to a different report.

When the report is unsorted it opens up the link to the new report as expected, however when interactive sort is applied the drill through report opens up on the parent report and the page loads a warning error

"can't execute code from freed script"

Has anyone seen this?

Ify

Conchango

Hello,

I have the same problem :

ASPX page + Report Viewer + Report with DrillDown and Jump to URL.

If the ReportViewer property AsyncRendering is set to true, after drilldown i have this message in IE (6) :

"can't execute code from freed script"

The problem is on this line (Reserved.Reportviewer.xad) :

function OnReportFrameLoaded()

{

this.m_reportLoaded = true;

this.ShowWaitFrame(false);

if (this.IsAsync && this.m_reportObject != null)

this.m_reportObject.OnFrameVisible();

If the ReportViewer property AsyncRendering is set to false, i don't have the problem (but my report is not "usable")

I don't know if it's an IE problem or a ReportViewer problem ?

Frederic

|||

I am also having the same error. Any help will be appreciated.

thanks,

Mini

Interactive Sort on Drillthrough reports

I have an issue with the use of interactive sorts on a table that has a field with a drill through to a different report.

"can't execute code from freed script"

Has anyone seen this?

Ify

Conchango

Hello,

I have the same problem :

ASPX page + Report Viewer + Report with DrillDown and Jump to URL.

If the ReportViewer property AsyncRendering is set to true, after drilldown i have this message in IE (6) :

"can't execute code from freed script"

The problem is on this line (Reserved.Reportviewer.xad) :

function OnReportFrameLoaded()

{

this.m_reportLoaded = true;

this.ShowWaitFrame(false);

if (this.IsAsync && this.m_reportObject != null)

this.m_reportObject.OnFrameVisible();

If the ReportViewer property AsyncRendering is set to false, i don't have the problem (but my report is not "usable")

I don't know if it's an IE problem or a ReportViewer problem ?

Frederic

|||

I am also having the same error. Any help will be appreciated.

thanks,

Mini

Interactive Sort on date field

I have an RS 2005 June CTP report where the data source is an MDX query against AS 2005 June CTP. I'm using Interactive Sort on several columns and it's working fine for the numeric and string fields, but it's sorting the date columns alphabetically instead of chronologically. Is there a way I can specify that these fields are date fields and should be sorted chronologically?
Thanks,
Dirk

Most likely the date field is returned as string through the provider. Try to explicitly convert it with the CDate(...) function in the sort expression. E.g. =CDate(Fields!OrderDate.Value)
-- Robert

|||That did the trick, thanks for the help.|||

I'm also using Interactive Sort on several columns in MSRS 2005,
my problem is with sorting the currency columns (columns with $ sign) - it doesn't work, dallor ammounts are not sorted in accending/decending order. Is there a way I can specify that these fields be sorted as numbers?

Thanks!

|||

It sounds like you are sorting on strings (because the underlying dataset field contains a string rather than a numeric value).

You should sort on a numeric value of the dollar amount - e.g. by changing the dataset query to return the numeric value instead of the string. You can then still apply the currency formatting in the report by using the Format property on textboxes and set it to e.g. C0 (for currency formatting with zero decimals)

-- Robert

Interactive Sort on date field

Most likely the date field is returned as string through the provider. Try to explicitly convert it with the CDate(...) function in the sort expression. E.g. =CDate(Fields!OrderDate.Value)
-- Robert

|||That did the trick, thanks for the help.|||

Thanks!

|||

It sounds like you are sorting on strings (because the underlying dataset field contains a string rather than a numeric value).

-- Robert

Interactive sort not working with snapshot

I'm using SSRS 2005. I have a pretty simple report: it's a table with an
optional date parameter. I have one column designated to allow interactive
sort. When testing the report everything works fine. When I change the report
execution to snapshot, the interactive sort no longer works. The icon will
sometimes change to make it appear as if it is sorted, but the data doesn't
actually get sorted.
Is there some config or option I've missed?
TIAThe interactive sort also does not appear to work when the report is cached.
I know this feature was new for 2005. I'm just wondering if this behavior is
by design, a bug, or a config setting that I'm missing.
Any info appreciated...
"Denise" wrote:
> I'm using SSRS 2005. I have a pretty simple report: it's a table with an
> optional date parameter. I have one column designated to allow interactive
> sort. When testing the report everything works fine. When I change the report
> execution to snapshot, the interactive sort no longer works. The icon will
> sometimes change to make it appear as if it is sorted, but the data doesn't
> actually get sorted.
> Is there some config or option I've missed?
> TIA|||SP1 appears to have fixed this bug. After applying the service pack, all
interactive sorting works, even when the report is executed as a snapshot.
"Denise" wrote:
> The interactive sort also does not appear to work when the report is cached.
> I know this feature was new for 2005. I'm just wondering if this behavior is
> by design, a bug, or a config setting that I'm missing.
> Any info appreciated...
> "Denise" wrote:
> > I'm using SSRS 2005. I have a pretty simple report: it's a table with an
> > optional date parameter. I have one column designated to allow interactive
> > sort. When testing the report everything works fine. When I change the report
> > execution to snapshot, the interactive sort no longer works. The icon will
> > sometimes change to make it appear as if it is sorted, but the data doesn't
> > actually get sorted.
> >
> > Is there some config or option I've missed?
> >
> > TIA

Interactive sort not working in Tabular View

I am just starting with Sql Server reporting, but I can't get interactive sort to work for columns with aggregate fields.

I am using the following query for DataSet:

SELECT
Store.ID as StoreID,
Store.Name as StoreName,
COUNT(*) as NumReservations,
SUM(Appointment.TotalBeforeTaxes) as Revenue
FROM Store LEFT JOIN Appointment ON Store.ID=Appointment.StoreID
GROUP BY ALL Store.ID, Store.Name
ORDER BY Store.Name ASC

For report, I am using tabular data view. Interactive sorting works great for StoreID, StoreName, but doesn't work for NumReservations and Revenue fields. I turned it on for all 4 columns.

What could be causing this problem?
Figured out the problem... It just doesn't work in FireFox. Seems to work fine in IE.

Interactive sort not working if sub report

Hi,
I am having an issue that when a sub report that contains fields that
are setup to do interactive sort only work if they are displayed as the
parent report. If they are included as a sub report when trying to do
a sort the page just posts back but comes back unsorted.
Is there a work around for this or is it just not possible on SSRS
2005?
Please Help!
Chrischris wrote:
> Hi,
> I am having an issue that when a sub report that contains fields that
> are setup to do interactive sort only work if they are displayed as the
> parent report. If they are included as a sub report when trying to do
> a sort the page just posts back but comes back unsorted.
> Is there a work around for this or is it just not possible on SSRS
> 2005?
> Please Help!
> Chris|||Chris,
I had the same problem with sorting in a sub report, I then changed my
report to not contain a sub report, however I found that when you group
your data in a table using a "Group On" expression, sorting does not
work either. Sorting only appears to work on non-grouped data fields
in a table and not in a sub report.
chris wrote:
> Hi,
> I am having an issue that when a sub report that contains fields that
> are setup to do interactive sort only work if they are displayed as the
> parent report. If they are included as a sub report when trying to do
> a sort the page just posts back but comes back unsorted.
> Is there a work around for this or is it just not possible on SSRS
> 2005?
> Please Help!
> Chris|||my report with sub-report is word well when sorting.

Interactive sort in matrix not working on 9.00.3054.00

I'm having problem with sorting in matrix. My report looks something like below.

Name* Avg.* | Test1 Test2 Test3

==============================================

Jim 50% | 100% 40% 10%

John 28% | 5% 40% 40%

The column with * need to be sorted. I can sort the name and average fine in Microsoft SQL Server Reporting Services Version 9.00.2047.00. BUt when I run this in another environment, sorting on Avg doesn't work. The version on that is Microsoft SQL Server Reporting Services Version 9.00.3054.00.

I put together a sample code against the northwinddatabase. Sorting works in 9.00.2047.00 but not 9.00.3054.00. Any ideas?

<?xml version="1.0" encoding="utf-8"?>

<DataSourceReference>DataSource1</DataSourceReference>

<rdataSourceID>632d2cbd-3d9c-44fe-97ac-fbdef687ef47</rdataSourceID>

</DataSource>

</DataSources>

<DataType>String</DataType>

<Value>Student</Value>

</Values>

</DefaultValue>

<Prompt>Object Type</Prompt>

</ReportParameter>

<DataType>Integer</DataType>

</Values>

</DefaultValue>

<Prompt>testid</Prompt>

</ReportParameter>

<DataType>String</DataType>

<Value>Element</Value>

</Values>

</DefaultValue>

<Prompt>groupby</Prompt>

</ReportParameter>

<DataType>String</DataType>

<Value>6453bybbyq</Value>

</Values>

</DefaultValue>

<Prompt>usertestdoc</Prompt>

</ReportParameter>

<DataType>String</DataType>

<Value>Data Source=10.88.22.00;Initial Catalog=xxx;User ID=sa;Password=xxxxx</Value>

</Values>

</DefaultValue>

<Prompt>dbserver</Prompt>

</ReportParameter>

<DataType>String</DataType>

</Values>

</DefaultValue>

<Prompt>copyright</Prompt>

</ReportParameter>

<DataType>String</DataType>

<Value>Teacher</Value>

</Values>

</DefaultValue>

<Prompt>levelby</Prompt>

</ReportParameter>

<DataType>Integer</DataType>

</Values>

</DefaultValue>

<Prompt>objectid</Prompt>

</ReportParameter>

</ReportParameters>

<rd:GridSpacing>0.0625in</rd:GridSpacing>

<Body>

</MatrixColumn>

</MatrixColumns>

<rdefaultName>shipcountry_1</rdefaultName>

<Style>

<Default>Solid</Default>

</BorderStyle>

<BackgroundColor>Gainsboro</BackgroundColor>

</Style>

<Value>=count(Fields!orderid.value)</Value>

</Textbox>

</ReportItems>

<GroupExpression>=Fields!shipcountry.Value</GroupExpression>

</GroupExpressions>

</Grouping>

</DynamicRows>

</RowGrouping>

</RowGroupings>

<rdefaultName>customerid</rdefaultName>

<Style>

<Default>Solid</Default>

</BorderStyle>

<TextAlign>Center</TextAlign>

<BackgroundColor>Gainsboro</BackgroundColor>

</Style>

<Value>=Fields!customerid.Value</Value>

</Textbox>

</ReportItems>

<GroupExpression>=Fields!customerid.Value</GroupExpression>

</GroupExpressions>

</Grouping>

</DynamicColumns>

</ColumnGrouping>

</ColumnGroupings>

<DataSetName>dataset</DataSetName>

<rdefaultName>textbox1</rdefaultName>

<Style>

</Style>

<SortExpression>=count(Fields!orderid.Value)</SortExpression>

<SortExpressionScope>matrix1_RowGroup1</SortExpressionScope>

</UserSort>

<Value>SORTME</Value>

</Textbox>

</ReportItems>

</Rectangle>

</ReportItems>

</Corner>

<rdefaultName>textbox4</rdefaultName>

<Style>

<Default>Solid</Default>

</BorderStyle>

<TextAlign>Center</TextAlign>

</Style>

<Value>=count(Fields!orderid.Value)</Value>

</Textbox>

</ReportItems>

</MatrixCell>

</MatrixCells>

</MatrixRow>

</MatrixRows>

</Matrix>

</ReportItems>

</Body>

<rd:ReportID>98ed88ab-a457-4446-8b4c-ff275e2b5e03</rd:ReportID>

<Query>

<rd:UseGenericDesigner>true</rd:UseGenericDesigner>

<CommandText>select top 30 shipcountry, customerid, orderid from orders</CommandText>

<DataSourceName>DataSource11</DataSourceName>

</Query>

<rd:TypeName>System.String</rd:TypeName>

<DataField>shipcountry</DataField>

</Field>

<rd:TypeName>System.String</rd:TypeName>

<DataField>customerid</DataField>

</Field>

<rd:TypeName>System.Int32</rd:TypeName>

<DataField>orderid</DataField>

</Field>

</Fields>

</DataSet>

</DataSets>

</PageFooter>

</Report>

I ran into the same problem a while back but we ended up rebuilding our reports to use tables. I'm kinda curious as to what caused this issue and if anyone ever found a fix.|||

You know it looks like they changed it so that it won't sort based on an aggregate. For example prior to the SP update

I could have a report like this

SortBox Year

Carrier Sum(Passengers)

sort expression Sum(Passengers)

sort expression scope Carrier

Now that still sucks because you can't sort on the Passengers for a given year but at least it sorts on total pax....

Now after the SP(and I checked this in VS05 9.00.3054,VS08 beta 2 RDLC, and Katmai Designer) only non aggregate fields work

sort expression Fields!Carrier, or Fields!Passengers

sort expression scope Carrier

The tablix in Katmai allows you to put something like this together

Year

(Label with sort Passengers)

Carrier Sum(Passengers)

The sort label:

sort expression Fields!Passengers or Sum(Passengers)

sort expression scope Carrier

I'm hopeful that the fact that it doesn't give me an error indicates that this excel type sort will work in the future.

In anycase one possible bypass for the .3054 change appears to be embedding a table in the matrix cell which allows you to sort the "row group" relative to that specific column group. While this doesn't work across all the columns, in some situations it might help out.

Interactive Sort in Matrix

Hi,

I making a report using Matrix with 2 row groups and 1 column group. The group names are:

Row : CompanyName, TotalUsers

Column: UserType

Detail Group has a count of number of user in each type.

I want to use interactive sort feature on my column group so that when I click on my column header, it sort my detail group data ascending or decending and companyName and total users based on datail group.

Thanks a lot,

-Rohit

I tried different options for the scope but non of them works. Does any one know how to do this?

Thanks.

Interactive Sort in Matrix

I have a Matrix in a report - created like below. Each row has a different dataset and I need to make each Column to be sortable so they can click on the column header say "Summary of Accounts" and sort them and do that for each column header. So far I havent seen anything that looks promising that can do this. Is there away this can be done?

6 Columns and 14 Rows

--headers

Summary of Accounts No debts origBal AccrInter PaidDate CurrBal

Activity count() Sum() Sum() First() Sum()

phase count() Sum() Sum() First() Sum()

attorney etc etc

collection

not inititated

resolved

interrupted

cancel

closed

revised

letter service

Totals:

The combination of Interactive Sort and Matrix are not good! I managed to get it working but only for row groups.|||I know they are not how about how did you do the row groups? If they can sort by row then fine that is good enough for me then!

interactive sort in group

hi,

i created a report using table with added group header and footer. i set a few columns at the table header for interactive sort. however, the sort doesn't work for thhe field that i place in the group header.

Is interactive sort supported in group header?

Thanks.

Yes, interactive sort is supported in group header. When you click on the sort in the group header, it just doesn't do anything? Can you attach your rdl so that I can see why it's not working for you?

- Fang

|||

thanks Fang for your reply. sorry if this seems silly. how do i attach the rdl file here?

thanks again

|||Looks like there is no way to attach a file here. Can you just post the XML in the thread?|||

hi Fang.. sorie... probably i should rephrase my question.

actually i have fields in my group header and place the labels for the respective fields at the table header. can i sort the fields in group header using the label in table header?

sorie for asking the wrong question.. thanks!

Monday, March 19, 2012

Interactive Sorting/Execution of query

Interactive Sorting -prevent group from collapsing

Interactive sorting of a list

Interactive Sorting

Interactive sort, forcing a row to remain at the end still cant get it to work

Interactive sort, forcing a row to remain at the end

Interactive sort, forcing a row to remain at the end

Interactive Sort within a Matrix

Interactive Sort within a Matrix

Monday, March 12, 2012

Interactive Sort on Drillthrough reports

Interactive Sort on Drillthrough reports

Interactive Sort on date field

Interactive Sort on date field

Interactive sort not working with snapshot

Interactive sort not working in Tabular View

Interactive sort not working if sub report

Interactive sort in matrix not working on 9.00.3054.00

Interactive Sort in Matrix

Interactive Sort in Matrix

interactive sort in group

Integrated Security

Blog Archive

About Me