Max length of textbox.

I want to display 1 million characters in a SQL Server Report's text box, but it is only showing 32000 charcters....how can I display all 1 million character without any truncation.

Question #1: Why in the world would you want to do that?

Question #2: Did you count all 32000 characters?

Answer to your question: you can't.

|||The count is approximated to 32000
Client is the King! and it is his requirment....
|||Can I use Custom Report Item to achive this?
|||Why don't you put many textboxes side by side with no border?

sql

Max Connections

On a SQL 2005 server I have set the max user connections to 500 and
restarted the SQL Services. The server is showing this as the current
running value.
However the user connections is reporting over 30,000 and sp_who
returns over 150 with the majority of these listed as sleeping.
Why is there difference between the values returned?You are comparing the results of sp_who and what else? Where
are you getting the user connections from?
If you are using @.@.connections, that is the number of
connections and attempted connections since SQL Server
started. It will not correlated to sp_who.
-Sue
On 24 Aug 2006 06:44:11 -0700, robin9876@.hotmail.com wrote:

>On a SQL 2005 server I have set the max user connections to 500 and
>restarted the SQL Services. The server is showing this as the current
>running value.
>However the user connections is reporting over 30,000 and sp_who
>returns over 150 with the majority of these listed as sleeping.
>Why is there difference between the values returned?|||It was a MoM rule which appears to be reporting all connections and
comparing at against concurrent connections.
Sue Hoegemeier wrote:[vbcol=seagreen]
> You are comparing the results of sp_who and what else? Where
> are you getting the user connections from?
> If you are using @.@.connections, that is the number of
> connections and attempted connections since SQL Server
> started. It will not correlated to sp_who.
> -Sue
> On 24 Aug 2006 06:44:11 -0700, robin9876@.hotmail.com wrote:
>|||But that doesn't answer what it's using. I don't have MOM
running where I'm at and don't remember all the details of
what runs what but there is a way to view what it's using.
Otherwise you can use Profiler and see what MOM is executing
when it checks your SQL Server.
-Sue
On 25 Aug 2006 01:32:13 -0700, robin9876@.hotmail.com wrote:
[vbcol=seagreen]
>It was a MoM rule which appears to be reporting all connections and
>comparing at against concurrent connections.
>
>Sue Hoegemeier wrote:

Matrix Subtotal is not summing

Hi,
I got a matrix, and a subtotal column (R-click on the column field, and
select "subtotal"), but at runtime the column is showing the value of the
first column, Matrix Subtotal is not summing.
Why is that.. ?
help please.
the same is when i make a subtotal for rows...I solved using SUM() in the data field of the matrix.
Tx.
"JuanCG_Col" wrote:
> Hi,
> I got a matrix, and a subtotal column (R-click on the column field, and
> select "subtotal"), but at runtime the column is showing the value of the
> first column, Matrix Subtotal is not summing.
> Why is that.. ?
> help please.
> the same is when i make a subtotal for rows...

Matrix Sub Total

Hi Experts...
I am using a matrix report. I am showing the subtotals of one of the columns
and it is comming correctly on the Right hand side of the column. My problem
is that I want the sub total to appear on the Left hand side of the selected
column insted of the Right side.
Is there any quick way of achieving this? Can anybody give a suggestion for
this?
Thanks
GaneshHi, Ganesh.
On the upper right corner of the subtotal cell, you should see a green
triangle.
Right-click over that triangle and select "Properties" (it should be
the only option enabled).
Then look for a property named "Position" set to the value "After".
You can switch it to "Before" and voil=E1. :)
Regards, Paulo Cunha|||thanks Paulo for the reply..it was really helpful
"Paulo X" <pjmcunha@.gmail.com> wrote in message
news:1141646924.794781.114380@.j33g2000cwa.googlegroups.com...
Hi, Ganesh.
On the upper right corner of the subtotal cell, you should see a green
triangle.
Right-click over that triangle and select "Properties" (it should be
the only option enabled).
Then look for a property named "Position" set to the value "After".
You can switch it to "Before" and voilá. :)
Regards,
Paulo Cunhasql

matrix showing wrong totals

Going bonkers here. I have a matrix that displays total referrals by month
for the year. Two months, Feb and April are off by 1 when I view the matrix,
but other months show correct amt. when just doing a simple query with same
criteria, the dataset is correct. I've looked at the data countless times
but cannot deterine where the issue is. Possible matrix problem? anyone seem
results llike this?
HELP!more food for thought. I changed the query a bit. rather than selecting all
companies who referred to us, I selected just one. Results were accurate with
just one referrer. I'm still perplexed though...
"Brian L" wrote:
> Going bonkers here. I have a matrix that displays total referrals by month
> for the year. Two months, Feb and April are off by 1 when I view the matrix,
> but other months show correct amt. when just doing a simple query with same
> criteria, the dataset is correct. I've looked at the data countless times
> but cannot deterine where the issue is. Possible matrix problem? anyone seem
> results llike this?
> HELP!|||are you using olap or relational?
sounds like a standard olap situation where you need to write some
crazy-ass MDX statement
-Aaron
Brian L wrote:
> more food for thought. I changed the query a bit. rather than selecting all
> companies who referred to us, I selected just one. Results were accurate with
> just one referrer. I'm still perplexed though...
> "Brian L" wrote:
> > Going bonkers here. I have a matrix that displays total referrals by month
> > for the year. Two months, Feb and April are off by 1 when I view the matrix,
> > but other months show correct amt. when just doing a simple query with same
> > criteria, the dataset is correct. I've looked at the data countless times
> > but cannot deterine where the issue is. Possible matrix problem? anyone seem
> > results llike this?
> >
> > HELP!

