When the COM+ dll does not start automatically through a client activation (automation error on the client) I try to start it manually through the "component services" of the "control panel". But then I get the following error
=> "An error occured while processing the...
when i read the report.papersource (hp 4050) value I get 257 for tray 1, 259 for tray 2 and 15 for automatic selection. How come, because the normal values are:
crPRBinAuto 7
crPRBinCassette 14
crPRBinEnvelope 5
crPRBinEnvManual 6
crPRBinFormSource 15
crPRBinLargeCapacity 11
crPRBinLargeFmt...
I made the following :
I change the font in a combo box when the users "dropdowns" to "courrier". (because all the letters have the same width) But i want to change it again to the normal font when the user selects an item.
(i can't place it in the click event because...
ADO stored procedure question
I've already called a stored procedure with parameters and so on.
Now I have the following question:
Is it possible to give a recordset as input parameter (REF CURSOR) to a stored procedure?
Because i must select some data for a lot of id's (not always the same...
i made a report with a subreport.
* if i run that report with 20 records it works normal.
* But if i retreive 50 records and push the next button it crashes after 40 reports and i get the error message "not supported"
* if i delete the subreport and run the report without...
In the examples i find a lot of "CRX..." variable declarations in visual basic.
But I cannot declare those. Is there a special reference or so i must set ?!
Thank you !
I use a stored procedure => for example
select 'Hello' text1, personal.id text2 from personal where personal.name = 'Jos'
and i placed those fields in a text object (width= whole page => large enough)
And that works ...
When i change 'Hello' in the stored procedure to 'Hell' is still works...
I've tried to change the printer settings through visual basic
*****************************************
Report.PrinterSetup (0)
Report.PaperSource = 259
Call Report.PrintOut(false, 1, True, 1, 1)
-- this prints the report from the correct tray, but
-- the user gets a popup window that i don't...
I have a report with three sections:
section a, section b, section c
and let's say 3 elements.
Now CR prints
a1 * b1 * c1 * a2 * b2 * c2 * a3 * b3 * c3
what i would like to have is the following =>
a1 * a2 * a3 * b1 * b2 * b3 * c1 * c2 * c3
Thanks, Bart
I have a table who looks like this
****A**** ****B**** ****C****
20005454 abc 01
20005454 aqr 02
20005445 q 01
20001212 b1 01
20001212 baq 02
20001212 rst 03
i want a query that gives the following result (but each time in one row !!!!!!)
for...
What i do get is the name: (debugging mode)
?report.FormulaFields.Item(1).Name
{@amountofdata}
So the formula field excists !
What doesn't work
?report.FormulaFields.Item(1).value
=> gives empty value although when i show the report on the screen a value is printed !?
Does...
Is it possible that you can only have one parameter in a stored procedure you whish to call from crystal reports??
Because test2 is selectable from the stored procedures and test is NOT ??
Thanx, Bart
**************************************************
PROCEDURE TEST2 (QUERY OUT REFTYPE...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.