Search results for query: *

Thanks, that article was more than enough info for me.

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?

Is there anything like this included with CE 10? I thought you could do scheduling/exporting/e-mailing with that? Would an option be to create and save the report for each parameter then schedule them individually?

That's not the part I'm worried about. I CAN double click on the graph....because I'm actually double clicking on the whole subreport. I just want to know if I can skip a level so they don't have to double click on the graph (on the subreport) then double click on "drill down" to get to the data.

yes, I meant group footer. sorry. the group header field to drill down on is the Company Name. Since my main report actually contains multiple subreports for the same company....they don't want to see the comapny name next to evert graph. So I can't just place the field there. My interim...

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

Yes I did. I wrote in my original post that I had already limited it to one day. After that I tried also limiting to one company. Neither seems to speed it up much. I think there must be something really wrong with the query forit to be taking this long. I may hold off a while until that can...

SV: You're right about the preview sample. I changed it to 100 records...but stopped waiting after 5 minutes. I'll have to see if we can setup a development database. Thanks for all of the tips.

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

thanks! That was fast!

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

Thanks for the suggestion, but we're trying to stay away from adding another application to the mix. Anyone have a suggestion to access the data as is?

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

anyone know how to set logon info for two datasources in one report? one is SQL, one is Oracle. Using the above method, it's no problem for either server when I am only using one datasource, but some of my reports require both. I am using c#.net.

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

Thanks, that worked just fine.

I found the solution... To use Basic Syntax to create a manual running total, create three formulas similar to the following: FORMULA 1: @Rtotal1 (in header) 'This formula initializes and resets '(if necessary) the running total variable Shared x as number x = 0 formula = x FORMULA 2...

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