Search results for query: *

Is it as easy as pointing to the datasource and going from there? I'd never even heard of Solomon until receiving a call about a contract position. I've done plenty of reporting with SQL and Oracle but not Solomon. Any issues to be aware of? Think any special skills beyond Crystal are necessary?

What's the best way to create a formula to show a message if no data is available? Is there something you can do with counting records or something? I'll be placing the formula on the report and suppress it if there is data available. Any suggestions?

I have a report (main report) that contains a subreport. The subreport has a graph in the footer...the graph is all I want to see on the main report. So I've hidden the group header and detail sections. I want to be able to double click on the graph in the main report and have it open the...

I have a report that takes about 15 minutes to return over 700,000 records. This obviously stinks for development whenever I add an additional field. The developers are working on the query to speed things up, but until then, is there a setting for Top N records or something that I can do so...

I have some text fields with data in all CAPS. Is there a formula I can use to convert them to lower case? Existing data: SEE THE CAT Convert to: See the cat I'm using CR 10

I've been asked to write a report that calls a table created by a stored proc. The stored proc deletes the old data in the table and replaces it with new data. Is there a way for me to do this? In the past, I've only worked with SPs that have parameters. I've connected to them directly like...

I have a report connected to two datasources. A SQL DB and an Oracle DB. I am using a C#.net app to run the reports. In other reports using the same datasources, just one at a time, I can add the logon info and the user never has to enter logon info. How do I do it for two datasources? Here is...

I have a report (using CR 9) that's bringing in all data for clients sorted by the highest balance. I want to be able to show on the report all clients if no parameter is entered, or show the top # clients (highest balance) based on the parameters entered. How do I accomplish this? By the...

I am trying to create a report that essentially performs like a bank statement. how do I make the balance field in the detail section change with each transaction? I'm using CR 9. I have the report grouped on TrnDate. The details have date, amount, and balance. I want the balance to be the...

I use the following formula in my report header to show the parameters entered: If {?chOrderDate} = false then "Order Date is between " + ToText({?dtpFromOrderDate}) + " and " + ToText({?dtpToOrderDate}) else "Order Date is NOT between " + ToText({?dtpFromOrderDate}) + " and " +...

I created a chart for count of a field on change of a date. The date is in the group (Y) axis. How do I format the labels? If I go to Chart Options/Grid I can select the format for the data axis on the Numbers tab. The Numbers tab is greyed out for the group axis. Any suggestions? Right...

I have created a chart in the footer of a group based on a date field. Right now it prints for every month for which there is data. I'd like to suppress all but the current month and the previous two. Any suggestion on the formula I should use in the Section Expert Suppress x+2 field? If...

I have created bar graph for # of orders per date, with a chart for each month being placed on the report. Right now the Group Axis is showing a label for each data point (order date). I would like to show every date of the month on this axis..whether or not there is an order for that date...

I currently have CE 9, but will be upgrading to 10 very soon. I have multiple reports that will be pulling from two databases. One is a SQL Server, the other is another application. Data from BOTH is necessary for most reports. Our idea was to create an xml file for each user request (the...

I'm trying to figure out if it's possible to create a report that uses dynamic XML as the datasource....without creating a system DSN. The format of the XML would be the same in every instance, but the data would be based on parameters requested by an end-user application (the parameters...

I am trying to figure out how to get a total count of groups in my report header. I have two groups (group1, group2). I want the count of group2 in my header. The only way I have managed to even get the count of group2 is by creating a running total. I can place this in the report footer and...

Is there a way to convert a field with a STRING data type to a number for sorting purposes? I need to sort ID numbers in ascending order. The problem is, the field is a string so I get the following when I sort: 10411 9028 9029 9696 9830 I want it to sort like this: 9028 9029 9696 9830 10411

I have a date/time field that I need to format so the date is on one line and the time is on the line below. with most fields I can do this by adjusting the field width/heighth...the text wraps. For some reason, the date time field does not wrap. One solution I have is to insert the field...

Is there a way to supress details based on an If, Then? I want to suppress the details based on a paramter entered, but there's a hitch. If the paramter is entered, I only want certain IDs suppressed, not all of them. I know I can put a formula in the Section Expert to suppress the details...

I'm having trouble formatting a line. I am inserting a line in the page header of a report in 8.5. All I am trying to do is insert a horizontal line and have the edges match up with two verticals lines on each side. It won't let me make it the exact length using the sizing handles. It's...