Adding new lines into results in the

I used to be able to enter new lines into the result pane cell for text
(and varchar) data in Enterprise Manager, but now that I am using SQL
2005 Management Studio, this feature is gone.

Is there any way to do this?

Also, copying to/from excel chops off part of the text in a cell and is
very infuriating.

Any help would be appreciated.

Dan(monkeyboydan@.gmail.com) writes:
> I used to be able to enter new lines into the result pane cell for text
> (and varchar) data in Enterprise Manager, but now that I am using SQL
> 2005 Management Studio, this feature is gone.
> Is there any way to do this?
> Also, copying to/from excel chops off part of the text in a cell and is
> very infuriating.

Time to learn to write INSERT and UPDATE statements, I see!

There are plenty of differences between the tools in SQL 2000 and SQL 2005.
Keep in mind that Open table is intended to be a fairly simple tool to
view and edit data. For more heavy-duty stuff, you would use an application.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Thanks for the reply.

Your point is noted and I am quite happy to do insert and update
statements but there are occasions where a little ad-hoc editing and
copying and pasting is useful and this isn't possible any more and it
seems a bit silly 'cause it makes the 'open table' functionality
vritually pointless is a lot of occasions.

Adding headers to matrix

Hi,
how can I add headers to my matrixcolumns?
I created a table inside the merged cell above, but this won't export
to excel: i get the error "Data Regions within table/matrix cells are ignored."

thx,
FrankHi!
I had the same problem, and i found a solution for the embedded data regions in EXCEL! Altough it is a limitation in RS :
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_dc_v1_8yhy.asp
There is a solution! Have a look at the riport item "List" in design mode! It has almost the same functionality like teh "Table". You have to manually add headers over the "List" and manually place the textboxes hierarchical inside the list if you want to group fields, but it has a big advantage! Inside the "List" every embedded data regions (just like matrix, or subreport) are displayed correctly in EXCEL!
IMPORTANT: if you place embedded data regions in a "List" you have to right click on the "List" and select properties. On the first tab of the property window click "edit details group" and you must specify grouping expressions here. For examle if there are "Parent" and "Child" rows inside a "List", a good grouping expression would be the Parent row ID.
I hope this helps:)
Rolf|||Oh! And to adding matrix headers, for columns, you have to create a rectangle instead of a table. And place textbox-es inside the rectangle. And finally drag and drop the rectangle inside a merged matrix columnheader cell.
Rolf|||

I am a newbie to the RS and need much more information then given here.

Can anybody please show me an example implementation of the same.

Tanveer

|||I have found the same problem with the "List" object in Reporting Services. Renders fine in HTML and PDF but Excel displays "Data Regions within table/matrix cells are ignored". Very frustrating limitation|||

Unfortunately there is no viable workaround for this particular limitation of the Excel renderer. Data regions cannot be nested in table or matrix cells. We are working to add this functinonality in the next version of Reporting Services.

Tanveer, please let us know specifically what questions you have and we'll do our best to answer.

-Chris

|||Do you have a timeline of when the next version of RS is going to be available?|||

This is exactly what brings touble down the road, One recommends RS over CR and then, when I implement a large matrix report which for very valid reasons is embedded within a table, I receive a user response that this stuff just simply doesn't work. I TRULY wish this stuff would just work as it is supposed to. I hate the fact that Microsoft's marketing machine is better and faster than it's technical arm which does absolutely nothing for our credibility!

Why include the option to export to Excel if it does not work?!

Adding headers to matrix

Hi,
how can I add headers to my matrixcolumns?
I created a table inside the merged cell above, but this won't export
to excel: i get the error "Data Regions within table/matrix cells are
ignored."
thx,
FrankI'm assuming you mean the top left cell of the matrix?
Add a rectangle outside the data region, insert a textbox for each
column heading formatting, sizing and positioning them accordingly.
Cut the rectangle and paste it into the matrix cell.
--
Regards
Chris
Frank Mestdagh wrote:
> Hi,
> how can I add headers to my matrixcolumns?
> I created a table inside the merged cell above, but this won't export
> to excel: i get the error "Data Regions within table/matrix cells are
> ignored."
> thx,
> Frank|||Thanks Chris!!! I am going to try that ... it seems hokey that we cant have
the OPTION to iniclude column headings for that area to me! I will try what
you suggested.
"Chris McGuigan" wrote:
> I'm assuming you mean the top left cell of the matrix?
> Add a rectangle outside the data region, insert a textbox for each
> column heading formatting, sizing and positioning them accordingly.
> Cut the rectangle and paste it into the matrix cell.
> --
> Regards
> Chris
>
> Frank Mestdagh wrote:
> > Hi,
> > how can I add headers to my matrixcolumns?
> > I created a table inside the merged cell above, but this won't export
> > to excel: i get the error "Data Regions within table/matrix cells are
> > ignored."
> >
> > thx,
> > Frank
>

Adding headers to matrix

Hi,
how can I add headers to my matrixcolumns?
I created a table inside the merged cell above, but this won't export
to excel: i get the error "Data Regions within table/matrix cells are ignored."

