How to show the border of the table?

hi,
How to adjust/display/hide the table border(including all cells)?
I see in the property page, there is a BorderStyle for the table, but it only changes the outline of the table border style, I want to change the border style including all cells, like we did in html page, is there an easy way to do this, or I have to make the setting for all cells?

Thanks

I don't think there is a way to force gridlines for the table. You'll probably need to specify the borders of the cells.|||

Oh...
When I created a report table by the wizard, it can be set to have the gridlines. From the rdl file, seems it sets this for each cell, not the whole table.

sql

How to show table header in each page

I want the table header appears in each page, how can i do this?
Thanks.
JasonClick on the Table header row handler,go to properties, you can see
Repeatonnewpage property,Enable it.that's it
Jason Chan wrote:
> I want the table header appears in each page, how can i do this?
> Thanks.
> Jason|||Got it. Thanks
"RajDeep" wrote:
> Click on the Table header row handler,go to properties, you can see
> Repeatonnewpage property,Enable it.that's it
> Jason Chan wrote:
> > I want the table header appears in each page, how can i do this?
> >
> > Thanks.
> >
> > Jason
>sql

how to show one record per one page

I am using reporting services to build a report to show customer's balance statements. I need each page only show one customer and related transactions and balance etc.

Now it shows several customers' balance in one page, how can i change it to show only one record per one page, and also one customer per one page when print it out.

how can i achieve that?

cheers

place all your controls in a list control

in the properties for the list control

group by customer

check the "page brake before" option

How to Show Memo Text at runtime in CR

hi all
i'm confused about this one..
can i show my memo text(very very long text maybe it can be 2 page length)
at runtime ??
cause i already tried to use formula field but it show error message
"There is too many character in this string"
is there another way??

thx alotHi try this!

1) RightCLick on the Memo Field Object
2) Select Format Editor
3) In common tab Enter the Value 0 for the Maximum No of Lines.

note : 0 is no limitsql

How to show line numbers in the first column of the report

Hi,
I want to show line numbers on report page in the first column of my
report. I am working on microsoft reporting services 2000.
How i can do this.
Regards
DineshOn Mar 9, 11:59 pm, "Dinesh" <dinesh...@.gmail.com> wrote:
> Hi,
> I want to show line numbers on report page in the first column of my
> report. I am working on microsoft reporting services 2000.
> How i can do this.
> Regards
> Dinesh
This should work: =RowNumber("DataSourceName") as an expression in the
Value property of the first column.
Regards,
Enrique Martinez
Sr. SQL Server Developer

How to show empty rows in crystal report when data reaches to EOF

I have designed a report in Crystal Report .Net with tabular Layout. I want to have table layout for empty rows in last page. But Report Detail Section is repeated only for record count, no more. How can I show blank rows in report?At the Report footer have a table structure with empty rows
Otherwise post some sample data and the format you want

How to show a stored PDF

New to asp and have no idea what I'm doing wrong here. I just want to open a pdf that I have stored in a table and show it on the page. Here is my code. I keep getting theSystem.NullReferenceException was unhandled by user code.

<asp:SqlDataSourceID="SqlDataSource1"runat="server"ConnectionString="<%$ ConnectionStrings:smithsdaConnectionStringtest %>"

ProviderName="<%$ ConnectionStrings:smithsdaConnectionStringtest.ProviderName %>"

SelectCommand="SELECT * FROM [correspondence] WHERE ([facilitiesID] = ?)">

<SelectParameters>

<asp:QueryStringParameterName="facilitiesID"QueryStringField="DACorr"Type="Int32"/>

</SelectParameters>

</asp:SqlDataSource>

<scriptrunat="server">

ProtectedSub Page_Load(ByVal senderAsObject,ByVal eAs System.EventArgs)

Dim ScanDocAsNew DataViewDim argAsNew DataSourceSelectArguments

ScanDoc = SqlDataSource1.Select(arg)

Dim ScanLet(1)AsByte

