adjust x,y position of crystal report data field from VB

dear friend,

as you know, to adjust x,y position of any data field on Crystal report,
we just open CR and manually put and adjust the datafield...

But how if our VB application want to change this setting too ?
how to pass the x,y parameter of specific data field to crystal report, so crystal report will adjust automatically before it displays. ??

Thank you,If you use RDC to display or print the report, you can do it by changing the properties of the object.

Report1.Object1.Property1 = Value1

MyRpt.fldDate.Left = 1500
MyRpt.fldDate.Top = 250

Adding two group sums

Hi guys,

I'm very new to Crystal reports and I've scoured the internet looking how to add two 'sums together in a field.

In group header 3 I'm trying to add the following two sums together

Sum ({WMLocnHandlingMediaConf.QtyStor}

and

Sum ({WMLocnHandlingMediaConf.QtyIn}

And I really don't have a clue on how to do, I am a novice on Crystal and this is probably the most complicated thing I've attempted to do.

If anyone can help it would be very much apperciated.

Many Thanks
NickTry inserting and configuring a Running Total Field|||Make sure the the two sums you have already created are physically on the report. (If you do not wanrt to show them just format/suppress).

Create a new formula. When looking for the two fields to sum in the formula, look into report fields. You should see the tweo previously created sums.

Adding subreport to report header?

Is it possible? Crystal allowed you to do it but RS doesn't seem to. I have
a number of reports that need to display same data (Org name, date etc.)
on the report header and I thought doing it as a subreport was a good idea.
Any workarounds?
Thanks in advance.Found report templates meet my needs better. Thanks anyway!
> Is it possible? Crystal allowed you to do it but RS doesn't seem to. I
> have a number of reports that need to display same data (Org name,
> date etc.) on the report header and I thought doing it as a subreport
> was a good idea.
> Any workarounds?
> Thanks in advance.
>sql

adding image dynamically to crystal report

hello
please could anyone help me to insert an image into crystal report if I saved the link in the database . I tried to change the type to "ole object" it works, but i don't have to change the type in my project.If you are using SQL Server then search for TextCopy.exe, you will get lot of related code.|||it is very easy in the Crystal 11.5 and later.

Place the OLE object -> Bitmap Image on the report. Right click the OLE Object -> Format Graphics -> Picture (tab) -> Graphic Location.

And enter the URL where the image file is placed.
Now the crystal Report will show the image on runtime by picking from the location mentioned.|||i'm using v8.0 , i'll download the XI version and I'll try

Adding full table names

I need to have the query select from dbname.dbo.client
instead of just client, in my query thats going to my sql server from crystal..is there a way to make it change to that format?
thanksCan u describe more ur problem, I m not getting

Adding Formula in CRYSTAL REPORT

Hi,

I am using a Crystal reports in order to get the information from the database (ORACLE 9).
The source of data is the script which I added via add command using ORACLE OLE Provider.

I would like to say that now I am trying to implement CR formulas in order to give the
following message :
"NO USERS LOGIN"

I wanted that when there is no user connected to the database Crystal Report gives this message.

In order to that I created the following forumla from the formula Tab, but it didn't give any
message on crystal reoport, when no user login to the database:

Formula 1

if count ({command.USER}) < 0
then "No User Login to Database"

or

Formula 1

if count ({command.USER}) < 1
then "No User Login to Database"

I tried to drag this formula on various section of reports (Detail, Report header), but it
did'nt work.

But when I used greater than sign instead of using less than size, this formula works and
gives the message.

For Example:

Formula 2

if count ({command.USER}) > 0
then "User Login to Database"

Could someone please inform what changes I made in the formula 1 in order to display the message
"No User Login to Database", when there is no user login to database.

I also like to say that the routine which I am using in the Crystal Report gives me information
of several Users who are connecting to the database.

Thanks

DavidI think that's normal, because crystal create a connection to your database to verify the number of user connections. So I think that you must put the following formula in your report:

if count ({command.USER}) < 2
then "No User Login to Database"

To verify what I say just print the field {command.USER} to see his value.|||Hi ariqa,
Use the following formula

if isnull ({command.USER})
then "No User Login to Database"

Madhivanan|||Hi Machuet & Madhi,

Thanks for your cooperation.
Yours solution helped me.

Thanks

Regards

David

Adding Field to Stored Procedure for Crystal Reports

Hello:

I have a stored procedure for generating our invoices in Crystal
Reports. I have added a new field to the SP, but when I try to add the
field to my Crystal Report invoice, the field isn't available in the
list. However, if I create a new, blank report using the same stored
procedure as the datasource, the field is available. I've seemingly
tried every iteration of "Verify Database" to no avail.

The obvious answer would be to simply drop the sp from my existing
report and then re-add it. However, if you do this, all your fields on
the report are dropped.

Any ideas?

Thanks,
ScottScott (scott@.oppligerbanking.com) writes:
> I have a stored procedure for generating our invoices in Crystal
> Reports. I have added a new field to the SP, but when I try to add the
> field to my Crystal Report invoice, the field isn't available in the
> list. However, if I create a new, blank report using the same stored
> procedure as the datasource, the field is available. I've seemingly
> tried every iteration of "Verify Database" to no avail.
> The obvious answer would be to simply drop the sp from my existing
> report and then re-add it. However, if you do this, all your fields on
> the report are dropped.

You probably get a better answer in a forum devoted to Crystal Reports.

In my shop we use ttx-files as the "database" for our report, so the
report has no connection to the SQL Server database. If one adds a column
to the result set, one has to add it to the TTX file too.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Adding Database Fields Dynamically To the Crystal Reports

I have a problem Where in i need to show 24 sizes in one session so i have sliced it to 3 rows 8 columns each , it is not necessary that all the 24 fields should contain data so if there are only 8 sizes i have to show 8 sizes and i have to reduce the size of the section to one row . I am able to suppress the fields in the section but iam unable to reduce the size of the section to one row . so i want to add the fields dynamically to the session instead of drag and drop using ASP.NET(VB) .
Please can any one help me .
Its very very urgent.Could you be using a crosstab? Placing rows and columns i seperate table columns and then printing them in a crosstab.

- Jukka