Search results for query: *

I'd like to use the data in an Excel spreadsheet in SAS. One of the fields in my spreadsheet sometimes contains a comma. I'm not able to access SAS right now, but I'm being told that the comma will cause a problem when I bring the data into SAS. Is this true?

Excellent. Much more concise than my method. Thanks.

I have a table with a Start Date field and an End Date field. I want to see all records in that table where the range between the Start Date and End Date hit some or all of last month. For example, if this is my data: Record # Start Date End Date 1 10/3/2004 10/15/2004...

I likes it! That is the first way I tried doing it, but the reports need to be run at the same time every day, so I've scheduled the parent report. On demand won't work for me. I'm having a brain storm now, with no Crystal in sight. Perhaps I'll mess around with drilldown tomorrow, thereby...

Sheesh. Sorry. I'm using CR 8.5 to design the report, and I'm displaying on the web using VB and .NET. I have a main report which serves only as a way to deliver several reports to a user in one fell swoop. The sub-reports are completely separate, and in fact don't even report against the...

I have a main report with several subreports in it. Can I create a hyperlink to place in, say, the Report Header, that offers a link to one of the subreports? Let's say the third subreport is on pages 14 through 25 of the parent report. Can I place a link on page 1 that will take the user to...

The web export sample is handy, or rather would have been a few months ago when we were muddling our way through it. :) But when exporting to Excel, it only does a basic export, with no formatting options utilized. It's no biggie though, because exporting in .NET is very limited anyway.

Yeah, the export works fine in CR 8.5. I'll check out the samples though. Thanks again.

I designed the report in CR 8.5 orginally, but I created the same report in VS .NET 2003 with the same problematic result. The service pack didn't help, but thanks for the suggestion. Bummer.

Thanks for taking a shot, synapsevampire. This is actually happening in a .NET web application, so I don't have the comma delimited option, nor to I have access to the Excel Data Only option. Those are the ways I'd have handled this if I was using Enterprise, or even the old VB ASP solution...

I have a chart in a report. When I export to Excel in a .NET web application, the chart is missing. I see placeholders where the object would be, but no chart. Is there a setting I need to change? Any other advice? Thanks.

I'm exporting to Excel in a .NET application, and when Can Grow is turned on for a given field, and the data in that field is too large for the field, the resulting Excel document contains extra rows with no data in them. For example, if the Crystal version of a report looks like this: Column...

Doh! Ugh.

I get a "The remaining text does not appear to be a part of the formula" error with this code: WhilePrintingRecords; Global NumberVar Array x; Global NumberVar y; x := Split ("111.222.333.444", "."); y := x(1); The cursor ends up on the last line between the x and the open paren. What am I...

I'm particularly interested in any web or computer based training for CE 9. I can't view user profiles to get this kind of information here with this wacky new and improved *ahem* Tek Tips. If you provide super duper training, even if you don't provide any non-classroom solutions, please post...

Gracias.

I'm trying to limit the data in my report by using Group Selection criteria. I notice that the Group Selection criteria is being applied to the report when I preview it, but that the Group Tree does not reflect the Group Selection. In other words, I'm seeing all of my data source's groups in...

I have a question about this thread. If you need to re-establish a connection to the data source after clicking on the "export" button (in the code samples above), does that mean that the report is being run again? I want to be clear that my data from the original query is being exported, not...

I'm going to be implementing a CE 9 install soon. Do I need to install a java engine? Thanks.

I'd like a date range in my CR 8.5 selection criteria that is like LastFullWeek, but instead of Sunday to Saturday, I want Monday to Sunday. Instead of {date field} in LastFullWeek, I would use {date field} in [{start date} to {end date}]. So for example, if I run the report on...