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 Length of "Text" and "Varchar"

I'm trying to save a memo to a database..
Right now it's declared as "text"
what's the max size of that?2,147,483,647 bytes

MAX COUNT

I have a data set with a list of text values for a survey.
Survey Response Text
54548 More than once a week
84318 More than once a week
81367 Once a week
87186 More than once a week
44987 Twice a week
84938 Twice a week
I've put them into a matrix to display the reponse count.
Response Text Count
More than once a week 3
Twice a week 2
Once a week 1
To do this I used: =COUNT(Fields!ResponseText.Value)
Now what I need to do is make a one-line table/matrix with only the maximum count value of the Response Text that looks something like this:
Response Text Count
More than once a week 3
Unfortunately, I can't do MAX(COUNT(Fields!ResponseText.Value)). MAX(Fields!ResponseText.Value) just gives me the largest string value. Is there a way I can achieve this without creating an additional dataset just to pull the maximum count value in?
Any help would be appreciated.
Thanks,
TedI'm afraid not. Aggregates of aggregates is on our wishlist for a future
version, but for now you'd need to either have a separate data set like you
describe or you could include the counts in your base data set (and do the
max in the report).
However, since you seem to be showing only the aggregates in your matrix
(and none of the details), you could just do this:
select ResponseText, Count(SurveyID) as RespCount from Surveys Group By
ResponseText
And then your grand total would be: =Max(Fields!RespCount.Value)
In fact, you could just put that into the data cell of the matrix (since the
max of one item is that item) and then add a subtotal to the matrix.
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"Ted" <Ted@.discussions.microsoft.com> wrote in message
news:EF2AC082-1DBE-4DF5-854F-F671DB674D5E@.microsoft.com...
> I have a data set with a list of text values for a survey.
> Survey Response Text
> 54548 More than once a week
> 84318 More than once a week
> 81367 Once a week
> 87186 More than once a week
> 44987 Twice a week
> 84938 Twice a week
> I've put them into a matrix to display the reponse count.
> Response Text Count
> More than once a week 3
> Twice a week 2
> Once a week 1
> To do this I used: =COUNT(Fields!ResponseText.Value)
> Now what I need to do is make a one-line table/matrix with only the
maximum count value of the Response Text that looks something like this:
> Response Text Count
> More than once a week 3
> Unfortunately, I can't do MAX(COUNT(Fields!ResponseText.Value)).
MAX(Fields!ResponseText.Value) just gives me the largest string value. Is
there a way I can achieve this without creating an additional dataset just
to pull the maximum count value in?
> Any help would be appreciated.
> Thanks,
> Ted

Matrix Sub-Totals

Hi,
I have one column group and 2 columns (one Amount & other Text) under
it in a matrix. I added subtotal to that column group and now Amount
total appears fine but first TEXT value appears in total coloumn. I
would like to hide the TEXT value appearing in Subtotal column.
I sure there are lot of threads addressing this sub-total issue but i
was unable to find answer for my query.
Any help would be appreciated.
-SGYou must use the InScope function if you only want text to be displayed in
the details and not the subtotal. There was another posting addressing this
issue. I use something like the following in the expression :
=iif(inscope("ProductGroup"),first(Fields!Price.value,"ProductGroup"),nothing)
"SG" wrote:
> Hi,
> I have one column group and 2 columns (one Amount & other Text) under
> it in a matrix. I added subtotal to that column group and now Amount
> total appears fine but first TEXT value appears in total coloumn. I
> would like to hide the TEXT value appearing in Subtotal column.
> I sure there are lot of threads addressing this sub-total issue but i
> was unable to find answer for my query.
> Any help would be appreciated.
> -SG
>|||Dawie wrote:
> You must use the InScope function if you only want text to be displayed in
> the details and not the subtotal. There was another posting addressing this
> issue. I use something like the following in the expression :
> =iif(inscope("ProductGroup"),first(Fields!Price.value,"ProductGroup"),nothing)
>
> "SG" wrote:
> > Hi,
> >
> > I have one column group and 2 columns (one Amount & other Text) under
> > it in a matrix. I added subtotal to that column group and now Amount
> > total appears fine but first TEXT value appears in total coloumn. I
> > would like to hide the TEXT value appearing in Subtotal column.
> >
> > I sure there are lot of threads addressing this sub-total issue but i
> > was unable to find answer for my query.
> > Any help would be appreciated.
> >
> > -SG
> >
> >Where can i write the Expression for the subtotal?
Actually i am struggling to find a way to find where i can write the
Expression for SubTotal?

