No Labels Showing in the Graphs

Hi..

Just want to ask if anyone has encountered the same problem..

I have used the Simple Bar Graph to display the list of employees with the most number of emails/chats and sorted it so that the highest number of emails will appear at the bottom of the graph. The problem is that the graph doesnt display a label on the highest number of email/chats. It displays the number of email/chats that the other employee has and its only the employee with the highest number of email/chats that has no number label. It just wont show and I have no idea now on what to do about it.

Does anybody have a solution for this one?

Try going into the chart properties, selecting the X Axis tab and checking Side Margins, and then do the same for Y Axis.

That worked for me when I had that problem.

BobP

|||

Thanks BobP - BIM...

i'll try that...

|||I have a similar problem : importing a bar chart from Excel 2003, I now don't get the labels any more, but a series of numbers. When I question the data window, this says that the labels are too complex to show up on the graph! It used to work well on the older software.

No Labels Showing in the Graphs

Hi..

Just want to ask if anyone has encountered the same problem..

I have used the Simple Bar Graph to display the list of employees with the most number of emails/chats and sorted it so that the highest number of emails will appear at the bottom of the graph. The problem is that the graph doesnt display a label on the highest number of email/chats. It displays the number of email/chats that the other employee has and its only the employee with the highest number of email/chats that has no number label. It just wont show and I have no idea now on what to do about it.

Does anybody have a solution for this one?

Try going into the chart properties, selecting the X Axis tab and checking Side Margins, and then do the same for Y Axis.

That worked for me when I had that problem.

BobP

|||

Thanks BobP - BIM...

i'll try that...

No Display Output using Stored Procedure

I call a stored procedure from the RS Data area and all data is retrieved on
the browse area when I run the procedure in the data window. I have
manually listed all fields in the Dataset->Fields window and drag them into
the Layout screen.
When I try to preview the report it seems to load the rows (ie 7 pages are
shown as loaded) but doesn't display any data, only the headings show with
and blank body section. If a put a string literal in one field it appears
on each row of the report but all other fields are blank.
I've looked through Output Options without any joy...Could you please post the rdl and ddl for a stored procedure that goes
against any of the sample databases so I can investigate?
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"spamh8ers" <spamh8ers@.discussions.microsoft.com> wrote in message
news:2C2EC175-8681-42F9-A398-CAF83DEE765C@.microsoft.com...
> Does anyone have a solution for this yet? I have similar issues with
> creating new reports. If I start the the report with text query like
Select
> SalesOrder from SalesOrders, the report runs with no problem but when I
> change to a stored procedure, I get pages of empty report body.
> Ideas or workarounds?
> "news.microsoft.com" wrote:
> > I call a stored procedure from the RS Data area and all data is
retrieved on
> > the browse area when I run the procedure in the data window. I have
> > manually listed all fields in the Dataset->Fields window and drag them
into
> > the Layout screen.
> >
> > When I try to preview the report it seems to load the rows (ie 7 pages
are
> > shown as loaded) but doesn't display any data, only the headings show
with
> > and blank body section. If a put a string literal in one field it
appears
> > on each row of the report but all other fields are blank.
> >
> > I've looked through Output Options without any joy...
> >
> >
> >

No data in datagrid

Hi,
Could anyone help me?
I'm trying to create a datagrid using ASP.NET. It works fine
except the coloum that is supposed to display the entrydate is blank. All
the other information displays correctly.
I used the following code to create the table on the SQL server.
CREATE TABLE ManuscriptList
(
u_id INT NOT NULL IDENTITY,
u_manuscripttitle VARCHAR( 100 ),
u_manuscriptauthor VARCHAR( 100 ),
u_genre VARCHAR( 100 ),
u_wordcount VARCHAR( 100 ),
u_critiquecount VARCHAR( 100 ),
u_entrydate DATETIME Default getDate()
)
Is the problem something to do with the last line [i.e. u_entrydate DATETIME
Default getDate()] or is it something to do with the ASP.NET code?
Thanks for your time
Paul Evans
ASP.net.
David Gugick
Imceda Software
www.imceda.com

next run date

I am setting up a new job that will run weekly. However, after setting up the
job the "NEXT RUN DATE" does not display. If I set up this job on another
server this date does get displayed. What might be the reason for this
behavior?
Can you post the results of the following query here:
SELECT * FROM msdb..sysjobschedules s1
WHERE EXISTS ( SELECT * FROM msdb..sysjobs s2
WHERE s2.job_id = s1.job_id )
AND s2.name = <jobname> );
Replace <jobname> with the name of your job.
Anith
|||Hi,
Below are the results:
schedule_id job_id name
enabled
-- --
37 DE69831F-F6EA-4E71-89B3-6542F82A8D2F test1
freq_typefreq_intervalfreq_subday_typefreq_subday_interval
8 4 1 0
freq_relative_intervalfreq_recurrence_factor
active_start_dateactive_end_date
0 1 2008031099991231
active_start_timeactive_end_timenext_run_datenext_run_time
100000 235959 0 0
date_created
03/10/2008 15:27:27.27
"Anith Sen" wrote:

