Recent content by Jumroo

found a SQL solution...just wanted to keep the post updated Select batch_id, SUM( CASE WHEN Day_of_month = 1 THEN 1 ELSE 0 END) AS DAY1, SUM( CASE WHEN Day_of_month = 2 THEN 1 ELSE 0 END) AS DAY2, SUM( CASE WHEN Day_of_month = 3 THEN 1 ELSE 0 END) AS DAY3, SUM( CASE WHEN Day_of_month = 4...

lbass, i dpn't want the difference....i want the days to be couted for each day of the month. Input BATCH_ID START_DATE END_DATE 99999 11/2/2008 11/06/08 88888 11/1/2008 11/03/08 Output 11/1 11/2 11/3 11/4 11/5 11/6 11/7 11/30 99999 0 1 1...

i have atbale called BATCH which has fields Batch_id, Startdate and end date. i have a start date of 11/2/08 and end date of 11/6/08....i want to create a logic for a monthly report where i need to count each of the day once for 11/1 11/2, 11/3, 11/4, 11/5, 11/6 0 1 1 1...

i have a requirement where i need to sample a 5% of records for each user group. select usr_id,user_name,batch_id,batch_date from batch_table i want 5% of each users records for each month. is it possible?

i have recommended the report to be converted to a Command based report. its upto the developer/user to decide. Thank you Lbass . appreciate all your help.

main report has 2 groups. one on the dept and one on the {@Visit_Prov} formula. the table used is PAT_VISIT. the selection filter just a date range filter. {PAT_VISIT.visit_date} in (if {?Run Period Parameter}='Custom Date Range' then {?Start Date} to {?End Date} else if {?Run Period...

Yes, we need summaries at Panel and non-panel subgroup levels.

this is a formula....placed at the group level. here are the 3 formulas. one is a group....one is a formula and one is summary based on the formula and group. GROUP {@Visit_Prov} {Prov_Visit.PROV_NAME}+" - "+{Prov_Visit.PROV_ID} @visit counts PCP IF ( {TABLE.PCP_ID} = {TABLE.VISIT_ID}...

Thankyou Lbass for your response. i will explain the actual issue i have. we have a group summary field and the users wants to group the group summary based on the value > 0 or = 0. since this is a summary field, it wasn't available for grouping and the developer went the subreport & shared...

Thanks Lbass for your response. will it be possible to group on this value if i REVERSE the Main and Subreports? like put all the displayed data in the subreport and have the main report calculate the shared value and pass it to the subreport?

i have a main report and a subreport with a shared variable passed from Subreport to MAIN report. i'm using CR10 and Teradata I need to group on this value. is it possible?

i think this thread is what you want!!! http://www.tek-tips.com/viewthread.cfm?qid=1368358 please search before posting questions....you might not the first to have the same issue. hope it helps

found a solution and wanted to update my thread qestion for others to use. it was a version issue with U2FTEXT.DLL when the DLL was updated...it worked fine...

I need help with an issue i am having when exporting a fixed width file from CE. i have a report with fixed width output. each record in the file has 250 characters and when it is less than the 250 characters.....it is padde with extra spaces to make it to 250. when exporting from CE with any...

Thanks al1024! my solution was very very close to what you suggested.