Matrix report with Commant type Text - cannot set OR condition

I have a matrix report that uses a Dataset of Command type - Text. I am
trying to set an OR condition but I am not able to - it defaults to AND. The
field in the filters is disabled in both the DataSet > Edit SElected Dataset
and Layout > Table > Properties.
Is there a way to specify the OR condition?
ThanksOn Feb 5, 3:55 pm, "shikarishambu" <shikarishamb...@.hotmail.com>
wrote:
> I have a matrix report that uses a Dataset of Command type - Text. I am
> trying to set an OR condition but I am not able to - it defaults to AND. The
> field in the filters is disabled in both the DataSet > Edit SElected Dataset
> and Layout > Table > Properties.
> Is there a way to specify the OR condition?
> Thanks
I'm not sure if I quite follow you. In terms of the Layout >> Table >>
Properties, the only option available for Fields is 'And.' For Dataset
>> Edit Selected Dataset, for the Filter tab, the same is also true.
In this case, the Command Type of text or Stored Procedure doesn't
really matter. It seems like you will want to create a separate
dataset for each filtering option in order to get the 'Or'
functionality. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Sorry, if i was not being clear. I have a dataset which has two date
fields - intial date and execution date. I have a parameter - for year
I want to show all rows that match the following condition
initial date_year = parm_year OR execution date_year = parm_year.
Is this not possible using the filters tab?
Thanks
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:def7007a-2bd5-4718-b21d-5540dbe4e6b0@.s8g2000prg.googlegroups.com...
> On Feb 5, 3:55 pm, "shikarishambu" <shikarishamb...@.hotmail.com>
> wrote:
>> I have a matrix report that uses a Dataset of Command type - Text. I am
>> trying to set an OR condition but I am not able to - it defaults to AND.
>> The
>> field in the filters is disabled in both the DataSet > Edit SElected
>> Dataset
>> and Layout > Table > Properties.
>> Is there a way to specify the OR condition?
>> Thanks
>
> I'm not sure if I quite follow you. In terms of the Layout >> Table >>
> Properties, the only option available for Fields is 'And.' For Dataset
>> Edit Selected Dataset, for the Filter tab, the same is also true.
> In this case, the Command Type of text or Stored Procedure doesn't
> really matter. It seems like you will want to create a separate
> dataset for each filtering option in order to get the 'Or'
> functionality. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant|||On Feb 6, 11:32 am, "shikarishambu" <shikarishamb...@.hotmail.com>
wrote:
> Sorry, if i was not being clear. I have a dataset which has two date
> fields - intial date and execution date. I have a parameter - for year
> I want to show all rows that match the following condition
> initial date_year = parm_year OR execution date_year = parm_year.
> Is this not possible using the filters tab?
> Thanks
> "EMartinez" <emartinez...@.gmail.com> wrote in message
> news:def7007a-2bd5-4718-b21d-5540dbe4e6b0@.s8g2000prg.googlegroups.com...
> > On Feb 5, 3:55 pm, "shikarishambu" <shikarishamb...@.hotmail.com>
> > wrote:
> >> I have a matrix report that uses a Dataset of Command type - Text. I am
> >> trying to set an OR condition but I am not able to - it defaults to AND.
> >> The
> >> field in the filters is disabled in both the DataSet > Edit SElected
> >> Dataset
> >> and Layout > Table > Properties.
> >> Is there a way to specify the OR condition?
> >> Thanks
> > I'm not sure if I quite follow you. In terms of the Layout >> Table >>
> > Properties, the only option available for Fields is 'And.' For Dataset
> >> Edit Selected Dataset, for the Filter tab, the same is also true.
> > In this case, the Command Type of text or Stored Procedure doesn't
> > really matter. It seems like you will want to create a separate
> > dataset for each filtering option in order to get the 'Or'
> > functionality. Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
Thanks for the clarification. The most effective way to do this is via
a stored procedure (Command type: StoredProcedure)/query (Command
type: text) that is sourcing the report. That way you can set the
dataset query to something like:
select xxxxx, ... from tableX where initial_date_year = @.parm_year OR
execution_date_year = @.parm_year
And then select the 'Edit Selected Dataset' [...] button on the 'Data'
tab >> 'Parameters' tab >> and for the 'Name' you should have
'@.parm_year' and then for the 'Value' select '=Parameters!
parm_year.Value' (assuming that your report parameter is named
'parm_year'). Hope this helps further.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thank you very much for the detailed explanation. Unfortunately, I am not in
a position to create sp as I not accessing the DB directly. My SSRS instance
interfaces with Microsoft Dynamics AX - which uses perspectives (models) to
expose the DB entities to SSRS.
Thanks
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:9deb4ce6-b98e-452e-b0dd-4ca5103b567f@.e10g2000prf.googlegroups.com...
> On Feb 6, 11:32 am, "shikarishambu" <shikarishamb...@.hotmail.com>
> wrote:
>> Sorry, if i was not being clear. I have a dataset which has two date
>> fields - intial date and execution date. I have a parameter - for year
>> I want to show all rows that match the following condition
>> initial date_year = parm_year OR execution date_year = parm_year.
>> Is this not possible using the filters tab?
>> Thanks
>> "EMartinez" <emartinez...@.gmail.com> wrote in message
>> news:def7007a-2bd5-4718-b21d-5540dbe4e6b0@.s8g2000prg.googlegroups.com...
>> > On Feb 5, 3:55 pm, "shikarishambu" <shikarishamb...@.hotmail.com>
>> > wrote:
>> >> I have a matrix report that uses a Dataset of Command type - Text. I
>> >> am
>> >> trying to set an OR condition but I am not able to - it defaults to
>> >> AND.
>> >> The
>> >> field in the filters is disabled in both the DataSet > Edit SElected
>> >> Dataset
>> >> and Layout > Table > Properties.
>> >> Is there a way to specify the OR condition?
>> >> Thanks
>> > I'm not sure if I quite follow you. In terms of the Layout >> Table >>
>> > Properties, the only option available for Fields is 'And.' For Dataset
>> >> Edit Selected Dataset, for the Filter tab, the same is also true.
>> > In this case, the Command Type of text or Stored Procedure doesn't
>> > really matter. It seems like you will want to create a separate
>> > dataset for each filtering option in order to get the 'Or'
>> > functionality. Hope this helps.
>> > Regards,
>> > Enrique Martinez
>> > Sr. Software Consultant
>
> Thanks for the clarification. The most effective way to do this is via
> a stored procedure (Command type: StoredProcedure)/query (Command
> type: text) that is sourcing the report. That way you can set the
> dataset query to something like:
> select xxxxx, ... from tableX where initial_date_year = @.parm_year OR
> execution_date_year = @.parm_year
> And then select the 'Edit Selected Dataset' [...] button on the 'Data'
> tab >> 'Parameters' tab >> and for the 'Name' you should have
> '@.parm_year' and then for the 'Value' select '=Parameters!
> parm_year.Value' (assuming that your report parameter is named
> 'parm_year'). Hope this helps further.
> Regards,
> Enrique Martinez
> Sr. Software Consultant|||On Feb 6, 12:32=A0pm, "shikarishambu" <shikarishamb...@.hotmail.com>
wrote:
> Sorry, if i was not being clear. I have a dataset which has two date
> fields - intial date and execution date. I have a parameter - for year
> I want to show all rows that match the following condition
> initial date_year =3D parm_year OR execution date_year =3D parm_year.
> Is this not possible using the filters tab?
> Thanks
> "EMartinez" <emartinez...@.gmail.com> wrote in message
> news:def7007a-2bd5-4718-b21d-5540dbe4e6b0@.s8g2000prg.googlegroups.com...
>
> > On Feb 5, 3:55 pm, "shikarishambu" <shikarishamb...@.hotmail.com>
> > wrote:
> >> I have a matrix report that uses a Dataset of Command type - Text. I am=
> >> trying to set an OR condition but I am not able to - it defaults to AND=.
> >> The
> >> field in the filters is disabled in both the DataSet > Edit SElected
> >> Dataset
> >> and Layout > Table > Properties.
> >> Is there a way to specify the OR condition?
> >> Thanks
> > I'm not sure if I quite follow you. In terms of the Layout >> Table >>
> > Properties, the only option available for Fields is 'And.' For Dataset
> >> Edit Selected Dataset, for the Filter tab, the same is also true.
> > In this case, the Command Type of text or Stored Procedure doesn't
> > really matter. It seems like you will want to create a separate
> > dataset for each filtering option in order to get the 'Or'
> > functionality. Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant- Hide quoted text -
> - Show quoted text -
In the "Filters" menu, you have Expression , Operator, and Value
I would suggest that you have an Expression:
=3D CBool( (Fields!InitialDateYear =3D Parameters!Year.Value )
Or ( Fields!ExecutionDateYear.Value =3D Parameters!Year.Value ) )
Operator: =3D
Value:
=3D True
This way all of the conditional OR is handled in the Expression that
returns True of False, then you filter on only the rows that are True
-- Scott|||Will try that out. Smart work around :)
"Orne" <polysillycon@.yahoo.com> wrote in message
news:27fce259-12e2-4bc0-a129-ade4a24c7148@.h11g2000prf.googlegroups.com...
On Feb 6, 12:32 pm, "shikarishambu" <shikarishamb...@.hotmail.com>
wrote:
> Sorry, if i was not being clear. I have a dataset which has two date
> fields - intial date and execution date. I have a parameter - for year
> I want to show all rows that match the following condition
> initial date_year = parm_year OR execution date_year = parm_year.
> Is this not possible using the filters tab?
> Thanks
> "EMartinez" <emartinez...@.gmail.com> wrote in message
> news:def7007a-2bd5-4718-b21d-5540dbe4e6b0@.s8g2000prg.googlegroups.com...
>
> > On Feb 5, 3:55 pm, "shikarishambu" <shikarishamb...@.hotmail.com>
> > wrote:
> >> I have a matrix report that uses a Dataset of Command type - Text. I am
> >> trying to set an OR condition but I am not able to - it defaults to
> >> AND.
> >> The
> >> field in the filters is disabled in both the DataSet > Edit SElected
> >> Dataset
> >> and Layout > Table > Properties.
> >> Is there a way to specify the OR condition?
> >> Thanks
> > I'm not sure if I quite follow you. In terms of the Layout >> Table >>
> > Properties, the only option available for Fields is 'And.' For Dataset
> >> Edit Selected Dataset, for the Filter tab, the same is also true.
> > In this case, the Command Type of text or Stored Procedure doesn't
> > really matter. It seems like you will want to create a separate
> > dataset for each filtering option in order to get the 'Or'
> > functionality. Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant- Hide quoted text -
> - Show quoted text -
In the "Filters" menu, you have Expression , Operator, and Value
I would suggest that you have an Expression:
= CBool( (Fields!InitialDateYear = Parameters!Year.Value )
Or ( Fields!ExecutionDateYear.Value = Parameters!Year.Value ) )
Operator: =
Value:
= True
This way all of the conditional OR is handled in the Expression that
returns True of False, then you filter on only the rows that are True
-- Scottsql

