Search results for query: *

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

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

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

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

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

HI, I am trying to create a report involving a left outer join. I couldn't figure it out in 8.5 so I finally upgraded to 9, but I still can't get it to work. Here is the situation: I have 3 tables with the following fields subscriber - each subscriber has one record subnum subname etc...

Hi, I need help figuring out the vb.net IDE. I am taking over an aspx w/ vb code behind project and I don't understand how to edit the form. When I try to add a label or anything the label jumps to the top left of the page and if I try to cursor down the label jumps to the bottom of the page...

Hi, I have a lot of html content in a database. I need to export the content to xml. I am trying to figure out if the data is usable in its current form. I can't figure out how to retain the html tags. For example: if my xml file looks like: <?xml version=&quot;1.0&quot...

Hi, I just took over support for a non-normalized database in Access. There are about 4 tables with many columns. ASP/VB .net is being used to access data and it is then sent to Crystal Reports to generate reports. The whole process is really slow. My question is: How much of a...

HI, I have been reading all the links about CR9 and the inability to compile and distribute, but before I buy one I want to make sure I completly understand. If I create a report in CR9 and compile it or do whatever with one of the 3rd party viewers then my user doesn't need anything installed...

Hi, I am trying to use Group record selection to narrow my results down to only those records whose sum of past due accounts + any adjustments > 25. The code in the Group record selection formula is as follows: - whileprintingrecords; - shared currencyvar adjAmt; - Sum ({@306090}...

Hi, I just started working w/ VB.NET and I am trying to run a query to select count(*). I am using access and have tried the query out on the dbase and get the correct results. My problem comes in when I try to access the field from VB.NET. CReader = Quart.ExecuteReader() TotalReporting(2)...

Hi, I am trying to supress duplicate data that I am getting from a one to many relationship. My supress x+2 formula checks for the existance of a previous value. For example, previous{(subid)} = {subid} Since this is the 1st record it seems like this would be false, but it is supressing the...

Hi, I am having trouble figuring out how to get the data I need. I have 2 tables - a deliquint account table and an adjustment table. The deliquint account table can have multiple rows for one account. The adjustment table may or may not have 1 row for a subscriber if there is an adjustment...

HI, I am having trouble with a query. I am selecting from 1 database. Equipment Table phone# equipcode I want all rows that have the same equipcode for one phone #. For example equipment table phone # equipcode 404-234-1232 DSL 404-234-1232 DSL 404-234-1232 XVU I should get...