Search results for query: *

I'm just starting to wrap my mind around application programming from the OO perspective. I've been asked to attempt to design and implement a small web application based on OO prinicipal. All previous development was completed by a third party group of programmers who chose to not include a...

keyser-- What programming language are you using? If you're using C#, thers is an adapted version of the GoF Design Patterns book which I recently purchased, Design Patterns in C# by Metsker. Also, Beginning C# Objects has been a good tutorial for me as I have recently focused on learning OO...

Yes, I've verified the database. Have you created reports supported by dynamic sql statements within SPs? It seems since the sql statement is dynamic crystal can't tell which fields are available at design time. Does this make sense? Any ideas how to get around this issue? OJ DB/.Net/CR Developer

Getting worse, switched to ODBC connection and now stored procedure is not pulling any data. Not sure what is going on. OJ DB/.Net/CR Developer

Has anyone else ran into the issue of all fields returned by the query datasource not showing up under the datasource name in the field explorer? My report is supported by a stored procedure which is running a dynamic sql statment. Using CR9 Dev. and SQL Server 2000. Any info. is appreciated...

I did read your previous post. However, I've done what you have written. Everytime I add my other parameter, after crystal has automatically added the SP parameters, and add the other parameter to the selection formula I get a Failed to Open Rowset error. When I delete the selection formula with...

So, this is not possible unless using the push model?? This can't be accomplished when designing the report CR 9 Developer? OJ DB/.Net/CR Developer

Using, CR 9.0 Developer and SQL Server 2000. Is it possible to use an SP as the source for my report, and then add another parameter that does not get passed to the SP? Instead, the parameter values are used in a selection formula against the result set retrieved via the SP. Trying to prevent...

We've recently upgraded our IIS server to Win2K3. Prior to this upgrade all our crystal reports stored in our production website folder could be opened without problem from within our asp.net app. However, since the upgrade we are now getting the following error when attempting to run some of...

Using CR9 Developer I've been unable to create and ODBC connection that works. It seems that setting up an ODBC connection in CR9 is a little bit different than it was in CR 8.5. I have some old reports that were originally created in 8.5 with ODBC connections that have been saved as 9 files and...

We've recently upgraded our IIS server to Win2K3. Prior to this upgrade all our crystal reports stored in our production website folder could be opened without problem from within our asp.net app. However, since the upgrade we are now getting the following error when attempting to run some of...

I have some CR9 reports that I'm trying to export from my an asp.net application written using C#. I have exported these reports using all the export formats, doc, rtf, pdf, and xls, successfully. However, I am now trying to export some of these using the HTML40 format. I'm able to successfully...

Dave-- I'm not familiar with ColdFusion syntax but your SELECT statement may work if you turn it into a dynamic sql string and then execute you the string against sql server. I would try storing the following in a string variable and execute it against the server using EXEC: string specials =...

LB, thanks for the info. OJ DB/.Net/CR Developer

I need to create a report formatted as follows: Client 9/24 9/25 9/26 9/27 9/28 9/29 9/30 1111 A A P P ND ND A 2333 P P P P ND ND A Basically pulling data for each client and their attendance status for each day of class during the report period...

I guess I wasn't clear in my description. I'm trying to limit records counted within a chart. I've found that it only allows me to set up a summary operation on a field but not use any type of formula filter within the chart. OJ DB/.Net/CR Developer

The subreport option worked, but if anyone knows how to accomplish this without a subreport feel free to enlighten me. oj OJ DB/.Net/CR Developer

I'm using CR9. Is it possible to set the summary operation to only count certain records rather than every record. For instance, on change of month I would like to show the count of the records that occurred during the month, but I only want to include a record in the total count if a certain...

It would be very easy to do something like this in crystal: Monitors IBM($60*) NEC($50) DELL($40) COMPAQ($30) Mouses DELL($2) IBM($1.8) COMPAQ($1) NEC($0.5) You would just insert a group with ItemID Or ItemName as the group field. Then add vendor price as a Sort...

I wouldn't use SELECT * within the EXISTS clause. The WHERE clause within the SELECT statement of the EXISTS clause is the important part. OJ DB/.Net/CR Developer