ScanLet(0) =CByte(ScanDoc(0)("Letter"))

If ScanDocIsNot""Then

Response.Buffer =True

Response.Clear()

Response.ClearContent()

Response.ClearHeaders()

Response.ContentType ="application/pdf"

Response.BinaryWrite(ScanLet)

Response.End()

EndIf

EndSub

</script

Any Help greatly appreciated.

My suggestion would be to store the PDF files, all in one directory, then, in the database, store the names of the PDF files.

Then, show the relevant information in the database, using a Gridview, including one TemplateField, which would have a Hyperlink to the folder where the pDFs are stored, and the PDF itself. Then, when people clicked on the hyperlink, the PDF would show

|||

David,

Thanks for the reply. I wish I could do it that way, unfortunately they want the pdfs stored in the database so noone can accidentally delete them. The db has probably 200 stored pdfs associated with records and they need to be able to pull them up for viewing.

Thanks,

DeWayne

|||

I've changed the code to this and now it just opens a blank web page.

Dim ScanDocAsNew DataViewDim argAsNew DataSourceSelectArguments

ScanDoc = SqlDataSource1.Select(arg)

Dim ScanLet(1)AsByte

ScanLet(0) =CByte(Request.QueryString("Letter"))

If ScanDocIsNot""Then

Response.Buffer =True

Response.Clear()

Response.ClearContent()

Response.ClearHeaders()

'Response.AddHeader("content-disposition", "inline;filename=" + ScanLet)

Response.ContentType ="application/pdf"

'Response.AppendHeader("content-disposition", "inline;filename=" + "Scan.PDF")

Response.BinaryWrite(ScanLet)

Response.End()

'Else

' Response.Write("Error")

EndIf

I think I am on the right track but no PDF file yet.

|||

I finally got it, thanks to reading other posts in the forum and especially the one from adam v on how to strip the ole header. Now I just have to deal with .doc and .tif headers. This is a great forum and I have found lots of useful tips and tricks in here.

Thanks.

Here is the code I ended up with...

myConnection.Open()Dim myDataReaderAs OleDbDataReader = myCommand.ExecuteReader() myDataReader.Read()Dim intLoopCountAs Integer Dim intPositionAs Integer Dim ScanLetAs Byte() = myDataReader("letter")Do While intLoopCount < ScanLet.LengthIf ScanLet(intLoopCount) = 37Then'%If ScanLet(intLoopCount + 1) = 80Then'PIf ScanLet(intLoopCount + 2) = 68Then'DIf ScanLet(intLoopCount + 3) = 70Then'FIf ScanLet(intLoopCount + 4) = 45Then'- intPosition = intLoopCount intLoopCount = ScanLet.LengthEnd If End If End If End If End If intLoopCount = intLoopCount + 1Loop Dim bytStrippedData(ScanLet.Length - intPosition - 1)As Byte System.Buffer.BlockCopy(src:=ScanLet, srcOffset:=intPosition, dst:=bytStrippedData, dstOffset:=0, count:=ScanLet.Length - intPosition) Response.Clear() Response.ClearContent() Response.ClearHeaders() Response.ContentType ="application/pdf" Response.BinaryWrite(bytStrippedData) Response.Flush() Response.End() myConnection.Close() Response.Write("Person info successfully retrieved!")End UsingEnd Sub

How to show a linked report in a report container?

I have a report container (reportviewer.dll) in a .net web page to display
the reports using the reporting services. Some of the reportds are linked
report and I am not sure how to display it in the report container.
Currently it opens on a new page. Thanks.I have the same problem...
Any luck with that?
--
http://dotnet.org.za/stanley
"Paul" wrote:
> I have a report container (reportviewer.dll) in a .net web page to display
> the reports using the reporting services. Some of the reportds are linked
> report and I am not sure how to display it in the report container.
> Currently it opens on a new page. Thanks.
>
>

How to set this up?