Matrix Filters

This is a multi-part message in MIME format.
--=_NextPart_000_001F_01C6A504.61E9EAD0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I have a parameter for displaying information from a particular = department, or from all departments. I can do the filter for a specific = department, but how do I set it up so that if the user selects all, I = basically ignore the deaprtment filter?
Thanks.
Jerry
--=_NextPart_000_001F_01C6A504.61E9EAD0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
I have a parameter for displaying = information from a particular department, or from all departments. I can do the = filter for a specific department, but how do I set it up so that if the user = selects all, I basically ignore the deaprtment filter?

Thanks.

Jerry
--=_NextPart_000_001F_01C6A504.61E9EAD0--Hi
You should use UnionAll to get all the department when u click ALL.
"rlrcstr@.newsgroups.nospam" wrote:
> I have a parameter for displaying information from a particular department, or from all departments. I can do the filter for a specific department, but how do I set it up so that if the user selects all, I basically ignore the deaprtment filter?
> Thanks|||Hi Jerry.
Thank you for your posting and thanks Calvin's suggestion.
If you are using SQL Reporting Services 2005, I think you could use
Multi-Value Parameter to implement this requirement.
For more detailed information, please try to follow this article:
Using Parameters in a Report
http://msdn2.microsoft.com/en-us/library/ms155917.aspx
Single and Multivalued Parameters
You can define a multivalued parameter by selecting the Multivalued option
in the Report Parameters dialog box. If this checkbox is not selected, the
parameter is single-valued. Specifying the Multivalued option adds
checkboxes to the available values in a parameter drop-down list in the
published report. Users can check the values they want; for example, in the
Sales Reason Comparisons sample report, users can select multiple products
to view the combined sales data for those products.
Hope this will be helpful for you!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||The issue isn't in having the user select the requirements, it's in how to
implement the selection in the matrix control's filters.
Thanks.
Jerry
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:EgZJkRYpGHA.4612@.TK2MSFTNGXA01.phx.gbl...
> Hi Jerry.
> Thank you for your posting and thanks Calvin's suggestion.
> If you are using SQL Reporting Services 2005, I think you could use
> Multi-Value Parameter to implement this requirement.
> For more detailed information, please try to follow this article:
> Using Parameters in a Report
> http://msdn2.microsoft.com/en-us/library/ms155917.aspx
> Single and Multivalued Parameters
> You can define a multivalued parameter by selecting the Multivalued option
> in the Report Parameters dialog box. If this checkbox is not selected, the
> parameter is single-valued. Specifying the Multivalued option adds
> checkboxes to the available values in a parameter drop-down list in the
> published report. Users can check the values they want; for example, in
> the
> Sales Reason Comparisons sample report, users can select multiple products
> to view the combined sales data for those products.
> Hope this will be helpful for you!
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Can you give me an example of how to implement this in the filters of a
matrix control on the report? Thanks.
Jerry
"calvin" <calvin@.discussions.microsoft.com> wrote in message
news:03B634AB-BA3A-4A7A-AFB4-A08ABE89439B@.microsoft.com...
> Hi
> You should use UnionAll to get all the department when u click ALL.
> "rlrcstr@.newsgroups.nospam" wrote:
>> I have a parameter for displaying information from a particular
>> department, or from all departments. I can do the filter for a specific
>> department, but how do I set it up so that if the user selects all, I
>> basically ignore the deaprtment filter?
>> Thanks|||Hi Jerry,
Thank you for the update.
I would like to know the filter you use in the matrix. Would you please
post it here? Thank you!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Jerry,
Have you got any progress on this issue? As Wei has mentioned in the last
reply, if you need further help on this, you can post the detailed info
about the filter you used in the matrix so that we can take some further
look into it. As always, if there is anything else we can help, please feel
free to post here.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||I haven't really made much progress here...
I have a data source that is a stored procedure. Let say, for instance,
that I get all records for all employees. In the report, I want to give the
viewer the option to see all employees, active employees, suspended
employees or decommissioned employees.
(The status of an employee is stored in the EmployeeStatus field. 1 =active, 2 = suspended, 4 = decommissioned)
I have no problem creating a filter that will show any of the selected
employee types. The issue is when the user wants to see all employees. How
do I set that up in the filter dialog? Thanks.
Jerry
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:GOfFXVkqGHA.5392@.TK2MSFTNGXA01.phx.gbl...
> Hello Jerry,
> Have you got any progress on this issue? As Wei has mentioned in the last
> reply, if you need further help on this, you can post the detailed info
> about the filter you used in the matrix so that we can take some further
> look into it. As always, if there is anything else we can help, please
> feel
> free to post here.
> Sincerely,
> Steven Cheng
> Microsoft MSDN Online Support Lead
> ==================================================>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Never mind... Figured it out. Thanks.
<rlrcstr@.newsgroups.nospam> wrote in message
news:u63vXVBsGHA.596@.TK2MSFTNGP04.phx.gbl...
>I haven't really made much progress here...
> I have a data source that is a stored procedure. Let say, for instance,
> that I get all records for all employees. In the report, I want to give
> the viewer the option to see all employees, active employees, suspended
> employees or decommissioned employees.
> (The status of an employee is stored in the EmployeeStatus field. 1 => active, 2 = suspended, 4 = decommissioned)
> I have no problem creating a filter that will show any of the selected
> employee types. The issue is when the user wants to see all employees.
> How do I set that up in the filter dialog? Thanks.
> Jerry
>
>
> "Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
> news:GOfFXVkqGHA.5392@.TK2MSFTNGXA01.phx.gbl...
>> Hello Jerry,
>> Have you got any progress on this issue? As Wei has mentioned in the last
>> reply, if you need further help on this, you can post the detailed info
>> about the filter you used in the matrix so that we can take some further
>> look into it. As always, if there is anything else we can help, please
>> feel
>> free to post here.
>> Sincerely,
>> Steven Cheng
>> Microsoft MSDN Online Support Lead
>> ==================================================>>
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>

