How to remove page breaks when you have multiple groups

Hi,
When you have more than one sub groups in a report, table keeptogether is not
functioning properly. It is always breaking into multiple pages.
I would appreciate if anybody give a fix for this problelm
Thanks,
vamsi.This problem has been a major irritant for me. Suggestions for a workaround
gratefully appreciated!

How to Remove Blank Pages CrystalReport9 problem

Hi,
I have designed report which do not have any group. It shows last page blank although it does not contain any record.I have tried with these

In SectionExpert=>NewPageAfter
IF OnLastRecord then
if isNull({Command.SNPSHT_ID}) then
formula = False
end if
end if

Please help to solve theseplease help me with removal of blank pages in crystalreport9|||if onlastrecord then
false
else
true

Try this formula on SectionExpert=>Page Footer->New Page After...
Don't forget to uncheck this option after writing formula.|||hi,
in PageFooter =>sectionexpert=>NewPageAfter is blocked|||oops sorry.
Try it in details section since u don't have group footer|||if onlastrecord then
false
else
true

Try this formula on SectionExpert=>Page Footer->New Page After...
Don't forget to uncheck this option after writing formula.

hi,
in PageFooter =>sectionexpert=>"NewPageAfter is blocked"

i have tried it in detail section which gives me one record on each page.
Please help me to resolve these problem|||remove else part from ur detail section formula.sql

How to redirect report to a frame?

