C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Communities   Interview   Jobs   Projects   Offshore Development    
Silverlight Tutorials | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Revenue Sharing |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !




Sorting in SQL Server Reporting 2000


Posted Date: 04 Sep 2008      Total Responses: 1

Posted By: Srilatha Bezgoan       Member Level: Bronze     Points: 1



Hi,

Is it possible that a User can sort the data that is shown on a SQL Report 2000?

While building a report we can sort the data and provide but can this functionality left to the User so that required column is sorted upon?

Thanks in advance,
Srilatha





Responses

Author: avtar    05 Sep 2008Member Level: GoldRating:     Points: -20

Grouping & Sorting

Creating a Group
• Right-click on left margin of table and select
Insert Group
• Select a field to group on or enter an expression
• Select any options (page break at start, page
break at end, etc.) and click OK to create group
• SRS doesn't automatically add the group field to
the group header (the wizard does, though) but
you can add it easily enough

------SORTING-----

• You can use Sorting tab of Grouping and
Sorting Properties dialog to sort groups
and detail with groups
• To edit group, right-click on left-hand
margin of group header or footer and
select Edit Group
• Groups can be nested many deep



Post Reply
You must Sign In to post a response.
Next : Free SQL Server tutorial for commercial purpose
Previous : sql query
Return to Discussion Forum
Post New Message
Category: SQL Server

Related Messages



dotNet Slackers   BizTalk Adaptors    Web Design


Contact Us    Privacy Policy    Terms Of Use