Hi rjohn
Thanks for your prompt reply. I already replaced the @String with @List.
Just one last question, can you provide a sample how to use this? :-)
I'm still kinda new with UDF in MSSQL. Can you relate it with the example I mentioned above. A basic query showing how to use this syntax...
Hi there,
I'm quite new in MSSQL. I'm having problems creating my
custom query in MSSQL syntax.
Background: I need to separate the string value of one field into separate columns. See example below.
OriginalField
TRUE,FALSE,Victoria,Phone,"Application Today",...
I need to create a query...
Hi there,
I'm using Crystal Reports 8.5. I have a report wherein users can drilldown the crystal report for more info. I'm having problems with my report format (aesthetics) reg. drilldowns.
Question: Is there a field or function that will tell me if I am on a drilldown page or if I am on the...
Hi there,
I'm currently creating a stored procedure. I would like to group my data by hour. Not sure which command to use.
My database source looks like the example below:
10/01/2005 01:25 Tom 10
10/01/2005 01:25 Tom 15
10/01/2005 01:30 John 25
10/01/2005 02:30 Tom...
Hi dgillz,
I get this error in Crystal Report 8.5 when I tried to add the stored procedure in my report.
Like I mentioned earlier, I do not get this error when I am using Crystal Reports 9. Also I have tested the stored procedure in SQL Query Analyzer and it works fine.
Any ideas? Thanks...
Hi there,
I am using Crystal Reports Dev 8.5 and the database I am using is MSSQL 2000 with SP3. I have created several stored procedures which I would use in my crystal reports.
Now when I try to access the stored procedures in Crystal Reports, I get an error "Syntax error or access...
Hi,
I'm not familar with all the Crystal math functions, just would like to know if there is a Hex to Decimal function (converter) that I can use in Crystal Reports?
Currently working on reports where I need to display raw values (Hex) in Decimal form. Thanks in advance.
Regards,
Chris
Hi,
I am using CR 9.0. I'm currently using bar charts to present my data. My data consist of dates vs sum of a particular field. They DB look similar like below:
Field1 Field2
10/01/04 102
10/02/04 346
10/03/04 223
...
11/01/04 987
11/02/04 214
11/03/04 567
...etc.
Everyday there...
Hi,
Just would want to ask how can I put in formula the start date and end date of my report based from the database fields (datetime)? Not sure if its OnFirstRecord function?
Basically I'm in charge of doing the reports only. I have no control over the database fields. My report consists of a...
Hi,
Currently I have created two groups (Date and Names) in Crystal Reports. My reports look like the ones below:
10/24/2004
John Doe
Lisa Marie
John Preston
etc.
10/25/2004
Erwin Days
Selvis Richmond
Welwin Darrack
etc.
I would like to achieve the above with the...
jacob200,
You can try to generate by creating an Address group first in nPOVisualizer. Specify the IP address you want in Address Groupings. You can actually add additional IP address in every group.
Then generate the Traffic Analysis Report from Custom reports. Choose the group you created...
Well I have resolved my problem by creating another "time period" table like what synapsevampire suggested. I have created two tables, "per hour" and "per minute" tables.
I have joined my original tables with this new ones. I am now using the time fields in these...
Hi Sonny,
I'm not quite sure what you're asking. If you want to have trendlines in your report, there is an option in Crystal reports to set it up. See steps below.
1. Right click the graph (line chart for example),
2. Click Format Chart->Grid. Go to Group Axis tab.
3. In Labels tab, you can...
Hi,
We have posted our Crystal reports via Crystal Enterprise and currently using it in production.
Our main fear now is if ever we encounter any hardware failure (such as hard disk failure) in the future. We would want to restore the Crystal Enterpise as quickly as possible, with minimal...
Thanks for the tip.
I was just hoping that there is already a built-in function (running fields, crosstab, etc.)in crystal that would automatically do this for me :)
Well anyways, I'll just create a new table like what you suggested. Thanks again for this tip.
Regards,
Topy
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.