VB Forum / Crystal Report / November 2003

I have a report that requires numbers to be formatted one way for US
and one way for Yen. US uses ####.00 and yen uses ####
I tried using the ToText, which formats the numbers ok, but then the
formula is treated as a string and the number isn't right justified. I

as in the subject line, im trying to concantenate Addr1 and Addr2 fields on
the same line, in most cases Addr2 is blank or null, when this IS the case,
the formula returns a blank field... would i use ToText function? if so,
how? if not, what? ;)~

in Textfields word wrap does not work with german umlaute.
Is there a solution for this problem?
Norbert

Hello,EveryBody,
I use Vs.net 2002,  Cr9 ,Sql2000 to view Report,But I have a error.If my
Datebase's user (eg:sa) has no password,The report view ok.But my Datebase's
user (eg:sa) has  passwor,I  always  get  error.The  error  is  "

I have someone doing a Crystal report for me in 9.2... I need it to appear
in an aspx page after I pass over to it parameters from my codebehind (C#)
page.  Anyone know where I can get instructions on how to do this?
TY

i want to create a report on ide,but when i push the crystalreportvirwer on
IDE,he say fail to create it
Can anybody help me!!!
Thanks s lot

Hello I use VSdotnet2003 and i'm trying to distribute an application using
the crystal reports. I already read the KBarticle about the keycodev2.dll
problem, but I cannot  find a solution. Can you help me?
This is my output after setup

I have created a crystal report which takes 2 date parameter via VB
application,for some reason data is not refreshed for specified date
range..it always displays data what date range I have entered as
default.

I need to create an ascii file for state reporting.  The easiest way seemed
to create a text box and drag the fields into it
separating fields by the | character.  However, the total record length is
815 bytes, which is bigger than our field sizes

I am trying to built a report with three count fields. i.e.
I have a table with the name BranchMaster, in which ID is primary Key.
Other tables are Branch1, Branch2 and Branch3 in which BranchID is present
as foreign key.

Can someone give me the correct syntax for selecting records that have dates
that are in the last 30 days period:
Like   {fielddate} > current date minus 30 days   ?
Also I am a confused  how to pass criteria from the main report into

I have a memo field in SQL Server db that I need to reference in a formula
in CR8.
Before I could write a formula referencing those fields I had to create a
Stored Procedure that put the contents of the memo field into a

Main report links to subreport by storeID.
In the report selection formula (in CR designer), not VB app), criteria are
set for the mainreport to display only stores that meet the criteria. This
is working fine, data in subreport also dislay in subreport section.

Hi , i need some help on how to design the details on my report... i'm new
on working with crystal
i got a Table Items with a field ItemDescription and ItemID and i got a
related table called Values with a ItemID and Value filed.... how can i do a

Is it possible to export a crystal report to an existence document?