I am new to reporting services, so forgive me if this is a simple question.
I have a simple report with 2 levels of grouping such as this:
Group 1
-Group 2
-item 1
-Item 2
I want to add a RowNumber to show the number (1, 2, 3, etc) before each item
within Group 2. I read the help and it said to use RowNumber(Scope) where
scope is the name of the grouping. However, any time I put the name of the
group in, I get an error. How do I refer to the group? I'm using this:
=RowNumber(First(Fields!Objective.Value, "DonorTrac_v3"))
RowNumber (Nothing) gives me the number for the outer group, but i want the
numbers in the inner group.
Any help you can provide is appreciated. Thanks!=RowNumber("Group 2")
Put the group name in double quotes!
Charles Kangai, MCDBA, MCT
"giggleraz" wrote:
> I am new to reporting services, so forgive me if this is a simple question.
> I have a simple report with 2 levels of grouping such as this:
> Group 1
> -Group 2
> -item 1
> -Item 2
> I want to add a RowNumber to show the number (1, 2, 3, etc) before each item
> within Group 2. I read the help and it said to use RowNumber(Scope) where
> scope is the name of the grouping. However, any time I put the name of the
> group in, I get an error. How do I refer to the group? I'm using this:
> =RowNumber(First(Fields!Objective.Value, "DonorTrac_v3"))
> RowNumber (Nothing) gives me the number for the outer group, but i want the
> numbers in the inner group.
> Any help you can provide is appreciated. Thanks!|||ah-hah! Thank you :)
"giggleraz" wrote:
> I am new to reporting services, so forgive me if this is a simple question.
> I have a simple report with 2 levels of grouping such as this:
> Group 1
> -Group 2
> -item 1
> -Item 2
> I want to add a RowNumber to show the number (1, 2, 3, etc) before each item
> within Group 2. I read the help and it said to use RowNumber(Scope) where
> scope is the name of the grouping. However, any time I put the name of the
> group in, I get an error. How do I refer to the group? I'm using this:
> =RowNumber(First(Fields!Objective.Value, "DonorTrac_v3"))
> RowNumber (Nothing) gives me the number for the outer group, but i want the
> numbers in the inner group.
> Any help you can provide is appreciated. Thanks!
Showing posts with label reporting. Show all posts
Showing posts with label reporting. Show all posts
Friday, March 30, 2012
Wednesday, March 28, 2012
Rowcount reporting incorrectly...
Why when I double click my table, does the "Rows"
field show 10 records, but when I do a SELECT COUNT(id)
it show me the right amount?
SQL 2000 Enterprise, Windows 2003
I've run DBCC CHECKALLOC, UPDATEUSAGE, DBREPAIR, SHOWCONTIG,
INDEXDEFRAG...etc.
I've never heard of this before.EM caches alot of information. Did you try refreshing the data? Exit
and restart EM and see if the problem still appears.|||DBCC UPDATEUSAGE may improve the accuracy of this number, but it would have
to be executed each time you want to look at the number. Read up on
statistics; how they are used and when they are updated.
"isideveloper" <isideveloper@.newsgroups.nospam> wrote in message
news:uwKyfr4RGHA.776@.TK2MSFTNGP09.phx.gbl...
> Why when I double click my table, does the "Rows"
> field show 10 records, but when I do a SELECT COUNT(id)
> it show me the right amount?
> SQL 2000 Enterprise, Windows 2003
> I've run DBCC CHECKALLOC, UPDATEUSAGE, DBREPAIR, SHOWCONTIG,
> INDEXDEFRAG...etc.
> I've never heard of this before.
>|||... and it has to be executed using the COUNT_ROWS option (which mean it wi
ll take a longer
time...).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"JT" <someone@.microsoft.com> wrote in message news:e6vBNy4RGHA.5036@.TK2MSFTNGP12.phx.gbl...
> DBCC UPDATEUSAGE may improve the accuracy of this number, but it would hav
e to be executed each
> time you want to look at the number. Read up on statistics; how they are u
sed and when they are
> updated.
>
> "isideveloper" <isideveloper@.newsgroups.nospam> wrote in message
> news:uwKyfr4RGHA.776@.TK2MSFTNGP09.phx.gbl...
>sql
field show 10 records, but when I do a SELECT COUNT(id)
it show me the right amount?
SQL 2000 Enterprise, Windows 2003
I've run DBCC CHECKALLOC, UPDATEUSAGE, DBREPAIR, SHOWCONTIG,
INDEXDEFRAG...etc.
I've never heard of this before.EM caches alot of information. Did you try refreshing the data? Exit
and restart EM and see if the problem still appears.|||DBCC UPDATEUSAGE may improve the accuracy of this number, but it would have
to be executed each time you want to look at the number. Read up on
statistics; how they are used and when they are updated.
"isideveloper" <isideveloper@.newsgroups.nospam> wrote in message
news:uwKyfr4RGHA.776@.TK2MSFTNGP09.phx.gbl...
> Why when I double click my table, does the "Rows"
> field show 10 records, but when I do a SELECT COUNT(id)
> it show me the right amount?
> SQL 2000 Enterprise, Windows 2003
> I've run DBCC CHECKALLOC, UPDATEUSAGE, DBREPAIR, SHOWCONTIG,
> INDEXDEFRAG...etc.
> I've never heard of this before.
>|||... and it has to be executed using the COUNT_ROWS option (which mean it wi
ll take a longer
time...).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"JT" <someone@.microsoft.com> wrote in message news:e6vBNy4RGHA.5036@.TK2MSFTNGP12.phx.gbl...
> DBCC UPDATEUSAGE may improve the accuracy of this number, but it would hav
e to be executed each
> time you want to look at the number. Read up on statistics; how they are u
sed and when they are
> updated.
>
> "isideveloper" <isideveloper@.newsgroups.nospam> wrote in message
> news:uwKyfr4RGHA.776@.TK2MSFTNGP09.phx.gbl...
>sql
Friday, March 23, 2012
row too long when exporting to PDF
if I have a table with 3 rows and 3 columns and the columns are wide so that
2 columns just fit on one page.By default reporting server, when exporting to
PDF, puts first 3 rows and 2 columns on one page and last column for all the
rows on second
first page:
header1 header2
1row 1col 1row 2 col
2row 1 col 2row 2 col
second page:
header 3
1 row 3 col
2 row 3 col
Is it possible to do so that it splits the data for all rows separately:
header 1 header 2
1 row 1 col 1 row 2 col
header 3
1 row 3 col
header 1 header 2
2 row 1 col 2 row 2 col
header 3
2 row 3 colOn May 16, 9:49 am, pardik <par...@.discussions.microsoft.com> wrote:
> if I have a table with 3 rows and 3 columns and the columns are wide so that
> 2 columns just fit on one page.By default reporting server, when exporting to
> PDF, puts first 3 rows and 2 columns on one page and last column for all the
> rows on second
> first page:
> header1 header2
> 1row 1col 1row 2 col
> 2row 1 col 2row 2 col
> second page:
> header 3
> 1 row 3 col
> 2 row 3 col
> Is it possible to do so that it splits the data for all rows separately:
> header 1 header 2
> 1 row 1 col 1 row 2 col
> header 3
> 1 row 3 col
> header 1 header 2
> 2 row 1 col 2 row 2 col
> header 3
> 2 row 3 col
You might try grouping on a report item at the row level. Then set
'Page break at end' as part of the grouping. If this does not work,
you could try using a matrix control and rearranging your dataset
(query/stored procedure) output to format the matrix in the above
format. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant
2 columns just fit on one page.By default reporting server, when exporting to
PDF, puts first 3 rows and 2 columns on one page and last column for all the
rows on second
first page:
header1 header2
1row 1col 1row 2 col
2row 1 col 2row 2 col
second page:
header 3
1 row 3 col
2 row 3 col
Is it possible to do so that it splits the data for all rows separately:
header 1 header 2
1 row 1 col 1 row 2 col
header 3
1 row 3 col
header 1 header 2
2 row 1 col 2 row 2 col
header 3
2 row 3 colOn May 16, 9:49 am, pardik <par...@.discussions.microsoft.com> wrote:
> if I have a table with 3 rows and 3 columns and the columns are wide so that
> 2 columns just fit on one page.By default reporting server, when exporting to
> PDF, puts first 3 rows and 2 columns on one page and last column for all the
> rows on second
> first page:
> header1 header2
> 1row 1col 1row 2 col
> 2row 1 col 2row 2 col
> second page:
> header 3
> 1 row 3 col
> 2 row 3 col
> Is it possible to do so that it splits the data for all rows separately:
> header 1 header 2
> 1 row 1 col 1 row 2 col
> header 3
> 1 row 3 col
> header 1 header 2
> 2 row 1 col 2 row 2 col
> header 3
> 2 row 3 col
You might try grouping on a report item at the row level. Then set
'Page break at end' as part of the grouping. If this does not work,
you could try using a matrix control and rearranging your dataset
(query/stored procedure) output to format the matrix in the above
format. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant
Tuesday, March 20, 2012
Row Level Security
Hello,
I want to implement row level security using sql server reporting
services.
I noticed another post asking the same question and the same subject
line, but it recieved no proper answer.
My situation is the same as his - I need to seperate data according to
the client user name, from the same table.
The internet system i am building, will need to handle many users,
which can't see each other's records, but their data is stored at the
same table.
Here is a link to the other post on the same subject, i find it not
relevant to post the same thing twice.
http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/messages/110300aa490910ed,de31f976623b6c89,3c78bd588c6aba03,f67dcd82d3646a3a,4761bb89bab82df9,448882c85246ac99?thread_id=f623781fb429616f&mode=thread&noheader=1&q=row+security#doc_110300aa490910ed
Thanks in advance,
ShlomoCan you use User!UserID.Value as a join key instead of Suser_Sname() as you
might do in T-SQL
I haven't test User! so I do not know whose id it is but I beleive it is
intended to be the report requestor (when using trusted security)
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
<shlomoid@.gmail.com> wrote in message
news:1108300806.467922.236190@.o13g2000cwo.googlegroups.com...
> Hello,
> I want to implement row level security using sql server reporting
> services.
> I noticed another post asking the same question and the same subject
> line, but it recieved no proper answer.
> My situation is the same as his - I need to seperate data according to
> the client user name, from the same table.
> The internet system i am building, will need to handle many users,
> which can't see each other's records, but their data is stored at the
> same table.
> Here is a link to the other post on the same subject, i find it not
> relevant to post the same thing twice.
> http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/messages/110300aa490910ed,de31f976623b6c89,3c78bd588c6aba03,f67dcd82d3646a3a,4761bb89bab82df9,448882c85246ac99?thread_id=f623781fb429616f&mode=thread&noheader=1&q=row+security#doc_110300aa490910ed
> Thanks in advance,
> Shlomo
>|||Thanks alot for the answer, this really does seem like something that
will prove to be usefull.
I have but another extension to this question:
The reporting services server does not provide authentication, only
authorization (as the rs books online state).
That means, that i need to create a user on the machine, a real windows
user, for each internet user i want to recieve some sort of
authorization.
This is of course a source of many problems, such as kinds of security
issues.
What is the common practice in this scenario?
How can i implement my own authentication mechanizm? And should I?
Thanks again,
Shlomo
I want to implement row level security using sql server reporting
services.
I noticed another post asking the same question and the same subject
line, but it recieved no proper answer.
My situation is the same as his - I need to seperate data according to
the client user name, from the same table.
The internet system i am building, will need to handle many users,
which can't see each other's records, but their data is stored at the
same table.
Here is a link to the other post on the same subject, i find it not
relevant to post the same thing twice.
http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/messages/110300aa490910ed,de31f976623b6c89,3c78bd588c6aba03,f67dcd82d3646a3a,4761bb89bab82df9,448882c85246ac99?thread_id=f623781fb429616f&mode=thread&noheader=1&q=row+security#doc_110300aa490910ed
Thanks in advance,
ShlomoCan you use User!UserID.Value as a join key instead of Suser_Sname() as you
might do in T-SQL
I haven't test User! so I do not know whose id it is but I beleive it is
intended to be the report requestor (when using trusted security)
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
<shlomoid@.gmail.com> wrote in message
news:1108300806.467922.236190@.o13g2000cwo.googlegroups.com...
> Hello,
> I want to implement row level security using sql server reporting
> services.
> I noticed another post asking the same question and the same subject
> line, but it recieved no proper answer.
> My situation is the same as his - I need to seperate data according to
> the client user name, from the same table.
> The internet system i am building, will need to handle many users,
> which can't see each other's records, but their data is stored at the
> same table.
> Here is a link to the other post on the same subject, i find it not
> relevant to post the same thing twice.
> http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/messages/110300aa490910ed,de31f976623b6c89,3c78bd588c6aba03,f67dcd82d3646a3a,4761bb89bab82df9,448882c85246ac99?thread_id=f623781fb429616f&mode=thread&noheader=1&q=row+security#doc_110300aa490910ed
> Thanks in advance,
> Shlomo
>|||Thanks alot for the answer, this really does seem like something that
will prove to be usefull.
I have but another extension to this question:
The reporting services server does not provide authentication, only
authorization (as the rs books online state).
That means, that i need to create a user on the machine, a real windows
user, for each internet user i want to recieve some sort of
authorization.
This is of course a source of many problems, such as kinds of security
issues.
What is the common practice in this scenario?
How can i implement my own authentication mechanizm? And should I?
Thanks again,
Shlomo
Saturday, February 25, 2012
Round 2...
I am VERY new to reporting services, so I think this should be an easy one.
I created a simple report that uses a SPROC as the dataset. There are 2
input parameters for the SPROC...
1) a Dealer number
2) a Inventory number.
The dealers are uploading pictures of the inventory items onto my server
into a folder.
The structure of the folder is as follows.
http://mywebsite.com/dealers/DEALER NUMBER/invetorypics/INVENTORY NUMBER.jpg
I am reposting - nobody answered the first time...
I have code so when the dealer uploads a picture of the piece of invetory,
the inventory number becomes the name of the image.
Example... dealer number is 1234 and the inventory number is 5678
The image is saved to this location, with this file name...
http://mywebsite.com/dealers/1234/autopics/5678.jpg
so here is my question... on a report that I run to show a specific piece of
inventory (including the image), how do I dynamically populate the "value"
property of my image control? I say dynamically, because the path of the
'value' property is built using the 2 input parameters (the user is
supplying the parameters under the covers by clicking a row in a grid).
so in the above case, the "value" property needs to be set to
http://mywebsite.com/dealers/1234/autopics/5678.jpg
Thanks in advance!
BrianSet the Image.Value property to this expression:
=http://mywebsite.com/dealers/ & Parameters!DealerNumber.Value &
"/autopics/" & Parameters!InventoryNumber.Value & ".jpg"
(the "http...dealers/" should be in quotes, but OE likes to remove quotes
and make a hyperlink)
--
Floyd
"Brian Cesafsky" <Brian.Cesafsky@.AutoTrackerPlus.com> wrote in message
news:%23d5f7QDnFHA.3544@.TK2MSFTNGP15.phx.gbl...
>I am VERY new to reporting services, so I think this should be an easy one.
> I created a simple report that uses a SPROC as the dataset. There are 2
> input parameters for the SPROC...
> 1) a Dealer number
> 2) a Inventory number.
> The dealers are uploading pictures of the inventory items onto my server
> into a folder.
> The structure of the folder is as follows.
> http://mywebsite.com/dealers/DEALER NUMBER/invetorypics/INVENTORY
> NUMBER.jpg
> I am reposting - nobody answered the first time...
>
> I have code so when the dealer uploads a picture of the piece of invetory,
> the inventory number becomes the name of the image.
> Example... dealer number is 1234 and the inventory number is 5678
> The image is saved to this location, with this file name...
> http://mywebsite.com/dealers/1234/autopics/5678.jpg
>
> so here is my question... on a report that I run to show a specific piece
> of
> inventory (including the image), how do I dynamically populate the "value"
> property of my image control? I say dynamically, because the path of the
> 'value' property is built using the 2 input parameters (the user is
> supplying the parameters under the covers by clicking a row in a grid).
> so in the above case, the "value" property needs to be set to
> http://mywebsite.com/dealers/1234/autopics/5678.jpg
> Thanks in advance!
> Brian
>
>|||I tried this, but it is not working, I don't get the image...
"Floyd Burger" <mrlements@.community.nospam> wrote in message
news:u6SnWhEnFHA.1948@.TK2MSFTNGP12.phx.gbl...
> Set the Image.Value property to this expression:
> =http://mywebsite.com/dealers/ & Parameters!DealerNumber.Value &
> "/autopics/" & Parameters!InventoryNumber.Value & ".jpg"
> (the "http...dealers/" should be in quotes, but OE likes to remove quotes
> and make a hyperlink)
> --
> Floyd
> "Brian Cesafsky" <Brian.Cesafsky@.AutoTrackerPlus.com> wrote in message
> news:%23d5f7QDnFHA.3544@.TK2MSFTNGP15.phx.gbl...
>>I am VERY new to reporting services, so I think this should be an easy
>>one.
>> I created a simple report that uses a SPROC as the dataset. There are 2
>> input parameters for the SPROC...
>> 1) a Dealer number
>> 2) a Inventory number.
>> The dealers are uploading pictures of the inventory items onto my server
>> into a folder.
>> The structure of the folder is as follows.
>> http://mywebsite.com/dealers/DEALER NUMBER/invetorypics/INVENTORY
>> NUMBER.jpg
>> I am reposting - nobody answered the first time...
>>
>> I have code so when the dealer uploads a picture of the piece of
>> invetory,
>> the inventory number becomes the name of the image.
>> Example... dealer number is 1234 and the inventory number is 5678
>> The image is saved to this location, with this file name...
>> http://mywebsite.com/dealers/1234/autopics/5678.jpg
>>
>> so here is my question... on a report that I run to show a specific piece
>> of
>> inventory (including the image), how do I dynamically populate the
>> "value"
>> property of my image control? I say dynamically, because the path of the
>> 'value' property is built using the 2 input parameters (the user is
>> supplying the parameters under the covers by clicking a row in a grid).
>> so in the above case, the "value" property needs to be set to
>> http://mywebsite.com/dealers/1234/autopics/5678.jpg
>> Thanks in advance!
>> Brian
>>
>
I created a simple report that uses a SPROC as the dataset. There are 2
input parameters for the SPROC...
1) a Dealer number
2) a Inventory number.
The dealers are uploading pictures of the inventory items onto my server
into a folder.
The structure of the folder is as follows.
http://mywebsite.com/dealers/DEALER NUMBER/invetorypics/INVENTORY NUMBER.jpg
I am reposting - nobody answered the first time...
I have code so when the dealer uploads a picture of the piece of invetory,
the inventory number becomes the name of the image.
Example... dealer number is 1234 and the inventory number is 5678
The image is saved to this location, with this file name...
http://mywebsite.com/dealers/1234/autopics/5678.jpg
so here is my question... on a report that I run to show a specific piece of
inventory (including the image), how do I dynamically populate the "value"
property of my image control? I say dynamically, because the path of the
'value' property is built using the 2 input parameters (the user is
supplying the parameters under the covers by clicking a row in a grid).
so in the above case, the "value" property needs to be set to
http://mywebsite.com/dealers/1234/autopics/5678.jpg
Thanks in advance!
BrianSet the Image.Value property to this expression:
=http://mywebsite.com/dealers/ & Parameters!DealerNumber.Value &
"/autopics/" & Parameters!InventoryNumber.Value & ".jpg"
(the "http...dealers/" should be in quotes, but OE likes to remove quotes
and make a hyperlink)
--
Floyd
"Brian Cesafsky" <Brian.Cesafsky@.AutoTrackerPlus.com> wrote in message
news:%23d5f7QDnFHA.3544@.TK2MSFTNGP15.phx.gbl...
>I am VERY new to reporting services, so I think this should be an easy one.
> I created a simple report that uses a SPROC as the dataset. There are 2
> input parameters for the SPROC...
> 1) a Dealer number
> 2) a Inventory number.
> The dealers are uploading pictures of the inventory items onto my server
> into a folder.
> The structure of the folder is as follows.
> http://mywebsite.com/dealers/DEALER NUMBER/invetorypics/INVENTORY
> NUMBER.jpg
> I am reposting - nobody answered the first time...
>
> I have code so when the dealer uploads a picture of the piece of invetory,
> the inventory number becomes the name of the image.
> Example... dealer number is 1234 and the inventory number is 5678
> The image is saved to this location, with this file name...
> http://mywebsite.com/dealers/1234/autopics/5678.jpg
>
> so here is my question... on a report that I run to show a specific piece
> of
> inventory (including the image), how do I dynamically populate the "value"
> property of my image control? I say dynamically, because the path of the
> 'value' property is built using the 2 input parameters (the user is
> supplying the parameters under the covers by clicking a row in a grid).
> so in the above case, the "value" property needs to be set to
> http://mywebsite.com/dealers/1234/autopics/5678.jpg
> Thanks in advance!
> Brian
>
>|||I tried this, but it is not working, I don't get the image...
"Floyd Burger" <mrlements@.community.nospam> wrote in message
news:u6SnWhEnFHA.1948@.TK2MSFTNGP12.phx.gbl...
> Set the Image.Value property to this expression:
> =http://mywebsite.com/dealers/ & Parameters!DealerNumber.Value &
> "/autopics/" & Parameters!InventoryNumber.Value & ".jpg"
> (the "http...dealers/" should be in quotes, but OE likes to remove quotes
> and make a hyperlink)
> --
> Floyd
> "Brian Cesafsky" <Brian.Cesafsky@.AutoTrackerPlus.com> wrote in message
> news:%23d5f7QDnFHA.3544@.TK2MSFTNGP15.phx.gbl...
>>I am VERY new to reporting services, so I think this should be an easy
>>one.
>> I created a simple report that uses a SPROC as the dataset. There are 2
>> input parameters for the SPROC...
>> 1) a Dealer number
>> 2) a Inventory number.
>> The dealers are uploading pictures of the inventory items onto my server
>> into a folder.
>> The structure of the folder is as follows.
>> http://mywebsite.com/dealers/DEALER NUMBER/invetorypics/INVENTORY
>> NUMBER.jpg
>> I am reposting - nobody answered the first time...
>>
>> I have code so when the dealer uploads a picture of the piece of
>> invetory,
>> the inventory number becomes the name of the image.
>> Example... dealer number is 1234 and the inventory number is 5678
>> The image is saved to this location, with this file name...
>> http://mywebsite.com/dealers/1234/autopics/5678.jpg
>>
>> so here is my question... on a report that I run to show a specific piece
>> of
>> inventory (including the image), how do I dynamically populate the
>> "value"
>> property of my image control? I say dynamically, because the path of the
>> 'value' property is built using the 2 input parameters (the user is
>> supplying the parameters under the covers by clicking a row in a grid).
>> so in the above case, the "value" property needs to be set to
>> http://mywebsite.com/dealers/1234/autopics/5678.jpg
>> Thanks in advance!
>> Brian
>>
>
Tuesday, February 21, 2012
Rotate Text
Hai
Iam in need to rotate text in reporting services.i can able to find only two options in writingmode property for a textbox namely lr-tb (left right-top bottom) and tb-rl(top bottom-right left)..
i need full text rotation (bottom top-right left) is there any way..
let please give your precious suggestions
thnx
-
Senthil
I have the same problem... Please let me know if you have found a solution. Thanks|||Sorry - The chart control is the only control that rotates text (it does this automatically). Text rotation is not supported anywhere else.|||I also have the same problem. I need to have the text in a textbox on a report go bt-rl. I wish there were an option for this. We are using this for addresses on a form that will show through windowed envelopes.
Rotate Text
Hai
Iam in need to rotate text in reporting services.i can able to find only two options in writingmode property for a textbox namely lr-tb (left right-top bottom) and tb-rl(top bottom-right left)..
i need full text rotation (bottom top-right left) is there any way..
let please give your precious suggestions
thnx
-
Senthil
I have the same problem... Please let me know if you have found a solution. Thanks|||Sorry - The chart control is the only control that rotates text (it does this automatically). Text rotation is not supported anywhere else.|||I also have the same problem. I need to have the text in a textbox on a report go bt-rl. I wish there were an option for this. We are using this for addresses on a form that will show through windowed envelopes.
Rotate Text
Hai
Iam in need to rotate text in reporting services.i can able to find only two options in writingmode property for a textbox namely lr-tb (left right-top bottom) and tb-rl(top bottom-right left)..
i need full text rotation (bottom top-right left) is there any way..
let please give your precious suggestions
thnx
-
Senthil
I have the same problem... Please let me know if you have found a solution. Thanks|||Sorry - The chart control is the only control that rotates text (it does this automatically). Text rotation is not supported anywhere else.|||I also have the same problem. I need to have the text in a textbox on a report go bt-rl. I wish there were an option for this. We are using this for addresses on a form that will show through windowed envelopes.
Rotate table?
Hi,
I'm searching how I can 'rotate' a table in Reporting Services. Now I have drawn a table like this:
- header
- detail --
--footer--
This will result in vertical grown when there are more details found. I want that the table grows horizontally, like this:
| | |
H D F
E E O
A T O
D A T
E I E
R L R
| | |
(Pffw, talking about ASCII art :) )
How would I do this? Thanks for any clarification.
You can try using a matrix instead of table. The header would be the static row header, the detail would be the column groupings (you'll need to group on a field that's unique across different rows if you want each data row to show up as a column), and you can put the footer in the subtotal column (you may need to use the InScope() function in order to display different contents than the details).
Subscribe to:
Posts (Atom)