thx,
FrankHi!
I had the same problem, and i found a solution for the embedded data regions in EXCEL! Altough it is a limitation in RS :
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_dc_v1_8yhy.asp
There is a solution! Have a look at the riport item "List" in design mode! It has almost the same functionality like teh "Table". You have to manually add headers over the "List" and manually place the textboxes hierarchical inside the list if you want to group fields, but it has a big advantage! Inside the "List" every embedded data regions (just like matrix, or subreport) are displayed correctly in EXCEL!
IMPORTANT: if you place embedded data regions in a "List" you have to right click on the "List" and select properties. On the first tab of the property window click "edit details group" and you must specify grouping expressions here. For examle if there are "Parent" and "Child" rows inside a "List", a good grouping expression would be the Parent row ID.
I hope this helps:)
Rolf|||Oh! And to adding matrix headers, for columns, you have to create a rectangle instead of a table. And place textbox-es inside the rectangle. And finally drag and drop the rectangle inside a merged matrix columnheader cell.
Rolf|||

I am a newbie to the RS and need much more information then given here.

Can anybody please show me an example implementation of the same.

Tanveer

|||I have found the same problem with the "List" object in Reporting Services. Renders fine in HTML and PDF but Excel displays "Data Regions within table/matrix cells are ignored". Very frustrating limitation|||

Unfortunately there is no viable workaround for this particular limitation of the Excel renderer. Data regions cannot be nested in table or matrix cells. We are working to add this functinonality in the next version of Reporting Services.

Tanveer, please let us know specifically what questions you have and we'll do our best to answer.

-Chris

|||Do you have a timeline of when the next version of RS is going to be available?|||

This is exactly what brings touble down the road, One recommends RS over CR and then, when I implement a large matrix report which for very valid reasons is embedded within a table, I receive a user response that this stuff just simply doesn't work. I TRULY wish this stuff would just work as it is supposed to. I hate the fact that Microsoft's marketing machine is better and faster than it's technical arm which does absolutely nothing for our credibility!

Why include the option to export to Excel if it does not work?!

Adding headers to matrix

Hi,
how can I add headers to my matrixcolumns?
I created a table inside the merged cell above, but this won't export
to excel: i get the error "Data Regions within table/matrix cells are ignored."

thx,
FrankHi!
I had the same problem, and i found a solution for the embedded data regions in EXCEL! Altough it is a limitation in RS :
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_dc_v1_8yhy.asp
There is a solution! Have a look at the riport item "List" in design mode! It has almost the same functionality like teh "Table". You have to manually add headers over the "List" and manually place the textboxes hierarchical inside the list if you want to group fields, but it has a big advantage! Inside the "List" every embedded data regions (just like matrix, or subreport) are displayed correctly in EXCEL!
IMPORTANT: if you place embedded data regions in a "List" you have to right click on the "List" and select properties. On the first tab of the property window click "edit details group" and you must specify grouping expressions here. For examle if there are "Parent" and "Child" rows inside a "List", a good grouping expression would be the Parent row ID.
I hope this helps:)
Rolf|||Oh! And to adding matrix headers, for columns, you have to create a rectangle instead of a table. And place textbox-es inside the rectangle. And finally drag and drop the rectangle inside a merged matrix columnheader cell.
Rolf|||

I am a newbie to the RS and need much more information then given here.

Can anybody please show me an example implementation of the same.

Tanveer

|||I have found the same problem with the "List" object in Reporting Services. Renders fine in HTML and PDF but Excel displays "Data Regions within table/matrix cells are ignored". Very frustrating limitation|||

Unfortunately there is no viable workaround for this particular limitation of the Excel renderer. Data regions cannot be nested in table or matrix cells. We are working to add this functinonality in the next version of Reporting Services.

Tanveer, please let us know specifically what questions you have and we'll do our best to answer.

-Chris

|||Do you have a timeline of when the next version of RS is going to be available?|||

This is exactly what brings touble down the road, One recommends RS over CR and then, when I implement a large matrix report which for very valid reasons is embedded within a table, I receive a user response that this stuff just simply doesn't work. I TRULY wish this stuff would just work as it is supposed to. I hate the fact that Microsoft's marketing machine is better and faster than it's technical arm which does absolutely nothing for our credibility!

Why include the option to export to Excel if it does not work?!

Adding headers to matrix

Hi,
how can I add headers to my matrixcolumns?
I created a table inside the merged cell above, but this won't export
to excel: i get the error "Data Regions within table/matrix cells are ignored."

