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!

Register Log in
  • Congratulations Rhinorhino 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: aks12
  • Content: Threads
  • Order by date
  1. aks12

    ODBC user and password in CMC

    Hello, I uploaded a Crystal report to Business Objects using an ODBC connection to a SQL Server. The DBA does not want me to have the SQL Server login credentials so I asked our BO server admin to create a DSN on the BO server. Can the report on the BO server use the credentials stored in the...
  2. aks12

    Generate unique values based on change from previous record

    I accidently hijacked another thread with my own question and I apologize for that. I'll start a new one here. I need help constructing a query that will read a column in a table and assign a unique value to the record (but not necessarily sequential) every time the current record does not...
  3. aks12

    How to return data from another record based on a table lookup

    Hello, I'm using Crystal XI and need some outside advice. I have the following two tables: Claims Claim# EventID EventDate 00123 1 4/22/10 1:23pm 00123 2 4/22/10 1:24pm 00123 3 4/22/10 1:25pm 00299 5 3/31/10 9:26am 00299 14 4/1/10 10:02am...
  4. aks12

    test

    Hello, I'm using Crystal XI and need some outside advice. I have the following two tables: Claims Claim# Event_ID Event_Date 00123 1 4/22/10 1:23pm 00123 2 4/22/10 1:24pm 00123 3 4/22/10 1:25pm 00299 5 3/31/10 9:26am 00299 14 4/1/10...
  5. aks12

    modify PlaceHolderSiteName across all pages

    Hello, I'm using Sharepoint 2007 and am trying to modify a site using Microsoft Sharepoint Designer. The particular content placeholder I want to modify is PlaceHolderSiteName. I want to change the text and center it in the box instead of having it flush against the logo. I modified the...
  6. aks12

    Crosstab average not ignoring nulls

    I have a simple crosstab in Report Studio that looks at a measure for months throughout the year across a few intervals. I have a calculated member at the bottom of my crosstab that creates an average for each column. My problem is that Cognos is treating nulls as 0 and including them in the...
  7. aks12

    Javascript to get number of entries in a value prompt?

    Using Cognos 8.4, what is the javascript syntax to return the number of entries in a value prompt? I'm not a javascript coder and have been struggling with this. I've tried variations of the code below with no luck. var theSpan = document.getElementById("fromDate"); var theSelect =...
  8. aks12

    alternate line shading for two lines

    Using Crystal XI... Is there a way to produce alternate line shading for every two lines of detail? white white gray gray white white etc.
  9. aks12

    Different page header for each subreport

    Hi, I have Crystal 10 using Oracle DB. I looked at thread767-1345144 for the solution to this, but my setup is a little different. In my main report and subreports, all the data is in crosstabs in the RFs. I want to put 5 subreports in the main report (one each in RFb, RFc, RFd, RFe, RFf)...
  10. aks12

    Crosstab is ignoring grouping?

    I am using CR 10 with Oracle. Data looks like this: RPT_MONTH PRODUCT PERSIST_INT ACCT_PERSISTENCY 05/01/2007 Protect 0 7161 05/01/2007 Generic 0 5 05/01/2007 Protect 1 6306 05/01/2007 Generic 1...
  11. aks12

    Calculate maximum of summed fields

    Hello, I'm using CR 10 with Oracle. I've got what is a fairly common problem I imagine, but I can't find any posts here that address it. I want to calculate the maximum of sums and put them in group headers. My group footers are designed to be blank and suppressed. I have data that looks...
  12. aks12

    convert 0 to null or blank in crosstab

    I am using CR 10 with Oracle database. I have a crosstab in my report and the user wants the final output format as Microsoft Excel (data only) and all crosstab values as numeric. The first column in the crosstab is a percentage calculation that by design returns 0.00% all the way down the...
  13. aks12

    Drill down and skipping groups

    Hi, I am using Crystal Reports 10 with Oracle. I have a drill down report with groups set up like this: group 1: quarterly stats for products group 2: quarterly stats for subproducts group 3: monthly stats for subproducts There are two products, A and B. Product B has two subproducts; A has...
  14. aks12

    Can't output legal size pdf report

    Hello, I am using CR 10 and CE 10. I have a report with many columns and margins set to legal size (8.5x14). When I export this report from CR 10 to my desktop in pdf format, I get exactly what I want: a legal size pdf report. When I save this same exact report to Enterprise and run it there...
  15. aks12

    crosstab with weighted average problems

    Hi, sorry the earlier incomplete post. I accidently hit submit instead of preview. I am using Crystal 10 and am having a problem with a crosstab. I am calculating capture rates on a daily then weekly basis in any given month. Capture rate is calls captured/calls handled. I have columns...
  16. aks12

    Fill in missing cross-tab dates

    Hi, I have a cross-tab that shows # of phone calls by day for any given time period that is determined by begin and end date parameters. My problem is that I want to see zeros for days which may not be included in my data table. For example, instead of this...

Part and Inventory Search

Back
Top