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!
Blue Screen
I get this screen on my laptop. It's an HP envy x360 with an Intel core i7. it happen all the time and nothing ever happens. I restart my computer and it seems to be fine, but this happens always while I am in the middle of a project. Does this happen to anyone else, and if so, how did you fix it without throwing it out the window!?!???
Issue with "Edit with Paint 3D" Functionality
I have recently encountered an issue with Paint 3D. When I try to edit a picture using Paint 3D by right-clicking on the photo and selecting "Edit with Paint 3D," I am unexpectedly prompted to choose an app to open the file instead of Paint 3D launching directly. Has anyone else experienced this problem, or does anyone have any insights on why this might be happening and how to resolve it? Thank you for your assistance! Following was done: Reinstall Paint 3D Open Microsoft Store: Go to the Start menu and open the Microsoft Store. Search for Paint 3D: In the search bar, type "Paint 3D." Reinstall Paint 3D: If the app is installed, you can click "Open." If it’s not installed or you suspect it might be corrupted, click "Install" or "Get" to reinstall it. Ensure Paint 3D is Enabled Open Settings: Press Win + I to open Settings. Go to Apps: Navigate to "Apps" and then "Apps & features." Find Paint 3D: Scroll through the list of installed apps to find "Paint 3D." Ensure It’s Enabled: If you find it, make sure it’s not disabled. If it is, re-enable it. Associate Image Files with Paint 3D Manually Right-click on the Image File: Right-click on an image file. Select Properties: Choose "Properties" from the context menu. Change the Default Program: In the Properties window, click the "Change" button next to "Opens with." Manually Find Paint 3D: Click "More apps" if Paint 3D is not listed. Scroll down and click "Look for another app on this PC." Navigate to C:\Program Files\WindowsApps and look for the Paint 3D executable. Note that you may need administrative permissions to access this folder. Use the Default Apps Settings Open Settings: Press Win + I to open Settings. Go to Apps: Navigate to "Apps" and then "Default apps." Reset Default Apps: Scroll down and click "Reset" under "Reset to the Microsoft recommended defaults." Change Defaults Manually: After resetting, try setting Paint 3D as the default app for your image files again. Check for System Updates Open Settings: Press Win + I to open Settings. Go to Update & Security: Navigate to "Update & Security." Check for Updates: Click "Check for updates" and install any available updates. Sometimes updates can fix issues with system apps like Paint 3D. 1. Check if Paint 3D is Installed Correctly Open PowerShell as Administrator: Press Win + X and select "Windows PowerShell (Admin)." Check Installation: Enter the following command to check if Paint 3D is installed: powershell Copy code Get-AppxPackage *Microsoft.MSPaint* | Select Name, PackageFullName If Paint 3D is listed, it’s installed. If not, proceed to reinstall it. Reinstall Paint 3D: Uninstall Paint 3D using PowerShell: powershell Copy code Get-AppxPackage *Microsoft.MSPaint* | Remove-AppxPackage Reinstall from the Microsoft Store: Open the Microsoft Store, search for "Paint 3D," and install it. 2. Reset Paint 3D Open Settings: Press Win + I to open Settings. Go to Apps: Navigate to "Apps" > "Apps & features." Find Paint 3D: Scroll down and select "Paint 3D." Advanced Options: Click on "Advanced options." Reset: Click the "Reset" button. This will reset Paint 3D to its default state. 3. Create a New User Profile Open Settings: Press Win + I to open Settings. Go to Accounts: Navigate to "Accounts" > "Family & other users." Add Someone Else to This PC: Click on "Add someone else to this PC." Create a New User: Follow the prompts to create a new user account. Log In: Log out of your current account and log in with the new user account. Check if Paint 3D works correctly in the new profile. 4. Repair Windows Using DISM and SFC Open Command Prompt as Administrator: Press Win + X and select "Command Prompt (Admin)" or "Windows PowerShell (Admin)." Run DISM: Enter the following command to repair the Windows image: powershell Copy code DISM /Online /Cleanup-Image /RestoreHealth Wait for the process to complete. Run SFC: Enter the following command to check and repair system files: powershell Copy code sfc /scannow Wait for the process to complete and restart your computer.
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
Excel
I’m looking for quite a lot of help in creating an excel spreadsheet for work. In a nutshell I want it to do the following •the user to enter details on a pre designed sheet (I’m thinking with VBA so the information is entered consistently) •the sheets to be stored and recalled •the sheets to be saved by work area •the sheets to be printable •to have different access for manager (ie adding new work areas, printing the sheets etc) •to have a custom search for the sheets, by work area and date) there’s more, but I figure that’s enough to give a picture. I have a version of this already, but it was created by someone else who I no longer have contact with and the code is too complex for me to pick apart. I have also already created the new sheet that I want to use for this. Thanks in advance for any help.VBA ICONS CEASE TO BE RECOGNIZED
I have several large workbooks that get out of sink periodically. When that happens, I go to the previous month and copy a worksheet from there to the new workbook, the result is that everything now balances out but sometimes my Icons cease to work on a separate worksheet. When I look at the properties of these icons the property response is that of the page instead of the icon. Today I added a new icon to replace one on that un-updated worksheet that now doesn't work and found that the new icon was only recognized as a worksheet instead of an icon. I'm supposed to have an automatic update but it doesn't work either so I updated the software and the new icon is still not recognized in properties as an icon. What setting am i missing?Checking the connection to Microsoft. This might take a while.
I have WDS and MDT configured to deploy windows 10 to Lenovo ThinkPad 15 Gen2 along with network driver and all the things needed. Due to a minor misconfiguration right network drivers were not being injected. But when we are doing the same windows 10 installation through Bootable USB, we won't be including any drivers in that, but that still works. What I don't understand is the whole WDS deployment happens on the private network which doesn't need internet which I am being mandated for the process after MDT GUI has done its work the laptop restarts and saying "Checking the connection to Microsoft. This might take a while." as the landing page and getting stuck there for hours not letting me go any further. Please help me understand the part where it says it is trying to connect to Microsoft and getting stuck meaning it is trying to connect to internet when there is no need for that.
