Showing posts with label section. Show all posts
Showing posts with label section. Show all posts

Wednesday, March 21, 2012

matrix row header

In RS 2000, how do you place headers on the columns in the row section of a
matrix?I've added a rectangle to the header section in a matrix, and then placed
individual textboxes inside the rectangle.
At first I used a table instead of rectangles and textboxes, but this gave
me an error message when exporting to Excel. The rectangle + textboxes
should be safe, though. (I've had no complaints. :) )
Kaisa M. Lindahl Lervik
"Rob K" <RobK@.discussions.microsoft.com> wrote in message
news:9B0EA510-629F-4EF7-87B3-DF6F990897DE@.microsoft.com...
> In RS 2000, how do you place headers on the columns in the row section of
> a
> matrix?|||Thanks. This solution works.
"Kaisa M. Lindahl Lervik" wrote:
> I've added a rectangle to the header section in a matrix, and then placed
> individual textboxes inside the rectangle.
> At first I used a table instead of rectangles and textboxes, but this gave
> me an error message when exporting to Excel. The rectangle + textboxes
> should be safe, though. (I've had no complaints. :) )
> Kaisa M. Lindahl Lervik
> "Rob K" <RobK@.discussions.microsoft.com> wrote in message
> news:9B0EA510-629F-4EF7-87B3-DF6F990897DE@.microsoft.com...
> > In RS 2000, how do you place headers on the columns in the row section of
> > a
> > matrix?
>
>|||However ,if you are exporting to an excel this report you may face
problem with row merging and takind time to open the file when it has
huge data.
make sure that you aligned them perfectly to the grid
you can also type in the textbox without rectangle and textboxes on the
space,but you cant have borders and formattings
Thank you
Raj Deep.A
Rob K wrote:
> Thanks. This solution works.
> "Kaisa M. Lindahl Lervik" wrote:
> > I've added a rectangle to the header section in a matrix, and then placed
> > individual textboxes inside the rectangle.
> > At first I used a table instead of rectangles and textboxes, but this gave
> > me an error message when exporting to Excel. The rectangle + textboxes
> > should be safe, though. (I've had no complaints. :) )
> >
> > Kaisa M. Lindahl Lervik
> > "Rob K" <RobK@.discussions.microsoft.com> wrote in message
> > news:9B0EA510-629F-4EF7-87B3-DF6F990897DE@.microsoft.com...
> > > In RS 2000, how do you place headers on the columns in the row section of
> > > a
> > > matrix?
> >
> >
> >

matrix row & column subtotals

The "Adding Subtotals" section in MSDN has me totally confused, I'm not
seeing a Subtotal menu. I need to create a simple cross tab table but
I'm not having any luck.
_____________________________________________
| "TITLE" | Column Name | "TOTAL" |
_____________________________________________
| Row Name | data | row total |
_____________________________________________
| "TOTAL" | column total | matrix total |
_____________________________________________Right click the Column Name cell and choose subtotals, to get column totals.
Right click the Row Name cell and choose subtotals, to get row totals.
"Harolds" wrote:
> Right click the Column Name cell and choose subtotals.
> "tomk10" wrote:
> > The "Adding Subtotals" section in MSDN has me totally confused, I'm not
> > seeing a Subtotal menu. I need to create a simple cross tab table but
> > I'm not having any luck.
> >
> > _____________________________________________
> > | "TITLE" | Column Name | "TOTAL" |
> > _____________________________________________
> > | Row Name | data | row total |
> > _____________________________________________
> > | "TOTAL" | column total | matrix total |
> > _____________________________________________
> >
> >|||Right click the Column Name cell and choose subtotals.
"tomk10" wrote:
> The "Adding Subtotals" section in MSDN has me totally confused, I'm not
> seeing a Subtotal menu. I need to create a simple cross tab table but
> I'm not having any luck.
> _____________________________________________
> | "TITLE" | Column Name | "TOTAL" |
> _____________________________________________
> | Row Name | data | row total |
> _____________________________________________
> | "TOTAL" | column total | matrix total |
> _____________________________________________
>sql

Monday, March 19, 2012

Matrix report (double row footer)

I have data that I would like to pivot in a matrix style report. The problem
is that I need two lines in my footer section and I am unable to find a way
to "insert" an additional row into my footer and use a calculated field to
calc the avg below the totals.
Year Month Group A Group B
1999 Jan 10 20
1999 Feb 10 20
.
.
Annual Total 20 40 Footer Line 1
Monthly Avg 10 20 Footer Line 2
Is there a way to do this?I have the exact same query. Anybody out there able to help.
"skmonroe" wrote:
> I have data that I would like to pivot in a matrix style report. The problem
> is that I need two lines in my footer section and I am unable to find a way
> to "insert" an additional row into my footer and use a calculated field to
> calc the avg below the totals.
> Year Month Group A Group B
> 1999 Jan 10 20
> 1999 Feb 10 20
> .
> .
> Annual Total 20 40 Footer Line 1
> Monthly Avg 10 20 Footer Line 2
> Is there a way to do this?

Matrix pivot column question

I have a report that I'm setting up as a matrix.
The dataset is returning:
Description | Total | Available | Section | SectionQty
Item 1 | 4 | 4 | |
Item 2 | 8 | 6 | DIS | 1
Item 2 | 8 | 6 | FNC | 1
Item 3 | 4667 | 4651 | FNC | 16
Which shows, for each item, the total # and the available #, along with
which section has how many.
The Item, Total & Available columns are set up as row groups, the Section
column is the column group, and the SectionQty is the detail.
When the report renders, I get results of:
Item | Total | Available | | DIS | FNC
Item 1 | 4 | 4 |
Item 2 | 8 | 6 | | 1 | 1
Item 3 | 4667 | 4651 | | | 16
Note the empty column showing up between the Available and DIS columns.
How do I get rid of that empty column caused by the null for the first item
(which still needs to be on the report to show the total / available qty)?
Thanks,
Waynecreate a data set to get above data then create a matix to pipulate
data
On Jan 30, 3:27=A0pm, Wayne <Wa...@.discussions.microsoft.com> wrote:
> I have a report that I'm setting up as a matrix.
> The dataset is returning:
> Description | Total | Available | Section | SectionQty
> Item 1 =A0 =A0 =A0 | =A0 =A0 =A04 =A0| 4 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 ==A0 =A0 =A0 =A0 |
> Item 2 =A0 =A0 =A0 | =A0 =A0 =A08 =A0| 6 =A0 =A0 =A0 =A0 =A0 =A0| DIS =A0 ==A0 =A0 | 1
> Item 2 =A0 =A0 =A0 | =A0 =A0 =A08 =A0| 6 =A0 =A0 =A0 =A0 =A0 =A0| FNC =A0 ==A0 =A0| 1
> Item 3 =A0 =A0 =A0 | 4667 =A0| 4651 =A0 =A0 =A0 | FNC =A0 =A0 =A0| 16
> Which shows, for each item, the total # and the available #, along with
> which section has how many.
> The Item, Total & Available columns are set up as row groups, the Section
> column is the column group, and the SectionQty is the detail.
> When the report renders, I get results of:
> Item =A0 =A0| Total | Available | =A0 =A0 | DIS | FNC
> Item 1 | =A0 =A04 =A0 =A0| =A0 =A0 4 =A0 =A0 =A0 =A0|
> Item 2 | =A0 =A08 =A0 =A0| =A0 =A0 6 =A0 =A0 =A0 =A0| =A0 =A0 | =A0 =A01 |= =A0 =A0 1
> Item 3 | 4667 =A0| 4651 =A0 =A0 =A0 | =A0 =A0 | =A0 =A0 =A0| =A0 =A016
> Note the empty column showing up between the Available and DIS columns.
> How do I get rid of that empty column caused by the null for the first ite=m
> (which still needs to be on the report to show the total / available qty)?=
> Thanks,
> Wayne

Saturday, February 25, 2012

matching users profiles using sql

Hi folks

I have a section in my networking site where people can write things about themselves, such as likes dislikes, hobbies etc for their profile.

I am looking to provide a very basic profile matching service, and have done a bit of searching to find out what the best way to approach this feature is. I have looked at using the sql LIKE clause, but since the profile information can be any length, there seem to be too many variables to account for. I have also looked at identifying keywords in profile blurbs to do the matching too, but I am struggling to see how this could be done with relative ease.

My reason for posting this is simply to get some experienced knowledge about where to start the problem, of even some resources to look at that I may not have found yet.

If anyone could give me some advice on where to start i would be very gratefulTongue Tied

I am develping in vb, with an sql server 2005 back-end

Hello my friend,

You are right about the SQL LIKE clause not being so useful when dealing with large amounts of text. I have worked on something similar before. The best thing to do is to have as many closed questions as possible regarding the profiles. And when they want to be more specific, add sub categories, and sub sub categories and so on. Then the SQL is easy. Most of the big guys do this. If you ever try and create a new hotmail account for example, they throw loads of checkboxes at you and throw the appropriate adverts at you every so often.

Kind regards

Scotty

|||

Hi Scotty

Thanks for the advice. I'm going to begin the development of this feature very soon so i will document what i have come up with here.