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 Chriss Miller 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: TedLiu
  • Content: Threads
  • Order by date
  1. TedLiu

    Print array problem in crystal report

    Hi, I'm using CR10 and CE10. I have a simple array to get summary data, but the way it display on report seems different with regular numeric data. e.g. My numeric data should display as below: 100 0 100- My Array formula: StringVar Array Split_LossPaid := [100, 0...
  2. TedLiu

    Retrieve DB detail from CE CI_INFOOBJECTS

    Hi, I'm working with CR & CE10 with Oracle 9i. My questions is if it's possible to retrieve Report Data Source (table or StoredProcedure) field information from CE DB objects, which I mean CI_INFOOBJECTS. We have around 300 Crystal Reports either convert or newly developed to work on CE10, for...
  3. TedLiu

    Batch update Crystal reports in Crystal Enterprise

    Hi, I'm using CR10 and CE10. We have more than 100 reports in CE10 need to be tested in the UAT stage, the reports are currently pointing to DEV database . The administrator complained about that seems too much job and time consuming for him to update report database access information to...
  4. TedLiu

    CR 10, questions about report grouping summary

    Hi, I'm working with Oracle 9i and CR 10. I have a report need to display data as below: detail: 1st QTR : Num1, Num2 2nd QTR : Num3, Num4 3nd QTR : Num5, Num6 group1: 1st QTR : sum(Num1), sum(Num2) 2nd QTR : sum(Num3), sum(Num4) 3nd QTR : sum(Num5), sum(Num6) group2: 1st QTR : sum(Num1)...
  5. TedLiu

    Internal Error when Scheduling report in CE 10

    Hi, I'm using CR & CE 10 against Oracle 9i. I have a report against a oracle procedure and inside a subreport against a table. Everything works fine against a default database except when you try to schedule it on CE base on a mapped data source, I was able to map the procedure and table to a...
  6. TedLiu

    Crystal Enterprise 10 Oracle Procedure data source mapping issue

    Hi, I'm working with CR10, CE10 with Oracle 9i. I got a problem in deploy reports in remote Client CE10 server. In my testing stage, I was able to perform specify table schema name in order for reports to switch between different schema of same data source in runtime. When those reports were...
  7. TedLiu

    Change Oracle Schema in Crystal Report 10 in SQL Expression

    Hi, I'm working with CR10 and CE10. I got something weird and seems no clue how to do it, I was able to change data source through CE 10 CMC interface when test scheduling. My problem is I have a SQL expression field to do Oracle function call like "schemaname.packagename.functionname(Param1...
  8. TedLiu

    Verticle text cross the different sections

    Hi, I'm working on the CR10 and got a problem which I'm not sure can be done or not. I need to have a verticle text wording stay on the right-side of the report which probably need to cross the detail sections or even go to group footer. Title Amount 1 $100 A 2 $200 C...
  9. TedLiu

    Show SQL Query is disabled in Crystal Report 10

    Hi, I'm currently working on Crystal Report 10 Professional edition, Oracle 8i as datasource, Oracle native driver as data access and found Show SQL Query is disabled in my report. What I want to implement is to use union statement in SQL Query, seems the only way I know is edit SQL Query...
  10. TedLiu

    How to print 2 reports in one page?

    Hi, I got a question asked my friend. He wants to display report details from left-hand side of the page first, if go to bottom, then continuelly display report details in right-hand side of page. Something like below example. ================= ================= Report Header left...
  11. TedLiu

    Is it possible to display Portrait and Landscape reports together?

    Hi, I got some questions even I never thought it can be done. But I still want to see any alternatives we can use. Questions as subject. I'm trying to find a way to display Portrait and Landscape reports as subreports in one viewer together. I asked Crystal Tech Support, the answer is no. Are...
  12. TedLiu

    unable to print report!

    One of our user get above popup error message, but she can view the report. Did anyone have the same experience before and how to solve it? Thanks in advance ! Ted
  13. TedLiu

    Did anyone experience firewall problem?

    Hi, We are using CE8.5 with web connector locates in Application server and CE locates in a report server. It has been working well all the time till the web connector was moved into DMZ. It can't find WCS anymore. The error is communication error. Did anyone have the same issue before and how...
  14. TedLiu

    Hi, Is it possible to distribute

    Hi, Is it possible to distribute APS for different projects from one CE system? i.e, we have one report server on which CE was installed, we have 2 or 3 projects will share using this report server, right now, different project use different folder to publish their reports to CE. I wonder Can...
  15. TedLiu

    Hi, I got 2 user unable to view

    Hi, I got 2 user unable to view report at all. We use Java viewer. Seems java viewer has problem with Java virtual machine. Did anyone have same problem as me? How do you solve the problem? Thanks in advance ! Ted
  16. TedLiu

    Is possible to change DSN name dynamically in CSP page?

    Hi, After publish reports to CE, ODBC DSN name was auto detected. What I want to know is we can change DSN name in CSP programmatically or not? i.e. I have one set of reports, 3 system DSNs against 3 databases (structure are identical). In cr8.5, I can implement it in asp. But I'm not sure in...
  17. TedLiu

    Help with SubReport Name in CSP

    Hi all, I'm working with CSP to use CE.8.5. Does anyone can tell me how I can get subreport name in csp. Thanks in advance! Ted

Part and Inventory Search

Back
Top