Private Messaging
9 TopicsSSRS: 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!180Views0likes0CommentsExcel Newbie here
I have bought excel for beginners books, and I still cannot for the life of me figure out how to Print this "worksheet" exactly how it looks on my screen.... when I go to print preview it looks nothing like what I have. I also want to save it as a go to template for my job.430Views0likes1CommentEXCELL 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 members1KViews0likes8CommentsExcel
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.418Views0likes1CommentVBA 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?395Views0likes1CommentExcel an einem festen Tag einen festen Betrag addieren
Excel an einem festen Tag einen festen Betrag addieren - ich möchte jeweils am 15. eines Monats einen festen Betrag zu einem bestehenden addieren. Beispiel: 15.08.2023 --> 750,00 € +70,00 € / 15.09.2023 --> 820,00 € +70 € / 15.10.2023 --> 890,00 € + 70 € usw. ohne Enddatum. Hat jemand eine Idee - wie die Formel lauten muss? Vielen Dank.690Views0likes3CommentsData extraction from Excel without table
I'm working on POC where In email attachments I will get excel file without table. I am trying to read that excel file using Microsoft flow and create item's in SharePoint list. For each row there will be new records. Please help me how can I achieve this1.3KViews1like2CommentsExcel
Create a Calendar for the employee, where you calculate total working days in last 1 month Consider weekend as Saturday and Sunday, And all the national Holidays This Employee has taken 1 CL and 2 sick dayslast month( 3rd, 4th and 26th,27th day of the month) Can anyone tell me how to do that981Views0likes1Comment