how to insert a picture in Crystal Report reading as binary

hi all,
how to insert a picture in Crystal Report reading as binary from database (SQL SERVER).isn't any guru here to solve my problem

i also used the follwing but not working


Picture1.SetoleLocation app.path & "\" & Field1.Value



i have a picture box in crystal report and field in table which stores path name of the picture file.

how to incorporate data from more than one table(having no relation) in CR9

how to incorporate data from more than one table(having no relation) in detail section of crystal report 9...In CR, on your left you have a "Field Explorer"
In there you have "Database Fields", you right click them and chose "Database Expert".
Then you chose meke new connection and you chose witch tables to import in your CR.
If the tables are in no relationship, thet is not a problem, you just won't be able to connect them together.
Afcourse CR will inform you about that, but just click OK a that should be it.
Afcourse if you don't get data from this tables (in code) you won't be able to show data.

How to include data from 2 unlinked tables

I am using VB6 and CR10 & SQL Server 7
I am working on an inventory project nw.. I'm new to crystal reports..

For the report i need to pick data from 2 tables(Sales_Details, Purchase_Details)
There is no link between these 2 tables (except a similarity that both have got a date field)

TABLE 1
Sale_Date... SalesQty
01/01/07...... 50
01/03/07...... 24
01/04/07...... 10

TABLE 2
Purch_Date... Purchase Qty
01/01/07 ....... 100
01/06/07 ....... 100

I need to take a report which shows the movement of a particular Item based on date range
It should look like this

------x----x----x
Date ......... Sales.......Purchase
------x----x----x

01/01/07 ........ 50 ........ 100
01/03/07 ........ 24 ........ 0
01/04/07 ........ 10 ........ 0
01/06/07 ........ 0 ........ 100
--------------
I tried inner and outer joins to links these tables, but all in vein( data is getting repeated then), tried with groups also..no use

Pleeeaaase... help me to do this...
This may be a simple issue for most of you...
But i am a beginner.. i need your valuable help..
Plzzzzz...Just to make sure, but there are no PKeys in either one of your tables?|||You say you need to report by item, so surely there must be some sort of item code in both tables otherwise how do you know what item you're buying / selling?|||Ofcourse item code is there... For sake of simplicity i dint mention that.

Actually both the purchase and sales table has the fileds- Date, Itemcode, Quantity

Sales Table

Date...... ItemCode........Qnty
------------
01/01/07 ..A001............50
01/03/07...A001............24
01/04/07...A001............10

Purchase Table
Date...... ItemCode........Qnty
------------
01/01/07...A001............100
01/06/07...A001............100

and i need a report (like the one mentioned above)based on the movement of Item -A001 ..

Please...........|||First:
You wrote:

There is no link between these 2 tables (except a similarity that both have got a date field)
This is the reason for the questions now I assume itemcode is your link.
Next you will group by date and itemcode if you want, now for grouping by date go to options and choose section to be printed by day.
Then you will need to create formulas that will check to see the quantity of sales and purchases.

Something like:

If {Sales.quantity} > 0
Then {Sales.quantity}
Else 0

Hope that helps,
GJ

how to import data from a vb program

hi. i hope you could help me with this problem.

the data i will be needing to show is from my vb program and not from the database. on the crystal report, it should look something like this.

name amount
betty 200
cristina 345
daniel 230
preston 300

but the number of list of names and amounts varies. depend on what is entered on an unbound grid in the vb program.

thanks for any help you could extend.the VB program could be modified to pass the data, but, if it isn't stored somewhere, how would CR know about it?|||oh sorry, it is temporarily stored on a data grid.|||You could try to get data from tables in your VB program and store it to a data set, then you could send this data to your CR, where you have to tell the CR which tables you are using.
If you forget to get data from any table you are triing to show in CR the report won't work.

something like this:
dim cr as dataset
dim X as new crX
dim Y as ReportForm
x.SetDataSource(cr)
Y=new ReportForm(x)

where cr is the dataset where you have all tables you are triing to show.

hope this will help|||i'll try that one. thanks a lot.|||i already made a dataset with three tables. but when i try to set it as the data source for the crystal report, it says that the report does not have tables.