Help with Crystal Reports

Hi, ,am fairly new to crystal reports......pretty much new...

I have a simple report that is to be done......

I need to generate a report....with columns...emp_num,name,ssn

I pull up these columns thru sql server 2000 from Employee table...

The tricky part is here....

The report has to be in such a way that...

1.)First it prompts asking if u have ssn number with u ,if yes enter the ssn no., display the name and emp_num corresponding to that,

2.)IF NO...prompt the user asking for emp_num, if yes ,enter the emp_num ,display the name and ssn corresponding to that...

I've written a stored procedure for this, but this is taking only one value..while connecting to the crystal....

Plz help me on this.......I dont think you can prompt user this way
Are you calling the report from any front end?

Help with charts

Hi all,

i'm trying to replicate some functionality I have seen in crystal reports
10, Im hoping it is also possible in SSRS (2005). Any help or pointers would
be appreciated, im stuck!

Basically I want to create a basic bar chart from a dateset. If one of the
bars are clicked, I would like to re-render the chart with data specific to
that bar (this involves performing some further grouping and sorting on the
dataset). This framework needs to be repeated to 5 levels.

Now, I know i can create a hidden report parameter (or a set of them) and
then when the bar is clicked, send this information back to the report and
rerun the report, but this takes time, especially if they are going 5 levels
deep. Is there a better way?

I would like to have a set of charts on my report and hide/unhide them as
needed but pass some parameters between them when the bars are clicked, I
cant figure out how todo this though.

Please help, any advice appreciated!

Kind Regards
Taz

i think there is not any such feature available to support u r problem

but ya u can create five different reports and using "jump to reports" and passing the shown by that bar as parameter to next report

i dont think there is any other option for above problem

Help with charts

Hi all,

i'm trying to replicate some functionality I have seen in crystal reports
10, Im hoping it is also possible in SSRS (2005). Any help or pointers would
be appreciated, im stuck!

Basically I want to create a basic bar chart from a dateset. If one of the
bars are clicked, I would like to re-render the chart with data specific to
that bar (this involves performing some further grouping and sorting on the
dataset). This framework needs to be repeated to 5 levels.

Now, I know i can create a hidden report parameter (or a set of them) and
then when the bar is clicked, send this information back to the report and
rerun the report, but this takes time, especially if they are going 5 levels
deep. Is there a better way?

I would like to have a set of charts on my report and hide/unhide them as
needed but pass some parameters between them when the bars are clicked, I
cant figure out how todo this though.

Please help, any advice appreciated!

Kind Regards
Taz

i think there is not any such feature available to support u r problem

but ya u can create five different reports and using "jump to reports" and passing the shown by that bar as parameter to next report

i dont think there is any other option for above problem

sql

Help with breaking out codes in a crystal report

Has anyone ever had a scenario where a calculations was showing totals but you had to break that down to the actual codes making up those totals?

For instance on a report, I have by Office by Employee totals for Hours and Wages but need a calculation of some kind to break those out to the individual codes and totals. how can I do that? See example below:

Current Report:

Naples Office Hours Dollars HrsTot $Tot

Smith, Tom 40:00 $400.00 40:00 $400.00

Desired Report:

Naples Office REG OT SICK Bonus Comm HrsTot $Tot

Smith, Tom 10:00 2:00 1:00 $20 $10 14:00 $30That information has to be available in your datasource. If so, you can change your groupings and such to get the information, but you might need a subreport if you want to display both together (depending on how the aggregations are happening).

Help with "like" or "wildcard" during a parameter entry.

Disclaimer - I'm a novice when it comes to Crystal Reports as well as VB, and I am using Crystal Reports XI.

My trouble - I have a report that uses a parameter field to show a history of a whatever number is entered into the parameter when the report is accessed. I would like to add a "like" or "wildcard" to this parameter filed.

Example:

Parameter entered = ED35A100

The results are correct I get a history of the number ED35A100

However, I would like to enter the parameter = ED35*

and get results like ED35A100, ED35C100, ED35A200, etc.

Any help on how to accomplish this would be greatly appreciated.maybe this will work...lookslike({Fieldname},"*{?Parameter}*") then go to Report...Select Expert then choose the Fieldname then in the drop down key choose Is True

Help using custom VB6 Function in Crystal

I have a function for a date format in VB6 that converts to a Long Integer. I then use the opposing function below to convert to a readable date. Can anyone help me implement the function in Crystal 10.

Public Function fDateLong(plngDate As Long) ' Gets Date from DB format YYYYMMDD (DB date is Long) ,
Dim sDate, sYYYY, sMM, sDD As String
sDate = Trim(CStr(plngDate)) ' trim a Converted Long Date
sYYYY = Left(sDate, 4) ' get YYYY from left
sMM = Mid(sDate, 5, 2) 'get MM from middle
sDD = Right(sDate, 2) ' get DD from right
sDate = sMM & "/" & sDD & "/" & sYYYY ' reassemble
fDateLong = CDate(sDate) ' Convert to Date

End Function

Right now my date is reporting as " 20060612". Any help in implementing this function in Crystal would be appreciated.What is your expected output?|||I would like to take it from the DB format (long) 20060615 to a date format like either June 15 2006 or even 6-15-2006 (or 15-06-2006).

Thanks for you response.|||Create a formula having this code and drag that in the report

Numbervar y:=0;
Numbervar m:=0;
Numbervar da:=0;

y:=Tonumber(left(replace(totext(20060615 ),",",""),4));
m:=Tonumber(mid(replace(totext(20060615 ),",",""),5,2));
da:=Tonumber(mid(replace(totext(20060615 ),",",""),7,2));

monthname(m)+" "+totext(da,0)+ " "+replace(totext(y,0),",","")|||Madhi,
Appreciate the help but I still have no bloody where to put this?
Can you advise?|||As I told you create new formula. Put that code. Save it. Drag it to the details section|||Madhi,

Great stuff; problem solved.

Thanks very much

Help Supress line object in CrytalReports

How can I supress line objects in crystal report?Does nobody knows ?|||well.. u need to suppress with formula..

if not ..then its so easy to suppress..right click..format line... then click on suppress...

but ..if u need to suppress with a formula / or condition..

then try this.

insert a line into the new section..
i.e. if u want to print lilne in detail section..
insert a detail section other than main detail section...so this section will be detail - 2
and insert line in new detail section...so the section have only the line..
then suppress or unsuppress the whole section with the formula ..

might be helpful
zeeshan|||you can manipulate it in VB or suppress it in the cryatal report. in VB just type the name of your report and select the line then suppres it. but first you have to make a reference to your report...

dim myreportname as yourreportname
set myreportname = new yourreportname

myreportname.line1.suppress = false