I need to set up the security on the Reporting Services such that user can
view the reports ONLY through a ReportViewer control on a asp.net web page
ie not allow to navigate all other folders or areas in the Report Manager.
Reporting services is installed on a stand alone server (not belong to any
domain, no AD set up) running on Windows 2003 server. Currently I configured
the "Report Manager" and "ReportServer" web site to allow annonyous access.
However some users know how to bypass the web application and directly enter
the IP address/reports of the stand alone server to view all the reports.
The asp.net page has built-in security to filter out the reports listed on
the page based on the user login and password. This web application is also
hosted at the stand alone server and is connected to a remote Sql server.
The web application is using the sql security.I have a similar problem and cannot find a solution provided by Microsoft.
However, I decidee to solve it by a trick. I develop an ASP.net web
application and the application have some report printing function. Whenever
a report is printed, a random key will be inserted into a database table
like this:
Key User
KE#n-asdfjk-ad33klj-kasjd WBush
The key and user are also passed in the query string. When the report is
run, the key and user will be checked again in the stored procedure to
verify that this user can print this report.
I am not sure whether this is a good solution, but I think that's what we
can do before Microsoft can provide a better solution.
"Paul" <paul_mak@.hotmail.com> wrote in message
news:eWZLuvhdGHA.2456@.TK2MSFTNGP04.phx.gbl...
> I need to set up the security on the Reporting Services such that user can
> view the reports ONLY through a ReportViewer control on a asp.net web page
> ie not allow to navigate all other folders or areas in the Report Manager.
> Reporting services is installed on a stand alone server (not belong to any
> domain, no AD set up) running on Windows 2003 server. Currently I
configured
> the "Report Manager" and "ReportServer" web site to allow annonyous
access.
> However some users know how to bypass the web application and directly
enter
> the IP address/reports of the stand alone server to view all the reports.
> The asp.net page has built-in security to filter out the reports listed on
> the page based on the user login and password. This web application is
also
> hosted at the stand alone server and is connected to a remote Sql server.
> The web application is using the sql security.
>|||Hi Paul.
The only way I know of is to have your web site's app pool use an identity
that is the only identity that is allowed to hit the reports.
For example, you might set up a service account called "WebApp1SvcAcct".
give that account and administrators group privileges in reporting services,
but not the rest of your users. This might be only half the solution. It's
been a while since we've had to deal with this.
-Tim
"Paul" <paul_mak@.hotmail.com> wrote in message
news:eWZLuvhdGHA.2456@.TK2MSFTNGP04.phx.gbl...
>I need to set up the security on the Reporting Services such that user can
>view the reports ONLY through a ReportViewer control on a asp.net web page
>ie not allow to navigate all other folders or areas in the Report Manager.
>Reporting services is installed on a stand alone server (not belong to any
>domain, no AD set up) running on Windows 2003 server. Currently I
>configured the "Report Manager" and "ReportServer" web site to allow
>annonyous access. However some users know how to bypass the web application
>and directly enter the IP address/reports of the stand alone server to view
>all the reports. The asp.net page has built-in security to filter out the
>reports listed on the page based on the user login and password. This web
>application is also hosted at the stand alone server and is connected to a
>remote Sql server. The web application is using the sql security.
>

How to set the ReportPath for the reportviewer control

In my solution I've got 2 projects. ABCWeb is my website and ABCReports is a Report Server project.

In ABCWeb I have an aspx page that has a single reportviewer control on it which is intended to display the various reports that are in ABCReports . I am not using the Reports Server. I just simply want to set the property of the reportviewer control under LocalReport.ReportPath to the location of the report in ABCReports .

I keep getting this error no matter how I try to reference it.

An error occurred during local report processing.

The report definition for report '/ABCReports/Reports/rptNoticeOfDecision.rdl' has not been specified

Could not find a part of the path 'C:\ABCReports\Reports\rptNoticeOfDecision.rdl'.

what am I doing wrong

try something like this

RVcl.LocalReport.ReportPath ="ABCReports/Reports/rptNoticeOfDecision.rdl";