Matrix Control pushes out Graphs on Report

I have a report with multiple graphs below each other (some bar, some line, some pie)
To the left of each graph, I have a few text boxes and tables tables displaying information about each graph to the right. (fits on A4 portait page)
For lack of being able to display a pic:
Table Graph
_______ ________________________________
| | | |
| | | |
|______ | |_______________________________|
_______ ________________________________
| | | |
| | | |
|______ | |_______________________________|
Right at the bottom of the report, just below the last table/graph combination, I have a simple matrix control.
In the preview pane, all is well, no problem. When I deploy the report to the report server, the matrix control pushes all graphs out for the entire length of the matrix.
Table Blank space Graph
_______ ________________________________
| | | |
| | | |
|______ | |_______________________________|
_______ ________________________________
| | | |
| | | |
|______ | |_______________________________|
_______________________
| |
|______________________|
Matrix /\
The only way I get the report to display correctly is when I specify that the matrix must start on a new page. Unfortunately, the customer wants all on one page.
Any ideas?As items grow vertically, they push items below them.
As they grow horizontally, they push items beside them on the page.
An easy way to prevent this is to make sure your graphs aren't considered to
be to the right of the matrix by grouping the table and graph together in a
rectangle:
--
| -- -- |
| |Table| |Graph| |
| -- -- |
--
--
|Matrix|
--
--
My employer's lawyers require me to say:
"This posting is provided 'AS IS' with no warranties, and confers no
rights."
"Michelle" <Michelle@.discussions.microsoft.com> wrote in message
news:363724F0-D9EE-4BD3-9769-032E79430C6F@.microsoft.com...
> I have a report with multiple graphs below each other (some bar, some
line, some pie)
> To the left of each graph, I have a few text boxes and tables tables
displaying information about each graph to the right. (fits on A4 portait
page)
> For lack of being able to display a pic:
> Table Graph
> _______ ________________________________
> | | | |
> | | | |
> |______ | |_______________________________|
> _______ ________________________________
> | | | |
> | | | |
> |______ | |_______________________________|
>
> Right at the bottom of the report, just below the last table/graph
combination, I have a simple matrix control.
> In the preview pane, all is well, no problem. When I deploy the report to
the report server, the matrix control pushes all graphs out for the entire
length of the matrix.
> Table Blank space Graph
> _______ ________________________________
> | | |
|
> | | |
|
> |______ | |_______________________________|
> _______ ________________________________
> | | |
|
> | | |
|
> |______ | |_______________________________|
> _______________________
> | |
> |______________________|
> Matrix /\
> The only way I get the report to display correctly is when I specify that
the matrix must start on a new page. Unfortunately, the customer wants all
on one page.
> Any ideas?