> Can you post the results of the following query here:
> SELECT * FROM msdb..sysjobschedules s1
> WHERE EXISTS ( SELECT * FROM msdb..sysjobs s2
> WHERE s2.job_id = s1.job_id )
> AND s2.name = <jobname> );
> Replace <jobname> with the name of your job.
> --
> Anith
>
>
|||I see that the next_run_date and next_run_time is not getting inserted into
the sysjobschedules table in msdb database after I create the job. What might
be the reason that this is not getting inserted? This works correctly on
other servers. Is this a permissions issue?
Thanks in advance.
"ronnie" wrote:
[vbcol=seagreen]
> Hi,
> Below are the results:
> schedule_id job_id name
> enabled
> -- --
> --
> 37 DE69831F-F6EA-4E71-89B3-6542F82A8D2F test1
> freq_typefreq_intervalfreq_subday_typefreq_subday_interval
> ----
> 8 4 1 0
> freq_relative_intervalfreq_recurrence_factor
> active_start_dateactive_end_date
> --
> 0 1 2008031099991231
>
> active_start_timeactive_end_timenext_run_datenext_run_time
> ----
> 100000 235959 0 0
>
> date_created
> --
> 03/10/2008 15:27:27.27
>
>
>
>
>
> "Anith Sen" wrote:

next run date

I am setting up a new job that will run weekly. However, after setting up the
job the "NEXT RUN DATE" does not display. If I set up this job on another
server this date does get displayed. What might be the reason for this
behavior?Can you post the results of the following query here:
SELECT * FROM msdb..sysjobschedules s1
WHERE EXISTS ( SELECT * FROM msdb..sysjobs s2
WHERE s2.job_id = s1.job_id )
AND s2.name = <jobname> );
Replace <jobname> with the name of your job.
--
Anith|||Hi,
Below are the results:
schedule_id job_id name
enabled
-- --
-- --
37 DE69831F-F6EA-4E71-89B3-6542F82A8D2F test 1
freq_type freq_interval freq_subday_type freq_subday_interval
-- -- -- --
8 4 1 0
freq_relative_interval freq_recurrence_factor
active_start_date active_end_date
-- --
-- --
0 1 20080310 99991231
active_start_time active_end_time next_run_date next_run_time
-- -- -- --
100000 235959 0 0
date_created
--
03/10/2008 15:27:27.27
"Anith Sen" wrote:
> Can you post the results of the following query here:
> SELECT * FROM msdb..sysjobschedules s1
> WHERE EXISTS ( SELECT * FROM msdb..sysjobs s2
> WHERE s2.job_id = s1.job_id )
> AND s2.name = <jobname> );
> Replace <jobname> with the name of your job.
> --
> Anith
>
>|||I see that the next_run_date and next_run_time is not getting inserted into
the sysjobschedules table in msdb database after I create the job. What might
be the reason that this is not getting inserted? This works correctly on
other servers. Is this a permissions issue?
Thanks in advance.
"ronnie" wrote:
> Hi,
> Below are the results:
> schedule_id job_id name
> enabled
> -- --
> -- --
> 37 DE69831F-F6EA-4E71-89B3-6542F82A8D2F test 1
> freq_type freq_interval freq_subday_type freq_subday_interval
> -- -- -- --
> 8 4 1 0
> freq_relative_interval freq_recurrence_factor
> active_start_date active_end_date
> -- --
> -- --
> 0 1 20080310 99991231
>
> active_start_time active_end_time next_run_date next_run_time
> -- -- -- --
> 100000 235959 0 0
>
> date_created
> --
> 03/10/2008 15:27:27.27
>
>
>
>
>
> "Anith Sen" wrote:
> > Can you post the results of the following query here:
> >
> > SELECT * FROM msdb..sysjobschedules s1
> > WHERE EXISTS ( SELECT * FROM msdb..sysjobs s2
> > WHERE s2.job_id = s1.job_id )
> > AND s2.name = <jobname> );
> >
> > Replace <jobname> with the name of your job.
> >
> > --
> > Anith
> >
> >
> >

Newspaper stykle 2-columns for a Table in RS.

