is it possible to recieve result of SQL stored procedure to web page?

I have web server with .aspx page from wich I call stored procedure on MSSQL server. In this procedure are lots of "select" statements and I need to show results of this statements in web page. Can I call this procedure in that manner that procedure output is writen in some file and this file then ir recieved by web server and included in web page.

for (int i=0; i<dataset.Tables.Count; i++) {
 Response.Write(dataset.Tables[i].TableName);
 Response.Write("\n");
 // loop rows
 for (int j=0; j<dataset.Tables[i].Rows.Count; j++) {
 // loop columns
 for (int k=0; k<dataset.Tables[i].Columns.Count; k++) {
 Response.Write(dataset.Tables[i].Rows[j][k].ToString());
 if (k < dataset.Tables[i].Columns.Count - 1) {
 Response.Write(", ");
 }
 }
 Response.Write("\n");
 }
 Response.Write("\n");
}

this isn't exactly what you want, but idea.|||If the procedure returns a fixed number of result sets, you can return the results a datareader and then bind each result set to something like a datagrid or a repeater using .nextresult between bindings. A datareader can hold more than one result set. It can be pretty handy.

Is it possible to make a report to fit in 1 page?

Hi all..
Is is possible, when exporting to PDF, to make the report to fit in 1 page?
Thanks
Jaimeset the Report PageSize same as your template PageSize.
This should solve the problem.
"Jaime Stuardo" wrote:
> Hi all..
> Is is possible, when exporting to PDF, to make the report to fit in 1 page?
> Thanks
> Jaime|||In report properties, I set 11 in height.
When you talk about template page size, you mean:
header height + body height + footer height?
If that is the case, that sum results 8,73229 in. Do I need to increase body
size so that that sum equal 11 in?
Jaime
"Hari" wrote:
> set the Report PageSize same as your template PageSize.
> This should solve the problem.
> "Jaime Stuardo" wrote:
> > Hi all..
> >
> > Is is possible, when exporting to PDF, to make the report to fit in 1 page?
> >
> > Thanks
> > Jaime|||In Report Designer, make sure to use the following:
(Report.PageWidth - Report.LeftMargin - Report.RightMargin) >= Body.Width.
Thanks!
"Jaime Stuardo" wrote:
> In report properties, I set 11 in height.
> When you talk about template page size, you mean:
> header height + body height + footer height?
> If that is the case, that sum results 8,73229 in. Do I need to increase body
> size so that that sum equal 11 in?
> Jaime
> "Hari" wrote:
> > set the Report PageSize same as your template PageSize.
> >
> > This should solve the problem.
> >
> > "Jaime Stuardo" wrote:
> >
> > > Hi all..
> > >
> > > Is is possible, when exporting to PDF, to make the report to fit in 1 page?
> > >
> > > Thanks
> > > Jaimesql

Is it possible to keep the page header at top of browser page with drill enabled?

When I click a drilldown [+] on a report in the browser the page starts
at the point where I start (click) the drill. Everything above the
click-point is above and I have to scroll up to see it. Is there a way
to keep the heading visible on a report using drill?RS 2005 will provide floating headers on table or matrix which may be close
to what you are looking for. For RS 2000 I can't think of anything that
would do it - unless you try to write your own "report viewing" application
which shows the required context information outside the boundaries where
you show the report contents.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Merkin" <flyin_merkin@.yahoo.com> wrote in message
news:1112206546.496405.301270@.f14g2000cwb.googlegroups.com...
> When I click a drilldown [+] on a report in the browser the page starts
> at the point where I start (click) the drill. Everything above the
> click-point is above and I have to scroll up to see it. Is there a way
> to keep the heading visible on a report using drill?
>

Is it possible to email a reportviewer graph as the email body not as an attachment

I have a page that disaplays a column report in a reportviewer control and the report processing mode is local not server. I was just wondering if its possible to programmatically email this graph as the email body not as an attachment using the system.net.mail classses. The email recepients have MS outlook email addresses.