-remove the first /

I assume ABCreports is a sub folder of the application root

How to set the path to the reports snapshots folder?

We have a statutory requirement to keep 5 years of history, so I've checked the option in the Site Settings page in the Report Manager to "Keep an unlimited number of snapshots in report history". The drives are partitioned as follows:

C: -- OS; 20GB

D: -- Apps; 20GB

E: --Data: 160GB

I want to force the report history snapshots onto the data (E:) drive, but I can't figure out what setting will force them there. Can anyone tell me how to set the path to the reports snapshots folder?

Hello,

The snapshots are stored in the database, not as seperate files on the server. You'll just need to put the data file for the ReportServer database on a drive with enough space allocated.

Jarret

How to set page orientation to landscape?

How can I set the page orientation to landscape? I tried to set "printDocument.DefaultPageSettings.Landscape = true;" but it didn't work. I have spent hours fixing the problem but I couldn't get it work. Below is the code:

private void printDocument_PrintPage(object sender,
System.Drawing.Printing.PrintPageEventArgs e)
{
e.HasMorePages = false;

printDocument.DefaultPageSettings.Landscape = true;

System.Drawing.Font printFont = new System.Drawing.Font("Arial",
12, System.Drawing.FontStyle.Regular);

e.Graphics.DrawString("Set the page orientation to landscape!", printFont,
System.Drawing.Brushes.Black, 30, 30, new StringFormat());
}

Could someone please tell me what is wrong with it, or what I should do to get it work? Your help is very much appreciated.

Thannks.

Hi.

may be I didn't understand to problem but why not just change to report parametrs?

right click on the report (empty space in the bottom)> properties (be sure that in the "report" is selected) --> change the page side to "11in, 8.5in".

That will change it to be sowen and printed in landscape.|||

Thanks Roy for the response, but I am not sure what report you are talking about. I don't use Crystal Report. Do I miss something here? By the way, I tried to override the PaperSize as shown below but it didn't seem to work.

printDocument.PrinterSettings.DefaultPageSettings.PaperSize = new System.Drawing.Printing.PaperSize("Letter", 850, 1100);

Thanks.

|||Hi,

I'm talking about a reporting services report.

I'm using visual studio 2005 for creating my report. maybe you are useing something also?

If you are useing vs2005 too, then check to report properties and change to report size like I wrote in the previuos post.

If not - ttry to give us few more details.

Take care,
Roy.|||

Hi Roy,

Thanks for your response. Forgive me if my question is unclear. Below is my reduced testcase to clarify my question. I hope it would clear up any confusion. Thank you again.

using System.Drawing;
using System.Drawing.Printing;
using System;
using System.Windows.Forms;

namespace WindowsApplication1
{
public class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void print_Click(object sender, EventArgs e)
{
printDocument.Print();
}

private void printDocument_PrintPage(object sender,
System.Drawing.Printing.PrintPageEventArgs e)
{
e.HasMorePages = false;

printDocument.DefaultPageSettings.Landscape = true;

System.Drawing.Font printFont = new System.Drawing.Font("Arial",
12, System.Drawing.FontStyle.Regular);

e.Graphics.DrawString("Set the page orientation to landscape!", printFont,
System.Drawing.Brushes.Black, 30, 30, new StringFormat());
}

private void InitializeComponent()
{
this.printButton = new System.Windows.Forms.Button();
this.printDialog = new System.Windows.Forms.PrintDialog();
this.printDocument = new System.Drawing.Printing.PrintDocument();
this.SuspendLayout();
//
// printButton
//
this.printButton.Location = new System.Drawing.Point(199, 69);
this.printButton.Name = "printButton";
this.printButton.Size = new System.Drawing.Size(75, 23);
this.printButton.TabIndex = 0;
this.printButton.Text = "Print";
this.printButton.Click += new System.EventHandler(this.print_Click);
//
// printDialog
//
this.printDialog.Document = this.printDocument;

//
// printDocument
//
this.printDocument.DocumentName = "";
this.printDocument.PrintPage += new System.Drawing.Printing.PrintPageEventHandler(this.printDocument_PrintPage);
//
// Form1
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(499, 412);
this.Controls.Add(this.printButton);
this.Name = "Form1";
this.ResumeLayout(false);
}
private System.Windows.Forms.Button printButton;
private System.Windows.Forms.PrintDialog printDialog;
private System.Drawing.Printing.PrintDocument printDocument;

static void Main()
{
Application.Run(new Form1());
}
}
}

