Search results for query: *

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

Did you ever figure out what was going on - I have this problem as well.

Hi, I just don't have the "Chart options" or "Auto arrange" inbetween Format Chart and Move. It is wierd other charts do have this...

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

I am using CR9. When I left click outside of the chart box I don't get any menu. Thanks for helping!

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.

CR 9 doesn't have the ability to delete records does it? What if you use a command?

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...