VB Forum / Crystal Report / May 2006

How can I use a ref cursor procedure at crystal ?
Should it be procedure or function ?
if procedure - Is the first parameter is the ref cursor ?
Need sample code, please.

My data comes in like this:
ReportNumber
   4/10/2006   Bob Smith    1.00
   4/10/2006   Bob Smith    8.00

For eg if current time is 2:15pm and 45 seconds I want it to show as 141545
in the report.
Thank you for your assistance.
Sam Commar

I need to put the page number in the page footer section. The constrain:
the page number must be at 1cm from the bottom of the page for the odd
pages and at 3cm from the bottom on even pages.
How can I do it? I work on Crystal Report 9 and I've no solution for

I am new to crystal reports,
I am working in dot net 1.1
I can't work out how or where to set the page layout or
margins. I am bumbling around looking for a likely

I need to be able to have a total of overtime hours, per week, per person.
Right now, my data comes in in such a ways that forces me to summarize the
amount of hours a person works per day (dailyHours). if that total is more
than 8, I figure out the overtime (overTime). I need to ...

          I got a report with Detail section in main report. And I got
subreport in Report footer. The problem is Crystal report will open a
new page for the subreport. But I just want the subreport to follow the
data in detail section line by line immediately without opening a new

          I got two Subreport. When the Subreport is shown. The
pageheader text from pageheader
will appear in the Subreport. I do not want the pageheader text appear
in Subreport. How can I do

we have many parameters in a report but we want them optional.
This means that user can enter a parameter or not.
For this purpose we have put some record selection if-then else's
like

I tried to bind a dataset to a crystal report(Windows form) at runtime
as follows:
Dim obj as crystalreport1
obj.setdatasource(ds.tables(0))

i created a report definition for a report that isn't working correctly to
see if i could figure out what the problem is.
what is noticed is that the word "weekly" is associated with the groups.
i created the report using the standard report wizard.

This is my first time to attempt a subreport and I was able to create it with
no problems (I think).  I am able to see the subreport when I preview it, but
when I run my report, I get nothing.  The page is blank.  I have no filters
on it at the moment so that's not it.  This is an ...

Sometimes I feel like using Crystal Reports is like pushing a car
uphill when it's emergency brake is on.
I have a report with several subreports.  In some of the subreports I
have a formula like:

I need to calculate overtime per day.  How do I go about it?  Basically, if
a person spent more than 8 hours per day, I need to subtract 8 hours from
the day's total.  Then, the amount that was subtracted has more math on it.
My data comes out like this:

I may be tired and just thinking about this the right way, so I am turning
to the NG's for help....
I have a database with visitors to a center. Although they login in one
table, there is another table that captures each visit.