Recent content by deborahyr

I can't get my subreports detail to print (export to excel) on the same line as my container report's detail. It displays correctly when I run it in Crystal but when I export it to Excel, the sub report detail prints on separate rows.

I am using Crystal 11. Yes, I was putting the subreport on same detail line as main report fields. I searched Shared Variables and tried following directions for creations but now can't get data to display in the variable fields. Main report formula is this - whileprintingrecords; shared...

I created a subreport for a couple fields that I inserted on my main report's detail. When I export the report to excel, the subreport prints on its own row instead of in the columns with other details - how can I get the subreport columns to stay and appear as columns with the main report?

I have SQL statements that I want to run using Crystal 2008 reports but once I view 'Show SQL Query' under Database Expert, there is no way to cut and paste my SQL statement into the report. Is this possible?

I have Crystal Reports 11.5 version 2.

Thanks for your quick response. I am still having trouble doing this. I click on Page Setup - select Paper Size and choose Custom Size - click No Printer button. Orientation = Landscape. Doing this does not widen the display area at all. Is there another area to set the actual page size to...

Need to do a data dump of a table that has over 100 fields and want them displayed in a single row within Crystal XI. How do I set my landscape to do this?

Ah ha! Got it - my record selection was off. Thank you so much!!!!!

Hmmm, I still seem to be missing something - this is not working or bringing back any data. Does the field itself have to be in certain type? My field is a String. This is what my sql looks like when entering stel in parameter field in running report... WHERE...

I'm trying to create a parameter that will allow the user to enter part of last name to do a search using a Crystal Report XI. How can I do this?

OMG! Thank you - you are a lifesaver!

We have a db that has memo fields in it that are in html format and we'd like to be able to display the memo field content without the html tags - can this be done in Crystal XI?

lbass, you are the greatest! It works!!! Thank you so so much!

I'm convinced this cannot be done based on responses and interpretation of my original issue. I only want to group by title when the title is the same as next title when sorted descending by datetime field. Example detail = 10/2009 Job3 Org99 9/2009 Job1 Org7 6/2007 Job1 Org3 1/2007 Job1...

Which is exactly what I did but the grouping on job title appears above the sort by datefield so it is doing the grouping first. I need to some how get it not to sort by job title first. How do I do this? The only way to get the datefield to sort first is to create a grouping by datefield in...