• Crystal Reports using SQL to create inner join

    I am new to Crsytal Reports. I want to join 2 tables using a formula, which I am trying to do in SQL. I created a simple test report and I can get it to work if I don't put any fields on the report from the joined table.  ie  -  if I just use fields from "sal-rep" the report works.  As soon as...

    Sparis5 pointsBadges:
  • how to perform a distinct count on a record over 2 sub reports

    hi all, i have a report returning list where it is grouped by city. it contains fields: ID (each record has unique id), serial(each client will have a serial to idenfy a person)group1 (A<B<C<D) and group2(A<B<C<D)and group date each client can have multiple entries based on how...

    N7865 pointsBadges:
  • Crystal Reports XI period in database name

    SQL Server 2005 database has a period in its name. For example, data.12. I call a crystal report from VS2008. I use ConnectionInfo object to pass connection info to a report. I get errors in formulas. Renaming DB resolves the issue. How can I get it to work with names like data.12?

    Fortuna35 pointsBadges:
  • Crystal Reports run time parameter problem

    Hi, I'm using Crystal Reports XI with a connection to MS SQL Server. I've created a SQL query in the 'Add Command' section for the report to run off which seems to work fine.  I've then added a couple of dynamic parameters on the report which again works fine. The problem I encountered was because...

    Darraca290 pointsBadges:
  • Crystal Reports grouping by multiple date fields

    Hi, I'm trying to sort two sub-reports chronologically. It doesn't work to create a group for each date, therefore I'm thinking I need to create a formula field in which to sort. what would the formula be?

    CrystalNewbie5 pointsBadges:
  • Crystal Reports 2008 Version 12 Viewer, whats the class name field and what to put there?

    In Crystal Reports 2008 version 12.  Im using the viewer to try and pull up the reports I created and designed to view outside of SAP Business 1, but im not sure what to put in the "class name" field. Can anyone help to what I should put there and the function of this field?

    Ricopersaud145 pointsBadges:
  • Crystal Reports XI formula problem

    Hi everyone,     It's been an while since I have used Crystal Reports and am having trouble with a formula... If paid by2/26/2011  12:00:00AM is what I see when I run my program, I don't need the time, just the date. Here is the formula: "If paid by" & DateAdd...

    Kamim5 pointsBadges:
  • refresh crystal reports XI using vb6

    i am currentl developing a system using vb6 and crystal report, but i found out that crystal report doesn't refresh or automatically updated unless i close the  system. can u help me in my problem? please?

    Yin5 pointsBadges:
  • how to open crystal report in new window

    Hi, I m new in crystal report please help me, How to open a crystal report in new window but i want to pass parameter on parent window (web page)?

    Amitshukla60 pointsBadges:
  • Sort Crystal Reports detail data once to process then again to display

    I have a report in which I have to sort the details in a specific way in order to calculate summaries but for display purposes I want to sort in a different order. Is this possible in Crystal XI

    Jenibean11305 pointsBadges:
  • Crystal Reports XI – Duplicate input parameters

    I am creating a Report with the input parameter for all the sales representatives across multiple states. On the report input parameter the values listed are as follows: N/A User1 - CA User2 - CA User3 - CA N/A User1 - CO User2 - CO User3 - CO and so on. I am hard coding N/A as the default value...

    NaviIT5 pointsBadges:
  • Crystal Reports View

    I have a crystal report that shows appointments. I would like to be able to view only the AM schedule sometimes or only the PM schedule sometimes. How would I do this?

    Delam25 pointsBadges:
  • Crystal Reports XI – SQL table fields that fail all compare tests

    I have an SQL table with a field that Crystal XI displays as string 300, call it mytable.mystring. If I create a formula field (myformula) such as... if {mytable.mystring} = "test value" then 1 else 2 This is what happens during execution...  when the the preceding test is true, Crystal returns a...

    BTod45 pointsBadges:
  • Creating Crystal Reports delivery labels with different references

    Hi, We have a delivery label which is creating a reference number for each label. if isnull({BoxLabel.JobNo}) then "*WWPML0" + {BoxLabel.OrderNo} else "*WWPML0" + {BoxLabel.JobNo} + "*" This works fine. However we need to now amend this so that the reference number changes if there is more than one...

    Kwirky5 pointsBadges:
  • How to manual configure tomcat with crystal reports 11

    How to manual configure tomcat with crystal reports 11

    Deepanshu0035 pointsBadges:
  • String results are printing on multiple pages in Crystal Reports XI

    I am a new, non-programmer user of Crystal Reports XI.  I set up a custom invoice in Crystal Reports which works well when there is only one line item on the invoice.  However if I have a multi-line item invoice, each line item description (string) prints on a separate page. Does anyone know...

    New2Crystal5 pointsBadges:
  • Crystal report XI passsing value help?

    hi! i have a problem with passing values in crystal report from my application (delphi). what i need to know is how to pass a variable that has a data to crystal report. any help would be appreciated Regards, Happy

    Hapipee15 pointsBadges:
  • What are the most common errors that occur when creating report on crystal report xi by using oracle (SQL) query?

    what r the most common errors occurs when creating report on crystal report xi by using oracle (SQl) query.also plz suggest the solutions for thoes errors.

    Deb4u50 pointsBadges:
  • What does this Crystal Reports XI Formulas Error mean?

    To many arguments have been given to this function

    Gamblersgobroke75 pointsBadges:
  • Crystal Reports to SSRS

    There is a proposal to migrate existing CR(11) application to SSRS for speed of execution as well as more flexibilty. WE have JPEG2000 images in the database and these are neither getting rendered in Crystal Reports nor in SSRS. Any suggestions on how I can make these JPEG2000 images render in the...

    Mbdaniel5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following