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 IamaSherpa 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: *

  1. handle1134

    question about parameters crystal 8.5

    Regarding this post, i want to add this: I am using CR XI R2, and i am running the report from a Java application, using the given API. However, i can not update the ListOfValues of the dynamic parameter before running a new report. I hoped this was done automatically, but i can notice that...
  2. handle1134

    Problem updating dynamic parameters in Crystal Reports XI

    Hi I've read several posts that say Crystal Reports 10 does not support dynamic parameters, they don't get updated when the database does, and this feature is expected to be implemented in CR XI. I am using Crystal Reports XI, and i designed a report with a dynamic parameter. But refreshing...
  3. handle1134

    Dynamic parameters: update dropdown list in Cystal Reports XI

    Yes, it works fine in the designer. However, the application that manages the report, written using the Business Objects Platform Web Services Java API, can not refresh the dynamic parameter list of values from datasource. Are there some code samples that shows how to handle dynamic parameters...
  4. handle1134

    Dynamic parameters: update dropdown list in Cystal Reports XI

    CMC is the Central Management Console for the Crystal Reports Server, where you can manipulate (upload, schedule, run, modify settings or delete) a report that is hosted on this server. For example a link to my CMC is: http://192.168.1.68:8080/businessobjects/enterprise115/admin/en/admin.cwr...
  5. handle1134

    Dynamic parameters: update dropdown list in Cystal Reports XI

    I have defined the parameter as dynamic and also configured the query to select the values for this parameter. It seems to work fine when running the report from CMC. The problem is when trying to get the list of values for that parameter using Java Web Services API. I tried to use...
  6. handle1134

    Dynamic parameters: update dropdown list in Cystal Reports XI

    Hi I've read several posts that say Crystal Reports 10 does not support dynamic parameters, they don't get updated when the database does, and this feature is expected to be implemented in CR XI. I am using Crystal Reports XI, and i designed a report with a dynamic parameter. But refreshing...
  7. handle1134

    Link between a UserGroup and a Folder

    I am using WebServices for CR Server XI Release2. I managed to create a new UserGroup and a new Folder using WebServices SDK but I do not know how to add 'Full Control' rights on the newly created group, for the newly created UserGroup. I've added 'Ful Control' rights from the CR Server. After...
  8. handle1134

    "Page -1 of 1" ?! - problem paging when export to CSV

    Hi I use Crystal Reports XI R2 to design a report, witch I need to export in 3 formats, Excel, Pdf and Character Separated Values (CSV). I use the special field (from the Field Explorer), "Page N of M" in the Page Header, for page numbering. It works fine in the Pdf and Excel format, but the...
  9. handle1134

    Changed the schema and got a Record Selection folmula error

    (I dont use SQL+, forgot to mention, sorry.) I use Crystal Reports XI 2 for report design, and a JDBC connector to a Oracle 10g database. Using the Bussines Objects API, I try to schedule some reports, but it looks like the database schema is hardcoded in the .rpt file. The only way I can...
  10. handle1134

    Changed the schema and got a Record Selection folmula error

    I use Crystal reports XI 2, and a JDBC conector to a Oracle 10g database. Here is the JDBC tag of my CRConfig.xml : <JDBC> <CacheRowSetSize>100</CacheRowSetSize> <JDBCURL>jdbcracle:thin:@192.168.1.42:1521:gemini</JDBCURL> <JDBCClassName>oracle.jdbc.driver.OracleDriver</JDBCClassName>...
  11. handle1134

    Changed the schema and got a Record Selection folmula error

    Hi I created in a paralel schema the same table for my report, having the same columns. When I run this report I get a "Failed" status with a reason: Error in formula <Record Selection>. '...' This field name is not known. Details: errorKind I have 20 fields in my formula, and it doesnt say...
  12. handle1134

    Changed the schema and got a Record Selection folmula error

    Hi I created in a paralel schema the same table for my report, having the same columns. When I run this report I get a "Failed" status with a reason: Error in formula <Record Selection>. '...' This field name is not known. Details: errorKind I have 20 fields in my formula, and it doesnt say...
  13. handle1134

    Exporting report to CSV in Crystal Report XI - too many headers

    I mentioned Excel because I use it to see if the csv file displays corectly. The CSV format is required by the report specifications. The problem is that the csv file generated by Excel (I export first to Excel, xls format, and after that save as csv file) is not the same with the csv exported...
  14. handle1134

    Exporting report to CSV in Crystal Report XI - too many headers

    Hi When I export in CSV format (read with Excel), from Crystal Reports XI (11.5) I get the Report Header and Page Header for every record. ReportHeader, PageHeader, "Column1", "Column2", "Value11", "Value12" ReportHeader, PageHeader, "Column1", "Column2", "Value21", "Value22" ReportHeader...
  15. handle1134

    How to set a background color in Crystal Reports XI

    Hi I use Crystal Reports XI to make a report that should be a yellow, as backgroud. Then the report must be exported to a Excel sheet, that should keep this color. I tried to add a image the size of the report and send it to back. But in Excel, the image is moved to the begining or the end of...
  16. handle1134

    How do you find out the children of a recurring instance

    I am trying to find out the instance objects for a recurring instance. Suppose that we have two recurring instances for a given report: one that executes DAILY and one that executes WEEKLY. After two weeks from scheduling these 2 instances, we will have 14 instance objects for the DAILY one...
  17. handle1134

    Can &quot;Total&quot; column be divided into subsections as the rest of columns?

    Ok, this will probabily work. But I already use multiple summarized fields, vertical. And I need it to stay that way. The summarized fields must be evluated both in 2005 and 2006. If only summarized fields could be displayed both on horizontal and vertical...
  18. handle1134

    Can &quot;Total&quot; column be divided into subsections as the rest of columns?

    Ok, the 'alias' ideea sounds good. You said to put it as a separate category, and that can be split by date. But what do you mean a separate category? Here is how I calculate the country of the record. I have a table with a field 'ID' witch is a number. And in the crosstab, a column with a...
  19. handle1134

    Can &quot;Total&quot; column be divided into subsections as the rest of columns?

    Hello again :) The top (columns) of my crosstab looks like this: Total USA Mexico Canada 2006 2005 2006 2005 2006 2005 Notice that the total is not divided for 2006 and 2005, just the total value. It should be like this: Total USA...
  20. handle1134

    SELECT in SQL Expression Field

    OK, that's it. Works fine now, 10x !!!

Part and Inventory Search

Back
Top