Search results for query: *

Sorry forgot again, using CR XI Professional and MS SQL 2005. I have Can Grow set to 3 (max I can put), but there can be fewer rows than 3 and those lines that don't have content show as blank lines. I'd like to eliminate the blanks. Thanks

Hi all, How can I vary the height of a memo field according to the content? Thanks for any suggestion.

Thanks, I did not know that I can update a command object without adding it to a repository. I searched the knowledge base and thats all I could find. How is it done? THX

Ok, can't use the command because I need to be able to update the datasource location and that can only be done by adding it to a repositry (which requires Businessobjects Ent.), can't do the view because i'm not allowed to mess with SQL server, so only option I have seems derived table. Don't...

MS SQL 2005 that is. I wish these posts were editable

I already posted the software and db. Crystal Reports XI and MS SQL. Are you not able to see my posts above?

I already included all the information above and yes I believe I do unterstand an outer join and no i do NOT want all the messages, I want ALL the parts (re-read what i posted above). This is not complicated. I have two tables, stock and messages. Messages contains notes for the entire system...

Thanks for your help lbass. Do you mean conditionally suppress the detail and add the formula there? When I do that I get an error "The formula result must be a boolean"

Ah well, that won't work. Let me clarify a little. The stock table and messages table are linked by a left outer join, so I want all the parts in the inventory, but only those messages related to a part that are flagged as 'ST' in the messages table. If I add {messages.doc_category} = 'ST' to...

Thanks for the fast answer guys, you guys are faster than the speed of light.

OOps, I think I posted in the wrong Crystal forum, I don't have BusinessObjects Enterprise (if thats what this forum is for). I have Crystal XI Professional.

Hi all, I could use some advice on the following: I have an inventory table and a related messages table, but the messages table stores messages from various places and the flag used to indicate where the message comes from is doc_category (in this case it would be 'ST' for stock). So my...

I meant the header "Price Breaks" the way I had outlined it above. It doesn't have to be on the side the way I have indicated, so your suggestion of adding another detail is what I should do. Thanks again, Anna

OOOps, not paying attention. Just one more thing, do have an idea how I can show the header: Price Breaks so it will only show once per detail? Thanks, Anna

Thank you so much for you response! I'm still a bit confused though. When I link the tables and I put the pricebreak.qty field on the report, then only those Quote line items that have a price break will actually show, so I don't understand suppressing when there is nothing there to suppress...

Formatting got a little messed up

Hi all, I am new to using Crystal and using Crystal 11. I have a lot of difficulty with something and hopefully someone can help. I have the following situation for the details section of my report: Quote No Part No Qty. Requested Unit Price 1 2xcyu 10...