Hi,
I've a web application. The default page consists of
three frames. 'List bar frame', 'Banner frame' and 'Main
frame'. Reports are displayed on this 'Main frame'.
I've a report which has got a column which is linked to
another report. I want the second report to be displayed
in the same frme ('Main frame'). Right now while
clicking the link column, report is displayed in the
parent frame, there by I'm loosing list bar and banner in
the application. How do I do this?
thanks,
DeeWhen you access the parent report in your frame, add the URL access
parameter rc:LinkTarget=framename. This will target all of the hyperlinks in
the report. You can also do stuff like rc:LinkTarget=_blank to open in a new
window.
--
Bryan Keller
Developer Documentation
SQL Server Reporting Services
A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.
"Deepak" <deee@.discussions.microsoft.com> wrote in message
news:02e201c46d7c$f84dff50$a501280a@.phx.gbl...
> Hi,
> I've a web application. The default page consists of
> three frames. 'List bar frame', 'Banner frame' and 'Main
> frame'. Reports are displayed on this 'Main frame'.
> I've a report which has got a column which is linked to
> another report. I want the second report to be displayed
> in the same frme ('Main frame'). Right now while
> clicking the link column, report is displayed in the
> parent frame, there by I'm loosing list bar and banner in
> the application. How do I do this?
> thanks,
> Dee|||After giving rc:LinkTarget=framename, second report is
opening in a new window. Not in the given frame. I'm
using Jump to report method for calling 2nd report.
thanks,
Deee
>--Original Message--
>When you access the parent report in your frame, add the
URL access
>parameter rc:LinkTarget=framename. This will target all
of the hyperlinks in
>the report. You can also do stuff like
rc:LinkTarget=_blank to open in a new
>window.
>--
>Bryan Keller
>Developer Documentation
>SQL Server Reporting Services
>A friendly reminder that this posting is provided "AS
IS" with no
>warranties, and confers no rights.
>
>"Deepak" <deee@.discussions.microsoft.com> wrote in
message
>news:02e201c46d7c$f84dff50$a501280a@.phx.gbl...
>> Hi,
>> I've a web application. The default page consists of
>> three frames. 'List bar frame', 'Banner frame'
and 'Main
>> frame'. Reports are displayed on this 'Main frame'.
>> I've a report which has got a column which is linked to
>> another report. I want the second report to be
displayed
>> in the same frme ('Main frame'). Right now while
>> clicking the link column, report is displayed in the
>> parent frame, there by I'm loosing list bar and banner
in
>> the application. How do I do this?
>> thanks,
>> Dee
>
>.
>|||You will need to use jump to URL action and build the URL as an expression,
adding rc:LinkTarget. I know it is not ideal, but it is the suggested
workaround for your scenario.
--
Bryan Keller
Developer Documentation
SQL Server Reporting Services
A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.
"Deepak" <dee@.discussions.microsoft.com> wrote in message
news:05b901c46e31$d7519f40$a501280a@.phx.gbl...
> After giving rc:LinkTarget=framename, second report is
> opening in a new window. Not in the given frame. I'm
> using Jump to report method for calling 2nd report.
> thanks,
> Deee
> >--Original Message--
> >When you access the parent report in your frame, add the
> URL access
> >parameter rc:LinkTarget=framename. This will target all
> of the hyperlinks in
> >the report. You can also do stuff like
> rc:LinkTarget=_blank to open in a new
> >window.
> >
> >--
> >Bryan Keller
> >Developer Documentation
> >SQL Server Reporting Services
> >
> >A friendly reminder that this posting is provided "AS
> IS" with no
> >warranties, and confers no rights.
> >
> >
> >"Deepak" <deee@.discussions.microsoft.com> wrote in
> message
> >news:02e201c46d7c$f84dff50$a501280a@.phx.gbl...
> >> Hi,
> >>
> >> I've a web application. The default page consists of
> >> three frames. 'List bar frame', 'Banner frame'
> and 'Main
> >> frame'. Reports are displayed on this 'Main frame'.
> >> I've a report which has got a column which is linked to
> >> another report. I want the second report to be
> displayed
> >> in the same frme ('Main frame'). Right now while
> >> clicking the link column, report is displayed in the
> >> parent frame, there by I'm loosing list bar and banner
> in
> >> the application. How do I do this?
> >>
> >> thanks,
> >>
> >> Dee
> >
> >
> >.
> >|||It's working. thank you very much.
>--Original Message--
>You will need to use jump to URL action and build the
URL as an expression,
>adding rc:LinkTarget. I know it is not ideal, but it is
the suggested
>workaround for your scenario.
>--
>Bryan Keller
>Developer Documentation
>SQL Server Reporting Services
>A friendly reminder that this posting is provided "AS
IS" with no
>warranties, and confers no rights.
>
>"Deepak" <dee@.discussions.microsoft.com> wrote in message
>news:05b901c46e31$d7519f40$a501280a@.phx.gbl...
>> After giving rc:LinkTarget=framename, second report is
>> opening in a new window. Not in the given frame. I'm
>> using Jump to report method for calling 2nd report.
>> thanks,
>> Deee
>> >--Original Message--
>> >When you access the parent report in your frame, add
the
>> URL access
>> >parameter rc:LinkTarget=framename. This will target
all
>> of the hyperlinks in
>> >the report. You can also do stuff like
>> rc:LinkTarget=_blank to open in a new
>> >window.
>> >
>> >--
>> >Bryan Keller
>> >Developer Documentation
>> >SQL Server Reporting Services
>> >
>> >A friendly reminder that this posting is provided "AS
>> IS" with no
>> >warranties, and confers no rights.
>> >
>> >
>> >"Deepak" <deee@.discussions.microsoft.com> wrote in
>> message
>> >news:02e201c46d7c$f84dff50$a501280a@.phx.gbl...
>> >> Hi,
>> >>
>> >> I've a web application. The default page consists
of
>> >> three frames. 'List bar frame', 'Banner frame'
>> and 'Main
>> >> frame'. Reports are displayed on this 'Main frame'.
>> >> I've a report which has got a column which is
linked to
>> >> another report. I want the second report to be
>> displayed
>> >> in the same frme ('Main frame'). Right now while
>> >> clicking the link column, report is displayed in
the
>> >> parent frame, there by I'm loosing list bar and
banner
>> in
>> >> the application. How do I do this?
>> >>
>> >> thanks,
>> >>
>> >> Dee
>> >
>> >
>> >.
>> >
>
>.
>

How to read the DBCC page through cleint application

Hi,
I am writing a application that require to read some DBCC Pages.
But when I execute dbcc page command through ADO, I get a page in terms of e
rror collection.
In that error collection each row of output is just a string.
I need to interpret that string value.
Is there some other way through which I can read DBCC Page.
I am interseted only in the memory dump portion of the page.
Is there some better way to read the data base page or I need to use this er
ror collection method only.
Any help is appreciated.
Thanks
PushkarHi
You may want to use DBCC BYTES but you will have to calculate the starting
address. Ken Henderson's "The Guru's Guide to Transact-SQL" ISBN
0-201-61576-2 gives some information on all these undocumented calls and
using them in production code carries the usual health warnings.
John
"Pushkar" wrote:

