How to show the values of a group in charting using tool tip?
--
asharmaHello Asharma,
In the Tooltip property of the Chart, you could specify your expression in
it.
For example, you could use the following expression:
=First(Fields!Fieldname.Value, "Group Name")
Hope this helps.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
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.|||Is there any way in which i can carry or retain the tooltip value which is
shown on my report into Excel sheet ...
i mean when i export the report into Excel sheet, tooltip value is gone'
how can i retain the tooltip value when i export into excel '
thanks a lot in advance
"Wei Lu [MSFT]" wrote:
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> 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.
>
Showing posts with label group. Show all posts
Showing posts with label group. Show all posts
Wednesday, March 28, 2012
How to show SUBREPORT when no data is returned.
I have a subreport within the details section of my main report. This is enclosed by a single group. When I preview the subreport alone, it diplays the subreport correctly with no data (meaning it still displays the header and footer without a detail section). When the subreport is run within the main report and no subreport data is returned the subreport does not show.
Based on other threads I understand that the default functionality is to display headers and footers when no data is returned. This appears accurate except on a subreport.
Would the "no rows"-property help you? there you can define a message that is shown when the subreport has no rows..|||I fixed this by returning a row of nulls in my return dataset when no records where found. Works.
How to show SUBREPORT when no data is returned.
I have a subreport within the details section of my main report. This is enclosed by a single group. When I preview the subreport alone, it diplays the subreport correctly with no data (meaning it still displays the header and footer without a detail section). When the subreport is run within the main report and no subreport data is returned the subreport does not show.
Based on other threads I understand that the default functionality is to display headers and footers when no data is returned. This appears accurate except on a subreport.
Would the "no rows"-property help you? there you can define a message that is shown when the subreport has no rows..|||I fixed this by returning a row of nulls in my return dataset when no records where found. Works.
How to show group header/footer again after hiding them?
I have started to work on a report with table data region, and there
was need to sort the records withing a group, so I created a new
group, assigned the appropriate sort order, and then cleared "Include
group header" and "Include group footer" checkboxes. Because of this
the group did not show up in the layout window. But now I want to make
some changes to the sort, and I could not find a way to get to the
group definition again. Please help. Thanks.Found the solution. From Table Properties, go to Groups tab, and then
you can manage the groups there.
was need to sort the records withing a group, so I created a new
group, assigned the appropriate sort order, and then cleared "Include
group header" and "Include group footer" checkboxes. Because of this
the group did not show up in the layout window. But now I want to make
some changes to the sort, and I could not find a way to get to the
group definition again. Please help. Thanks.Found the solution. From Table Properties, go to Groups tab, and then
you can manage the groups there.
How to show every second label in a chart
I have a stacked column chart shoving months from january 2004 to
december 2005 on the x-axis: (This is a Category Group.)
jan-04, feb-04, mar-04,apr-04.... oct-05-nov-05, dec-05
I want to show only every second month.
Any ideas how this is done? .......There are probably other ways to do it, but why not just create another
dataset that just contains the months of interest.
--
William Stacey [MVP]
<therese_gule@.hotmail.com> wrote in message
news:1137694813.606325.155960@.g14g2000cwa.googlegroups.com...
|I have a stacked column chart shoving months from january 2004 to
| december 2005 on the x-axis: (This is a Category Group.)
| jan-04, feb-04, mar-04,apr-04.... oct-05-nov-05, dec-05
|
| I want to show only every second month.
|
| Any ideas how this is done? .......
||||I need to show the trend of the data for a period of 2 years on the
same line.
A way is to implement code with MOD to do this, but that again requires
a counter.|||Assuming that in your dataset you have a row for every month returned, you
can enter an expression in the Label property of your category group for the
months that uses the month field value when the RowNumber() function returns
an odd number and uses a zero-length string when the RowNumber function
returns an even number.
"therese_gule@.hotmail.com" wrote:
> I need to show the trend of the data for a period of 2 years on the
> same line.
> A way is to implement code with MOD to do this, but that again requires
> a counter.
>
december 2005 on the x-axis: (This is a Category Group.)
jan-04, feb-04, mar-04,apr-04.... oct-05-nov-05, dec-05
I want to show only every second month.
Any ideas how this is done? .......There are probably other ways to do it, but why not just create another
dataset that just contains the months of interest.
--
William Stacey [MVP]
<therese_gule@.hotmail.com> wrote in message
news:1137694813.606325.155960@.g14g2000cwa.googlegroups.com...
|I have a stacked column chart shoving months from january 2004 to
| december 2005 on the x-axis: (This is a Category Group.)
| jan-04, feb-04, mar-04,apr-04.... oct-05-nov-05, dec-05
|
| I want to show only every second month.
|
| Any ideas how this is done? .......
||||I need to show the trend of the data for a period of 2 years on the
same line.
A way is to implement code with MOD to do this, but that again requires
a counter.|||Assuming that in your dataset you have a row for every month returned, you
can enter an expression in the Label property of your category group for the
months that uses the month field value when the RowNumber() function returns
an odd number and uses a zero-length string when the RowNumber function
returns an even number.
"therese_gule@.hotmail.com" wrote:
> I need to show the trend of the data for a period of 2 years on the
> same line.
> A way is to implement code with MOD to do this, but that again requires
> a counter.
>
Friday, March 23, 2012
How to setup Padding after clicking ToggleItem
I am trying to format the output result from a Recursive Group dataset.
The dataset is very simple with EmployeeID and ManagerID as recursive and
the latter being the parent id. Table structure is very simple with one
line on the detail level with EmployeeID, EmployeeName, ManagerName & Level
(using Level Function).
The report correctly returns all the records order by Level and Toggle by
EmployeeID. However, I would like to setup Padding when subsequent levels
show up after clicking the ToggleItem. Where would I set that up? Any
required scripts involved (iif...?). I would also like to setup different
color formatting for the different levels, and I assume it could be setup at
the same property setting as the Padding.
Much appreciated!
-Lawrenceyou could use Level() function to set padding and color.
For example, setting left padding to expression
=String.Format("{0}pt",Level() * 10) provides 10 points padding per level.
I would suggest using =Switch() for changing color:
=switch (Level() = 0, "Red", Level() = 1, "Blue", True, Nothing)
switch () takes a variable number of parameters in the form of (evaluation,
if true return, next evaluation ...)--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lawrence" <Lawrence@.discussions.microsoft.com> wrote in message
news:61F57876-20A5-4A81-94DB-3ABA16AD8053@.microsoft.com...
> I am trying to format the output result from a Recursive Group dataset.
> The dataset is very simple with EmployeeID and ManagerID as recursive and
> the latter being the parent id. Table structure is very simple with one
> line on the detail level with EmployeeID, EmployeeName, ManagerName &
Level
> (using Level Function).
> The report correctly returns all the records order by Level and Toggle by
> EmployeeID. However, I would like to setup Padding when subsequent levels
> show up after clicking the ToggleItem. Where would I set that up? Any
> required scripts involved (iif...?). I would also like to setup different
> color formatting for the different levels, and I assume it could be setup
at
> the same property setting as the Padding.
> Much appreciated!
> -Lawrence
The dataset is very simple with EmployeeID and ManagerID as recursive and
the latter being the parent id. Table structure is very simple with one
line on the detail level with EmployeeID, EmployeeName, ManagerName & Level
(using Level Function).
The report correctly returns all the records order by Level and Toggle by
EmployeeID. However, I would like to setup Padding when subsequent levels
show up after clicking the ToggleItem. Where would I set that up? Any
required scripts involved (iif...?). I would also like to setup different
color formatting for the different levels, and I assume it could be setup at
the same property setting as the Padding.
Much appreciated!
-Lawrenceyou could use Level() function to set padding and color.
For example, setting left padding to expression
=String.Format("{0}pt",Level() * 10) provides 10 points padding per level.
I would suggest using =Switch() for changing color:
=switch (Level() = 0, "Red", Level() = 1, "Blue", True, Nothing)
switch () takes a variable number of parameters in the form of (evaluation,
if true return, next evaluation ...)--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lawrence" <Lawrence@.discussions.microsoft.com> wrote in message
news:61F57876-20A5-4A81-94DB-3ABA16AD8053@.microsoft.com...
> I am trying to format the output result from a Recursive Group dataset.
> The dataset is very simple with EmployeeID and ManagerID as recursive and
> the latter being the parent id. Table structure is very simple with one
> line on the detail level with EmployeeID, EmployeeName, ManagerName &
Level
> (using Level Function).
> The report correctly returns all the records order by Level and Toggle by
> EmployeeID. However, I would like to setup Padding when subsequent levels
> show up after clicking the ToggleItem. Where would I set that up? Any
> required scripts involved (iif...?). I would also like to setup different
> color formatting for the different levels, and I assume it could be setup
at
> the same property setting as the Padding.
> Much appreciated!
> -Lawrence
Monday, March 19, 2012
How to set up a central store for server registration information (Enterprise Ma
I tried this, all i can get from my central server is SQL
Registrations Groups, i can't get the registered servers
I.E. i set up a group named MAIN
under main, i registered servers APP01,APP02,APP03
when i remotely connect to my central server thru
Enterprise manager, all i get is MAIN, i can't get the
servers registrations
any one ever had this problem ?
TIA
JL
Books online article :
>To set up a central store for server registration
>information on a remote server
>Click the server, and then on the Tools menu, click
>Options.
>On the General tab, clear the Read/Store user independent
>check box.
>Use SQL Server Enterprise Manager to create server groups
>and register servers.
>To set up a central store for server registration
>information on a local server
>Click the server, and then on the Tools menu, click
>Options.
>On the General tab, click Read from remote.
>In the Server name box, type the name of the remote
>server from which you want to use registration
>information.
Have you logged in with the same Windows account, as the one with which you
registered the servers in EM?
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"JL Gervais" <anonymous@.discussions.microsoft.com> wrote in message
news:d19f01c439ca$fbe5e0a0$a401280a@.phx.gbl...
I tried this, all i can get from my central server is SQL
Registrations Groups, i can't get the registered servers
I.E. i set up a group named MAIN
under main, i registered servers APP01,APP02,APP03
when i remotely connect to my central server thru
Enterprise manager, all i get is MAIN, i can't get the
servers registrations
any one ever had this problem ?
TIA
JL
Books online article :
>To set up a central store for server registration
>information on a remote server
>Click the server, and then on the Tools menu, click
>Options.
>On the General tab, clear the Read/Store user independent
>check box.
>Use SQL Server Enterprise Manager to create server groups
>and register servers.
>To set up a central store for server registration
>information on a local server
>Click the server, and then on the Tools menu, click
>Options.
>On the General tab, click Read from remote.
>In the Server name box, type the name of the remote
>server from which you want to use registration
>information.
|||the Exact same NT account on both. i actually solved my
problem, i developped something using SQLDMO
but still, it would be useful if i could share my SQL
registrations with other users.
with SQL 7, exporting registry keys to other users was
possible, but it looks like it's not working with SQL2K.
Actually, i get the exact same behavior exporting registry
keys with SQL2K (i only get Groups, i do not get servers
registrations)
thanks
JL
>--Original Message--
>Have you logged in with the same Windows account, as the
one with which you
>registered the servers in EM?
>--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>Is .NET important for a database professional?
>http://vyaskn.tripod.com/poll.htm
>
>"JL Gervais" <anonymous@.discussions.microsoft.com> wrote
in message
>news:d19f01c439ca$fbe5e0a0$a401280a@.phx.gbl...
>I tried this, all i can get from my central server is SQL
>Registrations Groups, i can't get the registered servers
>I.E. i set up a group named MAIN
>under main, i registered servers APP01,APP02,APP03
>when i remotely connect to my central server thru
>Enterprise manager, all i get is MAIN, i can't get the
>servers registrations
>any one ever had this problem ?
>TIA
>JL
>Books online article :
>
>
>
>.
>
Registrations Groups, i can't get the registered servers
I.E. i set up a group named MAIN
under main, i registered servers APP01,APP02,APP03
when i remotely connect to my central server thru
Enterprise manager, all i get is MAIN, i can't get the
servers registrations
any one ever had this problem ?
TIA
JL
Books online article :
>To set up a central store for server registration
>information on a remote server
>Click the server, and then on the Tools menu, click
>Options.
>On the General tab, clear the Read/Store user independent
>check box.
>Use SQL Server Enterprise Manager to create server groups
>and register servers.
>To set up a central store for server registration
>information on a local server
>Click the server, and then on the Tools menu, click
>Options.
>On the General tab, click Read from remote.
>In the Server name box, type the name of the remote
>server from which you want to use registration
>information.
Have you logged in with the same Windows account, as the one with which you
registered the servers in EM?
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"JL Gervais" <anonymous@.discussions.microsoft.com> wrote in message
news:d19f01c439ca$fbe5e0a0$a401280a@.phx.gbl...
I tried this, all i can get from my central server is SQL
Registrations Groups, i can't get the registered servers
I.E. i set up a group named MAIN
under main, i registered servers APP01,APP02,APP03
when i remotely connect to my central server thru
Enterprise manager, all i get is MAIN, i can't get the
servers registrations
any one ever had this problem ?
TIA
JL
Books online article :
>To set up a central store for server registration
>information on a remote server
>Click the server, and then on the Tools menu, click
>Options.
>On the General tab, clear the Read/Store user independent
>check box.
>Use SQL Server Enterprise Manager to create server groups
>and register servers.
>To set up a central store for server registration
>information on a local server
>Click the server, and then on the Tools menu, click
>Options.
>On the General tab, click Read from remote.
>In the Server name box, type the name of the remote
>server from which you want to use registration
>information.
|||the Exact same NT account on both. i actually solved my
problem, i developped something using SQLDMO
but still, it would be useful if i could share my SQL
registrations with other users.
with SQL 7, exporting registry keys to other users was
possible, but it looks like it's not working with SQL2K.
Actually, i get the exact same behavior exporting registry
keys with SQL2K (i only get Groups, i do not get servers
registrations)
thanks
JL
>--Original Message--
>Have you logged in with the same Windows account, as the
one with which you
>registered the servers in EM?
>--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>Is .NET important for a database professional?
>http://vyaskn.tripod.com/poll.htm
>
>"JL Gervais" <anonymous@.discussions.microsoft.com> wrote
in message
>news:d19f01c439ca$fbe5e0a0$a401280a@.phx.gbl...
>I tried this, all i can get from my central server is SQL
>Registrations Groups, i can't get the registered servers
>I.E. i set up a group named MAIN
>under main, i registered servers APP01,APP02,APP03
>when i remotely connect to my central server thru
>Enterprise manager, all i get is MAIN, i can't get the
>servers registrations
>any one ever had this problem ?
>TIA
>JL
>Books online article :
>
>
>
>.
>
Monday, March 12, 2012
How to set the breakepage of grouping
I use a List to group my data.
I can set the breakpage in the EditDetailGroup.
But how can I set it with codes?Ad,
Edit the group, on the general tab you can set this.
Perry
"ad" <flying@.wfes.tcc.edu.tw> wrote in message
news:%23YoZtVf1GHA.1256@.TK2MSFTNGP02.phx.gbl...
>I use a List to group my data.
> I can set the breakpage in the EditDetailGroup.
> But how can I set it with codes?
>|||Thank, but I want to set it at run time.
"Perry" <noemail@.this.adress> ¼¶¼g©ó¶l¥ó·s»D:u4jWIkw1GHA.4924@.TK2MSFTNGP05.phx.gbl...
> Ad,
> Edit the group, on the general tab you can set this.
> Perry
>
> "ad" <flying@.wfes.tcc.edu.tw> wrote in message
> news:%23YoZtVf1GHA.1256@.TK2MSFTNGP02.phx.gbl...
>>I use a List to group my data.
>> I can set the breakpage in the EditDetailGroup.
>> But how can I set it with codes?
>
I can set the breakpage in the EditDetailGroup.
But how can I set it with codes?Ad,
Edit the group, on the general tab you can set this.
Perry
"ad" <flying@.wfes.tcc.edu.tw> wrote in message
news:%23YoZtVf1GHA.1256@.TK2MSFTNGP02.phx.gbl...
>I use a List to group my data.
> I can set the breakpage in the EditDetailGroup.
> But how can I set it with codes?
>|||Thank, but I want to set it at run time.
"Perry" <noemail@.this.adress> ¼¶¼g©ó¶l¥ó·s»D:u4jWIkw1GHA.4924@.TK2MSFTNGP05.phx.gbl...
> Ad,
> Edit the group, on the general tab you can set this.
> Perry
>
> "ad" <flying@.wfes.tcc.edu.tw> wrote in message
> news:%23YoZtVf1GHA.1256@.TK2MSFTNGP02.phx.gbl...
>>I use a List to group my data.
>> I can set the breakpage in the EditDetailGroup.
>> But how can I set it with codes?
>
Wednesday, March 7, 2012
how to set Formula Grouping in Crystal report 9
i want a group of hours from 1 to 24 in following format
01 - 02
02-03
04-05
..
.
.
.
.
.
21-22
22-23
23-24
24-01
and as per this group i want to give different running total.On create new group form select "Use formula as group" option and write down your's desire formula.
you can write formula as
if{@.Cond}='1' then
'01 - 02'
else if {@.Cond}='2' then
'02 - 03'
...
...
and so on|||thanks Anand
but i want to create a group with 01-02 , 02-03, 03-04 and so on up to 23-24, 24-01. and there not a single field in database which can represent this type of group
so plz let me know as eairly as possible|||?
Do you mean you want to group like this:
01 - 02 // or may be 00 - 01 ?
03 - 04
05 - 06
.
.
24 - 00 ?
I don't really understand what do you mean by '01 - 02' and '02 - 03' ?
The hour 02 can be included just into one group.
OK, if {your_table.date_time_field} you want to group by, returns date_time or time, create a formula @.Hour:
hour({your_table.date_time_field})
then you will be able to create another formula @.Groupping_by_Hour:
if {@.Hour} in [0,1] then '0 - 1' else
if {@.Hour} in [2,3] then '2 - 3' else
.
.
if {@.Hour} in [20,21] then '20 - 21' else '22_23'|||i want report as follows
time! No of person came for interview
01 am: 02 am 1
02am : 03am 1
03am : 04am 2
04am : 05am 1
.
.
.
21 pm : 22 pm 1
22 pm : 23 pm 1
23 pm : 24 pm 1
24 pm : 01 am 1
i don't have any field which i an get time. but i want a group as per time. and i have a field of noof person came for interviw and their time|||You had to post a such info in your first post. When you say you need to group the records by hour, it sounds (at least for me) that you have some {table.date_time} field, otherwise how you can get an hour to group your records on, if you don't have a such field.
So, from your last post I understand that you have 2 fields:
the 1st one is time the person came for his/her interview at, again, it sounds like it's a date_time field, but you didn't say anything about your field formats;
the 2nd one is 'their time';
Which time? Is that a numeric field which containes a number of hours/minutes the person had been interviewing for or the time when he/she left (date_time field)... or :) their time they had an appointment at?
Can you post an example of these fields?|||sorry friend, for providing inproper information, i have a form in which i accept name of person, addres and other details of a person who came for interview and his timing of arrival. and thus the information is stored in the database with timing of arrival as datetime. now i want a report which shows count of person arrived for interview between
01:00 to 02:00 am
02:00 to 03:00 am
03:00 to 04:00 am
04:00 to 05:00 am
.
.
.
.
.
.
..
.
.
.21:00 to 22:00 pm
22:00 to 23:00 pm
23:00 to 24:00 pm
24:00 to 01:00 am
if the information is still in proper plz let me know|||:) it's OK.
So why did you say you 'don't have any field which u can get time' if you have info 'stored in the database with timing of arrival as datetime' ?
Use that field, this is the one you need.
I probably understood you wrong about how you want to group your records (I really need my vacation :)).
I guess you actually want to group by hour
01:00 to 02:00 am // this is time from 1:00:00 am to 1:59:59 am
02:00 to 03:00 am // that is time from 2:00:00 am to 2:59:59 am
.
.
but in your GF you would like to have a note like these
01-02
02-03
.
.
Right?
You can group your records on {your_table.timing_of_arrival} field by hour, which you said was datetime field;
for 'The section will be printed' select 'for each hour'.
Count how many people came for interview each hour. You might have a person ID field or something so, right click on it -> insert -> summary;
for calculate this summary select 'Count'
for summary location select group based on that field.
Suppress GH and Details sections
then create a formula @.Groupping
local numbervar HH:=hour({your_table.timing_of_arrival});
if HH=1 then '01 - 02' else
if HH=2 then '02 - 03' else
if HH=3 then '03 - 04' else
.
.
.
if HH=22 then '22 - 23' else
if HH=23 then '23 - 24' else
if HH=0 then '24 - 01'
Place it in the Group Footer|||thanks,
but one small problem. i am getting group of hours only if the person came within that range of hours and if no one came for interview withing that hour then the group is not shown. eg
if 2 person came for interview between 11:00 - 12:00 then group is shown
and if no one came between 2:00 - 3:00 then group of 2:00-3:00 is not shown
and i want that all hours must be displayed.|||Ah, that old chestnut - used to be a common question but I haven't seen it for a while.
I believe the concensus was that you need a table containing all of the values that you want to display, and use this as the main table for the report with either
1) a left join to your table containing the times
or
2) running a subreport for each record in the main table, i.e. you'll run a subreport 24 times, once per hour period.
01 - 02
02-03
04-05
..
.
.
.
.
.
21-22
22-23
23-24
24-01
and as per this group i want to give different running total.On create new group form select "Use formula as group" option and write down your's desire formula.
you can write formula as
if{@.Cond}='1' then
'01 - 02'
else if {@.Cond}='2' then
'02 - 03'
...
...
and so on|||thanks Anand
but i want to create a group with 01-02 , 02-03, 03-04 and so on up to 23-24, 24-01. and there not a single field in database which can represent this type of group
so plz let me know as eairly as possible|||?
Do you mean you want to group like this:
01 - 02 // or may be 00 - 01 ?
03 - 04
05 - 06
.
.
24 - 00 ?
I don't really understand what do you mean by '01 - 02' and '02 - 03' ?
The hour 02 can be included just into one group.
OK, if {your_table.date_time_field} you want to group by, returns date_time or time, create a formula @.Hour:
hour({your_table.date_time_field})
then you will be able to create another formula @.Groupping_by_Hour:
if {@.Hour} in [0,1] then '0 - 1' else
if {@.Hour} in [2,3] then '2 - 3' else
.
.
if {@.Hour} in [20,21] then '20 - 21' else '22_23'|||i want report as follows
time! No of person came for interview
01 am: 02 am 1
02am : 03am 1
03am : 04am 2
04am : 05am 1
.
.
.
21 pm : 22 pm 1
22 pm : 23 pm 1
23 pm : 24 pm 1
24 pm : 01 am 1
i don't have any field which i an get time. but i want a group as per time. and i have a field of noof person came for interviw and their time|||You had to post a such info in your first post. When you say you need to group the records by hour, it sounds (at least for me) that you have some {table.date_time} field, otherwise how you can get an hour to group your records on, if you don't have a such field.
So, from your last post I understand that you have 2 fields:
the 1st one is time the person came for his/her interview at, again, it sounds like it's a date_time field, but you didn't say anything about your field formats;
the 2nd one is 'their time';
Which time? Is that a numeric field which containes a number of hours/minutes the person had been interviewing for or the time when he/she left (date_time field)... or :) their time they had an appointment at?
Can you post an example of these fields?|||sorry friend, for providing inproper information, i have a form in which i accept name of person, addres and other details of a person who came for interview and his timing of arrival. and thus the information is stored in the database with timing of arrival as datetime. now i want a report which shows count of person arrived for interview between
01:00 to 02:00 am
02:00 to 03:00 am
03:00 to 04:00 am
04:00 to 05:00 am
.
.
.
.
.
.
..
.
.
.21:00 to 22:00 pm
22:00 to 23:00 pm
23:00 to 24:00 pm
24:00 to 01:00 am
if the information is still in proper plz let me know|||:) it's OK.
So why did you say you 'don't have any field which u can get time' if you have info 'stored in the database with timing of arrival as datetime' ?
Use that field, this is the one you need.
I probably understood you wrong about how you want to group your records (I really need my vacation :)).
I guess you actually want to group by hour
01:00 to 02:00 am // this is time from 1:00:00 am to 1:59:59 am
02:00 to 03:00 am // that is time from 2:00:00 am to 2:59:59 am
.
.
but in your GF you would like to have a note like these
01-02
02-03
.
.
Right?
You can group your records on {your_table.timing_of_arrival} field by hour, which you said was datetime field;
for 'The section will be printed' select 'for each hour'.
Count how many people came for interview each hour. You might have a person ID field or something so, right click on it -> insert -> summary;
for calculate this summary select 'Count'
for summary location select group based on that field.
Suppress GH and Details sections
then create a formula @.Groupping
local numbervar HH:=hour({your_table.timing_of_arrival});
if HH=1 then '01 - 02' else
if HH=2 then '02 - 03' else
if HH=3 then '03 - 04' else
.
.
.
if HH=22 then '22 - 23' else
if HH=23 then '23 - 24' else
if HH=0 then '24 - 01'
Place it in the Group Footer|||thanks,
but one small problem. i am getting group of hours only if the person came within that range of hours and if no one came for interview withing that hour then the group is not shown. eg
if 2 person came for interview between 11:00 - 12:00 then group is shown
and if no one came between 2:00 - 3:00 then group of 2:00-3:00 is not shown
and i want that all hours must be displayed.|||Ah, that old chestnut - used to be a common question but I haven't seen it for a while.
I believe the concensus was that you need a table containing all of the values that you want to display, and use this as the main table for the report with either
1) a left join to your table containing the times
or
2) running a subreport for each record in the main table, i.e. you'll run a subreport 24 times, once per hour period.
Sunday, February 19, 2012
How to service data for multiple customers
Hello All,
I do not know if this is the proper group to ask my question. Please do
direct me to the proper place.
I have a database server and would like to store data for multiple
groups of customers. The data is not shared amongst the groups but are
shared only amongst individuals composing a group.
One solution would be to lump all data from all groups into a single
instance of the database server accompanied with a tag that would
identify to which group each piece of information belongs.
Is there a better method to achieve what I want to do. Would my
solution present any difficulties in the future in terms of performance,
maintenance, scalability.
Are there other solutions that may be available to address my needs.
Any suggestions would be greatly appreciated.
ThanksCREATE TABLE CustomerGrps
(grp_nbr INTEGER NOT NULL, -- a code for the CHAID analysis??
customer_id ...,
..
PRIMARY KEY (grp_nbr, customer_id),
...)'|||Thanks for the input. I was looking towards a solution more from a DBA's
perspective rather than a programmer's perspective.
For example. In order to service multiple groups of customers. Would it be
better to have one sqlserver instance to service the need of all groups of
customers or would it be more advantageous to install multiple instances of
sqlserver, one instance for each group of customers.
thanks
"--CELKO--" <jcelko212@.earthlink.net> wrote in message
news:1121912144.832540.98870@.g49g2000cwa.googlegro ups.com...
> CREATE TABLE CustomerGrps
> (grp_nbr INTEGER NOT NULL, -- a code for the CHAID analysis??
> customer_id ...,
> ..
> PRIMARY KEY (grp_nbr, customer_id),
> ..)'|||If all the customers will have similar admin/support demands and expect
the same service levels then fewer servers/instances will likely mean
less work from a DBA perspective. In that case, the main considerations
will probably be around performance/scalability and any security
concerns the customer has about sharing the server with others.
Multiple instances on the same server don't offer anything much on the
scalability front but design the application such that it can support
multiple servers in case you need that capability in the future.
--
David Portas
SQL Server MVP
--
Subscribe to:
Posts (Atom)