Matrix Report Not Showing All Columns

I have a matrix report that I am using with MonthName(Fields!Month.Value) across the top of the report. However, when there is no data under the column, the month is skipped. So, for example, I get this:

January March

Actual Goal Actual Goal

25 25 30 35

I have tried adding

iif(Sum(Fields!Total.Value, "DatasetName")> 0, Sum(Fields!Total.Value, "DatasetName"),"N/A")

But it still is not showing up.

Any ideas?

Thanks,

SHP

SHP,

You will need to make sure in your SQL statement you are returning data for that month. If there is no data then you will need to return "Zero" and or "Spaces"

Ham

|||

Thanks, Ham.

Yeah, I set up the month table in the stored procedure and then returned isnull(datafield,0) and that took care of the problem.

Thanks for your help. I found a similiar question that directed the person to the SQL statement and realized that was where I needed to make my changes.

Thanks again.

SHP

|||

Not a problem glad to help,

Also can you mark my reply as answer so I can get credit for the solution. Thanks.

Ham

|||Sure. No problem.sql

Matrix Percentage Column ( Column 2 vs Column 1)

Need help with calculating percentage column in a matrix.

2005 2006

Jan 10 15

Feb 20 25

Need to add column showing variance :

Var Var

Jan 10 15 50%

Feb 20 25 25%

Any help would be appreciated....

Hi. Did you manage to get the result.I also have the similar case. If you have solved can you plz help me out.

Matrix Percentage Column ( Column 2 vs Column 1)

Need help with calculating percentage column in a matrix.

2005 2006

Jan 10 15

Feb 20 25

Need to add column showing variance :

Var Var

Jan 10 15 50%

Feb 20 25 25%

Any help would be appreciated....

Hi. Did you manage to get the result.I also have the similar case. If you have solved can you plz help me out.

Matrix columns

Hi,
I have a report which is showing monthly sales figures on a matrix. the Rows
are grouped by year and product and the Columns grouped by month. What i
would like to achieve now is to add a column between each month column to
show the % increase between the months.
so that the report looks something like:
Year JAN % diff FEB %diff
MAR ......
2004
Product A 10 100% 5 0%
5 ......
Product B .....
...
2003....
...
regards,You could put a rectangle which has two textboxs in the data cell. One
textbox is for sum of sales and another for percentage of increase. In
column header, do same things to show different title.
Regards,
Henry
"Kazar" <kazar@.kazar.kaz> wrote in message
news:uO%23kdK0lEHA.2880@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have a report which is showing monthly sales figures on a matrix. the
> Rows
> are grouped by year and product and the Columns grouped by month. What i
> would like to achieve now is to add a column between each month column to
> show the % increase between the months.
> so that the report looks something like:
> Year JAN % diff FEB %diff
> MAR ......
> 2004
> Product A 10 100% 5 0%
> 5 ......
> Product B .....
> ...
> 2003....
> ...
>
> regards,
>

Matrix - adding a column for calculating difference

