But how do I sort my list by this value before printing it out? I can't use this as part of my query. Is there a way to sort in CR after you have gotten your SQL results?
Thanks so much.
Hi,
I have a query that displays the following data in a CR:
map #
11B1-10
11B1-23
11B1-9
11B1-9A
11B1-9ZZ
I need to strip off the numeric part of the field that is after the "-" and sort. For example, I need to display the rows in the following order:
11B1-9
11B1-9A
11B1-9ZZ
11B1-10
11B1-23...
Thanks for the info! I am using CR 9.0.
I don't know if I explained it correctly above. My header will have one graphic and few fields that are filled in by fields passed in from a asp.net application. If I was using asp I could write the header in an include file and use the same include...
Hi,
Is there any way to use some type of include file to include a standard header on multiple reports? I have about 60 crystal reports that all use the same header (although there are dynamic fields in the header that are determined in each report). I have to update a graphic and next time I...
Hi,
I am taking over a project written in asp.net w/ vb code behind. It has crystal reports written in 9.0 (not the integrated cr ide). The reports are called from the vb code behind. I need to modify these and can't find a good reference or examples that show how to send in paramters and...
Hi,
I have a report that I run for several different clients. One client's graph will have a longer bar line for 50% than another client's graph with 80%. How do I get these lenghts to be consistant - like 100% is always 3 inches. Is there anything like that?
Thanks a lot!
Barb
Thanks everyone,
When I do this the chart option at the top of the page does not appear. I know what you mean though - if I go look at another chart and I click on the graph I get a "Chart" tab at the top of the page. This one graph does not do that.
Barb
Hi,
I am changing a bar graph chart and when I right click I don't have a Chart Options option. I go from "Format Chart" to "Move->" on the right click menu. I am going crazy please help.
Thanks, Barb
Thanks so much for helping. When I right click on the chart I don't have the options:
"Chart Options" or "Auto-Arrange Chart" - my menu skips from "Format Chart" to "Move". I just looked at another Report with a bar graph and it has the "Chart Options" option. what could be wrong with my...
Thanks for helping. I am using CR9 and can't find:
Chart Options, Grid, Scales tab.
I go to Chart Expert and choose Options. I have the following choices:
Color chart
Data points
Legend
Customize settings
Transparent background
Marker size/shape
bar size
Am I looking in the wrong...
Hi,
I have a bar graph which is working perfectly. My values range from 16.05% to 53.02%. The y-axis ranges from 15% to 55%. My client wants the first value on the y-axis to start with 0. I have tried many things but can't figure out how to do this in the chart expert. Please help.
Thanks...
Thanks for all your posts. The database I am querying is missing some records and I happened to be connected at the time they were deleted. I wanted to make sure I hadn't accidently done it in CR. I definitley have a select and not a delete! Thanks again to everyone.
Hi, I am new to ASP.NET, but very familier with ASP and am trying to use dynamically created field names. For example, I have a database with survey questions. I dynamically generate the form field names. (question1, question2 etc.) I can't figure out how to access them. In old asp you could...
Hi, I know I must be doing something stupid. I am using 8.5 and am trying to use a pie chart to chart running total values. I display the running total values and then chart them. The values are ever so slightly off. For example:
runtotvalues %(i figured) This val the pie chart shows...
Hi, I know I must be doing something stupid. I am using 8.5 and am trying to use a pie chart to chart running total values. I display the running total values and then chart them. The values are ever so slightly off. For example:
runtotvalues %(i figured) This val the pie chart shows...
Thank you so much. I have been struggling with this for a long time. It works perfectly. I didn't know you could use a subquery in this way. I have only used them with IN or EXISTS etc. If I want to search for info in my database book or on the internet what would I search under? Is it a...
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.