-1
голосов
1ответов
649 просмотров

how to (count all record)/2 in Crystal Report?

how to (count all record)/2 and show the result in the report - in Crystal Report ? (working in C#) thank's in advance

1
голосов
1ответов
1328 просмотров

how to make line after 2 rows in crystal report?

how to make line after 2 rows in crystal report ? ex: aaaaaa bbbbbb cccccc ddddddd (working in C#) thank's in advance

0
голосов
1ответов
918 просмотров

Crystal Reports Server 2008 - How do you create a APS Logon Token programmatically in .Net

Could some one guide me to create a APS logon token in .Net programmatically? I need to use this token for URL reporting....

1
голосов
2ответов
3802 просмотров

How to display a total of time values?

Using Crystal Report 8.5 In Crystal report time column values are String. I display a record order by person id. Like this. Personid Intime Outtime 001 08:00:00 17:00:00 001 14:00:00 22:00:00 002 07:00:00 10:00:00 002 04:00:00 21:00:00 ..., From the above report i need a total of Intime, t...

0
голосов
1ответов
457 просмотров

Is it possible to make a TABLE PARAMETER in CR?

I would like to ask , is that got possible to change the table name just by using the TABLE PARAMETER setting? but the column name consists in the both table are the same. eg: table 1(dailyregistration) table 2(dayreg) P.S: both table got same column name, just the table name had change to (da...

1
голосов
3ответов
13995 просмотров

Crystal Reports: including a subreport into a grouping section?

I have a report which lists out a company detail. There are two sections to the company detail. The first portion lists out environmental data and the second is actually a subreport which lists out Cash flow details for every single year of the company. I have multiple companies i need to do th...

0
голосов
1ответов
1720 просмотров

How to Export a PDF using .NET and Oracle and Dynamic Parameters

I am having difficulties getting the following to export. I am running CR2008SP2 and ASP.NET 3.5 against an Oracle 10g database. If i do not set any of the parameters, then the page works great, and pumps out a pdf(well, except for the fact that because the parameters weren't specified, its not ...

8
голосов
5ответов
77194 просмотров

Passing parameters to crystal reports in C#

I've been trying to get this to work for a while, and all the example code I've seen aren't quite doing what I'm doing. I have a program that returns a pdf of a report that I pass a data table to. This works fine, except I would like to pass it a couple of other parameters (the date range of the...

0
голосов
1ответов
746 просмотров

How to Assign 2 different PARAMETER in crystal report?

select (distributor_code+ '-' +master_dealer_code+ '-' +state_code+ '-' +dealer_code) as agent_code, agent_type, company,contact_person, status, created_date as date, (CASE WHEN contact_mobile_no IS NOT NULL THEN contact_mobile_no WHEN contact_mobile_no IS NULL and contact_office_no IS NOT NU...

0
голосов
2ответов
7283 просмотров

How to dynamically assign report and connectioninfo to crystal report

I am completely lost on this one-- I have a .Rpt file that runs fine by itself. This report file takes 4 parameters and connects to an oracle database. I have all the database code set up correctly. So i think. I cannot for the life of me connect this report file to the connection and have the ...

0
голосов
2ответов
1008 просмотров

Setting report to current date

I have a report where it shows meetings and their requirements. However i just want the report to show ONLY today's stuff--not the entire week's worth. I tried setting my group header (i'm grouping by day) to currentdate but yet it still shows me the entire week. I then have to go to the groupi...

6
голосов
1ответов
12790 просмотров

Crystal Reports Error: The Maximum Report Processing Jobs Limit

On my web server, which is running Crystal Reports 2008 SP2 I've been getting the error "The maximum report processing jobs limit configured by your system administrator has been reached." Having researched the topic online i came across a fix in which if you alter a registry value, specificall...

1
голосов
1ответов
5583 просмотров

Crystal Reports in ASP.NET3.5

I am trying to add crystal report viewer in ASP.NET 3.5 application, but its giving me this error. The type 'CrystalDecisions.Enterprise.EnterpriseSession' is defined in an assembly that is not referenced. You must add a reference to assembly 'CrystalDecisions.Enterprise.Framework, Version=10.5...

2
голосов
4ответов
2307 просмотров

Flatten data inside a crystal report

Ok, this might be a weird request, but is it possible to essentially flatten my dataset inside a crystal report? I have a datatable in C# that was created with a join, so when it hits the report its 2 records. Most of the columns have identical data, with the last few displaying a different addr...

0
голосов
1ответов
340 просмотров

Crystal Reports; Last Accessed

How do I determine when a crystal report was last run?

0
голосов
2ответов
745 просмотров

Crystal Report --Missing number

I have a list of numbers and I want to somehow know if there is a number missing.

1
голосов
2ответов
6254 просмотров

vb2005 crystal reports : Name 'CrystalReportViewer1' is not declared error

I'm running through this tutorial found here: http://vb.net-informations.com/crystal-report/vb.net_crystal_report_from_multiple_tables.htm which teaches how to pass a parameter text field on a vb form to an embedded Crystal Report in visual studio. I've followed it all the way through however whe...

6
голосов
2ответов
2636 просмотров

Dynamically change XSD filepath in Crystal Reports

I have a crystal report that is based on an XSD schema file. Within the report definition, I can modify the datasource location, specifically, the file path. This is where I can set the file path to where the XSD schema file resides on my machine. At this point, everything works correctly. He...

0
голосов
1ответов
1531 просмотров

Crystal Reports Failing after upgrading app to VS2008\.NET 3.5

I'm in the process of upgrading an existing ASP.NET2.0 application to .NET3.5 (moving from VS2005 to 2008 - yes I know I'm late!) and have encountered a problem with Crystal Reports. Basically the following line of code causes the Webdev.WebServer.exe to close and the application to crash (I'm r...

0
голосов
2ответов
6422 просмотров

Suppressing Booleans on Crystal Reports

Simple question, yet i haven't found the answer. Anybody here know how to suppress a boolean field from displaying a "False" ? For example in my report, I have fields that say True or False...i'd rather just see a True and have crystal reports suppress the "False" Anybody know how to do that?

2
голосов
5ответов
17116 просмотров

Crystal Reports parameter selection limit?

I'm trying to make a Crystal Reports 11 report off an Oracle database that's grouped by user. I've got over one thousand users. I want to create a parameter field that prompts the person to select which users they would like to view the results for. However my parameter selection field is only...

0
голосов
3ответов
1225 просмотров

Suppressing information on Crystal Reports

I have the following fields in my report (I am running a report on meetings that occur at my company): Meeting start , meeting end , General/meeting title, general/host, booked by and finally a custom formula field that shows only IT requirements. Right now if i run the report, it shows me ever...

1
голосов
2ответов
3774 просмотров

Crystal reports in Delphi 2007

I have: Delphi 2007 Crystal 11 The Delphi 7 version of the Crystal VCL component (latest one I'm aware of, and it compiles fine in D2007) A very simple test Crystal report, written in Crystal 11, which just dumps a table onto the screen (no selection criteria, no formulas, just straight data)...

0
голосов
1ответов
1307 просмотров

ASP.NET crystal report parameters from query string not working

I am updating an existing reporting system in ASP.NET which uses crystal reports. In the past reports have been given their parameters by session variables, however I now have a need to post them in the web address e.g. www.mysite.com?reportname=myreport&year=2009 I have grabbed the parame...

0
голосов
1ответов
1442 просмотров

SQL Expressions in Crystal Reports

I am not at all familiar with SQL expressions and was hoping to get some help I have this: "Reservations"."NY IT Services/Computer Presentation" which is a boolean How would i write this to say "If "Reservations"."NY IT Services/Computer Presentation" is a 1, then display, else do not display? ...

0
голосов
1ответов
339 просмотров

Show Report group even when no records selected

I'm trying to show employees at a company grouped by worked and still working (in vs2005 crystal reports). The user can pass by parameter a list of companies they want to show. Tables: VRP-COMPANY, VRP-COMPANY-OPPORTUNITY, VRP-OPPORTUNITY-PRODUCT The record selection formula: {VRP-COMPANY.COMP...

0
голосов
1ответов
582 просмотров

Formatting Formulas by Code?

I have the following formula as the grouping for a Cross Tab Report: {Command.Year} & ' ' & {Command.RF Period} Year is a SmallInt and Period is a TinyInt. The problem is that it shows on the report as: 2,009.00 9.00 The database values are actually: 2009 9 I can't r...

2
голосов
1ответов
5674 просмотров

Export file as CSV in Crystal Report 11

Hi I am trying to export a report as CSV format from Crystal Reports 11, but the problem is that each string value is wrapped inside quotes, which I don't want. I tried to set the delimiter as space but it didn't works. Can someone please help me with this..? Here is my code: elseif ExportForma...

1
голосов
3ответов
9250 просмотров

Crystal Reports -- filtering data from a database

I have a crystal report that is connecting to a database. The datatable from which this information is coming from is rather large and I need to know how to filter information. I have a field in my report that needs a list of requirements. The datatable i'm pulling from has all these extraneou...

0
голосов
1ответов
959 просмотров

Programmatically move a FormulaFieldDefinition object

Given that FormulaFieldDefinition does not have a Top, Bottom, Left, or Right properties...is there any way to move/resize the formula at runtime?