Crystal Report

[Surrendermonkey]

Hi there - and congratulations on this thread - it's a credit to you.

If you could help me with this I'd appreciate it.

I'm attempting to pass two date parameter values to a report -more specifically, to each of three subreports over the url line.
I've tried prompt0=date(2001,11,01)&prompt1=D...etc

I've tried prompt0@subreport1=Date(2001,11,1)&prompt1@subreport1=Date(2001,11,30)&prompt..etc

I have the parameter fields unsuppressed and they are simply not picking up any values at all.

Do you have any relevant wisdom to share.

thanks man,

Surrendermonkey

Colon-Hyphen-Close-Bracket

[Aldo H.]

I need to printing one repport with many columns that don't fit in landscape orientantion, i need more than 1 page to print the report, how could i do to printing in multiple pages??? this is in VB6 and the crystal reports that comes with in, version 4.6.1 think so..... thanks

[cksiow]

I was just wondering how to I pass a VB variable to crystal report ?? thanks.




HTH

cksiow
http://vblib.virtualave.net - share our codes

[nageshpatil]

Hi..
How can reduce time to dispaly a crystal report
I mean to saycan U explainbest possible ways toreduce time .I know it depends on
no of records UR where conditions in sql.and UR machine configuration etc.
but is there some other ways by which one can reduce time to display a report
Nagesh Patil

[KokoLiso]

Hi,
I'm using CR7.0 with VB6.0 and I have problems with the installation program and the libraries I have to join. When I install my soft in a PC without CR, reports don't display. I've just achieved show them, but they aren't able to connect to data base. I think that some DLL's are missing, but I can't found them. I don't know which ones are the libraries that I need to install. Although there is a DLL that program requires but that DLL doesn't exist: 'pdssql.dll'

Please HEEEEELP!!!!

Thanks a lot.

KokoLiso --> choripene@hotmail.com

[dipesh2000]

i have find topics on RDC but i can't found much details.
Can u send me sample code for that to mail tpever2000@yahoo.com
Thanks for your support.

[brutus100]

Hi there!
I hope you might be able to help me
Here's the problem:
I have a form in Access,with a list box and a command button in it.
I putted a Crystal activeX, named Crystal1.
I can set the reportname variable equal to list boxes' value, so if the user selects a report and presses the command button, hecan see the specified report. My problem is that I want to use parameters, BUT I don't want user to opens the report's parameter field. I want set parameter values from a combo box in the form.
I would appreciate any help.
Thanks a lot
brutus

[K.Babu]

shiv kumar,

Can you send me a mail regarding, your previous crystal reports doubts, now i collecting overall general problem in crystal report for all programmers.

Thanks.

MailID: k_babs@hotmail.com

[K.Babu]

hi,

for example you want to print name = 'Raj'

' you should enter the single quote for string data type
cr.SelectionFormula = "{Employee.Name} = 'Raj'"

'you no need to enter single quote for numeric data type.
cr.SelectionFormula = "{Employee.RecNo} = 10001"

do your level best.
Babu

MailID: k_babs@hotmail.com

[shaikh_intekhab]

Hi,
I cannot see why i cannot see the report.
Private Sub Form_Load()

CRViewer1.EnableExportButton = True
Set webBroker = CreateObject("WebReportBroker.WebReportBroker")
Set webSource = CreateObject("WebReportSource.WebReportSource")
webSource.ReportSource = webBroker
webSource.URL = "http://www.pay-ware.com/documents/Ut...tall-guide.pdf"
'webSource.URL = "file:///C:\Documents and Settings\ishaikh\Desktop\Report2.rpt"
webSource.PromptOnRefresh = False

'webSource.AddParameter "user0"
CRViewer1.ReportSource = webSource
CRViewer1.ViewReport

End Sub



Please rate the article if it is of any use to you. This encourages me to reply more and more and more.

[stealbreeze]

Hello there.
I have a crystal report with several parameters. I want to pass a value to one of the paramters (or at least set the default value) but let the user enter the other parameters.

Any help will be appreciated.

[K.Babu]

hi,

create formulas names in crystal report design time.

eg. EmpName
EmpDesignation



vbcode:

cr.formulas(0) = "EmpName = 'Babu'"
cr.formulas(1) = "EmpDesignation = 'Programmer'"

if you had input variables use bellow code:

cr.formulas(0) = "EmpName = '" & svEmpname & "'"

K.Babu

[K.Babu]

Originally posted by stealbreeze
Hello there.
I have a crystal report with several parameters. I want to pass a value to one of the paramters (or at least set the default value) but let the user enter the other parameters.

Any help will be appreciated.

do you solve the problem?

[stealbreeze]

Hello,
Yes I was able to solve my problem. Thanks for your advice. I 'm sure to have more questions in the near future.

I have been using Crystal for a reporting tool for a few years. But I have just begun to incorporate it into VB programs.

Thanks

[pavankiran]

Is there any way to read the Item Values from the same section where i click.

Basically, I have a report which is grouped by a field in the recordset. I show also show a link which is an on demand subreport. Now when the user clicks on the subreport link i need to identify and read the Items in that section where he clicked as i need to do some processing for that item.

Any ideas would be of great help.
(Or any pointer to some good news groups about crystal reports can be better too.
PS: Codeguru guys, please don't get offended by this , Its 'coz of my urgency. )

Thanks,
kiran.