How to set No of rows per page in ssrs

Hi All,

By default in ssrs there are some fixed records..per page.......i mean each page contains (n) no of records.........per page..........?I want to display 100 records per page...for this what can i do ..please suggest .......

Thank's in Advance....

Hi
Add group with the following expression = Ceiling(RonNumber(Nothing)/N). Here N is the No of records in per page. And Select the Check box "Page Break either after/before"

Thanks

How to send notification to .aspx page...

... as far as I understand, I need to create a custom HTTP protocol. Where do get an example of this? Shyam's book has an example of creating custom protocol that is not HTTP based. There are few remarks on HTTP custom protocol in Chapter 10, but those are not very helpful.

The scenario it is used for is as follows: ASP.NET messenger (an .aspx page) writes messages into SQL server table. The page needs to get notified as soon as new entry appears in the table (from another instance of messenger), so that the first instance of messenger would be able to get new message from the table. Is this appropriate usage of notification services? If not, can you suggest alternative ways to write ASP.NET messenger?

Thank you in advance.

Is this a kinda IM application ? If so NS is not a right choice for Real Time Communication I would prefer to explore RTC (Real Time CommunicationI API with MS Live Communication Server. These two works well for any IM/Messaging related application.

If you mention ur requirements in detail (what do u mean by message etc) i will be more clear... thanks

--Satyen

|||

Query Notifications may be a better technology choice for you in this application.

HTH...

Joe

How to send notification to .aspx page...

... as far as I understand, I need to create a custom HTTP protocol. Where do get an example of this? Shyam's book has an example of creating custom protocol that is not HTTP based. There are few remarks on HTTP custom protocol in Chapter 10, but those are not very helpful.

The scenario it is used for is as follows: ASP.NET messenger (an .aspx page) writes messages into SQL server table. The page needs to get notified as soon as new entry appears in the table (from another instance of messenger), so that the first instance of messenger would be able to get new message from the table. Is this appropriate usage of notification services? If not, can you suggest alternative ways to write ASP.NET messenger?

Thank you in advance.

Is this a kinda IM application ? If so NS is not a right choice for Real Time Communication I would prefer to explore RTC (Real Time CommunicationI API with MS Live Communication Server. These two works well for any IM/Messaging related application.

If you mention ur requirements in detail (what do u mean by message etc) i will be more clear... thanks

--Satyen

|||

Query Notifications may be a better technology choice for you in this application.

HTH...

Joe

How to send notification to .aspx page...

... as far as I understand, I need to create a custom HTTP protocol. Where do get an example of this? Shyam's book has an example of creating custom protocol that is not HTTP based. There are few remarks on HTTP custom protocol in Chapter 10, but those are not very helpful.

The scenario it is used for is as follows: ASP.NET messenger (an .aspx page) writes messages into SQL server table. The page needs to get notified as soon as new entry appears in the table (from another instance of messenger), so that the first instance of messenger would be able to get new message from the table. Is this appropriate usage of notification services? If not, can you suggest alternative ways to write ASP.NET messenger?

Thank you in advance.

Is this a kinda IM application ? If so NS is not a right choice for Real Time Communication I would prefer to explore RTC (Real Time CommunicationI API with MS Live Communication Server. These two works well for any IM/Messaging related application.

If you mention ur requirements in detail (what do u mean by message etc) i will be more clear... thanks

--Satyen

|||

Query Notifications may be a better technology choice for you in this application.

HTH...

Joe