I wanna know how can i passing the SQL statement from VB.NET to crystal report for making the report ?
where can i find the tutor web site for this thing ?
I'm a newbie about .NET and crystal report.
I can using VB.NET to view the report with crystal report but by wizard.. I wanna do in manually.
Thanks
KeeCR.SQLQuery="YourQuery"
where CR is Crystal Reports object|||Could you give me a full sample ? I'm a newbie for the crystal report. and it has no any manually tutorial site. hasn't it?
Thks
Kee|||If if you find this in FAQ section of www.VBCity.com|||Hi,
why couln't you try for strongly typed datasets as ur report source.
get the tutorial from MSDN 2006
here is the link
ms-help://MS.MSDNQTR.2006JAN.1033/dnmag02/html/Crystal.htmsql
Showing posts with label crystal. Show all posts
Showing posts with label crystal. Show all posts
Wednesday, March 28, 2012
Monday, March 26, 2012
How to use the Thousand Seperators In Crystal Report 8.5
Hi!
I am developing a accounting application using visual basic and ms access.
then i use the crystal report 8.5 for report.
plz explain how to use the thousand seperator formula in number field.
like Rs.5,55,555.00
when i applied the thousand seperator formula
it should be displayed like this :
Rs 55,555,55.00
what can i do for these problem plz explain.
then one more doubt is there :
how to use the crystal report in asp page.
plz have u got any source plz send me.
thanks in advance.What is your desired output?
Rs 55,555,55.00 or 5,55,555.00?|||hi mathivanan!
i like the following format
indian currency format
Rs : 5,55,55,555.00
plz explain|||Create a formula having this code
StringVar Amt;
StringVar s;
NumberVar N;
Amt:=Replace(Totext({AmountField}),",","");
s:=left(Amt,len(Amt)-3);
N:=len(s);
Select N
case 4:
left(s,1)&","& right(s,3) & ".00"
case 5:
left(s,2)&","& right(s,3)& ".00"
case 6:
left(s,1)&","& mid(s,2,2) & "," & right(s,3)& ".00"
case 7:
left(s,2)&","& mid(s,3,2) & "," & right(s,3)& ".00"
case 8:
left(s,1)&","& mid(s,3,2) & "," & mid(s,6,2) & "," & right(s,3)& ".00"
case 9:
left(s,2)&","& mid(s,3,2) & "," & mid(s,6,2) & "," & right(s,3)& ".00"
default:
s;
and place it in the details section|||hi mathi!
when i am using the formula!
i got the error message
"The Formula Result Must be a Boolean"
here u also use ToText Function but its fired error.
what can i do for these problem plz explain.
StringVar Amt;
StringVar s;
NumberVar N;
Amt:=Replace(Totext({product_details.prod_price}),",","");
s:=left(Amt,len(Amt)-3);
N:=len(s);
Select N
case 4:
left(s,1)&","& right(s,3) & ".00"
case 5:
left(s,2)&","& right(s,3)& ".00"
case 6:
left(s,1)&","& mid(s,2,2) & "," & right(s,3)& ".00"
case 7:
left(s,2)&","& mid(s,3,2) & "," & right(s,3)& ".00"
case 8:
left(s,1)&","& mid(s,3,2) & "," & mid(s,6,2) & "," & right(s,3)& ".00"
case 9:
left(s,2)&","& mid(s,3,2) & "," & mid(s,6,2) & "," & right(s,3)& ".00"
default:s;|||It should work correctly
Check again whether you miss something in the code|||Hi MathiVanan!
your code is working properly!
thanking you.|||Well
How did you have problem initially?|||Hi Mathy!
actually i am applying the function to the price field object using
Field Object --> Format -->Number Format-->
Thousand Seperator -->Choose the Formula Editor
later i just create a new formula field and applying this code.
and then drag the formula field in my report page
it working properly.
thanks mathi!
muthu
I am developing a accounting application using visual basic and ms access.
then i use the crystal report 8.5 for report.
plz explain how to use the thousand seperator formula in number field.
like Rs.5,55,555.00
when i applied the thousand seperator formula
it should be displayed like this :
Rs 55,555,55.00
what can i do for these problem plz explain.
then one more doubt is there :
how to use the crystal report in asp page.
plz have u got any source plz send me.
thanks in advance.What is your desired output?
Rs 55,555,55.00 or 5,55,555.00?|||hi mathivanan!
i like the following format
indian currency format
Rs : 5,55,55,555.00
plz explain|||Create a formula having this code
StringVar Amt;
StringVar s;
NumberVar N;
Amt:=Replace(Totext({AmountField}),",","");
s:=left(Amt,len(Amt)-3);
N:=len(s);
Select N
case 4:
left(s,1)&","& right(s,3) & ".00"
case 5:
left(s,2)&","& right(s,3)& ".00"
case 6:
left(s,1)&","& mid(s,2,2) & "," & right(s,3)& ".00"
case 7:
left(s,2)&","& mid(s,3,2) & "," & right(s,3)& ".00"
case 8:
left(s,1)&","& mid(s,3,2) & "," & mid(s,6,2) & "," & right(s,3)& ".00"
case 9:
left(s,2)&","& mid(s,3,2) & "," & mid(s,6,2) & "," & right(s,3)& ".00"
default:
s;
and place it in the details section|||hi mathi!
when i am using the formula!
i got the error message
"The Formula Result Must be a Boolean"
here u also use ToText Function but its fired error.
what can i do for these problem plz explain.
StringVar Amt;
StringVar s;
NumberVar N;
Amt:=Replace(Totext({product_details.prod_price}),",","");
s:=left(Amt,len(Amt)-3);
N:=len(s);
Select N
case 4:
left(s,1)&","& right(s,3) & ".00"
case 5:
left(s,2)&","& right(s,3)& ".00"
case 6:
left(s,1)&","& mid(s,2,2) & "," & right(s,3)& ".00"
case 7:
left(s,2)&","& mid(s,3,2) & "," & right(s,3)& ".00"
case 8:
left(s,1)&","& mid(s,3,2) & "," & mid(s,6,2) & "," & right(s,3)& ".00"
case 9:
left(s,2)&","& mid(s,3,2) & "," & mid(s,6,2) & "," & right(s,3)& ".00"
default:s;|||It should work correctly
Check again whether you miss something in the code|||Hi MathiVanan!
your code is working properly!
thanking you.|||Well
How did you have problem initially?|||Hi Mathy!
actually i am applying the function to the price field object using
Field Object --> Format -->Number Format-->
Thousand Seperator -->Choose the Formula Editor
later i just create a new formula field and applying this code.
and then drag the formula field in my report page
it working properly.
thanks mathi!
muthu
Labels:
access,
accounting,
application,
basic,
crystal,
database,
developing,
explain,
hii,
microsoft,
mysql,
oracle,
plz,
report,
seperators,
server,
sql,
thousand,
visual
Friday, March 23, 2012
How to Use Suppressed Formula?
Hi!
i am devleoping a application using with visual basic and crystal reports 8.5. i would like to know
how to suppress the field value when the both entries are same?
like : table.filedname="January"
plz explain.Right click on the field
Select Format section
Goto Suppress option
There is button labelled x-2
Click that and write this
table.filedname="January"
i am devleoping a application using with visual basic and crystal reports 8.5. i would like to know
how to suppress the field value when the both entries are same?
like : table.filedname="January"
plz explain.Right click on the field
Select Format section
Goto Suppress option
There is button labelled x-2
Click that and write this
table.filedname="January"
Monday, March 19, 2012
How to use parameters
iam developing the crystal report there was small problem iam facing
please help me
How to use parameter of main report into the subreport
example
@.startdatetime is a parameter in main report
ia want to use the same parmeter in subreportcreate startdatetime parameter in subreport as well, then like it with main reports parameter.
i think i already suggested this to you.|||Thanks for reply
But we are getting six parameter while running the report
six parameters are
3 from sub reports(@.agencyid,@.startdatetime,@.Enddatetime)
3 from main reports(@.agencyid,@.startdatetime,@.Enddatetime)
while running the report it asking for
@.agencyid for subreport name
@.startdatetime for subreport name
@.Enddatetime for subreport name
@.agencyid
@.startdatetime
@.Enddatetime
but i requried only three parameter to be displayed to enter the values
please suggest me to solve the problem|||yes after linking it will ask only for main report parameters.|||You can make use of shared variables. Read it in help file
please help me
How to use parameter of main report into the subreport
example
@.startdatetime is a parameter in main report
ia want to use the same parmeter in subreportcreate startdatetime parameter in subreport as well, then like it with main reports parameter.
i think i already suggested this to you.|||Thanks for reply
But we are getting six parameter while running the report
six parameters are
3 from sub reports(@.agencyid,@.startdatetime,@.Enddatetime)
3 from main reports(@.agencyid,@.startdatetime,@.Enddatetime)
while running the report it asking for
@.agencyid for subreport name
@.startdatetime for subreport name
@.Enddatetime for subreport name
@.agencyid
@.startdatetime
@.Enddatetime
but i requried only three parameter to be displayed to enter the values
please suggest me to solve the problem|||yes after linking it will ask only for main report parameters.|||You can make use of shared variables. Read it in help file
Labels:
crystal,
database,
developing,
facingplease,
iam,
mehow,
microsoft,
mysql,
oracle,
parameter,
parameters,
report,
server,
sql
Wednesday, March 7, 2012
how to use designer environment in cystal report 11
I have used crystal report 8.5 in a vb6.0 project using designer activex environment. Now i have installed crystal report11. But 11 does not apear in the activex environment. Vb refrence also shows activex run time library missing.
Please help me !
note : - Crystal Report is really a mess!You need to use Report Viewer
Please help me !
note : - Crystal Report is really a mess!You need to use Report Viewer
How to use connectionproperties collection in c++
Crystal report 9 introduces a new feature:connectionproperties.
I find the Vb code using it
Dim Report As CRAXDRT.Report
' Open the report from a file
Set Report = Application.OpenReport("C:\Mytest.rpt")
' Provide database logon credentials (in this case
' for an OLEDB connection to a SQL Server database)
Dim tbl As CRAXDRT.DatabaseTable
Set tbl = Report.Database.Tables(1)
tbl.ConnectionProperties.Item("password")="mypass"
...
This works well in vb.But in Vc++,I can't find the collection.I add type library in stdafx.h
#import "craxdrt9.dll" no_namespace
...
IApplicationPtr pApplication;
pApplication.CreateInstance("CrystalRuntime.Application.9");
IReportPtr pReport;
pReport = pApplication->OpenReport("c:\mytest.rpt");
IDatabasePtr pDb;
pDb = pReport->Database;
IDatabaseTablePtr pDbTable;
pDbTable = pDb->Tables->GetItem(1);
I think I should reference connectionproperties collection through either pDb(Database object,as file "crystal report developers help.chm", chapter "Report Designer Component Object Model" showes) or pDbTable(DatabaseTable object,as Vb example showes).But I can't find the collection.
Does that mean the collection is only supported in vb.If not so,how to use.It's better give an example.
:confused:I'm sorry, I know nothing about VC++, but I've found some VB examples of code on Crystal's Website:
http://support.businessobjects.com/search/advsearch.asp
If you look there, you might be able to find some VC++ references. You could also try an internet search engine such as www.google.com.
Good luck and sorry I couldn't be of any more help.
I find the Vb code using it
Dim Report As CRAXDRT.Report
' Open the report from a file
Set Report = Application.OpenReport("C:\Mytest.rpt")
' Provide database logon credentials (in this case
' for an OLEDB connection to a SQL Server database)
Dim tbl As CRAXDRT.DatabaseTable
Set tbl = Report.Database.Tables(1)
tbl.ConnectionProperties.Item("password")="mypass"
...
This works well in vb.But in Vc++,I can't find the collection.I add type library in stdafx.h
#import "craxdrt9.dll" no_namespace
...
IApplicationPtr pApplication;
pApplication.CreateInstance("CrystalRuntime.Application.9");
IReportPtr pReport;
pReport = pApplication->OpenReport("c:\mytest.rpt");
IDatabasePtr pDb;
pDb = pReport->Database;
IDatabaseTablePtr pDbTable;
pDbTable = pDb->Tables->GetItem(1);
I think I should reference connectionproperties collection through either pDb(Database object,as file "crystal report developers help.chm", chapter "Report Designer Component Object Model" showes) or pDbTable(DatabaseTable object,as Vb example showes).But I can't find the collection.
Does that mean the collection is only supported in vb.If not so,how to use.It's better give an example.
:confused:I'm sorry, I know nothing about VC++, but I've found some VB examples of code on Crystal's Website:
http://support.businessobjects.com/search/advsearch.asp
If you look there, you might be able to find some VC++ references. You could also try an internet search engine such as www.google.com.
Good luck and sorry I couldn't be of any more help.
Labels:
code,
collection,
connectionproperties,
craxdrt,
crystal,
database,
featureconnectionproperties,
introduces,
itdim,
microsoft,
mysql,
oracle,
report,
server,
sql
Subscribe to:
Posts (Atom)