Hi ,
I can't find a possible way of doing this at present
If I have a Table element containing 3 columns, how can I get it to display
the following way? Is it possible? If I get 10 rows, I want 5 rows in each
of the following. If there are say 7 rows, I'd want 4 ros on the left and
3 rows on the right.
Required layout follows....
ColA ColB ColC ColA ColB ColC
How feasible is this or am i expecting too much?
Thx,
PaulI have an example of multi column layout at www.MSBICENTRAL.com It is in the
downloads section... The only issue is that the column setup MUST apply to
the entire body of the report ( this is an RS restriction.)
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Paul Buxton" <paul@.nospamspireite.ndo.co.uk> wrote in message
news:1ihujo3tfvqbl$.5hm437dvn3y2$.dlg@.40tude.net...
> Hi ,
> I can't find a possible way of doing this at present
>
> If I have a Table element containing 3 columns, how can I get it to
> display
> the following way? Is it possible? If I get 10 rows, I want 5 rows in
> each
> of the following. If there are say 7 rows, I'd want 4 ros on the left and
> 3 rows on the right.
> Required layout follows....
>
> ColA ColB ColC ColA ColB ColC
>
> How feasible is this or am i expecting too much?
> Thx,
> Paul

newline character in sqlserver

what is the newline character in sqlserver.
My problem is ,I have to display text (say "Hi \n abcd\n hhh\n") where \n is the newline.
But when i print this in sqlserver storedproc,Its displaying as it is instead of newlines.

please help

thxyou can do it via asp.net when you pass in the string do a string.replace of newlines ..something like

txtstmtbdy.text.replace(environment.newline,"<br>")

and when you display it the html is automatically parsed by the browser..so you dont have to worry about messing with it in sql server.

hth|||I assume you mean displaying the results in Query Analyser? If so I believe its the good old fashioned ASCII 10+13

NewLine and Carriage return issue in PDF format

If I insert the following expression in a textbox it will display
correctly in HTML format but not in PDF format. Can anyone show me how
to accomplish the same thing so that it will display correctly in both
HTML and and PDF format.
vbCrLf & vbCrLf & vbCrLf & "My Text"
In HTML format, it will display "My Text" on the 4th "row". Whereas in
PDF format, it displays "My Text" on the first row of the textbox.This has to be an issue (bug) with PDF and how it formats initial blank
space before the literal text. I am not sure if this is addressed in a
service pack for 2000 or in 2005 (I am using 2000 to test this) but here is
a workaround that I found that places an ASCII record seperator in the first
position before the CRLF's as:
=CHR(30)&vbCrLf & vbCrLf & vbCrLf & "My Text"
That should work.
Rodney Landrum
<Nergock@.gmail.com> wrote in message
news:1143588675.322590.215140@.u72g2000cwu.googlegroups.com...
> If I insert the following expression in a textbox it will display
> correctly in HTML format but not in PDF format. Can anyone show me how
> to accomplish the same thing so that it will display correctly in both
> HTML and and PDF format.
> vbCrLf & vbCrLf & vbCrLf & "My Text"
> In HTML format, it will display "My Text" on the 4th "row". Whereas in
> PDF format, it displays "My Text" on the first row of the textbox.
>

Newbie:help on maximum of a series of columns

Hi,
I have the following table:
tblMeasurements
Date | value1| value2| ...|value24|
I need to find (and display) the maximum per day, i.e. the maximum number
among the value1...value24 in the same row (date).
I tried MAX(value1,....,value24) to no avail.
The examples I see on the net seem to find the max for all the entries of a
*specific* column. I want the max of a specific row. Can it be done and am i
looking at the right function ?
I know its a simple question but i cant seem to find the answer.
TIA
-steveSteve
Why not to store like this
CREATE TABLE #Test
(
[Id] Int not null primary key,
[Date] datetime not null,
Value int not null
)
SELECT MAX(Value),Date FROM #Test
GROUP BY Date
"Steve" <try@.this.com> wrote in message
news:xOz0e.19063$ZC6.78184@.wagner.videotron.net...
> Hi,
> I have the following table:
> tblMeasurements
> Date | value1| value2| ...|value24|
> I need to find (and display) the maximum per day, i.e. the maximum number
> among the value1...value24 in the same row (date).
> I tried MAX(value1,....,value24) to no avail.
> The examples I see on the net seem to find the max for all the entries of
a
> *specific* column. I want the max of a specific row. Can it be done and am
i
> looking at the right function ?
> I know its a simple question but i cant seem to find the answer.
> TIA
> -steve
>|||Try,
select
[Date]
max(value)
from
(
select
[date],
case n.colA
when 1 then value1
when 2 then value2
..
when 24 then value24
end as value
from
t
cross join
(
select 1
union all
select 2
union all
..
select 24
) as n(colA)
) as a
group by
[date]
go
AMB
"Steve" wrote:

> Hi,
> I have the following table:
> tblMeasurements
> Date | value1| value2| ...|value24|
> I need to find (and display) the maximum per day, i.e. the maximum number
> among the value1...value24 in the same row (date).
> I tried MAX(value1,....,value24) to no avail.
> The examples I see on the net seem to find the max for all the entries of
a
> *specific* column. I want the max of a specific row. Can it be done and am
i
> looking at the right function ?
> I know its a simple question but i cant seem to find the answer.
> TIA
> -steve
>
>