SSRS: Display 10 Rows from Two Tables Per Page with Pagination
Question: I’m working on an SSRS report where I need to display data from two tables on a single page. The requirement is to show a total of 10 rows combined from both tables on each page. If there are more than 10 rows, the next set of rows should be printed on the subsequent pages, maintaining the same pattern. Example: Page 1: Rows 1-10 from both tables combined. Page 2: Rows 11-20 from both tables combined. And so on... Expected Result: How can I achieve this in SSRS? What is the best approach to ensure that I correctly paginate 10 rows per page from both tables combined? Any guidance or example would be greatly appreciated!
EXCELL Conditional formatging
I have a spreadsheet that I download from our turnstyle in/out system. I use conditional formatting to see who leaves early (before 5:20, before 4:00 and before 2:00) we are building a power plant and we have 2 sites side by side so several employees go back and forth... I ONLY NEED HIGHLIGHTED THE LAST CLOCK OUT FOR EACH EMPLOYEE and not every time they punched the clock out in a days time.... Can you please assist me... @links to members
Name Search in Excel
I have say one worksheet (say A) where there are names such as: 1. Aby Gomes 2. Jacob Hunter Streep 3. Gomes Jake Leo 4. Ms Margot Robert 5. Ms Selena Leo 6. Dianne Cobb Another worksheet (B) 1. Drake Joseph 2. Dianne Celeb 3. Peter Aby Gomes 4. Streep Jacob Hunter 5. Cobb, Dianne 6. Ms Leo 7. Drake Cobb 8. Nill Manderson Data in my excel files are like this, is there any way I can use a function to find if a certain name in worksheet A exists in worksheet B or not. I need to find a partial match (even if they are not the same person i just need the partial matching names highlighted) also is there any way to find by their calling names like Aby, Jacob, Leo etc?
VBA reference libraries
If I want to interact with another application using Excel's VBA, how can I find out what is the correct reference library to be selected? Finding PowerPoint reference library is very straightforward and easy, but SAP, for instance, seems to have many and I don't know which is the correct one to interact with SAP Hana (to combine VBS script with VBA). Can this be normally found in the Help tool of each application? Is there any convention to find the reference library in commonly used applications?