Matrix - Subtotal Conditional Formatting - How do you do it?

My subtotal column's background color is dark gray and the text is bold
when the row group is collapsed, but I don't see this in other similar
matrix reports without a row group. This report was inherited from a
previous developer.
How did they do it? Even if I set the subtotal cell's colors to be
different from the entire column, they synchronize. I want to do this,
but can't figure out whether it's a setting or not.
Thanks!
MIkeThe subtotal heading should have a little green triangle on it. If you click
on that triangle, the VS properties window should show style settings that
specifically apply to subtotals row/columns.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bassist695" <Michael.EJ.Reynolds@.gmail.com> wrote in message
news:1128365078.625735.314000@.g49g2000cwa.googlegroups.com...
> My subtotal column's background color is dark gray and the text is bold
> when the row group is collapsed, but I don't see this in other similar
> matrix reports without a row group. This report was inherited from a
> previous developer.
> How did they do it? Even if I set the subtotal cell's colors to be
> different from the entire column, they synchronize. I want to do this,
> but can't figure out whether it's a setting or not.
> Thanks!
> MIke
>

math or text

in the below sql why is year(classdate) " + " a " + " MONTH(classdate) a math command giving me 2006 - 12 = 167

and not "2006/12" as text? please help me

cmdGetCat = New SqlDataAdapter("SELECT DISTINCT year(classdate) " + " a " + " MONTH(classdate) AS monthcode FROM dbo.classT INNER JOIN dbo.classgiven ON dbo.classT.classcode = dbo.classgiven.classcode WHERE (dbo.classT.discount = '-1') AND (dbo.classT.coned IS NOT NULL) ", conNorthwind)