thx,
FrankHi!
I had the same problem, and i found a solution for the embedded data regions in EXCEL! Altough it is a limitation in RS :
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_dc_v1_8yhy.asp
There is a solution! Have a look at the riport item "List" in design mode! It has almost the same functionality like teh "Table". You have to manually add headers over the "List" and manually place the textboxes hierarchical inside the list if you want to group fields, but it has a big advantage! Inside the "List" every embedded data regions (just like matrix, or subreport) are displayed correctly in EXCEL!
IMPORTANT: if you place embedded data regions in a "List" you have to right click on the "List" and select properties. On the first tab of the property window click "edit details group" and you must specify grouping expressions here. For examle if there are "Parent" and "Child" rows inside a "List", a good grouping expression would be the Parent row ID.
I hope this helps:)
Rolf|||Oh! And to adding matrix headers, for columns, you have to create a rectangle instead of a table. And place textbox-es inside the rectangle. And finally drag and drop the rectangle inside a merged matrix columnheader cell.
Rolf|||

I am a newbie to the RS and need much more information then given here.

Can anybody please show me an example implementation of the same.

Tanveer

|||I have found the same problem with the "List" object in Reporting Services. Renders fine in HTML and PDF but Excel displays "Data Regions within table/matrix cells are ignored". Very frustrating limitation|||

Unfortunately there is no viable workaround for this particular limitation of the Excel renderer. Data regions cannot be nested in table or matrix cells. We are working to add this functinonality in the next version of Reporting Services.

Tanveer, please let us know specifically what questions you have and we'll do our best to answer.

-Chris

|||Do you have a timeline of when the next version of RS is going to be available?|||

This is exactly what brings touble down the road, One recommends RS over CR and then, when I implement a large matrix report which for very valid reasons is embedded within a table, I receive a user response that this stuff just simply doesn't work. I TRULY wish this stuff would just work as it is supposed to. I hate the fact that Microsoft's marketing machine is better and faster than it's technical arm which does absolutely nothing for our credibility!

Why include the option to export to Excel if it does not work?!

Adding headers to matrix

Hi,
how can I add headers to my matrixcolumns?
I created a table inside the merged cell above, but this won't export
to excel: i get the error "Data Regions within table/matrix cells are ignored."

thx,
FrankHi!
I had the same problem, and i found a solution for the embedded data regions in EXCEL! Altough it is a limitation in RS :
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_dc_v1_8yhy.asp
There is a solution! Have a look at the riport item "List" in design mode! It has almost the same functionality like teh "Table". You have to manually add headers over the "List" and manually place the textboxes hierarchical inside the list if you want to group fields, but it has a big advantage! Inside the "List" every embedded data regions (just like matrix, or subreport) are displayed correctly in EXCEL!
IMPORTANT: if you place embedded data regions in a "List" you have to right click on the "List" and select properties. On the first tab of the property window click "edit details group" and you must specify grouping expressions here. For examle if there are "Parent" and "Child" rows inside a "List", a good grouping expression would be the Parent row ID.
I hope this helps:)
Rolf|||Oh! And to adding matrix headers, for columns, you have to create a rectangle instead of a table. And place textbox-es inside the rectangle. And finally drag and drop the rectangle inside a merged matrix columnheader cell.
Rolf|||

I am a newbie to the RS and need much more information then given here.

Can anybody please show me an example implementation of the same.

Tanveer

|||I have found the same problem with the "List" object in Reporting Services. Renders fine in HTML and PDF but Excel displays "Data Regions within table/matrix cells are ignored". Very frustrating limitation|||

Unfortunately there is no viable workaround for this particular limitation of the Excel renderer. Data regions cannot be nested in table or matrix cells. We are working to add this functinonality in the next version of Reporting Services.

Tanveer, please let us know specifically what questions you have and we'll do our best to answer.

-Chris

|||Do you have a timeline of when the next version of RS is going to be available?|||

This is exactly what brings touble down the road, One recommends RS over CR and then, when I implement a large matrix report which for very valid reasons is embedded within a table, I receive a user response that this stuff just simply doesn't work. I TRULY wish this stuff would just work as it is supposed to. I hate the fact that Microsoft's marketing machine is better and faster than it's technical arm which does absolutely nothing for our credibility!

Why include the option to export to Excel if it does not work?!

Adding Carriage Return and Line Feeds to a text box

Hi All,

I am trying to print 10 values in a single cell in a text box.....

To make it readable I put carriage returns and line feeds into the boxes.

These rendered ok in visual studio but did not render ok in explorer....no carriage return or line feed.

This is what I added...

=Fields!segment_sdesc_00.Value & chr(10) & chr(13)

Can anyone advise me as to what is wrong with this? There must be a way to put a cr/lf or newline into a report in a text box.....

Thanks in Advance

Peter

www.peternolan.com

Try using the + sign over the ampersand.

Code Snippet

=Fields!segment_sdesc_00.Value + chr(10) + chr(13)

This has worked for me in Explorer so far.

|||

If you are working with SRS and need to combine two CRM fields together, but having each on its own line, use the following expression:

=Fields!ShipToName.Value & vbCRLF & Fields!ShipToAddress.Value

vbCRLF is a special system constant that contains the values of carriage return and line feed characters.

- Mitch Milam’s Microsoft Discussions

|||

Hi All,

thanks for the tips...will try both....

Peter

|||

Hi Simone,

some of the fields are numbers and from memory it complained about the plus sign when there was a mixture of numeric and string fields...but I will try again.

Thanks

Peter