How Do I Manage a Report Header

In a post titled "Report Header Only on First Page", Charles Kangai replied
that:
"It sounds like you have used a page header rather than a report header in
your report. A report header automatically does what you are wanting to do.
To create a report header, just place a textbox above your data region and
type in the text for your header. It will automatically appear only on the
first page."
I'll be danged if I can find the Report Header option in SRS. I have a Page
Header and I also need a Report Header. Can anyone help, please
Thank you,
msflinxReport Header and Footer is hidden by Default in Designer. Go to "Report" on
the Menu and You can See "Report header" and "Report Footer" options. Click
on the options to enable it.
--
THANKS & PLEASE RATE THE POSTING.
--RAVI--
"msflinx" wrote:
> In a post titled "Report Header Only on First Page", Charles Kangai replied
> that:
> "It sounds like you have used a page header rather than a report header in
> your report. A report header automatically does what you are wanting to do.
> To create a report header, just place a textbox above your data region and
> type in the text for your header. It will automatically appear only on the
> first page."
> I'll be danged if I can find the Report Header option in SRS. I have a Page
> Header and I also need a Report Header. Can anyone help, please
> Thank you,
> msflinx|||I see "Page Header" & "Page Footer". I do not see "Report Header" & "Report
Footer". I'm using SRS2000. Is this a SRS2005 only option?
Thanks,
msflinx
"Ravi" wrote:
> Report Header and Footer is hidden by Default in Designer. Go to "Report" on
> the Menu and You can See "Report header" and "Report Footer" options. Click
> on the options to enable it.
> --
> THANKS & PLEASE RATE THE POSTING.
> --RAVI--
>
> "msflinx" wrote:
> > In a post titled "Report Header Only on First Page", Charles Kangai replied
> > that:
> >
> > "It sounds like you have used a page header rather than a report header in
> > your report. A report header automatically does what you are wanting to do.
> > To create a report header, just place a textbox above your data region and
> > type in the text for your header. It will automatically appear only on the
> > first page."
> >
> > I'll be danged if I can find the Report Header option in SRS. I have a Page
> > Header and I also need a Report Header. Can anyone help, please
> >
> > Thank you,
> >
> > msflinx|||Actually in RS2005, when you click on Report, you see "Page Header" and
"Page Footer", not the report header and footer.
"Ravi" <ravishankart@.hotmail.com> wrote in message
news:CB7C7C32-2911-4977-8D94-5B9EFD3EEDBB@.microsoft.com...
> Report Header and Footer is hidden by Default in Designer. Go to "Report"
> on
> the Menu and You can See "Report header" and "Report Footer" options.
> Click
> on the options to enable it.
> --
> THANKS & PLEASE RATE THE POSTING.
> --RAVI--
>
> "msflinx" wrote:
>> In a post titled "Report Header Only on First Page", Charles Kangai
>> replied
>> that:
>> "It sounds like you have used a page header rather than a report header
>> in
>> your report. A report header automatically does what you are wanting to
>> do.
>> To create a report header, just place a textbox above your data region
>> and
>> type in the text for your header. It will automatically appear only on
>> the
>> first page."
>> I'll be danged if I can find the Report Header option in SRS. I have a
>> Page
>> Header and I also need a Report Header. Can anyone help, please
>> Thank you,
>> msflinx|||Are you using a table?
--
THANKS & PLEASE RATE THE POSTING.
--RAVI--
"msflinx" wrote:
> I see "Page Header" & "Page Footer". I do not see "Report Header" & "Report
> Footer". I'm using SRS2000. Is this a SRS2005 only option?
> Thanks,
> msflinx
> "Ravi" wrote:
> > Report Header and Footer is hidden by Default in Designer. Go to "Report" on
> > the Menu and You can See "Report header" and "Report Footer" options. Click
> > on the options to enable it.
> >
> > --
> > THANKS & PLEASE RATE THE POSTING.
> > --RAVI--
> >
> >
> > "msflinx" wrote:
> >
> > > In a post titled "Report Header Only on First Page", Charles Kangai replied
> > > that:
> > >
> > > "It sounds like you have used a page header rather than a report header in
> > > your report. A report header automatically does what you are wanting to do.
> > > To create a report header, just place a textbox above your data region and
> > > type in the text for your header. It will automatically appear only on the
> > > first page."
> > >
> > > I'll be danged if I can find the Report Header option in SRS. I have a Page
> > > Header and I also need a Report Header. Can anyone help, please
> > >
> > > Thank you,
> > >
> > > msflinx|||Sorry for the delay in answering. Had a "child emergency" and had to leave
the office.
Yes, I am using a table.
"Ravi" wrote:
> Are you using a table?
> --
> THANKS & PLEASE RATE THE POSTING.
> --RAVI--
>
> "msflinx" wrote:
> > I see "Page Header" & "Page Footer". I do not see "Report Header" & "Report
> > Footer". I'm using SRS2000. Is this a SRS2005 only option?
> >
> > Thanks,
> > msflinx
> >
> > "Ravi" wrote:
> >
> > > Report Header and Footer is hidden by Default in Designer. Go to "Report" on
> > > the Menu and You can See "Report header" and "Report Footer" options. Click
> > > on the options to enable it.
> > >
> > > --
> > > THANKS & PLEASE RATE THE POSTING.
> > > --RAVI--
> > >
> > >
> > > "msflinx" wrote:
> > >
> > > > In a post titled "Report Header Only on First Page", Charles Kangai replied
> > > > that:
> > > >
> > > > "It sounds like you have used a page header rather than a report header in
> > > > your report. A report header automatically does what you are wanting to do.
> > > > To create a report header, just place a textbox above your data region and
> > > > type in the text for your header. It will automatically appear only on the
> > > > first page."
> > > >
> > > > I'll be danged if I can find the Report Header option in SRS. I have a Page
> > > > Header and I also need a Report Header. Can anyone help, please
> > > >
> > > > Thank you,
> > > >
> > > > msflinx

How do I make Newspaper Columns in RS