Hi,

i think the code that you provided has certain syntax problem, can you verify the codes?

anyway the sql statement should be something like this:

"SELECT DISTINCT year(classdate) + ' a ' + MONTH(classdate) AS monthcode FROM dbo.classT INNER JOIN dbo.classgiven ON dbo.classT.classcode = dbo.classgiven.classcode WHERE (dbo.classT.discount = '-1') AND (dbo.classT.coned IS NOT NULL) "

|||

sorry its this.... i dont get 2006/12 ...i get 126 which is 2006-12=126 hahaha ..i need "yyyy/mm" why god why!!!

"SELECT DISTINCT year(classdate) + ' -/' + MONTH(classdate) AS monthcode FROM dbo.classT INNER JOIN dbo.classgiven ON dbo.classT.classcode = dbo.classgiven.classcode WHERE (dbo.classT.discount = '-1') AND (dbo.classT.coned IS NOT NULL) "

|||

Hi,

You can use this sql statement to giv you yyyy/MM in varchar format:
SELECT CAST(YEAR(classdate) AS VARCHAR(4)) + '/' + CAST(MONTH(classdate) AS VARCHAR(2)) AS 'monthcode'
FROM dbo.classT INNER JOIN dbo.classgiven ON dbo.classT.classcode = dbo.classgiven.classcode WHERE (dbo.classT.discount = '-1') AND (dbo.classT.coned IS NOT NULL)

