About SteveNZ

SteveNZ · ‎09-30-2024

Thanks all, I'll get in touch with the admins and go from there. If anyone from SAS monitors this it would be a good feature if a user could put the filter on at the data source level when you add it to a report.

SteveNZ · ‎09-29-2024

Thanks for this, so is there no way to do it at the report level? It appears I don't have access to Manage Environment in SAS VA

SteveNZ · ‎09-25-2024

We have a number of dashboards that contain sensitive data. In each separate piece of data we have a Usercode variable which is the same the user uses to log in with. Is there a way to automatically filter the data based on their login matching the Usercode variable? Many thanks in advance!

SteveNZ · ‎12-08-2022

Hi, thanks so much for replying! I'll definitely pursue the ideas re the interaction between VA and the portal - the SASVA function will be the key. I'm not seeing the options you suggest for the formatting of the long text though? I'm using Release 8.5.1 and Viya V.03.05 - is this functionality a recent thing?

SteveNZ · ‎12-02-2022

Hi all, I'm developing a dashboard that shows payments to clients from multiple suppliers. One of the data sets contains individual payment details (Supplier -> Client) and that is linked to a notes dataset that shows any notes that staff have entered in about the individual payments. I have the notes popping up in a window when the user double clicks a payment in a table. The users have asked if I can, from the dashboard, create a link or button to download a PDF file showing all notes associated with payments in one file based on the report filters. The report filters are Suppliers ID/Name and Date Range. Ideally I'd have, for each payment, the details of the payment followed by the note in date order. Is this possible? I'm thinking if I can create the PDF code in SAS Portal then pass parameters to the Portal from SAS VA it would work? Preferably it would use the same data sets so I wouldn't have to replicate them? Any pointers really appreciated! As a side question does anyone know how to get SAS VA to honour line breaks in long text fields?

SteveNZ · ‎03-31-2022

Hi and sorry for late response but been offline. I think you're correct and even if client and partner were in the mapping I cant use them individually i.e. Client for one report and Partner for another. Thanks for your help, really appreciated.

SteveNZ · ‎03-23-2022

I have a table in my Master Report where I've set up a Report Link to the Detail Report and I use Report ID to link:

SteveNZ · ‎03-23-2022

I have a report link via a table in the Master report that brings up the detail report and the variables in the image above are from the table even though I am only using the Report ID to link. Seems a bit odd we can't somehow use these dynamically in VA?

SteveNZ · ‎03-22-2022

Hiya, I tried that but it just showed me the Report ID that I've used to link things up. Can I assign the other incoming filters such as Client and Partner below to make titles more descriptive?

SteveNZ · ‎03-22-2022

Hiya, version is 8.5.1

SteveNZ · ‎03-21-2022

Hi all, I have a master report in VA that uses a Report Link to send the user to a detail report. When the user double clicks in the table on the master report it opens the detail report and at the top of the screen is a breadcrumbs type navigation eg: Master Report > Detail Report and then a filter icon showing incoming filter information. Clicking on the filter I can see all the report level filters and in particular variables I would like to use in Dynamic Titles eg Client Name. Is there any way I can get these filters into a title? Many thanks in advance for your help

SteveNZ · ‎12-09-2021

We are on a pathway to updating but not sure what the timeline is - hopefully early next year. I don't use the versioning in EG currently, I use the old fashioned way of Save As with a filename change. Is there a reason this may help solve the issue?

SteveNZ · ‎12-09-2021

Hi, we are running 7.13 and a gov agency as well with similar issues updating. The issue is still happening and very frustrating. A work around we have is to save the individual programs within a project to a shared drive our team has access to which does work but is a pain. The Copy Files Task we use all the time however cannot be saved locally and REGULARLY loses the source and destination directories - they just go blank causing the program to fall over. Sometimes SAS then signs users out meaning we have to start the whole program again. Be good if a fix was found.

SteveNZ · ‎09-03-2020

Just checked and the HASHING_MAC function is available only from 9.4M6 and we're on M4....

SteveNZ · ‎09-03-2020

Thanks Chris, really appreciate the response and I'll give your suggestions a try. I have anonymised the post as it had my client specific client-id, is there a way you know of that can encode?

Online Status	Offline
Date Last Visited	‎01-14-2025 07:21 PM

Re: SAS VA filter data based on the USERID the user logs in with

Re: SAS VA filter data based on the USERID the user logs in with

SAS VA filter data based on the USERID the user logs in with

Re: Create a Download Link For Dynamic PDF File

Create a Download Link For Dynamic PDF File

Re: Use Report Level Filters in Dynamic Titles

Re: Use Report Level Filters in Dynamic Titles

Re: Use Report Level Filters in Dynamic Titles

Re: Use Report Level Filters in Dynamic Titles

Re: Use Report Level Filters in Dynamic Titles

Re: Code Going Missing

Code Going Missing

Lines Wrapping in ODS Excel

Re: Concatenate multiple rows into a single value

Re: Which day of the week has highest number of accidents?

Re: SAS VA filter data based on the USERID the user logs in with

Re: SAS VA filter data based on the USERID the user logs in with

SAS VA filter data based on the USERID the user logs in with

Re: Create a Download Link For Dynamic PDF File

Create a Download Link For Dynamic PDF File

Re: Use Report Level Filters in Dynamic Titles

Re: Use Report Level Filters in Dynamic Titles

Re: Use Report Level Filters in Dynamic Titles

Re: Use Report Level Filters in Dynamic Titles

Re: Use Report Level Filters in Dynamic Titles

Use Report Level Filters in Dynamic Titles

Re: Code Going Missing

Re: Code Going Missing

Re: UTF-8 Byte Array and Base64 Decode?

Re: UTF-8 Byte Array and Base64 Decode?