I have 3 columns on my report in a table region. I would like for these 3 cols to print across the page (landscape)width such that more data can fit on to a page - like using newspaper columns in word. How can I do this in reporting services? Thanks in advance for your help.

You can add columns to a report. However, they only show up in certain rendering extensions. In the PDF and TIFF rendering extensions. This means you will not see the column layout in Report Manager or when Previewing the reports in Report Designer. See this link:

http://msdn2.microsoft.com/en-us/library/ms155816.aspx

sql

How do I link two different field lengths with the same data

Hi,
In Crystal Reports 8.5, I am linking one file to another but do not get report data. The reason is the fields I am using to link one string is 4 characters while the other is 6. Is there a way to get two fields containing the same data in different files but wth different field lengths to link. thank youBump. This post is old, but I'm needing to do basically the same thing. I've got Crystal Reports 11.

Thanks

how do I keep a table from shifting items below the table

I have a table on a report that will have the max of 6 rows and below that I
need to have other information on the report to print onto fields on a form,
when the rows change in the table the textboxes below get shifted. How do I
stop this from happening?
Thanks,
JimMake your textboxes as large as they should grow and turn off 'CanGrow'.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jim Ciotuszynski" <jimcio@.hotmail.com> wrote in message
news:uu2Kr%237WEHA.1128@.TK2MSFTNGP10.phx.gbl...
>I have a table on a report that will have the max of 6 rows and below that
>I
> need to have other information on the report to print onto fields on a
> form,
> when the rows change in the table the textboxes below get shifted. How do
> I
> stop this from happening?
> Thanks,
> Jim
>

How do I keep a report from automatically running?

This is a multi-part message in MIME format.
--=_NextPart_000_000A_01C75C1E.0326B0B0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Perhaps this is just behavior in the dev environment, but if I provide = default values for all of my paramters, the report runs automatically = when I switch to preview.
Is there a way to provide defaults, but still require the user to click = view before the report runs?
Thanks.
--=_NextPart_000_000A_01C75C1E.0326B0B0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Perhaps this is just behavior in the = dev environment, but if I provide default values for all of my paramters, = the report runs automatically when I switch to preview.

Is there a way to provide defaults, but = still require the user to click view before the report runs?

Thanks.
--=_NextPart_000_000A_01C75C1E.0326B0B0--On Mar 1, 5:23 pm, <rlrc...@.newsgroups.nospam> wrote:
> Perhaps this is just behavior in the dev environment, but if I provide default values for all of my paramters, the report runs automatically when I switch to preview.
> Is there a way to provide defaults, but still require the user to click view before the report runs?
> Thanks.
As far as I know, there is not a way to keep the report from
automatically running without removing at least one of the parameter's
default values.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||You can probably create a parameter and hide it...and then not provide it
default value.
-
HelpSeeker
"rlrcstr@.newsgroups.nospam" wrote:
> Perhaps this is just behavior in the dev environment, but if I provide default values for all of my paramters, the report runs automatically when I switch to preview.
> Is there a way to provide defaults, but still require the user to click view before the report runs?
> Thanks|||Hi rlrcstr,
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.

How do I jump to another report based on a value in my current report? report has no parameters.

How do I jump to another report based on a value in my current report. The report that I am jumping from has no parameters, just values.

Hello,

Does your target report have parameters? For example, you want to go to the target report and run it with the value you selected on the current report?

Or are you saying... If the field value is between a and b, go to report 1, if it's between b and c, go to report 2, otherwise go to report 3.

Can you explain a little more about your situation?

Jarret

|||

the report I am jumping from has no parameters. I want to be able to click on a value and have it jump to another report. That report possibly being jumped too might or might not have parameters.

I just used the following expression and it works to a degree, but it enables all the values in the column for jumping, rather than just the report I want

=iif(Fields!YN_DESC.Value="A","Report 1","Report2")

|||

Sorry for the delay...

This will only enable the "A" values to jump to a report (Report 1), any other values will not have the jump to enabled.

=Switch(Fields!YN_Desc.Value = "A", "Report 1")

If you need to add additional conditions... Example, if the value is "C" - Report 31, "D" - Report 7.

=Switch(Fields!YN_Desc.Value = "A", "Report 1",
Fields!YN_Desc.Value = "C", "Report 31",
Fields!YN_Desc.Value = "D", "Report 7")

Hope this helps.

Jarret

How do I jump to another report based on a value in my current report? report has no parameters.

How do I jump to another report based on a value in my current report. The report that I am jumping from has no parameters, just values.

Hello,

Does your target report have parameters? For example, you want to go to the target report and run it with the value you selected on the current report?

Or are you saying... If the field value is between a and b, go to report 1, if it's between b and c, go to report 2, otherwise go to report 3.

Can you explain a little more about your situation?

Jarret

|||

the report I am jumping from has no parameters. I want to be able to click on a value and have it jump to another report. That report possibly being jumped too might or might not have parameters.

I just used the following expression and it works to a degree, but it enables all the values in the column for jumping, rather than just the report I want

=iif(Fields!YN_DESC.Value="A","Report 1","Report2")

|||

Sorry for the delay...

This will only enable the "A" values to jump to a report (Report 1), any other values will not have the jump to enabled.

=Switch(Fields!YN_Desc.Value = "A", "Report 1")

If you need to add additional conditions... Example, if the value is "C" - Report 31, "D" - Report 7.

=Switch(Fields!YN_Desc.Value = "A", "Report 1",
Fields!YN_Desc.Value = "C", "Report 31",
Fields!YN_Desc.Value = "D", "Report 7")

Hope this helps.

Jarret

How do I jump to another report based on a value

How do I jump to another report based on a value in my current report?

Right-click on the field you wish to link, select Navigation, select jump to report, and specify the report and any parameters required.

Here are a couple of links that may help.

http://msdn2.microsoft.com/en-us/library/aa964132.aspx

http://www.codeproject.com/useritems/InputParmReport.asp?df=100&forumid=290297&exp=0&select=1472409

