InnerQuery Report -
Hi,
I have one table named "Ledger". as follows ....
acccode ---------- vdate ---------- amount----------drcr
---------------------------------------------------------------------
101---------------02/4/03-----------2000.00------------D
103---------------11/4/03-----------3000.00------------C
102---------------12/4/03-----------2500.00------------D
103---------------05/5/03-----------2000.00------------D
103---------------21/5/03-----------3500.00------------D
101---------------15/5/03-----------5000.00------------C
104---------------20/5/03-----------6000.00------------C
I want to generate the report in Crystal reports.
two parameters should be passed from vb...
the report format should be as follows.....
StartDate : 20/4/03
EndDate : 20/5/03
===========(A)============(B)============(C)=====
acccode----openingamount-------transactionamount-----balance
*********Debit-----Credit--------Debit-----Credit-----Debit---Credit
----------------------------------------------------------------------------------
101--------2000.00--------0-----------0------5000.00-->---0-----3000.00
102--------2500.00--------0-----------0---------0-------->-2500.00-----0--
103--------3000.00-------0------------0-------2000.00-->--1000.00-----0
104---------------0-------0-------------0--------6000.00-->---0----6000.00
[note : for naming convension i have given (A)(B)&(C).]
(A) - amounts should be the as on 19/4/03 date amount.balance as on 1day before to 'startdate'.
(B) - amounts should be the transaction amount, done in the period of 'startdate' and 'enddate'. i.e. from 20/4/03 to 20/5/03.
(C) - amounts should be the difference amounts of 'opening' and 'transaction'. i.e.
1. (C) debit = (A)Debit - (B)Credit or (B)Debit - (A)Credit
2. (C) Credit = (A)credit - (B)debit or (B)credit - (A)debit
for the above format...... the print command will be given ... by choosing startdate and enddate thru vb application.
Thanks in advance.....
InnerQuery Report -
Hi,
I have one table named "Ledger". as follows ....
acccode ---------- vdate ---------- amount----------drcr
---------------------------------------------------------------------
101---------------02/4/03-----------2000.00------------D
103---------------11/4/03----
How to refresh crytal report 7 -
hello, everybody
I have a problem here with crystal report 7 in VB6. My report is working fine. But the problem i faced here is that the report is kept on showing the same report even though i have assigned a new variable to the report. Let's say the report is printed based o
Crystal reports sub report -
In my crstal report I am having a sub report.And I want to run my report from vb by passing a query at run time. I can able to run the query only for main report and not for sub report. How can I make my app. to have full report along with sub report at run time.
thanx in adva
I need a report done with crystal report -
Hi, i have the database and the report design i just want someone who will create the report from the report, it' sjust 1/2 A4 paper report.
Please send me a PM with the price
thanks
beginner question for Report -
hi every one,
i have installed Crystal Report in my system and i created a Report by just browsing the Database and put the Fields into the Detail Section. This is my first Report.
Please tell me how can i Generate Report using SQL Statement. and how can i show the Picture in Repo
Forumulas in Report -
Hi Everyone,
I have a report with 6 sub reports and am needing to do a forumula with two numbers from sub report 1 and sub report 2.
The problem is I can't figure out how to do a calculation with one figure in sub report 1 and the other in sub report 2 and show the result in sub
Access Report - Total Sub Report -
Hi,
I have a report that contains a sub-report. I'm trying to show a total in my main report report footer based on the sub-report, but no luck.
I've found an article (208835) on the MS website, but this doesn't work, it's either me or it's not correct?
Can someone tell me ho
Crystral report 9 -
Hi
I am using Crystal Report 6 but today I install cr9.
Problem is this
in VB6 :- I can call cr6 report with crystal report control
and working properly.
But in Cr9 i can not find the said components in vb6.
Pls help how to run the cr9 report in existing vb6 code for repo
Error With Character in VB.Net Cristal Report -
I have a module printing a report made en Cristal Report. When i Show the report in the print preview option everything looks fine. When I send the report to the printer appear odd characters in all the report.
Can you help?
Jorge W.
Thanks
Clearing Crystal Report Form -
Hello:
I am using Crystal Report 9, I have a Tab control where one of the tabs is for Reports. Here is my problem. When I goto the Report tabs and generate a report (Which all works fine) and then move to another tab and then come back to the report tab the LAST Report is still displa
Need help onn VB.Net report -
i need a report which is like the default data report in VB 6.0 for VB .Net but i cannot find any report like this and also no default report in VB.Net other than the crystal report.......but that need a license and is 2 much for the report that i wanted to create...........
i just
create crystal report -
Hi All
I try to create simple crystal report in VS2005 based on table. I added crystal report to my project ans use Standard Report Creation Wizard. Than copy report file and past it to Debug folder. Run form and click Run Report button on my form. The report viewer open report but wi
[2008] Save Report to PDF Programmatically -
I've created a report (not CR) in VB.net, and I'm able to view the report using a report viewer, however, I want to be able to export this report as a PDF file. How do I do that?
Crystal Rpts dbase login -
Guys,
I have an app that works with a SQL database. I have a Crystal Report that has been designed outside of .NET and then e-mailed to me.
This crystal report contains the databse and table definitions and will work stand alone, I think this uses ODBC connection ?
I am now tr
Call Crystal Report in ASP.NET -
HI
i designed one crystal report , then i added that report to crystal viewer control, it is displaying as it is report at runtime in browser.
but my requirement is some conditional data only should display in the report. i need to pass some parameters to report.
how to do
Crystal Report Viewer in ASP.NET Problem -
Dear friends,
I have made a report in .NET environment by crystal report. I have loaded it in a web form with a crystal report viewer.
It is working good. But when I print the report it prints Report Name and Page No on the top of the paper and the report url on the bottom of the
Crystal to EXCEL -
I have Crystal Report Writer 85.. I want my vb6 app to run the report that will export the data to EXCEL.
My questions are:
Do I need this code?
Report.SelectPrinter glbPrinterDriver, glbPrinterName, glbPrinterPort
I know I need:
Set Report = crxApplication.OpenReport("
PLEASE HELP!!! Data Report problems -
We are using the Data Report Manager to create a report from a query. How do you get the report to update once changes have been made to the query? Example: 2 items are added to the report. View the report. Make changes to the report and add 2 more items. The report does not reflect th
Report/Sub-Report Parameter Linking -
Greetings,
I have one report that gets data from a stored procedure, I have a sub-report that is ran with its own stored procedured.
They are both grouped together.
Heres what I want. I want [Report 1].[Field 1] to be passed to the parameter of the second report so each time
Crystal Report Dynamic Report (VS2005 CR10) -
I wish to create a report that accepts a value that generates the report.
I have a combo box in my form, in the box contains User names.
I want to select the user name and Generate the report concerning that users information.
How does one pass a value to a Crystal Report?
Report timing out when clicking Next or last pae -
We have a report designed in ver 8.5 and on the report server we use ver 10. When we call the report VIA asp, the report is displayed on the screen, but if we click the next button or the last page, the report times out and fails. Odd thing is if we try to run this report on another ma
show report from vb.net -
hi
i want to know the way/code/anything to display a report in crystal report?
i have a report (crystal report) that i built in vs.net, now i want to call him from a aspx page or a vb.net with a button
i want to click on the button and the report will appere ?
is
show report from asp.net -
hi
i want to know the way/code/anything to display a report in crystal report?
i have a report (crystal report) that i built in vs.net, now i want to call him from a aspx page or a vb.net with a button
i want to click on the button and the report will appere ?
is
Passing value from Sub-Report to Main-Report -
Can anyone please help me...
Did anyone know how to pass a sum value (or any value) from Sub-Report to Main-Report?
I mean pass it to a formular or parameter, not just view it on Main-Report.
Please and Thank you.
I am using Crystal Report 8.0 and Ms Access Database.
Report C
how to refresh Report -
Dear all,
I am using front end as VB6, sql server & Crystal report. in VB 6 im using "Cystal Report Control" Component. Can anybody help me in how to refresh the report.
for the report i m passing one query & saving into one temp table. & that data i m gener
accounting report! please help -
This is a question about selecting the right tool for the job.
we are developing an accounting system and we are now creating the reports.
right now we are looking at a very difficult report called the balance report (is that the name of the report in english???) anyway in that r
accounting report! help! -
This is a question about selecting the right tool for the job.
we are developing an accounting system and we are now creating the reports.
right now we are looking at a very difficult report called the balance report (is that the name of the report in english???) anyway in that
DataReport and pagebreaks -
I have now finished the datareports for my program, except for the report footers. If the report is less than a page it displays the footer right under the contents of the report.
How can I have my report footers displayed at the bottom of the report?
two sub report in one report -
i have two sub report in one report but the problem is that one either of the sub report when expand it comes over the other when..is there a way to maintain a gap between the two reports.
thanx
VB6.0 with Crystal Report 10 -
Hi friends,
Im using VB6.0 with Crystal Report 10 DB: MSACCESS
Please provide some sample coding that connects the report(CR 10) to view the report. I was using crystal report 6 and now i have upgraded to 10. But im getting error as "Unable to load report"
Please help me o
Crystal report data refresh problem -
Dear all ,
i am new to Vb forms , but i find this very usefull , thanks to all in advance for a small help .
I am using crystal report 8+ version and i call the report from Vb6 . My back end is ms access. i have used ado for creating the report directly in the Crystal report .
P
problems with crystal reports in mdi -
im having problems with crystal under mdi form. i would like my report to be viewed in mdi.
my question: the problem starts when i view the report the 2nd time around. it wont load the 2nd time around. sometimes the report is loaded but it is located at the back of a another report
Report -
I went in to Crystal report and followed the wiz and made a report. Then I went to previewand some of the field around in preview save it.
I place Crystal Report control on the form and give the code to Print it to a window. The problem is that it show the report but not how edit it i
Selecting only certain records -
Hello all,
I have a crystal report going to a database for my report currently. In that database I hold all the information needed to previous reports as well as the report I am trying to print, which will be the most recent report 9/10 times. (This will be the report with the highest
ttx report with a odbc subreport -
i'm using vb 6, crystal 8.5 and sql server2000. i have a report that is linked to a ttx file. the report recives an adp recordset from my vb app. theis works fine. the issue is i need to put a subreport in my existing report. i do NOT want to link my subreport to a ttx file. i want to
Problem with summary report - summing fields -
Ok, I have my report already completed with the design I want. I have tested the report as a Detail report only. My Select statement that populates the report was simply grabbing fields from the table and dropping them in the report.
I saved my dataset schema and imported it to th
Sourceobject, LinkMasterFields, LinkChildFields -
I'm doing a report with Access 2000, I have to put a condition in to it when it load(open). I have one under-report(a report inside a report, I hope I got the good term here) that is defined when it loads. I have something like:
[Name of the main Report].[Name of the Under-Report c
How to make crystal report for VB6.0 -
hello
How i run vb application using a crystal report on any other machine on which crytsal report isn ot installed ?
how can we embedd crystal report in visual basic to make trake ur reports.. ?
Is it possible that we make a crystal report in Crystal report and direct call i
loading data to a crystal report one by one -
I have used crystal report 9 in my vb6 project with sql server 2000. I have used a combo box on a vb form to place file numbers and ask user to select a number to generate a report. at the first time report is visible. for the second time no report is generated. but report format is vi
Crystal Report! -
Hi all,
I know how to design an report by Crystal Report but I do not know how to transfer database from Accscess to Crystal Report (I use Visual Basic and design Report by DataReport in VB6 but it can print Landscape orientation, that why I use Crystal report. )
Can you tell me ho