Search results for query: *

Still working on this report... is there anyone here who has an idea why my report is giving me an error when I add more stored procedure parameters? I wonder why I am getting an error when the SP declation below was combined with more than one parameter. Procedure DailyTime(pOutput IN OUT...

I was reading online how to use SP in CR and it says that I should have an IN OUT cursor for the report to work which I have proven combining that parameter with another parameter CO. It worked. And I already have one report in production thats using SP that has IN OUT cursor param. So I am...

This is the SP: Spec: REATE OR REPLACE PACKAGE LL.Test IS TYPE cursor_type1 IS REF CURSOR RETURN avwf_daily_time_temp%ROWTYPE; Procedure DailyTime(pOutput IN OUT cursor_type1,CO in NUMBER,WORKDT IN DATE, USR in VARCHAR2); END Test; Body: CREATE OR REPLACE PACKAGE BODY LL.Test IS...

Using CR Version 9, Oracle, stored procedure as datasource, MS OLE DB Provider for Oracle as connectivity. My stored procedure is using: TYPE cursor_type IS REF CURSOR RETURN temp_table%ROWTYPE; With 2 parameters company_id as number and user_id as varchar2. Both parameters were declared as...

It is in GF2c my second grouping is employee. Thanks!

I have a follow-up question on this... Based on the formula given above, I should have two columns for Comp Hrs and Non-comp hrs. My question is: Is it possible to have those columns visible eventhough its zero hour? I want to have this layout in report: Summary by Pay Payment code...

Thanks a lot LBass!

Thanks LB. I'm sorry, the posting on the other place was a mistake. Ok, my report seems to be more complicated than that... what about this? Date: 01-01-2007 Employee: 1234 Detail Payment code Hours Comp Pay A 3 Yes Pay B...

Hello Rahul, Can you explain how you did this report for I have the same problem. Thanks

Sorry, I am using CR 9.

I need to create a daily detail and summary report in one page that will look like this: Date: 01-01-2007 Employee: 1234 Detail Payment code Hours Pay A 3 Pay B 4 Pay A 5 Summary by Pay Payment code...

I need to create a daily detail and summary report in one page that will look like this: Date: 01-01-2007 Employee: 1234 Detail Payment code Hours Pay A 3 Pay B 4 Pay A 5 Summary by Pay Payment code...

Sorry, I am using ReportNet.

I am updating default_layout.css and wants to modify BG and FG color of Grand Total row. Tried using inlineFooter, inlineSummary class and both sub-total and grand total was formatted. Do you have any idea how I can set sub-total and grand total with different BG and FG color?