you can also choose to use the CONVERT function to return a certain format of the date and use the data in your programm

Hope this helps

|||

Here is a Convert Sample for you:

select convert(varchar(7),classdate,111) AS 'monthcode' FROM
...........

master4IDR ??

This is a multi-part message in MIME format.
--=_NextPart_000_0015_01C51FEB.C5E3BF60
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Does anyone know what the "4IDR" databases are? (Master/Model/MSDB)
MSSQL Log entry: Starting up database 'master4IDR'.
I do see the .mdf & .ldf, but I have no such db on this server.
What are these databases?
Thanx!
--=_NextPart_000_0015_01C51FEB.C5E3BF60
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Does anyone know what = the "4IDR" databases are? (Master/Model/MSDB)

MSSQL Log entry: = Starting up database 'master4IDR'.

I do see the .mdf = & .ldf, but I have no such db on this server.

What are these databases?

Thanx!


--=_NextPart_000_0015_01C51FEB.C5E3BF60--I've never see any such animals. My guess is that some 3rd party tool (like backup sw or similar)
has created these.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"JLS" <jlshoop@.hotmail.com> wrote in message news:eYXq6WBIFHA.2620@.tk2msftngp13.phx.gbl...
Does anyone know what the "4IDR" databases are? (Master/Model/MSDB)
MSSQL Log entry: Starting up database 'master4IDR'.
I do see the .mdf & .ldf, but I have no such db on this server.
What are these databases?
Thanx!|||I did a google search on 'masteri4dr' and got several, but inconclusive,
hits. Many referred to third party backup software.
Try running the query below to identify the databases associated with these
files.
SELECT *
FROM master..sysaltfiles
WHERE filename LIKE '%4IDR.mdf%'
--
Hope this helps.
Dan Guzman
SQL Server MVP
"JLS" <jlshoop@.hotmail.com> wrote in message
news:eYXq6WBIFHA.2620@.tk2msftngp13.phx.gbl...
Does anyone know what the "4IDR" databases are? (Master/Model/MSDB)
MSSQL Log entry: Starting up database 'master4IDR'.
I do see the .mdf & .ldf, but I have no such db on this server.
What are these databases?
Thanx!|||They are copies of databases made by Veritas, when it does an online backup of SQL. Most of the time it cleans up after itself, but when it does not, you will find these files laying around
From http://www.developmentnow.com/g/118_2005_3_0_0_482621/master4IDR-.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com