Loop thru Data

(0) Share

Report

Posted on by jsshivalik

3,027

In a report user has entered Date from 01022018..050220018 . I have filtered records using setrange. Now i want to calculate data Date wise thru loop.

I want this thru C/al code only.

First i want to do calculation of data as on 01022018 , then 02022017 & so on.

Thanks

*This post is locked for comments

All responses (6)

Answers (0)

Suggested answer

RockwithNav 6,562 on at

Like (0)

Report

RE: Loop thru Data

Change the Sorting in Dataitem so that record executes like this only. If you have taken any variable Record then do SETCURRENKEY based on date.
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Loop thru Data

You can use grouping in RDLC by date... i think it easeir
ManishS 78 on at

Like (0)

Report

RE: Loop thru Data

Group you data in a temporary table and then show on the report.
Suggested answer

Suresh Kulla 43,749 on at

Like (0)

Report

RE: Loop thru Data

As explained above create a temporary variable for your record type and do that logic mentioned, try to write something and share with us we will correct it.
jsshivalik 3,027 on at

Like (0)

Report

RE: Loop thru Data

Hi

Can u pls help me with some code

Thanks
Suggested answer

Suresh Kulla 43,749 on at

Like (0)

Report

RE: Loop thru Data

First sort the data by the date and then use a temporary table to store the data by date wise. If the same record in temp table exists for that date then update or else insert. this way at the end you will have the data summarized by the date.