Column Sorting

I want to be able to allow a user of a report to sort the records returnedc in a table control based on the column heading they select.

ie say the report returns a list of properties as row headings then a list of cost categories as column headings with cost values as the data. I want the user to be able to click on a column heading say a cost castegory of 'Cleaning' i then want the report to order the properties by 'Cleaning Value'

Is that possoble?
cheers.... anyone...

In the June 2005 CTP, there's a new feature called Interactive Sort that does precisely what you're talking about. To access it, open up the properties of the header's text box and navigate to the Interactive Sort tab of the dialog.|||Sorry whats June 2005 CTP is it to do with SQL Reporting Services?

Regards,
Geoff|||

CTP - Community Technology Preview. It's a post-Beta release of the new Reporting Services 2005 due out this year. More information at -> http://www.microsoft.com/sql/2005/productinfo/ctp.mspx

As far as i know, the interactive sort was not available previous to this version. I was using a previous beta release of the 2005 edition and it did not have this capability.

|||cheers for this i guess i will have to just wait!

column heading is missing on some pdf rendered pages

I am new to RS so this might be a stupid question. Since the page header
can't have table, I have placed the table in the body as table group header.
The table contains column heading for my report. The report produces over a
hundred pages of PDF files. As I scroll through the PDF pages I noticed that
on some pages the column heading is missing. Does anyone know why or is there
a better way to do this?
Thanks,
TimThis might not be the right answer, but my impression is that where pages
break in the web report, and in the PDF exported report, are two different
things. I noticed it when I added a footer with a line to a report. THis
line would show up at the end of each page in the web report, and totally
randomly in the PDF report. And there would be a lot more text on each page
in the web report, than in the PDF. At least this goes for reports with 8pt
font and landscape view.
Try to check if what you see on each page in the PDF corresponds with what
you see in your web report.
Kaisa M. Lindahl
"Tim2Be" <Tim2Be@.discussions.microsoft.com> wrote in message
news:5660FC32-2C75-43F2-BA22-212001F7D535@.microsoft.com...
> I am new to RS so this might be a stupid question. Since the page header
> can't have table, I have placed the table in the body as table group
header.
> The table contains column heading for my report. The report produces over
a
> hundred pages of PDF files. As I scroll through the PDF pages I noticed
that
> on some pages the column heading is missing. Does anyone know why or is
there
> a better way to do this?
> Thanks,
> Tim|||My web report looks perfectly find with all the column heading in tack on all
pages. Only some of the PDF pages that is missing the column heading. I don't
know why it does that.
"Kaisa M. Lindahl" wrote:
> This might not be the right answer, but my impression is that where pages
> break in the web report, and in the PDF exported report, are two different
> things. I noticed it when I added a footer with a line to a report. THis
> line would show up at the end of each page in the web report, and totally
> randomly in the PDF report. And there would be a lot more text on each page
> in the web report, than in the PDF. At least this goes for reports with 8pt
> font and landscape view.
> Try to check if what you see on each page in the PDF corresponds with what
> you see in your web report.
> Kaisa M. Lindahl
> "Tim2Be" <Tim2Be@.discussions.microsoft.com> wrote in message
> news:5660FC32-2C75-43F2-BA22-212001F7D535@.microsoft.com...
> > I am new to RS so this might be a stupid question. Since the page header
> > can't have table, I have placed the table in the body as table group
> header.
> > The table contains column heading for my report. The report produces over
> a
> > hundred pages of PDF files. As I scroll through the PDF pages I noticed
> that
> > on some pages the column heading is missing. Does anyone know why or is
> there
> > a better way to do this?
> >
> > Thanks,
> > Tim
>
>

Column Heading in Output File

Hi
I am running a SQL query and printing the output to a file, as well as
showing it in the Grid. The Grid has column headings, my file does not. Is
there a way of getting my column headings into the output file?
To create the output file I am using the following;
EXEC master..xp_cmdshell 'bcp "DATABASE.dbo.FILE" out
"C:\SQLSCRIPT\OUTPUT.txt" -c -t, -q -Sserver -U"username" -P"password"'
GO
Any help appreciated.
SteveBCP will not export the headings. You can use OSQL to do that.
Rand
This posting is provided "as is" with no warranties and confers no rights.

Column Heading in Crosstab

I have a crosstab that contains dates grouped by week as the column. Since it is grouped by week it gives Sunday as the start date of the week. Does anyone know how I can change it so that it will show Monday as the beginning of the week?Create a formula having this code
weekdayname(weekday({datefield})+1)
Now Group the report by this formula|||I tried this formula in my crosstab and it seperated the columns into Monday, Tuesday, Wednesday etc. I need it to show the dates. For example, what it shows across the top now is:

6/5/05 6/12/05 6/19/05 6/26/05

what I need it to show is the week starting on Monday:

6/6/05 6/13/05 6/20/05 6/27/05

Any help would be appreciated.

column heading centered when sort enabled

SQL Server 2005
I have a report with 20+ columns. Normally the text in each colum
heading is aligned at the top of the column heading. The column
heading is three lines high - there is so much text in some of the
columns - it takes three rows to display all of the column heading
text.
Without any sorting enabled - the column heading text is aligned to
the top of the heading row.
For columns with sorting enabled - it appears that it centers the
text. So column headings that are only one row - they are centered in
the heading row - whereas columns that are not sorted align at the
top.
The vertical align property for the row containing column headings is
set to top
It looks bad and I know my customer will object and might rather
disable sorting.
Any ideas?
Thanks!I believe I know what you are talking about. What is happening is that when
sorting is enabled it has to add the sorting "arrow" icon to the headers
and therefore moves the text around in the column header. If you want the
header to not change size (if the size of the cell is growing when you do
this) then turn the "CanGrow" property to "False" and see if that helps.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: GoogleGroups@.BaldwinNC.com
> Newsgroups: microsoft.public.sqlserver.reportingsvcs
> Subject: column heading centered when sort enabled
> Date: Tue, 02 Oct 2007 07:03:15 -0700
> SQL Server 2005
> I have a report with 20+ columns. Normally the text in each colum
> heading is aligned at the top of the column heading. The column
> heading is three lines high - there is so much text in some of the
> columns - it takes three rows to display all of the column heading
> text.
> Without any sorting enabled - the column heading text is aligned to
> the top of the heading row.
> For columns with sorting enabled - it appears that it centers the
> text. So column headings that are only one row - they are centered in
> the heading row - whereas columns that are not sorted align at the
> top.
> The vertical align property for the row containing column headings is
> set to top
> It looks bad and I know my customer will object and might rather
> disable sorting.
> Any ideas?
> Thanks!
>|||Thanks for the idea. I only had to change the very first column,
TextBox properties, Format Tab, - I unchecked the "Can increase to
accomodate contents".
Note I only modified the first column heading textbox properties - and
all column headings now appear to be aligned (correctly) to the top.
Thanks!|||I take my last post back. When I "previewed" the report changing just
the first column seemed to fix all columns. But when I deploy the
report - I had to change each column.|||Great. Glad we got it working for you at least :)
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: GoogleGroups@.BaldwinNC.com
> Newsgroups: microsoft.public.sqlserver.reportingsvcs
> Subject: Re: column heading centered when sort enabled
> Date: Tue, 02 Oct 2007 10:37:17 -0700
> I take my last post back. When I "previewed" the report changing just
> the first column seemed to fix all columns. But when I deploy the
> report - I had to change each column.
>