Search results for query: *

Been racking my brain over this one. I have a report that needs to print duplex when the data meets a certain condition. It also needs a "Page A of B" field. So, when there are 3 pages, a 4th blank page must generate, but I need page text to read : "Page 3 or 3" on the 3rd page instead of...

------------------------------------------------------------------------------- -- sp_UIHOEndorsements ------------------------------------------------------------------------------- IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[sp_UIHOEndorsements]') AND...

Have you done reporting off sp's that use results from embedded sp's? anyone know if database connectivity is enhanced in CR v.10 or v.11? This is very agitating.

I'm just selecting everything from the #temp table. it will only result in one row.

I have a stored procedure which executes another stored procedure and uses those results in the final dataset being returned by my stored proc. Using Crystal 9 Report Designer, the report stalls when trying to access this stored proc. Does CR 9 have a problem w/stored procs when they have...

I don't know if this issue has been covered here before, but I have a group that could print on one page or infinity pages. If the group finishes on an odd numbered page, I want to print an additional page with everything suppressed (page header/footer). If the group finishes on an even...

Why the hostility towards cursors and User defined functions? I use several functions as they are much cleaner and easier to debug.

Thanks for the ideas, all. Using a cursor was the easiest way for me to visualize this. I've heard bad news about using cursors, but this is just a simple fetch and read with not too many records. I don't think system performance will take a hit. I ended up using a simple identity function...

The building id will always be a unique id. the earlier post was just a simple count for display purposes.

Yes. The building id is a primary key.

Anyone else? Please.

I know. i jwant help writing the temp tables within my stored proc to do the count. or i believe it can be done with cursors, i just don't know how.

My feeble SQL skills have failed me on this one. I ned a row count on buildings per location to reset on a new location. Can this be done in MS SQL? Example: Location Building Row_Count 1 A 1 1 B 2 1 C 3 2 A 1 2 B 2

Our company currently uses Crystal 9 for report design and deploys over the web with ASP. Just trying to figure out the advantages of Crystal 10. Sometimes, client's machines will get bogged down due to the database drag of some larger reports and the 3 concurrent license issue. I've heard in...

That works. You are a bad ass. Thanks a million!

Need help with formula for array. For example: Given a string like this, "1;1500;3804^^0.757;2200;2880" I'd like to stuff 3804 and 2880 in the array and then sum those numbers. I want to split the string by the '^^' character, then split the element by the ';' and take the 3rd element. There...