columns dont work in subreport reporting services

only one long column is showing up in the main report for the suyb report
part of it, but when i run the subreport by itself it shows two.I have the exact same issue. When I run the report alone it looks great but
as soon as I add it to a main report the two coulumns only show as one long
column. I have posted a question on the boeard and have asked for a help
article number so I can give that to MS support otherwise they want to charge
me for a support ticket. I believe this is a MS bug. I have also consulted
with authors and traininers of SQL RS and they can not seems to get this to
work either. I have also found NO book that actually references this issue.
Any help you find would help me out as well. jasonmr2@.hotmail.com
Jason Miller
"D Witherspoon" wrote:
> only one long column is showing up in the main report for the suyb report
> part of it, but when i run the subreport by itself it shows two.
>
>|||This is right from MS...
"The multi column functionality is ignored by subreports. It only works when
used in the main report
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights."
"D Witherspoon" wrote:
> only one long column is showing up in the main report for the suyb report
> part of it, but when i run the subreport by itself it shows two.
>
>|||... they make it sound like a feature ... :(
"Jason Miller" <JasonMiller@.discussions.microsoft.com> wrote in message
news:3AF18960-6CAF-4C6B-A56F-65BF3D0FF5F7@.microsoft.com...
> This is right from MS...
> "The multi column functionality is ignored by subreports. It only works
> when
> used in the main report
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
> rights."
> "D Witherspoon" wrote:
>> only one long column is showing up in the main report for the suyb report
>> part of it, but when i run the subreport by itself it shows two.
>>

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.

Colour of the series in legend

I have few chart based reports where I am showing different costs in series. I want to fix the colour of each type of cost so that I can maintain the same colour for each cost in different reports.

Is it possible? If yes, then please let me know.

Thanks in advance!!!

Check out my sample report on Brian Welcker's blog: http://blogs.msdn.com/bwelcker/archive/2005/05/20/420349.aspx

-- Robert