Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: oj75
  • Content: Threads
  • Order by date
  1. oj75

    OO Design and DAO

    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...
  2. oj75

    Report supported by Dynamic sql

    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...
  3. oj75

    Passing Parameter Values to a Stored Procedure

    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...
  4. oj75

    Incorrect Logon Parameters

    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...
  5. oj75

    How to create ODBC connection

    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...
  6. oj75

    Incorrect Logon Parameters

    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...
  7. oj75

    CR9 Html Export

    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...
  8. oj75

    Can a Crosstab be used?

    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...
  9. oj75

    Chart Summary Option

    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...
  10. oj75

    crosstab grouped by rolling 12 month quarters

    how do I go about creating a crosstab report like the following: Type and Number of Infection Quarter UTI URI GI Skin January 2003 -March 2003 3 44 2 0 October 2002 - December 2002 10 2 1 4 July 2002 - september 2002...
  11. oj75

    Subreport Stored Procedure Issue

    I have a report that is supported by an SQL View db object.On the main report i have a parameter "ReportDate". I have a subreport which is supported by an SQL SPROC. The sproc has a ReportDate Parameter as well. Is their a way to pass the main report ReportDate value to the subreport...
  12. oj75

    Misaligned Field Text

    Has anyone ran into the problem with text labels and db field text not aligning correctly eventhough the fields themselves are aligned in the Crystal designer. I'm using CR9 Developer, TimesNewRoman 12pt. My labels show text in the center of the control, but my db field controls seem to shift...
  13. oj75

    Crystal Reports exported via ASP.Net App Issues

    Has anyone else ran into this problem. I am currently using CR 9.0. via an ASP.Net application. I am exporting various crystal reports to PDF and Excel. I am having two problems. 1)The excel exports are not allowing my text column headings or fields to grow. Even though the "Can...
  14. oj75

    Crystal Report Exporting Issue -Text cutting off

    Has anyone else ran into this problem. I am currently using CR 9.0. I am exporting various crystal reports to PDF and Excel. I am having two problems. 1)The excel exports are not allowing my text column headings or fields to grow. Even though the "Can Grow" option has been checked...
  15. oj75

    Creating New Sql Server Connection Problem

    I've created a new connection to an sql server and have successfully connected to the server. However, when I click on the (+)Tables icon all I can see is the following system tables : dbo.syssegments, dbo.sysconstraints, dbo.dtproperties. I am not able to see the database tables needed for my...
  16. oj75

    EM Script Possibility ??

    Is there any option within Enterprise Manager that will automate scripting of the changes made to the db structure during a given session? I would like to make structure changes through EM, and was hoping the EM had some way of tracking the changes I have made so that I don't have to do it...
  17. oj75

    Why doesn't CR allow Sureports within Subreports

    Are there any potential workarounds for this situation. I have a main report that needs to drilldown to subreport1 which in turn needs to drill down to subreports 2, 3, and 4. Finally, subreport4 needs to drill down to subreport 5. I should be able to get rid of subreport 1 by including all the...
  18. oj75

    ASP.Net Crystal Reporting References

    Could anyone recommend any books or other reference materials that cover interacting with and using crystal reports via ASP.net pages? thanks, oj
  19. oj75

    ASP.Net Crystal Reporting References

    Can anyone recommend books or other materials geared towards showing how to work with crystal reports in ASP.net pages? Thanks, OJ.
  20. oj75

    Sharing Main Report Parameter Input with Subreport

    I am selecting records on the main report based on 3 parameters. A number and two date parameters. I want to link a subreport to the main report based on a foreign key field in the main report. However, I want to select the records in the subreport based on the two date parameters stored in the...

Part and Inventory Search

Back
Top