Adding a legend to a report

I want to add a legend to a report. In the .Net version of the report, a
button was clicked which brought up a html page. Any suggestions?Why not adding a hyperlink to your RS reports which also points to a html
page?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Delton Blackwell" <deltonblackwell@.hotmail.com> wrote in message
news:OjCNQTTWEHA.3024@.TK2MSFTNGP09.phx.gbl...
> I want to add a legend to a report. In the .Net version of the report, a
> button was clicked which brought up a html page. Any suggestions?
>|||I don't quite understand your question. Would you please elaborate on what
you are attempting to achieve
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Delton Blackwell" <deltonblackwell@.hotmail.com> wrote in message
news:OjCNQTTWEHA.3024@.TK2MSFTNGP09.phx.gbl...
> I want to add a legend to a report. In the .Net version of the report, a
> button was clicked which brought up a html page. Any suggestions?
>

Add javascript code to report page inside the report manager

Hi all,
Does anyone knows how can I add some javascript code into the html page
which contains a report into the report manager?.
Let's the following scenario, suppose that any user wants to execute some
reports from report manager, first the user goes to http://server/reports
after that he/she will be at home page configured due to his/her profile, the
user select a report with a click and, he/she executes it. The report will be
rendered in html inside the same window where the report manager is, but in
different frame.
I know using both htc and css files I can modify some behavior of the html
page but, the problem is that both report manager and the rendered report
coexist in the same window( I mean different frames for each of them ) I
don't know how to add some javascript code into the frame or page or whatever
the report lives in.
Any help will be appreciated.Hi
in the htc you can access the frame page which contain the report and the
report manager using the javascript dhtml code.
you can use like
frame[0].document.
or window.document.getelementbyID['asd'].
you dont have to insert script in the frame
you can put all the code in htc to call the code..
"jhcp" wrote:
> Hi all,
> Does anyone knows how can I add some javascript code into the html page
> which contains a report into the report manager?.
> Let's the following scenario, suppose that any user wants to execute some
> reports from report manager, first the user goes to http://server/reports
> after that he/she will be at home page configured due to his/her profile, the
> user select a report with a click and, he/she executes it. The report will be
> rendered in html inside the same window where the report manager is, but in
> different frame.
> I know using both htc and css files I can modify some behavior of the html
> page but, the problem is that both report manager and the rendered report
> coexist in the same window( I mean different frames for each of them ) I
> don't know how to add some javascript code into the frame or page or whatever
> the report lives in.
> Any help will be appreciated.|||Hi Bava,
thanks for your answer but, how can I know which frame contains the rendered
report?.
The htc file I coded is the following
<public:component tagName="test1">
<PUBLIC:ATTACH EVENT="oncontextmenu" onevent="f_CancelEvent()" />
<PUBLIC:ATTACH EVENT="onselectstart" onevent="f_CancelEvent()" />
<PUBLIC:ATTACH EVENT="ondragstart" onevent="f_CancelEvent()" />
</public:component>
<SCRIPT language="javascript">
function f_CancelEvent()
{
event.returnValue = false;
}
</script>
After that, I reference that piece of code in a css file as following
body {
margin: 0;
background-color: White;
font-family: Verdana, Sans-Serif;
font-size: x-small;
behavior: url(../js/test1.htc);
}
"Bava Mani" wrote:
> Hi
> in the htc you can access the frame page which contain the report and the
> report manager using the javascript dhtml code.
> you can use like
> frame[0].document.
> or window.document.getelementbyID['asd'].
> you dont have to insert script in the frame
> you can put all the code in htc to call the code..
> "jhcp" wrote:
> > Hi all,
> > Does anyone knows how can I add some javascript code into the html page
> > which contains a report into the report manager?.
> > Let's the following scenario, suppose that any user wants to execute some
> > reports from report manager, first the user goes to http://server/reports
> > after that he/she will be at home page configured due to his/her profile, the
> > user select a report with a click and, he/she executes it. The report will be
> > rendered in html inside the same window where the report manager is, but in
> > different frame.
> > I know using both htc and css files I can modify some behavior of the html
> > page but, the problem is that both report manager and the rendered report
> > coexist in the same window( I mean different frames for each of them ) I
> > don't know how to add some javascript code into the frame or page or whatever
> > the report lives in.
> > Any help will be appreciated.|||Hi,
are you using 2000 or 2005 reporting service?
in 2000 there is only one iframe so you can just use
window.frames.item(0)
or
window.document.getElementById(framid) if it is 2005
hope it helps
"jhcp" wrote:
> Hi Bava,
> thanks for your answer but, how can I know which frame contains the rendered
> report?.
> The htc file I coded is the following
> <public:component tagName="test1">
> <PUBLIC:ATTACH EVENT="oncontextmenu" onevent="f_CancelEvent()" />
> <PUBLIC:ATTACH EVENT="onselectstart" onevent="f_CancelEvent()" />
> <PUBLIC:ATTACH EVENT="ondragstart" onevent="f_CancelEvent()" />
> </public:component>
> <SCRIPT language="javascript">
> function f_CancelEvent()
> {
> event.returnValue = false;
> }
> </script>
> After that, I reference that piece of code in a css file as following
> body {
> margin: 0;
> background-color: White;
> font-family: Verdana, Sans-Serif;
> font-size: x-small;
> behavior: url(../js/test1.htc);
> }
>
> "Bava Mani" wrote:
> > Hi
> > in the htc you can access the frame page which contain the report and the
> > report manager using the javascript dhtml code.
> > you can use like
> > frame[0].document.
> > or window.document.getelementbyID['asd'].
> > you dont have to insert script in the frame
> > you can put all the code in htc to call the code..
> >
> > "jhcp" wrote:
> >
> > > Hi all,
> > > Does anyone knows how can I add some javascript code into the html page
> > > which contains a report into the report manager?.
> > > Let's the following scenario, suppose that any user wants to execute some
> > > reports from report manager, first the user goes to http://server/reports
> > > after that he/she will be at home page configured due to his/her profile, the
> > > user select a report with a click and, he/she executes it. The report will be
> > > rendered in html inside the same window where the report manager is, but in
> > > different frame.
> > > I know using both htc and css files I can modify some behavior of the html
> > > page but, the problem is that both report manager and the rendered report
> > > coexist in the same window( I mean different frames for each of them ) I
> > > don't know how to add some javascript code into the frame or page or whatever
> > > the report lives in.
> > > Any help will be appreciated.|||Hi Bava,
I'm using SSRS 2000.
Actually, I don't know how can I reference the iframe from htc file. Let me
explain.
What I want to do is to disable select any text or image inside the report
frame and, disable contextual menu too, that's why I posted the code
yesterday.
Could you please help me to do that?
I really appreciated your help.
"Bava Mani" wrote:
> Hi,
> are you using 2000 or 2005 reporting service?
> in 2000 there is only one iframe so you can just use
> window.frames.item(0)
> or
> window.document.getElementById(framid) if it is 2005
> hope it helps
> "jhcp" wrote:
> > Hi Bava,
> > thanks for your answer but, how can I know which frame contains the rendered
> > report?.
> > The htc file I coded is the following
> >
> > <public:component tagName="test1">
> > <PUBLIC:ATTACH EVENT="oncontextmenu" onevent="f_CancelEvent()" />
> > <PUBLIC:ATTACH EVENT="onselectstart" onevent="f_CancelEvent()" />
> > <PUBLIC:ATTACH EVENT="ondragstart" onevent="f_CancelEvent()" />
> > </public:component>
> > <SCRIPT language="javascript">
> > function f_CancelEvent()
> > {
> > event.returnValue = false;
> > }
> > </script>
> > After that, I reference that piece of code in a css file as following
> >
> > body {
> > margin: 0;
> > background-color: White;
> > font-family: Verdana, Sans-Serif;
> > font-size: x-small;
> > behavior: url(../js/test1.htc);
> > }
> >
> >
> >
> > "Bava Mani" wrote:
> >
> > > Hi
> > > in the htc you can access the frame page which contain the report and the
> > > report manager using the javascript dhtml code.
> > > you can use like
> > > frame[0].document.
> > > or window.document.getelementbyID['asd'].
> > > you dont have to insert script in the frame
> > > you can put all the code in htc to call the code..
> > >
> > > "jhcp" wrote:
> > >
> > > > Hi all,
> > > > Does anyone knows how can I add some javascript code into the html page
> > > > which contains a report into the report manager?.
> > > > Let's the following scenario, suppose that any user wants to execute some
> > > > reports from report manager, first the user goes to http://server/reports
> > > > after that he/she will be at home page configured due to his/her profile, the
> > > > user select a report with a click and, he/she executes it. The report will be
> > > > rendered in html inside the same window where the report manager is, but in
> > > > different frame.
> > > > I know using both htc and css files I can modify some behavior of the html
> > > > page but, the problem is that both report manager and the rendered report
> > > > coexist in the same window( I mean different frames for each of them ) I
> > > > don't know how to add some javascript code into the frame or page or whatever
> > > > the report lives in.
> > > > Any help will be appreciated.

