I am trying to pass parameters from the URL to the .rpt file. What I have is a coldfusion page in which the users put in a date range. I want to pass those 2 parameters to my Crystal Report. I can't seem to find any good documentation on how to pass parameter in. can anyone point me to some...
This is more of a question than a problem. Currently, I am pretty much getting the data I need for my chart, but I am curious to why the "Don't Summarize values" checkbox is still disabled.
I am using CR 8.5. I am using a stacked line graph in the advanced layout. I am doing the...
Thank you for the offer. I solved the problem at the source...I changed the varchar fields to numeric and it appears to be doing what I need it to do right now. Thanks so much everyone for your help!!
Have a great day!
Ok, this is what I have
tonumber({database.fieldname})
and it STILL is giving me 0.00
Am I supposed to be doing something else in the the formula editor? Am I supposed to be declaring something?
Again, thank you for all your help! Hopefully I will get this soon!
I took the quotes out and I am still getting the same result.
val({database.fieldname})
It still comes up as all 0.00
Any other suggestions?
Thanks for you help!
Version of CR 8.5
Per Ken's suggestion (thank you so much!!!) I am trying to convert a varchar field (CR says its a string field, and the values in these fields are purely numeric). However, I can't seem to get the val function to work for me.
Here is what I am doing (found this in the CR...
Ok the report has 8 fields.
territory 1 total
territory 2 total
territory 3 total
territory 4 total
territory 5 total
territory 6 total
territory grand total
Date
All totals are calculated before they are insterted into the SQL table. CR just uses a simple select query to retrieve...
Thank you for responding.
I am using CR 8.5.
I am trying to use the value from my report field (retrieved from a SQL query). I am not doing any type grouping.
The data type for one of the fields is date/time (I want these values to be along the bottom axis of the line graph) and the other...
I am trying to implement a chart in a report. I am trying to do a line graph using the "On Change Of" method. However, when I put in my Show values, it automatically makes me calculate using the count method when in fact, I just want to use the value of the field. The Don't...
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.