cheers,

Andrew

|||

Thanks Andrew,

The examples that you gave me are based on parameters. I made a mistake. What I actually need is to be able to jump to a

report based on a value in one of the report columns. The report that I am jumping from has no parameters and is just a table with

columns and values. How can I do this?

|||

Hi,

you can use the hyperlink action "jump to report" using an expression like this:

=IIf(Logical_Expression, "reportname 1", "reportname 2")

Best regards

Sven

|||

Hi Sven

I tried doing this and it jumps to the report. The problem I am encountering is that the whole column is being enabled to jump rather than just the selected being enabled when the user passes his cursour over it. How do I enable just that value and not all the column values?

|||Hi,
then you have to use the switch-function instead of the iif-function.
=switch(Logical_Expression, "reportname")
br
Sven

How do I in Crystal 10

Using CRYSTAL 10.
A field titled INVOICE NUMBER always has *0000000 at the end. These are extraneous characters I do not need on the report. How do I remove them from the Invoice Number field. The field length is 25; and, again, I do not need the last eight characters.If it is a character field then u can use SQL expression , and builtin function substring.sql

How do i implement Multi value parameter

Hi..

I want to have a multivalue parameter in my report... I have selected that parameter and clicked on multivalue and then when i run the report.. it works fine for one and and not for more than one...

any help will be appreciated.

Regards

Karen

Karen, a question, how is your multivalue parameter used in your datasource? It should be :

SELECT *
FROM HELLO_DATA
WHERE COLUMN1 IN (@.MULTIVALUEPARAMETER1)

Hope this helps,

|||

thanks i figured it out and now it works fine.

Regards

Karen

sql

How do I hide a table in a report programatically?

Hi,
I have 2 tables in a report and, depending on which value a user picks in a
particular parameter, I want to display only one of the tables. Is there any
way to do something like, "IIF(parameters!param_A.value = "Y", visible = true, visible = false)" or something like that for a table?
--
Thanks,
JeffSet the table's Hidden property to an expression. For example:
=CBool(Parameters!HideTheTable.Value)
The Hidden property can be accessed by expanding Visibility... in the
Properties window.
HTH
On Oct 1, 3:39 pm, Jeff Stroope
<JeffStro...@.discussions.microsoft.com> wrote:
> Hi,
> I have 2 tables in a report and, depending on which value a user picks in a
> particular parameter, I want to display only one of the tables. Is there any
> way to do something like, "IIF(parameters!param_A.value = "Y", visible => true, visible = false)" or something like that for a table?
> --
> Thanks,
> Jeff|||On Oct 1, 5:39 pm, Jeff Stroope
<JeffStro...@.discussions.microsoft.com> wrote:
> Hi,
> I have 2 tables in a report and, depending on which value a user picks in a
> particular parameter, I want to display only one of the tables. Is there any
> way to do something like, "IIF(parameters!param_A.value = "Y", visible => true, visible = false)" or something like that for a table?
> --
> Thanks,
> Jeff
The best way to accomplish this is to control the data populating the
table controls at the stored procedure/query level that is sourcing
the report. For example, pass the parameter value back to the stored
procedure(s)/query(ies) and if it is a certain value, return an empty
resultset to the report. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thanks Chris!
--
Thanks,
Jeff
"Chris Durkin" wrote:
> Set the table's Hidden property to an expression. For example:
> =CBool(Parameters!HideTheTable.Value)
>
> The Hidden property can be accessed by expanding Visibility... in the
> Properties window.
>
> HTH
>
> On Oct 1, 3:39 pm, Jeff Stroope
> <JeffStro...@.discussions.microsoft.com> wrote:
> > Hi,
> >
> > I have 2 tables in a report and, depending on which value a user picks in a
> > particular parameter, I want to display only one of the tables. Is there any
> > way to do something like, "IIF(parameters!param_A.value = "Y", visible => > true, visible = false)" or something like that for a table?
> > --
> > Thanks,
> >
> > Jeff
>
>|||Thanks Enrique!
--
Thanks,
Jeff
"EMartinez" wrote:
> On Oct 1, 5:39 pm, Jeff Stroope
> <JeffStro...@.discussions.microsoft.com> wrote:
> > Hi,
> >
> > I have 2 tables in a report and, depending on which value a user picks in a
> > particular parameter, I want to display only one of the tables. Is there any
> > way to do something like, "IIF(parameters!param_A.value = "Y", visible => > true, visible = false)" or something like that for a table?
> > --
> > Thanks,
> >
> > Jeff
>
> The best way to accomplish this is to control the data populating the
> table controls at the stored procedure/query level that is sourcing
> the report. For example, pass the parameter value back to the stored
> procedure(s)/query(ies) and if it is a certain value, return an empty
> resultset to the report. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>

How do I get Visual Studio to open a deployed report?

Greetings,

I have a report that was previously deployed to a reporting services host (running Reporting Services 2005 SP2) and I'm running the version of Visual Studio that came with reporting services on the same reporting serviceshost. The deployed report was never opened on this particular server, so it doesn't appear in the recent files list. Is there a trick to open a deployed report in all of Visual Studio's report editing glory? Visual Studio has a File Open option to open an analysis services database, a project, or a file. A "deployed report" seems to be none of these options since it's an RDL file stored somewhere that IIS can find it. I know that I can use Report Manager and export the RDL for the report and then edit that RDL file in Visual Studio, but doing that appears to disable all of Visual Studio's report editing features (ie it works no better than notepad). What's the trick to get Visual Studio to open the deployed report and allow all of it's editing tools to work properly and then save the updated report back to the reporting services server?

Thanks,

Ron

In report manager, go to the report properties.

there is a button in there 'save/edit' or similar

you can then save the file locally and open it in vs.net

NB don't forget 2000 rdl files will be automatically upgraded to 2005

How do i get the report in PDF format?

Hi all,

I need to get a report in PDF format.How to get that.I did the coding but am not getting.The following code i tried am not getting.what is the wrong in this coding.