Thanks in advance.

I still want help on this. And now i'm backing off from sending the report as the email body. It wouldn't hurt if the report is send as an attachment. Please some out there help.

|||

http://www.codeproject.com/csharp/Email_a_PDF_Report.asp

is it possible to do a redirect in the custom code?

Is it possible to do a redirect to an arbitrary page in by using custom code?

eg.

Public sub myRedirect()

response.redirect(http://www.microsoft.com)

End sub

/Alex

Or automatically open a new webpage when viewing the report?

Is it possible to create libraries to reuse parts of my report?

Is it possible to create libraries to reuse parts of my report? For Example
my first page looks always the same - image, title (of courese not always the
same) and three subtitles
Thank youInherited Report
Now you can create your custom Report Templates, and keep it in managed code
and reuse it!, in this example will show you, how to sub-class
the Report Class and create your report templates for further reuse.
http://www.rdlcomponents.com/examples/inherited/inherited.aspx
"Hawkeye" wrote:
> Is it possible to create libraries to reuse parts of my report? For Example
> my first page looks always the same - image, title (of courese not always the
> same) and three subtitles
> Thank you
>|||... I don't want to buy further tools!!!!
"Jerry" wrote:
> Inherited Report
> Now you can create your custom Report Templates, and keep it in managed code
> and reuse it!, in this example will show you, how to sub-class
> the Report Class and create your report templates for further reuse.
> http://www.rdlcomponents.com/examples/inherited/inherited.aspx
>
> "Hawkeye" wrote:
> > Is it possible to create libraries to reuse parts of my report? For Example
> > my first page looks always the same - image, title (of courese not always the
> > same) and three subtitles
> >
> > Thank you
> >|||You can do by yourself w/o buy anything, but if you have enough time:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/htm/rss_tutorials_v1_02ua.asp
"Hawkeye" wrote:
> ... I don't want to buy further tools!!!!
> "Jerry" wrote:
> > Inherited Report
> >
> > Now you can create your custom Report Templates, and keep it in managed code
> > and reuse it!, in this example will show you, how to sub-class
> > the Report Class and create your report templates for further reuse.
> >
> > http://www.rdlcomponents.com/examples/inherited/inherited.aspx
> >
> >
> > "Hawkeye" wrote:
> >
> > > Is it possible to create libraries to reuse parts of my report? For Example
> > > my first page looks always the same - image, title (of courese not always the
> > > same) and three subtitles
> > >
> > > Thank you
> > >

Is it possible to create a cover page in SSRS 2005?

Very simply, I need to add a cover page to my SSRS 2005 report. I've tried this using the Page Header region, but the cover page will not show up on Preview or Export. How and where do I create a cover page?

Hi, Bibble,

Whatever you place first on the Report Design surface (the dotted white area), renders first. So try adding a rectangle which will act as a container, put whatever you want in the rectangle, and set a page break at the end of the rectangle.

==========================================================

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

is it a good practice to do integrity check before perform backup?

On maintenance plan, there is a check box on integrity tab page, is it a good
way to do that first? if there is error found, will the backup stop? thanks
Hi
It depends on what error it will find. Actually, you can checkbox but make
sure that you uncheck Attempt to repair... option.
"tulip" <tulip@.discussions.microsoft.com> wrote in message
news:06E26A1F-4F08-4D81-9502-07E9DB0F5041@.microsoft.com...
> On maintenance plan, there is a check box on integrity tab page, is it a
> good
> way to do that first? if there is error found, will the backup stop?
> thanks
|||My approach is that if you have plenty of maintenance window for doing the
integraity checks (i.e. DBCC checks), do them by all means. And if you are
running into integrity issues, you may want to perform the DBCC checks more
regularly. It becomes a more difficult question when you are dealing with a
large amount of data and when you are struggling to contain your maintenance
jobs inside a limited maintenance window. In that case, you may have to forgo
the DBCC checks or do them very selectively.
Linchi
"tulip" wrote:

> On maintenance plan, there is a check box on integrity tab page, is it a good
> way to do that first? if there is error found, will the backup stop? thanks

is it a good practice to do integrity check before perform backup?

On maintenance plan, there is a check box on integrity tab page, is it a good
way to do that first? if there is error found, will the backup stop? thanksHi
It depends on what error it will find. Actually, you can checkbox but make
sure that you uncheck Attempt to repair... option.
"tulip" <tulip@.discussions.microsoft.com> wrote in message
news:06E26A1F-4F08-4D81-9502-07E9DB0F5041@.microsoft.com...
> On maintenance plan, there is a check box on integrity tab page, is it a
> good
> way to do that first? if there is error found, will the backup stop?
> thanks|||My approach is that if you have plenty of maintenance window for doing the
integraity checks (i.e. DBCC checks), do them by all means. And if you are
running into integrity issues, you may want to perform the DBCC checks more
regularly. It becomes a more difficult question when you are dealing with a
large amount of data and when you are struggling to contain your maintenance
jobs inside a limited maintenance window. In that case, you may have to forgo
the DBCC checks or do them very selectively.
Linchi
"tulip" wrote:
> On maintenance plan, there is a check box on integrity tab page, is it a good
> way to do that first? if there is error found, will the backup stop? thanks

Is Forms Authentication available on Standard

I have been looking at the forms authentication sample that creates a custom login page. After looking at the licencing am I right in saying that this can only be implemented using SQL server enterprise edition as standard edition does not have the security extension API. If this is the case is there any way to custom authenticate a user when using URL calls that is not windows Authentication?I have found the answer which is simply no. Back to Crystal Reports then. Good luck getting this off the ground when you have to buy Enterprise Edition just to securely provide reports over the web that have some kind of functionality.
"Ryan Smith" wrote:
> I have been looking at the forms authentication sample that creates a custom login page. After looking at the licencing am I right in saying that this can only be implemented using SQL server enterprise edition as standard edition does not have the security extension API. If this is the case is there any way to custom authenticate a user when using URL calls that is not windows Authentication?|||Web services does not support everything as it only provides a snapshot of
the report and does not have drill down functionality. If you have a report
that has drill downs (95% of my reports) in it and you run a webservice for
it, when the user clicks on the drill down they get an error.
"Richard" wrote:
> You can still build your own web app (report manager) and use the web service
> to communitate with it. I have gone over the api for the ws and it supports
> everyting you need. Yes it's a bit of work up front but there are no
> licensing issues at all
> "Ryan Smith" wrote:
> > I have found the answer which is simply no. Back to Crystal Reports then. Good luck getting this off the ground when you have to buy Enterprise Edition just to securely provide reports over the web that have some kind of functionality.
> >
> > "Ryan Smith" wrote:
> >
> > > I have been looking at the forms authentication sample that creates a custom login page. After looking at the licencing am I right in saying that this can only be implemented using SQL server enterprise edition as standard edition does not have the security extension API. If this is the case is there any way to custom authenticate a user when using URL calls that is not windows Authentication?

Is BOL incomplete or incorrect? YOU can make it better!

If you think that the BOL page you're reading has incorrect or incomplete information, you can make it better by using the Send Feedback link that's available on every page.

It's easy for the SQL Server documentation team to miss documentation issues buried in newsgroup and forum postings. But when you use the Send Feedback link, an automated process creates a bug in our database and assigns it directly to the owner of the individual topic on which you've commented. Now there's no way I can miss it. And my boss sees it too.

Please help us to make SQL Server Books Online better by using the Send Feedback link whenever appropriate!

Thanks,

-Doug

SQL Server Integration Services documentation team

P.S. Don't use the BOL feedback mechanism to send product feature requests, product gripes, or product bug reports...they won't reach their destination. It's intended exclusively for issues with BOL content.

I think it's already pretty good for a beta, but I will remember your suggestion.

Keep up the good work!