Report with Multiple Tables Join

I am designing a Receipt using Crystal Reports 8.5 Developer, MS SQL 2000 Server and MS Visual Basic 6.0 sp6. My Receipt will grab some data from RCP, RCPGL, RCPDetail and Customer tables.

SQL = SELECT RCP.RCPID, RCPGL.RCPGLID, RCPDetail.RCPDetailID, RCP.RCPDate, RCP.RCPID, RCPGL.GLDate, RCPGL.ChequeNo, RCPGL.GrossAmount, RCPDetail.InvoiceNo, RCPDetail.AmountPaid, Customer.CustomerName FROM RCP, RCPDetail, RCPGL, Customer WHERE RCP.RCPID=RCPDetail.RCPID AND RCP.RCPID=RCPGL.RCPID AND RCP.CustomerID=Customer.CustomerID AND RCP.RCPID= glngRCPID

Let say RCPDetail has 3 Invoices data and RCPGL has 2 cheque transactions, my SQL query will returns 6 records.

What I want is to display a section with 3 records of Invoice and another section to display 2 lines of cheque transactions.

Anyone can give me some recommendation?Group on the record type. If this is implicit from the data (e.g. ChequeNo is non-0 for cheques) then create a formula to return a type and group on the formula.|||Hi JaganEllis,
Thanks for your suggestion. I have found an idea and it is using grouping too. I will create a temporary table call TempReceipt. I'll SELECT data from RCPGL table and INSERT "RCPGL" as the key into TempReceipt and then SELECT data from RCPDetail table and INSERT "RCPDetail" as the key. After that join the TempReceipt table with Customer table using ADO. When display the data in Report, I'll use Group by the key of TempReceipt to separate the data.sql

report with groupby

hi,
i have a query working with crystal reports on oracle server.

--There is a table transaction_hist containing 'due_date' column(which is a number to be converted to date). In the report i want the summary of the amounts with current due_date, future due_date, past 1to30 days due_date,31to60,61to90 and 91to180 due_dates.

eg
current future 1_30 31_60 61_90 91_181
sum 99999 99999 99999 9999 9999 9999


PS: i have tried to make formula column for all these due_dates...but could not group by them and summarize them.Try uisng Cross tab reports. Read more in help file

Report Viewer shrinking and shows scrollbar

I am using Crystal Report Viewer in ASP.NET page. In some of my reports, the viewer seem to be shrinking to about one third of the page. I have set all properties including width etc properly.
Have anybody seen this behaviour before?I have also faced same problem..If you get any solve pls. post in this forum.|||We found that this problem happens when we install some specific printer drivers. If I uninstall all printers from my server, all reports are working fine. Please post your updates too..|||I was reading something on Crystal KB the other day about print drivers. I can't remember the exact scenario but the gist of it was that the report was misbehaving in the production environment.

The solution was to set the report to "No Printer" in the design environment so that it didn't carry over the print driver settings. Everytime a user prints with a different printer and those settings conflict with the design print settings, it creates havoc.

Just wondering if setting your report to "No Print" would alleviate this problem too?

Linda|||We tried that. And it worked fine until I try to print the report. When I print, it returns to the smaller size.

- Tony|||Sounds like a bug to me!

Report to be printed in the orientation set in the rpt

I run a crystal report from VB. I send the report directly to the printer. The rpt file of the report that i am generating has paper orientation set to "Landscape". When i print the report , it prints in Portrait(setting of the default printer). But, if i preview the report instead of directly sending to the printer, the orientation is what is in the rpt. How to solve this problem ? Has anyone came up with this problem.

thanks
priyaI have a code example in my signature called "VB6/CR Print Setup Dialog Ex." which shows how to preset the printer setting and use those for printing, etc.

report templates

We want all our reports to have the same header and footer, in crystal
reports we could make a template report... can something similar be done in
report services? Thanks!Sort of. You can create a style template for the creation of reports.
However, if you want to change it later you have to go to each report one by
one and modify it.
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/f84b9ac6-bf37-4f27-bbe4-273a4af84c2e.htm
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Smokey Grindle" <nospam@.dontspamme.com> wrote in message
news:%23q9LZBmNHHA.2140@.TK2MSFTNGP03.phx.gbl...
> We want all our reports to have the same header and footer, in crystal
> reports we could make a template report... can something similar be done
> in report services? Thanks!
>|||thanks!
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:ejuo$PmNHHA.4928@.TK2MSFTNGP06.phx.gbl...
> Sort of. You can create a style template for the creation of reports.
> However, if you want to change it later you have to go to each report one
> by one and modify it.
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/f84b9ac6-bf37-4f27-bbe4-273a4af84c2e.htm
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Smokey Grindle" <nospam@.dontspamme.com> wrote in message
> news:%23q9LZBmNHHA.2140@.TK2MSFTNGP03.phx.gbl...
>> We want all our reports to have the same header and footer, in crystal
>> reports we could make a template report... can something similar be done
>> in report services? Thanks!
>|||Awesome, thanks!
"Reeves Smith" <ReevesSmith@.discussions.microsoft.com> wrote in message
news:1725398D-0098-4EC6-AF16-C1AADFC53241@.microsoft.com...
> Another Idea:
> Create a template RDL file and save it.
> Place the RDL file into the location:
> Drive:\Program Files\Microsoft Visual Studio
> 8\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject
> Now when you click add a new item (from a reports project), it will be one
> the available selections.
> Reeves
> "Smokey Grindle" wrote:
>> We want all our reports to have the same header and footer, in crystal
>> reports we could make a template report... can something similar be done
>> in
>> report services? Thanks!
>>