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...
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...
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...
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'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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.