> Hi,
> I am writing a application that require to read some DBCC Pages.
> But when I execute dbcc page command through ADO, I get a page in terms of
error collection.
> In that error collection each row of output is just a string.
> I need to interpret that string value.
> Is there some other way through which I can read DBCC Page.
> I am interseted only in the memory dump portion of the page.
> Is there some better way to read the data base page or I need to use this
error collection method only.
> Any help is appreciated.
> Thanks
> Pushkar|||I believe that you can add WITH TABLERESULTS to get back a resultset instead
a string (messages).
Note: It is not supported or documented (but nor is DBCC PAGE, so you are on
your own anyhow :-) ).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Pushkar" <pushkartiwari@.gmail.com> wrote in message news:%23x6XXvsvFHA.1256
@.TK2MSFTNGP09.phx.gbl...
Hi,
I am writing a application that require to read some DBCC Pages.
But when I execute dbcc page command through ADO, I get a page in terms of e
rror collection.
In that error collection each row of output is just a string.
I need to interpret that string value.
Is there some other way through which I can read DBCC Page.
I am interseted only in the memory dump portion of the page.
Is there some better way to read the data base page or I need to use this er
ror collection method
only.
Any help is appreciated.
Thanks
Pushkar|||Thanks, I think this will solve my problem.
Pushkar
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OG8y%23h4vFHA.464@.TK2MSFTNGP15.phx.gbl...
>I believe that you can add WITH TABLERESULTS to get back a resultset
>instead a string (messages). Note: It is not supported or documented (but
>nor is DBCC PAGE, so you are on your own anyhow :-) ).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Pushkar" <pushkartiwari@.gmail.com> wrote in message
> news:%23x6XXvsvFHA.1256@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I am writing a application that require to read some DBCC Pages.
> But when I execute dbcc page command through ADO, I get a page in terms of
> error collection.
> In that error collection each row of output is just a string.
> I need to interpret that string value.
> Is there some other way through which I can read DBCC Page.
> I am interseted only in the memory dump portion of the page.
> Is there some better way to read the data base page or I need to use this
> error collection method only.
> Any help is appreciated.
> Thanks
> Pushkar
>

How to query for master-detail output on same page

I'd like to create a master-detail output from SQL2005 to display in a page using classic ASP. Ideally, I want the output to contain a <div> to show/hide the order details beneathe the order header, as shown below.

OrderNo OrderDate

1001 7/27/2007

+ <div to show/hide>

Item Description

AAA desc_for_itemAAA

BBB desc_for_itemBBB

+ </div>

1002 7/26/2007

+ <div to show/hide>

Item Description

CCC desc_for_itemCCC

+ </div>

I currently just have a stored procedure returning the results and it is very slow as I'm simply querying the details section for each order header. Does anyone have any ideas on how I can create an efficient and fast method for returning these results in the format above?

It’s always better to do these rendering on the ASP/UI page,

For your courtesy,

Code Snippet

Create Table #order (

[OrderNo] int ,

[OrderDate] datetime

);

Insert Into #order Values('1001','7/27/2007');

Insert Into #order Values('1002','7/26/2007');

Create Table #orderdetails (

[OrderNo] int ,

[Item] Varchar(100) ,

[Description] Varchar(100)

);

Insert Into #orderdetails Values('1001','AAA','desc_for_itemAAA');

Insert Into #orderdetails Values('1001','BBB','desc_for_itemBBB');

Insert Into #orderdetails Values('1002','CCC','desc_for_itemCCC');

Select

OrderNo,

OrderDate,

Replace(Replace((Select '<td>' + Item + '</td><td>' + Description + '</td>' as [text()] From #orderdetails OD Where OD.[OrderNo] = O.[OrderNo] For XML Path('tr')),'&gt;','>'),'&lt;','<')

From

#order O

<!--

On ASP/UI page,

While NOT rs.eof

Response.Write(“<tr><td>”)

Response.Write(rs(0))

Response.Write(“</td><td>”)

Response.Write(rs(1))

Response.Write(“</td></tr><tr>”)

Response.Write(“<td colspan=2><span style='cursor:hand' click=ExpandOrCollopse(‘div_” + rs(0) + “’)>+</span>”)

Response.Write (“<div style='display:none' id=’div_”)

Response.Write(rs(0))

Response.Write(“’><table>”)

Response.Write(rs(2))

Response.Write(“</table></div>”)

Wend

-->

|||

What you are proposing is clearly a presentation side issue and should not be 'forced' on SQL Server.

I suggest that you may find utility in the new XML output functionality.

|||

Manivannan, thanks for the sample code. I was able to create an output as you explained.

Arnie, can you point me to an easy to understand resource for this xml output functionality? I haven't really had any exposure to xml.

|||

Here are a couple of resources to get you started:

http://www.topxml.com/sql/

http://technet.microsoft.com/en-us/library/ms175024.aspx

Using XML data is perfect for web applications.