Add Dataset Field in Page Header or Footer

Hi,
Is there any way to add a dataset field in Page Header or Footer
Thanks
PonnuPonnurangam,
Not a dataset field directly, but you can have a texbox item which displays
the field value and then in the page header/footer reference the textbox
item using the ReportItems collection.
--
Hope this helps.
----
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
----
"Ponnurangam" <ponnurangam@.trellisys.net> wrote in message
news:%23ZynKQqqEHA.3396@.tk2msftngp13.phx.gbl...
> Hi,
> Is there any way to add a dataset field in Page Header or Footer
> Thanks
> Ponnu
>

Add blank rows to table

Hello,
I need to create a report with a fixed number of table rows. For example:
the table is fixed at 20 rows per page regardless of data retrieved. If say
10 rows are filled with data then the rest are blanks. If 25 rows of data is
retrieved then the first page is filled and next page has 5 rows filled with
the rest blank. I also need a running row number in the first column. I've
managed that with "RowNumber(Nothing)" but I am not sure if it will work with
blank rows too. Is there any way to accomplish this? Through report
designer or custom code?
Thanks,
RodneyI would add rows to the source dataset. If the data is coming from a stored
procedure, append a dummy column to the end of the dataset and put a 1 in it
if the row contained data and a 2 if it did not (this way you have something
to sort on so that the blank rows are at the end of the report. Use a
count() in the stored procedure to determine how many rows to append to the
end of the dataset.
"Rodney" wrote:
> Hello,
> I need to create a report with a fixed number of table rows. For example:
> the table is fixed at 20 rows per page regardless of data retrieved. If say
> 10 rows are filled with data then the rest are blanks. If 25 rows of data is
> retrieved then the first page is filled and next page has 5 rows filled with
> the rest blank. I also need a running row number in the first column. I've
> managed that with "RowNumber(Nothing)" but I am not sure if it will work with
> blank rows too. Is there any way to accomplish this? Through report
> designer or custom code?
> Thanks,
> Rodney|||How would I append blank rows to a select query? Are you suggesting a
temporary table where the data and blank rows are dumped into? Would this be
a problem in a multiuser app?
"Kebler" wrote:
> I would add rows to the source dataset. If the data is coming from a stored
> procedure, append a dummy column to the end of the dataset and put a 1 in it
> if the row contained data and a 2 if it did not (this way you have something
> to sort on so that the blank rows are at the end of the report. Use a
> count() in the stored procedure to determine how many rows to append to the
> end of the dataset.
> "Rodney" wrote:
> > Hello,
> >
> > I need to create a report with a fixed number of table rows. For example:
> > the table is fixed at 20 rows per page regardless of data retrieved. If say
> > 10 rows are filled with data then the rest are blanks. If 25 rows of data is
> > retrieved then the first page is filled and next page has 5 rows filled with
> > the rest blank. I also need a running row number in the first column. I've
> > managed that with "RowNumber(Nothing)" but I am not sure if it will work with
> > blank rows too. Is there any way to accomplish this? Through report
> > designer or custom code?
> >
> > Thanks,
> >
> > Rodney

Add Blank Page

I have a report that is grouped by employee. The report lists the
training each employee has taken. What I want to do is have a page
with just the employee's name and some lines that can be used for
writing comments to print after the last page of data for the employee
is displayed. So, if page 1 and page 2 have employee training data,
page 3 will just have the employee's name and than a bunch of blank
lines.
Any help is appreciated.
Thanks. MKOn Nov 12, 12:21 pm, Mark <mark...@.gmail.com> wrote:
> I have a report that is grouped by employee. The report lists the
> training each employee has taken. What I want to do is have a page
> with just the employee's name and some lines that can be used for
> writing comments to print after the last page of data for the employee
> is displayed. So, if page 1 and page 2 have employee training data,
> page 3 will just have the employee's name and than a bunch of blank
> lines.
> Any help is appreciated.
> Thanks. MK
One way of doing it is to add a table control at the bottom of the
report and have the employee's name as the detail record. Then right-
click the top-left corner of the table control >> select Properties >>
select the General tab >> below 'Page breaks:' select 'Insert a page
break after this table.' Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Nov 12, 9:01 pm, EMartinez <emartinez...@.gmail.com> wrote:
> On Nov 12, 12:21 pm, Mark <mark...@.gmail.com> wrote:
> > I have a report that is grouped by employee. The report lists the
> > training each employee has taken. What I want to do is have a page
> > with just the employee's name and some lines that can be used for
> > writing comments to print after the last page of data for the employee
> > is displayed. So, if page 1 and page 2 have employee training data,
> > page 3 will just have the employee's name and than a bunch of blank
> > lines.
> > Any help is appreciated.
> > Thanks. MK
> One way of doing it is to add a table control at the bottom of the
> report and have the employee's name as the detail record. Then right-
> click the top-left corner of the table control >> select Properties >>
> select the General tab >> below 'Page breaks:' select 'Insert a page
> break after this table.' Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
Thank you for your reply Enrique
When I add the table to my report, it ends up printing after all of
the employees have printed. What I want to happen is:
Page 1 = employee one detail records
Page 2 = employee one detail records
Page 3 = employee one detail records
Page 4 = notes page for employee one
Page 5 = employee two detail records
Page 6 = employee two detail records
Page 7 = notes page for employee two
The notes page will just have the employees name and than a bunch of
lines for note writing.
Thanks for any help. Mark.|||On Nov 13, 12:30 pm, Mark <mark...@.gmail.com> wrote:
> On Nov 12, 9:01 pm, EMartinez <emartinez...@.gmail.com> wrote:
>
> > On Nov 12, 12:21 pm, Mark <mark...@.gmail.com> wrote:
> > > I have a report that is grouped by employee. The report lists the
> > > training each employee has taken. What I want to do is have a page
> > > with just the employee's name and some lines that can be used for
> > > writing comments to print after the last page of data for the employee
> > > is displayed. So, if page 1 and page 2 have employee training data,
> > > page 3 will just have the employee's name and than a bunch of blank
> > > lines.
> > > Any help is appreciated.
> > > Thanks. MK
> > One way of doing it is to add a table control at the bottom of the
> > report and have the employee's name as the detail record. Then right-
> > click the top-left corner of the table control >> select Properties >>
> > select the General tab >> below 'Page breaks:' select 'Insert a page
> > break after this table.' Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
> Thank you for your reply Enrique
> When I add the table to my report, it ends up printing after all of
> the employees have printed. What I want to happen is:
> Page 1 = employee one detail records
> Page 2 = employee one detail records
> Page 3 = employee one detail records
> Page 4 = notes page for employee one
> Page 5 = employee two detail records
> Page 6 = employee two detail records
> Page 7 = notes page for employee two
> The notes page will just have the employees name and than a bunch of
> lines for note writing.
> Thanks for any help. Mark.
You're welcome. The best way to control this is to pass the dataset
into the report in the format that you want to display it in. I'm not
sure how you would have a page break in this scenario though (aside
from possibly passing in empty records). Otherwise, you can underline
the field by: selecting the table row on the left >> right-click and
select Properties >> in the Properties tab, select BorderStyle >>
select the Drop-down list to the right of Bottom >> select
<Expression...> and enter something like:
=iif(Fields!ExtraColumn.Value = "Notes", "Solid", "None")
Where ExtraColumn is just that, set to either something like:
"Details" or "Notes". So in this expression if the extra field ="Notes", then set the bottom border to solid, else set it to none (or
invisible). Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Add blank lines after end of data on group

I have a report that looks sort of like:
Route: 123
Name: Jim
Name: Sue
Name: Mary
Route: 456
Name: Monica
Name: Steve
which page breaks on "Route". What i need is to have blank lines to
fill to the end of the page like:
Route: 123
Name: Jim
Name: Sue
Name: Mary
Name:
Name:
Name:
Name:
Name:
Name:
Thank you in advance!
Cheers,
SteveOn Dec 4, 4:18 pm, sfp <stevenprev...@.gmail.com> wrote:
> I have a report that looks sort of like:
> Route: 123
> Name: Jim
> Name: Sue
> Name: Mary
> Route: 456
> Name: Monica
> Name: Steve
> which page breaks on "Route". What i need is to have blank lines to
> fill to the end of the page like:
> Route: 123
> Name: Jim
> Name: Sue
> Name: Mary
> Name:
> Name:
> Name:
> Name:
> Name:
> Name:
> Thank you in advance!
> Cheers,
> Steve
Unfortunately, this type of behavior is not supported; however, you
could try using a while loop and determining the number of records per
page in T-SQL (the stored procedure/query that is sourcing the report)
and then return (x - known records per Route) as null/blank rows,
where x is the number of records that will fit on a page when printed/
etc based on your desired export option. Another much less desirable
option would be to modify the report after the fact using a
custom .NET application that utilizes StreamReader, StreamWriter, etc.
With this option, you can control extra text down to the character;
however, this a good deal of work and most likely is not the best
option for you situation. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Hi
Heres another tip to do what you want , I assume you are using a
table. Place another column in your table and use =rownumber(nothing).
When you render the report, you'll see the number of rows which are
created prior to the page break. Lets say 10 rows are created. Now
write a stored proc or a query , something like this
Declare @.counter int
Declare @.Temp table (rowno int)
Set @.counter=0
While @.Counter<10
Begin
Insert into @.Temp
Select @.Counter
Set @.counter = @.Counter + 1
End
Select * from @.Temp
Now create another table object under the one you have created, with
one column , no header or footer and the above data source. Hardcode
the value "Name:" in the single column . That should do it. Please be
aware that I have not tested the code I have written.
Cheers
Shai
On Dec 5, 11:11 pm, EMartinez <emartinez...@.gmail.com> wrote:
> On Dec 4, 4:18 pm, sfp <stevenprev...@.gmail.com> wrote:
>
>
> > I have a report that looks sort of like:
> > Route: 123
> > Name: Jim
> > Name: Sue
> > Name: Mary
> > Route: 456
> > Name: Monica
> > Name: Steve
> > which page breaks on "Route". What i need is to have blank lines to
> > fill to the end of the page like:
> > Route: 123
> > Name: Jim
> > Name: Sue
> > Name: Mary
> > Name:
> > Name:
> > Name:
> > Name:
> > Name:
> > Name:
> > Thank you in advance!
> > Cheers,
> > Steve
> Unfortunately, this type of behavior is not supported; however, you
> could try using a while loop and determining the number of records per
> page in T-SQL (the stored procedure/query that is sourcing the report)
> and then return (x - known records per Route) as null/blank rows,
> where x is the number of records that will fit on a page when printed/
> etc based on your desired export option. Another much less desirable
> option would be to modify the report after the fact using a
> custom .NET application that utilizes StreamReader, StreamWriter, etc.
> With this option, you can control extra text down to the character;
> however, this a good deal of work and most likely is not the best
> option for you situation. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant- Hide quoted text -
> - Show quoted text -

add an image to the web page

hi

u didnot get the question!

I asked I copeid an image to the app_data folder and dropdowned a image object to the web form, image--> style-->background-->background image-->select back ground image from the app_data folder , the image appear on the page but when I debug the page it donot display

Thats because you posted in the wrong forum, this is a SQL Server Express forum and depending on the rare information you gave, I assumed that you want to load the image from SQL Server and display it in a webpage. If the file is on disk you will have to provide the code you are using to do this. BTW the app_data folder is reserved for storing data not the actual res / misc files.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

add a pramater.value to the jump to url link

I need to open a aspx page from a report jump to ulr action. but I need to pass in a prameter value. see example
http://ktec_inet/gco/productionreports/prod_asp/pcba_station_detail.asp?processname=335ICT×tampw=999999999&userid=WeeklyYieldPCBA&queryflag= Parameters!prod_cls.Value
--
Message posted via http://www.sqlmonster.comUse the expression
="http://ktec_inet/gco/productionreports/prod_asp/pcba_station_detail.asp?
processname=335ICT×tampw=999999999&userid=WeeklyYieldPCBA&queryflag=" &
Parameters!prod_cls.Value
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lee Hopkins via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:4b989eb2a43e487a8a731afd19e27357@.SQLMonster.com...
>I need to open a aspx page from a report jump to ulr action. but I need to
>pass in a prameter value. see example
> http://ktec_inet/gco/productionreports/prod_asp/pcba_station_detail.asp?processname=335ICT×tampw=999999999&userid=WeeklyYieldPCBA&queryflag=
> Parameters!prod_cls.Value
> --
> Message posted via http://www.sqlmonster.com