Detail Section Limit Records

Hi,

I have limited my detail section output to print 20 records per page, but if have total of 108 records ,First 100 records are printing 5 pages and the 6 thpage prints 8 records .

I want that the 6 th page to print 8 records , plus 12 lines filled with dashes (---).Making the page to appear having 20 lines .

Can anybody help

thanks
ShaliniI had resolved something like that by modifying the data source, I mean, generating the extra lines when writing the output file

Design Preview Vs Print Preview

My report that I am writing looks great and pages properly (have the option selected to keep a table together ) when it is in the Reporting Services development preview. But as soon as I click on the print preview, which includes exporting it to a PDF, I get bold lines, other weirdities and the table in the report will split across pages etc.

Ideally, I would like it to print exactly as it looks in the RS preview.

Any ideas?

dotnetnow

While in design-view, right-click and select Properties then Layout tab. This is where you can set margins and page size/orientation, anything you do here will affect the output to PDF.

Design Pages on Report Server

Hi every body

I have developed an reporting solution for a customer with reporting services and using report builder.

When he connect to http://localhost/reports , he see the page like

http://img215.imageshack.us/img215/583/folderhl1.jpg

But i would to custom design of my default page, and other maybe. Where i can do it ?

Thanks all

Regards

Erwan Sarcelet, France

Hi.

There's not much you can do to change the look of report manager. However, if you have purchased Visual Studio 2005, you can build a customized front end for your reports. I have a feeling that is what you are asking for.

|||

Yes, that is what i wanted to know. So i cant modify the Folder.aspx file ?

Thank you Greg.

Erwan

|||

I'm not sure. Try to open it in Visual Studio and see what you can do to it.

However, I'm not really sure I would recommend doing that. I would think that you could potentially cause damage to report manager. That sounds too much like a hack to me.

I would recommend creating your own front end.

Design Help – Access SQL Database behind a firewall from ASP .NET pages.

Hi,

I am new to internet development and would like some advice on the technology used to access a SQL database that sits on a network behind a firewall.

** ASP .NET Page ** -> ** Web Server ** -> ** FIREWALL ** -> ** SQL **

So to give an example; from an ASP .NET page on the internet, I would like to populate a DataGrid with the contents of a single table from a SQL database. The SQL database is sitting on our company network behind a firewall.

Could someone please explain / point me in the right direction in how the ASP .NET page / Web Server can securely access the SQL database.

Thanking you in advance
ScottThe firewall needs to allow SQL access between the WebServer and the SQL server. This is usually port 1433. Only requests initiated by the webservers IP should be allowed to get to the db server.

You could also put together some web services on SQL server to send back datasets through the firewall (assuming its running iis and the .net framework).

Then you would just need to open port 80 between the webserver and the sql server. The webservices we run on our db server required an encrypted key as part of all method calls to insure that only we can run them.

No matter which way you do it, your opening a hole in your firewall for communication to occurr between the two boxes.|||Mbanavige – thanks for your reply. Can I confirm my understanding??

Option 1.
The firewall opens port 1433 with an additional rule to only allow the IP address of the web server to communicate on port 1433. As such this allows web server code to create a connection string to SQL? How would I fully qualifying the connection string server property - <SQL Server NetBIOS Name><domain>??

Option 2.
Have a second web server (internal) running on the same box as the SQL server. The internal web server will host web services, which can be called from the external web server. This requires the opening of port 80. Further security is added with the use of an encrypted key required for all method calls. How is the encrypted key implemented?

Is there an industry preferred solution?

Is option 2 more secure against SQL attacks since SQL access is further controlled through the use of web services?

Thanking you again in advance for your replies.
Scott