WebMedRS.ReportingService rs = new WebMedRS.ReportingService();
rs.Credentials = System.Net.CredentialCache.DefaultCredentials;
parametersIn[0] = new ParameterValue();
parametersIn[0].Name = "claimid";
parametersIn[0].Value = Request.QueryString[0].ToString();
ParameterValue[] parametersOut = null;
byte[] result = null;
string reportPath = "/CMS/CmsFrom1";
string format = "Image";
string historyID = null;
string encoding;
string mimeType;
string extension;
Warning[] warnings = null;
string[] streamIDs = null;
result = rs.Render(reportPath, format, null, null, parametersIn, null, null, out encoding, out mimeType, out parametersOut, out warnings, out streamIDs);
Response.ClearContent();
Response.AppendHeader("content-length", result.Length.ToString());
Response.ContentType = "application/pdf";
Response.BinaryWrite(result);
Response.Flush();
Response.Close();

Thanks In Advance,

Yours,

Senthil

You will have to change the format:

string format = "PDF";

Jens K. Suessmeyer.

http://www.sqlserver2005.de

How do I get the initals of a name in a report?

Hello all,
does anybody know the code to get the name initials for a field in a report?
e.g. username is 'John Miller' and i want only the initials 'JM'?
Thanks.Hey is your data going to be same meaning (firstname lastname) then can be
done using
= left(field!name, 1) + " " + mid(field!name, instr(" ", field!name) +1 ,1)
left will return the first letter and instring will search the space +1 so
the last name letter is pointed and length is 1 so it picks up the first
letter of the lastname.
Amarnath
"Joggel" wrote:
> Hello all,
> does anybody know the code to get the name initials for a field in a report?
> e.g. username is 'John Miller' and i want only the initials 'JM'?
>
> Thanks.
>

How Do I Get SQL Server 2000 Reboot Time

I'd like to report to the user when the server was most recently
rebooted.
Is there a stored procedure or SQL Server 2000 command that I can issue?you can use this script here from www.insidesql.de:
SELECT
DATEDIFF(hh,crdate,GETDATE()) AS UpTimeInStunden
FROM
master.dbo.SYSDATABASES
WHERE
Name = 'TempDB'
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--|||Hi,
no need to multipost, asnwered in .sqlserver.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--|||Just use the SystemInfo.exe commandline tool.
<BillJohnson4@.gmail.com> wrote in message
news:1145643233.124362.207240@.i39g2000cwa.googlegroups.com...
> I'd like to report to the user when the server was most recently
> rebooted.
> Is there a stored procedure or SQL Server 2000 command that I can issue?
>|||> I'd like to report to the user when the server was most recently rebooted.
> Is there a stored procedure or SQL Server 2000 command that I can issue?
SELECT login_time FROM master.dbo.sysprocesses WHERE spid=1

How Do I Get SQL Server 2000 Reboot Time

I'd like to report to the user when the server was most recently
rebooted.
Is there a stored procedure or SQL Server 2000 command that I can issue?you can use this script here from www.insidesql.de:
SELECT
DATEDIFF(hh,crdate,GETDATE()) AS UpTimeInStunden
FROM
master.dbo.SYSDATABASES
WHERE
Name = 'TempDB'
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--|||Hi,
no need to multipost, asnwered in .sqlserver.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--|||Just use the SystemInfo.exe commandline tool.
<BillJohnson4@.gmail.com> wrote in message
news:1145643233.124362.207240@.i39g2000cwa.googlegroups.com...
> I'd like to report to the user when the server was most recently
> rebooted.
> Is there a stored procedure or SQL Server 2000 command that I can issue?
>|||> I'd like to report to the user when the server was most recently rebooted.
> Is there a stored procedure or SQL Server 2000 command that I can issue?
SELECT login_time FROM master.dbo.sysprocesses WHERE spid=1

How do i get rid of page breaks for HTML view...