I have a report showing registered hours (invoicable, not invoicable and
total) for the last 3 weeks this year and last year. It looks something like
this:
...............Invoicable hours.........Not invoicable
.........Total
..................2005|2004..............2005|2004............2005|2004
Week
1............12|...13..................5|..10...............17|...23
Week
2............10|...12..................6|..12...............16|...24
Week
3............15|...14..................7|..14...............22|...28
Total...............37|...39.................12|...36...............55|...75
Row groups: Weeks.
Column groups: [Static group], Years
So far, so good. But I'm supposed to add an extra column for each column,
called "Difference". Which is this year - last year's numbers for each of
the different sets of numbers. And I can't figure out how.
I've added a column to the right of my first column, and my current matrix
looks like this:
............Invoicable hours...Difference....Not invoicable
.........Total
...............2005|2004......2005|2004....2005|2004............2005|2004
Week
1.........12|...13.........-1|..-1.........5|..10...............17|...23
Week
2.........10|...12.........-2|..-2.........6|..12...............16|...24
Week
3.........15|...14..........1|...1.........7|..14...............22|...28
Total............37|...39..........-2|..-2.......12|...36...............55|...75
And I need to suppress one row of numbers in the difference column in some
way. Is this possible? How? Add a new column group or do some conditional
visibility check?
All help appreciated!!!
Kaisa M. LindahlHi Kaisa,
Did you manage to get the Totals working, I am facing a similiar problem &
wanted to check how did u manage to do it.
Thanks
"Kaisa M. Lindahl" <kaisaml@.hotmail.com> wrote in message
news:uHTZOT6BGHA.1088@.tk2msftngp13.phx.gbl...
>I have a report showing registered hours (invoicable, not invoicable and
>total) for the last 3 weeks this year and last year. It looks something
>like this:
> ...............Invoicable hours.........Not invoicable
> .........Total
> ..................2005|2004..............2005|2004............2005|2004
> Week
> 1............12|...13..................5|..10...............17|...23
> Week
> 2............10|...12..................6|..12...............16|...24
> Week
> 3............15|...14..................7|..14...............22|...28
> Total...............37|...39.................12|...36...............55|...75
> Row groups: Weeks.
> Column groups: [Static group], Years
> So far, so good. But I'm supposed to add an extra column for each column,
> called "Difference". Which is this year - last year's numbers for each of
> the different sets of numbers. And I can't figure out how.
> I've added a column to the right of my first column, and my current matrix
> looks like this:
> ............Invoicable hours...Difference....Not invoicable
> .........Total
> ...............2005|2004......2005|2004....2005|2004............2005|2004
> Week
> 1.........12|...13.........-1|..-1.........5|..10...............17|...23
> Week
> 2.........10|...12.........-2|..-2.........6|..12...............16|...24
> Week
> 3.........15|...14..........1|...1.........7|..14...............22|...28
> Total............37|...39..........-2|..-2.......12|...36...............55|...75
> And I need to suppress one row of numbers in the difference column in some
> way. Is this possible? How? Add a new column group or do some conditional
> visibility check?
> All help appreciated!!!
> Kaisa M. Lindahl
>|||I got the total for the 4 weeks by right-clicking the Row group (Weeks) and
clicked Subtotals.
Then I changed the formula for the =Fields!Measures_Invoicable.Value to
=SUM(Fields!Measures_Invoicable.Value).
Then I added a Subtotal on the Year column group, and changed the column
name to Difference.
I then changed the formula again to check for "direction" and do the right
calculation based on the scope
=IIF(InScope("matrix2_DateWeek_Year"),
SUM(Fields!Measures_Billable_Hours.Value),
(First(Fields!Measures_Billable_Hours.Value, "matrix2_DateWeek_Week") -
Last(Fields!Measures_Billable_Hours.Value, "matrix2_DateWeek_Week")))
Meaning -
If I'm in the bottom (total) row for weeks, it will give me this, and if I'm
going from left to right, I get the difference between numbers for this year
and last year.
Unfortunately, it will now also try to calculate the total of the
difference. But it fails, giving me this:
Invoicable hours
2005 2004 Difference
Week 44 33 30 3
Week 43 20 7 13
Week 42 30 59 -30
Week 41 37 43 -6
Total 120 140 7
Any suggestions on what I can do to make the number in the yellow section
(7) turn out right or just hide the number? Right should be -20, not 7.
(can't figure out how this turns into 7.)
Kaisa
"Vishal" <vrajput77@.hotmail.com> wrote in message
news:O1m6rF$CGHA.1312@.TK2MSFTNGP09.phx.gbl...
> Hi Kaisa,
> Did you manage to get the Totals working, I am facing a similiar problem &
> wanted to check how did u manage to do it.
> Thanks
> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> wrote in message
> news:uHTZOT6BGHA.1088@.tk2msftngp13.phx.gbl...
>>I have a report showing registered hours (invoicable, not invoicable and
>>total) for the last 3 weeks this year and last year. It looks something
>>like this:
>> ...............Invoicable hours.........Not invoicable
>> .........Total
>> ..................2005|2004..............2005|2004............2005|2004
>> Week
>> 1............12|...13..................5|..10...............17|...23
>> Week
>> 2............10|...12..................6|..12...............16|...24
>> Week
>> 3............15|...14..................7|..14...............22|...28
>> Total...............37|...39.................12|...36...............55|...75
>> Row groups: Weeks.
>> Column groups: [Static group], Years
>> So far, so good. But I'm supposed to add an extra column for each column,
>> called "Difference". Which is this year - last year's numbers for each of
>> the different sets of numbers. And I can't figure out how.
>> I've added a column to the right of my first column, and my current
>> matrix looks like this:
>> ............Invoicable hours...Difference....Not invoicable
>> .........Total
>> ...............2005|2004......2005|2004....2005|2004............2005|2004
>> Week
>> 1.........12|...13.........-1|..-1.........5|..10...............17|...23
>> Week
>> 2.........10|...12.........-2|..-2.........6|..12...............16|...24
>> Week
>> 3.........15|...14..........1|...1.........7|..14...............22|...28
>> Total............37|...39..........-2|..-2.......12|...36...............55|...75
>> And I need to suppress one row of numbers in the difference column in
>> some way. Is this possible? How? Add a new column group or do some
>> conditional visibility check?
>> All help appreciated!!!
>> Kaisa M. Lindahl
>