Hello, I would like to get my reports to be on one page when viewing in HTML
in the report viewer. People generally dont want to have to flip through
pages when looking at reports online... they would much rather see the entire
report and just keep scrolling... however when printing you would want the
page-breaks to still happen (naturall).
Currently in Crystal using their report viewer control I simply removing the
paging controls to get this effect iirc... i tried hiding the paging control
in the RS report viewer control and i simply got a paged report with no way
of advancing through the pages...
Can someone please help me do this.Here is the solution. This works only for RS 2005. RS 2005 introduced
interactivesize which consists of interactivewidth and interactiveheight. To
have no page breaks set the interactiveheight to 0. This only works for
height, not width. You need to get to the report properties. You know how
when you click on the body or a textbox you see the property page for that
element on the right. If you click to the left of the ruler, that gets the
report properties to show (the menu, report properties does allow setting
this). Look for interactivesize, expand and then set interactiveheight to 0.
Not very discoverable but pretty cool.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"thejez" <thejez@.discussions.microsoft.com> wrote in message
news:E4ABC9C1-43F0-4564-B248-7EE7D818CC0B@.microsoft.com...
> Hello, I would like to get my reports to be on one page when viewing in
> HTML
> in the report viewer. People generally dont want to have to flip through
> pages when looking at reports online... they would much rather see the
> entire
> report and just keep scrolling... however when printing you would want the
> page-breaks to still happen (naturall).
> Currently in Crystal using their report viewer control I simply removing
> the
> paging controls to get this effect iirc... i tried hiding the paging
> control
> in the RS report viewer control and i simply got a paged report with no
> way
> of advancing through the pages...
> Can someone please help me do this.|||I think im posting this question to wrong place (but in all fairness its very
confusing from MS) - I am using a LOCAL report in VS 2005 ReportViewer
control - so i dont see the interactive options. I have RS 2005 but I am
unable to use it because of the limitations of how i can poplate the data (I
have to do pre-aggregation on the data before it gets to the dataset to get
around the aggregate of aggregates lmiitation). So my only option was to use
a local report where i could get the data from the DB pre-process it and then
pop the dataset and then render the report... this a big pain i know but what
can i do...
so is there any way in the VS 2005 ReportViewer and a local Report file
(rdlc). I have height set to 100% on everything and i even went to far as to
define the report at 160in high... but alas the control seems to break at the
same place ignoring everything i throw at it!
:(
"Bruce L-C [MVP]" wrote:
> Here is the solution. This works only for RS 2005. RS 2005 introduced
> interactivesize which consists of interactivewidth and interactiveheight. To
> have no page breaks set the interactiveheight to 0. This only works for
> height, not width. You need to get to the report properties. You know how
> when you click on the body or a textbox you see the property page for that
> element on the right. If you click to the left of the ruler, that gets the
> report properties to show (the menu, report properties does allow setting
> this). Look for interactivesize, expand and then set interactiveheight to 0.
> Not very discoverable but pretty cool.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "thejez" <thejez@.discussions.microsoft.com> wrote in message
> news:E4ABC9C1-43F0-4564-B248-7EE7D818CC0B@.microsoft.com...
> > Hello, I would like to get my reports to be on one page when viewing in
> > HTML
> > in the report viewer. People generally dont want to have to flip through
> > pages when looking at reports online... they would much rather see the
> > entire
> > report and just keep scrolling... however when printing you would want the
> > page-breaks to still happen (naturall).
> >
> > Currently in Crystal using their report viewer control I simply removing
> > the
> > paging controls to get this effect iirc... i tried hiding the paging
> > control
> > in the RS report viewer control and i simply got a paged report with no
> > way
> > of advancing through the pages...
> >
> > Can someone please help me do this.
>
>|||Bruce, i managed to just put the <InteractiveHeight>0in</InteractiveHeight>
element into my RDLC file and it worked... so even though there isnt any
design-tim support for setting that value (at least that i saw) adding it to
the source file did the trick.
thanks!
"thejez" wrote:
> I think im posting this question to wrong place (but in all fairness its very
> confusing from MS) - I am using a LOCAL report in VS 2005 ReportViewer
> control - so i dont see the interactive options. I have RS 2005 but I am
> unable to use it because of the limitations of how i can poplate the data (I
> have to do pre-aggregation on the data before it gets to the dataset to get
> around the aggregate of aggregates lmiitation). So my only option was to use
> a local report where i could get the data from the DB pre-process it and then
> pop the dataset and then render the report... this a big pain i know but what
> can i do...
> so is there any way in the VS 2005 ReportViewer and a local Report file
> (rdlc). I have height set to 100% on everything and i even went to far as to
> define the report at 160in high... but alas the control seems to break at the
> same place ignoring everything i throw at it!
> :(
> "Bruce L-C [MVP]" wrote:
> > Here is the solution. This works only for RS 2005. RS 2005 introduced
> > interactivesize which consists of interactivewidth and interactiveheight. To
> > have no page breaks set the interactiveheight to 0. This only works for
> > height, not width. You need to get to the report properties. You know how
> > when you click on the body or a textbox you see the property page for that
> > element on the right. If you click to the left of the ruler, that gets the
> > report properties to show (the menu, report properties does allow setting
> > this). Look for interactivesize, expand and then set interactiveheight to 0.
> >
> > Not very discoverable but pretty cool.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "thejez" <thejez@.discussions.microsoft.com> wrote in message
> > news:E4ABC9C1-43F0-4564-B248-7EE7D818CC0B@.microsoft.com...
> > > Hello, I would like to get my reports to be on one page when viewing in
> > > HTML
> > > in the report viewer. People generally dont want to have to flip through
> > > pages when looking at reports online... they would much rather see the
> > > entire
> > > report and just keep scrolling... however when printing you would want the
> > > page-breaks to still happen (naturall).
> > >
> > > Currently in Crystal using their report viewer control I simply removing
> > > the
> > > paging controls to get this effect iirc... i tried hiding the paging
> > > control
> > > in the RS report viewer control and i simply got a paged report with no
> > > way
> > > of advancing through the pages...
> > >
> > > Can someone please help me do this.
> >
> >
> >|||You beat me to it, that is what I was going to suggest.
Also, here is a suggestion for development. Develop reports in RS 2005
designer. The designer is better and you can quickly preview. Don't deploy
the report. Then, rename the rdl file to rdlc and bring it into your
project. This is how I do it. Much nicer development environment.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"thejez" <thejez@.discussions.microsoft.com> wrote in message
news:1A2F6C1F-3453-412A-AC0E-363C18C89D08@.microsoft.com...
> Bruce, i managed to just put the
> <InteractiveHeight>0in</InteractiveHeight>
> element into my RDLC file and it worked... so even though there isnt any
> design-tim support for setting that value (at least that i saw) adding it
> to
> the source file did the trick.
> thanks!
> "thejez" wrote:
>> I think im posting this question to wrong place (but in all fairness its
>> very
>> confusing from MS) - I am using a LOCAL report in VS 2005 ReportViewer
>> control - so i dont see the interactive options. I have RS 2005 but I am
>> unable to use it because of the limitations of how i can poplate the data
>> (I
>> have to do pre-aggregation on the data before it gets to the dataset to
>> get
>> around the aggregate of aggregates lmiitation). So my only option was to
>> use
>> a local report where i could get the data from the DB pre-process it and
>> then
>> pop the dataset and then render the report... this a big pain i know but
>> what
>> can i do...
>> so is there any way in the VS 2005 ReportViewer and a local Report file
>> (rdlc). I have height set to 100% on everything and i even went to far
>> as to
>> define the report at 160in high... but alas the control seems to break at
>> the
>> same place ignoring everything i throw at it!
>> :(
>> "Bruce L-C [MVP]" wrote:
>> > Here is the solution. This works only for RS 2005. RS 2005 introduced
>> > interactivesize which consists of interactivewidth and
>> > interactiveheight. To
>> > have no page breaks set the interactiveheight to 0. This only works for
>> > height, not width. You need to get to the report properties. You know
>> > how
>> > when you click on the body or a textbox you see the property page for
>> > that
>> > element on the right. If you click to the left of the ruler, that gets
>> > the
>> > report properties to show (the menu, report properties does allow
>> > setting
>> > this). Look for interactivesize, expand and then set interactiveheight
>> > to 0.
>> >
>> > Not very discoverable but pretty cool.
>> >
>> >
>> > --
>> > Bruce Loehle-Conger
>> > MVP SQL Server Reporting Services
>> >
>> > "thejez" <thejez@.discussions.microsoft.com> wrote in message
>> > news:E4ABC9C1-43F0-4564-B248-7EE7D818CC0B@.microsoft.com...
>> > > Hello, I would like to get my reports to be on one page when viewing
>> > > in
>> > > HTML
>> > > in the report viewer. People generally dont want to have to flip
>> > > through
>> > > pages when looking at reports online... they would much rather see
>> > > the
>> > > entire
>> > > report and just keep scrolling... however when printing you would
>> > > want the
>> > > page-breaks to still happen (naturall).
>> > >
>> > > Currently in Crystal using their report viewer control I simply
>> > > removing
>> > > the
>> > > paging controls to get this effect iirc... i tried hiding the paging
>> > > control
>> > > in the RS report viewer control and i simply got a paged report with
>> > > no
>> > > way
>> > > of advancing through the pages...
>> > >
>> > > Can someone please help me do this.
>> >
>> >
>> >|||another update... after re-starting visual studio (since my properties window
was laggin very badly) i went back into the report and now i notice that when
you click on the out-grey area of the report i can see the interactive
property... hrmm so it is there... at least now it is... i dont think it was
there before.. but like i said my properties page was acting VERY funky (like
showing the properties for a DD control on another page while editing the
report...)
"thejez" wrote:
> Bruce, i managed to just put the <InteractiveHeight>0in</InteractiveHeight>
> element into my RDLC file and it worked... so even though there isnt any
> design-tim support for setting that value (at least that i saw) adding it to
> the source file did the trick.
> thanks!
> "thejez" wrote:
> > I think im posting this question to wrong place (but in all fairness its very
> > confusing from MS) - I am using a LOCAL report in VS 2005 ReportViewer
> > control - so i dont see the interactive options. I have RS 2005 but I am
> > unable to use it because of the limitations of how i can poplate the data (I
> > have to do pre-aggregation on the data before it gets to the dataset to get
> > around the aggregate of aggregates lmiitation). So my only option was to use
> > a local report where i could get the data from the DB pre-process it and then
> > pop the dataset and then render the report... this a big pain i know but what
> > can i do...
> >
> > so is there any way in the VS 2005 ReportViewer and a local Report file
> > (rdlc). I have height set to 100% on everything and i even went to far as to
> > define the report at 160in high... but alas the control seems to break at the
> > same place ignoring everything i throw at it!
> >
> > :(
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > Here is the solution. This works only for RS 2005. RS 2005 introduced
> > > interactivesize which consists of interactivewidth and interactiveheight. To
> > > have no page breaks set the interactiveheight to 0. This only works for
> > > height, not width. You need to get to the report properties. You know how
> > > when you click on the body or a textbox you see the property page for that
> > > element on the right. If you click to the left of the ruler, that gets the
> > > report properties to show (the menu, report properties does allow setting
> > > this). Look for interactivesize, expand and then set interactiveheight to 0.
> > >
> > > Not very discoverable but pretty cool.
> > >
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "thejez" <thejez@.discussions.microsoft.com> wrote in message
> > > news:E4ABC9C1-43F0-4564-B248-7EE7D818CC0B@.microsoft.com...
> > > > Hello, I would like to get my reports to be on one page when viewing in
> > > > HTML
> > > > in the report viewer. People generally dont want to have to flip through
> > > > pages when looking at reports online... they would much rather see the
> > > > entire
> > > > report and just keep scrolling... however when printing you would want the
> > > > page-breaks to still happen (naturall).
> > > >
> > > > Currently in Crystal using their report viewer control I simply removing
> > > > the
> > > > paging controls to get this effect iirc... i tried hiding the paging
> > > > control
> > > > in the RS report viewer control and i simply got a paged report with no
> > > > way
> > > > of advancing through the pages...
> > > >
> > > > Can someone please help me do this.
> > >
> > >
> > >|||Good advice! Ill do that from now on!
thanks
"Bruce L-C [MVP]" wrote:
> You beat me to it, that is what I was going to suggest.
> Also, here is a suggestion for development. Develop reports in RS 2005
> designer. The designer is better and you can quickly preview. Don't deploy
> the report. Then, rename the rdl file to rdlc and bring it into your
> project. This is how I do it. Much nicer development environment.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "thejez" <thejez@.discussions.microsoft.com> wrote in message
> news:1A2F6C1F-3453-412A-AC0E-363C18C89D08@.microsoft.com...
> > Bruce, i managed to just put the
> > <InteractiveHeight>0in</InteractiveHeight>
> > element into my RDLC file and it worked... so even though there isnt any
> > design-tim support for setting that value (at least that i saw) adding it
> > to
> > the source file did the trick.
> >
> > thanks!
> >
> > "thejez" wrote:
> >
> >> I think im posting this question to wrong place (but in all fairness its
> >> very
> >> confusing from MS) - I am using a LOCAL report in VS 2005 ReportViewer
> >> control - so i dont see the interactive options. I have RS 2005 but I am
> >> unable to use it because of the limitations of how i can poplate the data
> >> (I
> >> have to do pre-aggregation on the data before it gets to the dataset to
> >> get
> >> around the aggregate of aggregates lmiitation). So my only option was to
> >> use
> >> a local report where i could get the data from the DB pre-process it and
> >> then
> >> pop the dataset and then render the report... this a big pain i know but
> >> what
> >> can i do...
> >>
> >> so is there any way in the VS 2005 ReportViewer and a local Report file
> >> (rdlc). I have height set to 100% on everything and i even went to far
> >> as to
> >> define the report at 160in high... but alas the control seems to break at
> >> the
> >> same place ignoring everything i throw at it!
> >>
> >> :(
> >>
> >> "Bruce L-C [MVP]" wrote:
> >>
> >> > Here is the solution. This works only for RS 2005. RS 2005 introduced
> >> > interactivesize which consists of interactivewidth and
> >> > interactiveheight. To
> >> > have no page breaks set the interactiveheight to 0. This only works for
> >> > height, not width. You need to get to the report properties. You know
> >> > how
> >> > when you click on the body or a textbox you see the property page for
> >> > that
> >> > element on the right. If you click to the left of the ruler, that gets
> >> > the
> >> > report properties to show (the menu, report properties does allow
> >> > setting
> >> > this). Look for interactivesize, expand and then set interactiveheight
> >> > to 0.
> >> >
> >> > Not very discoverable but pretty cool.
> >> >
> >> >
> >> > --
> >> > Bruce Loehle-Conger
> >> > MVP SQL Server Reporting Services
> >> >
> >> > "thejez" <thejez@.discussions.microsoft.com> wrote in message
> >> > news:E4ABC9C1-43F0-4564-B248-7EE7D818CC0B@.microsoft.com...
> >> > > Hello, I would like to get my reports to be on one page when viewing
> >> > > in
> >> > > HTML
> >> > > in the report viewer. People generally dont want to have to flip
> >> > > through
> >> > > pages when looking at reports online... they would much rather see
> >> > > the
> >> > > entire
> >> > > report and just keep scrolling... however when printing you would
> >> > > want the
> >> > > page-breaks to still happen (naturall).
> >> > >
> >> > > Currently in Crystal using their report viewer control I simply
> >> > > removing
> >> > > the
> >> > > paging controls to get this effect iirc... i tried hiding the paging
> >> > > control
> >> > > in the RS report viewer control and i simply got a paged report with
> >> > > no
> >> > > way
> >> > > of advancing through the pages...
> >> > >
> >> > > Can someone please help me do this.
> >> >
> >> >
> >> >
>
>

How Do I Get Rid of Blank Pages in Reports?

Every report I've done puts a blank page in between each report page. The
page header is printed on all the blank pages.
I haven't specified any page breaks anywhere.
Is there a way to get rid of the blank pages?On Apr 20, 4:34 pm, Liz <L...@.discussions.microsoft.com> wrote:
> Every report I've done puts a blank page in between each report page. The
> page header is printed on all the blank pages.
> I haven't specified any page breaks anywhere.
> Is there a way to get rid of the blank pages?
One way to alleviate this, in some cases, would be to enclose your
controls (i.e., tables/matrices/textboxes, etc) in a list or rectangle
control and make sure that 'Fit table on one page if possible' is
selected for the table/matrix controls (where applicable). Hope this
is helpful.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Apr 21, 7:34 am, Liz <L...@.discussions.microsoft.com> wrote:
> Every report I've done puts a blank page in between each report page. The
> page header is printed on all the blank pages.
> I haven't specified any page breaks anywhere.
> Is there a way to get rid of the blank pages?
The most likely cause for this is either:
* your report items stretch too wide (beyond the page dimensions) and
are causing extra pages to be printed
* but more likely; the dimensions for your report are not the same as
your printing paper dimensions. Always check the width of your report
body + margins is about equal to the size of your printing paper (e.g.
for A4, your report body should be around 19.5cm wide, and left and
right margins 0.75cm each)|||Well, I'm afraid none of this works.
I put my table in a rectangle and specified to fit on one page when
possible. My report size is not larger than the page size. Nothing is
running off the sides or bottom. The whole report prints; I just get an
extra page between each report page.
I've messed with all of my margins making them bigger then smaller but that
doesn't make any difference either.
If you have any other ideas, I'm all ears. This is going to be a huge waste
of paper.
Thanks,
Liz
"Tokes" wrote:
> On Apr 21, 7:34 am, Liz <L...@.discussions.microsoft.com> wrote:
> > Every report I've done puts a blank page in between each report page. The
> > page header is printed on all the blank pages.
> >
> > I haven't specified any page breaks anywhere.
> >
> > Is there a way to get rid of the blank pages?
> The most likely cause for this is either:
> * your report items stretch too wide (beyond the page dimensions) and
> are causing extra pages to be printed
> * but more likely; the dimensions for your report are not the same as
> your printing paper dimensions. Always check the width of your report
> body + margins is about equal to the size of your printing paper (e.g.
> for A4, your report body should be around 19.5cm wide, and left and
> right margins 0.75cm each)
>|||On Apr 23, 11:56 pm, Liz <L...@.discussions.microsoft.com> wrote:
> Well, I'm afraid none of this works.
> I put my table in a rectangle and specified to fit on one page when
> possible. My report size is not larger than the page size. Nothing is
> running off the sides or bottom. The whole report prints; I just get an
> extra page between each report page.
> I've messed with all of my margins making them bigger then smaller but that
> doesn't make any difference either.
> If you have any other ideas, I'm all ears. This is going to be a huge waste
> of paper.
> Thanks,
> Liz
I'm fairly sure its to do with the size of your report body being
bigger than the paper size (width or height); try setting the report
body size to the absolute minimum it needs to be (i.e. the EXACT size
of the table in the design view) and see if that makes a difference
> "Tokes" wrote:
> > On Apr 21, 7:34 am, Liz <L...@.discussions.microsoft.com> wrote:
> > > Every report I've done puts a blank page in between each report page. The
> > > page header is printed on all the blank pages.
> > > I haven't specified any page breaks anywhere.
> > > Is there a way to get rid of the blank pages?
> > The most likely cause for this is either:
> > * your report items stretch too wide (beyond the page dimensions) and
> > are causing extra pages to be printed
> > * but more likely; the dimensions for your report are not the same as
> > your printing paper dimensions. Always check the width of your report
> > body + margins is about equal to the size of your printing paper (e.g.
> > for A4, your report body should be around 19.5cm wide, and left and
> > right margins 0.75cm each)|||I did all of the above; nothing worked. My entire report width was 10 inches
for a landscape report.
Finally, changing all my margins to zero fixed the problem.
"Tokes" wrote:
> On Apr 23, 11:56 pm, Liz <L...@.discussions.microsoft.com> wrote:
> > Well, I'm afraid none of this works.
> >
> > I put my table in a rectangle and specified to fit on one page when
> > possible. My report size is not larger than the page size. Nothing is
> > running off the sides or bottom. The whole report prints; I just get an
> > extra page between each report page.
> >
> > I've messed with all of my margins making them bigger then smaller but that
> > doesn't make any difference either.
> >
> > If you have any other ideas, I'm all ears. This is going to be a huge waste
> > of paper.
> >
> > Thanks,
> > Liz
> I'm fairly sure its to do with the size of your report body being
> bigger than the paper size (width or height); try setting the report
> body size to the absolute minimum it needs to be (i.e. the EXACT size
> of the table in the design view) and see if that makes a difference
> >
> > "Tokes" wrote:
> > > On Apr 21, 7:34 am, Liz <L...@.discussions.microsoft.com> wrote:
> > > > Every report I've done puts a blank page in between each report page. The
> > > > page header is printed on all the blank pages.
> >
> > > > I haven't specified any page breaks anywhere.
> >
> > > > Is there a way to get rid of the blank pages?
> >
> > > The most likely cause for this is either:
> > > * your report items stretch too wide (beyond the page dimensions) and
> > > are causing extra pages to be printed
> > > * but more likely; the dimensions for your report are not the same as
> > > your printing paper dimensions. Always check the width of your report
> > > body + margins is about equal to the size of your printing paper (e.g.
> > > for A4, your report body should be around 19.5cm wide, and left and
> > > right margins 0.75cm each)
>
>|||>I did all of the above; nothing worked. My entire report width was 10
>inches
> for a landscape report.
> Finally, changing all my margins to zero fixed the problem.
You had a 10 inch width (not sure of height) and you had margins. OK. What
is your printer's printable page area?
IOW: I'm pretty sure you were given correct advice here. Your height +
your top and bottom margin were > your printer's printable page height..
versus actual paper page height...
>L<
"Liz" <Liz@.discussions.microsoft.com> wrote in message
news:F1707B09-ABE5-4CB8-BE2E-FA8436DE5FA6@.microsoft.com...
>I did all of the above; nothing worked. My entire report width was 10
>inches
> for a landscape report.
> Finally, changing all my margins to zero fixed the problem.
> "Tokes" wrote:
>> On Apr 23, 11:56 pm, Liz <L...@.discussions.microsoft.com> wrote:
>> > Well, I'm afraid none of this works.
>> >
>> > I put my table in a rectangle and specified to fit on one page when
>> > possible. My report size is not larger than the page size. Nothing is
>> > running off the sides or bottom. The whole report prints; I just get
>> > an
>> > extra page between each report page.
>> >
>> > I've messed with all of my margins making them bigger then smaller but
>> > that
>> > doesn't make any difference either.
>> >
>> > If you have any other ideas, I'm all ears. This is going to be a huge
>> > waste
>> > of paper.
>> >
>> > Thanks,
>> > Liz
>> I'm fairly sure its to do with the size of your report body being
>> bigger than the paper size (width or height); try setting the report
>> body size to the absolute minimum it needs to be (i.e. the EXACT size
>> of the table in the design view) and see if that makes a difference
>> >
>> > "Tokes" wrote:
>> > > On Apr 21, 7:34 am, Liz <L...@.discussions.microsoft.com> wrote:
>> > > > Every report I've done puts a blank page in between each report
>> > > > page. The
>> > > > page header is printed on all the blank pages.
>> >
>> > > > I haven't specified any page breaks anywhere.
>> >
>> > > > Is there a way to get rid of the blank pages?
>> >
>> > > The most likely cause for this is either:
>> > > * your report items stretch too wide (beyond the page dimensions) and
>> > > are causing extra pages to be printed
>> > > * but more likely; the dimensions for your report are not the same as
>> > > your printing paper dimensions. Always check the width of your report
>> > > body + margins is about equal to the size of your printing paper
>> > > (e.g.
>> > > for A4, your report body should be around 19.5cm wide, and left and
>> > > right margins 0.75cm each)
>>

how do i get grid view inside the report

hi there... how do i grid view in report?

Are you asking for a Grid view like in SharePoint, where you can edit data in place? If so, Reporting Services does not offer this capability right now.

You can display data in a table layout. You can also display data in a cross-tab or matrix layout. The only thing you cannot do is edit that data in the web page.

Hope that helps,

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

How do I get a RS report onto an Internet website?

I've written our first Reporting Services report, using SQL Server 2005. Since we've never used RS before, we may, or may not, have done some things correctly. One of the things is that we only have the Reporting Services, and Report Manager, on our SQL Server 2005 server, which is in our network behind our firewall.

We also have an ASP.NET 1.1 application which is used by external users (other businesses that do business with us). Because of the nature of our business, we don't want people from one agency to access data from another agency. Since calling the report in RS involved passing parameters to the report in the URL, I decided that I would hide those details by putting the web page returned by RS into an IFRAME in an aspx page. It works just fine in our network, but I discovered that it does not work at all outside of our network.

So, my question is how do I make the RS report available to users outside of our network, in such a way that they don't have access to the parameters that I pass to the report? Should I discard the whole IFRAME approach? I have been told that it will likely require doing something about passing credentials to the backend server from the ASP.NET app, but I don't know how to do that, nor do I know what would be involved.

The most straightforward approach is to use the VS reportviewer control & run your report in local mode, e.g., do not rely upon the report server. This approach eliminates the need to create a security extesion for report server. Cheers!|||

I'm sorry to be so obtuse, but what do you mean by, "run [my] report in local mode"?

|||

DoctorWho:

I'm sorry to be so obtuse, but what do you mean by, "run [my] report in local mode"?

Never mind, I've found it (local mode).