Recent content by Jacque

Hi Everyone, I'm currently working with Visual Studio Community 2015 and the Report Server is 2016. I'm new to Linked reports but have worked with multiple versions of SSRS. I'm trying to understand why some reports are not able to be created as linked reports? [ponder] Some of my simplest...

SamBones, thanks for both the response and great information. Sending you a star [thanks2]

Hi SamBones, Thanks for responding. Can I ask the industry you are in and is it all three blurbs or just one or two specific blurbs? My industry is Health Care Revenue and Services.

Does anyone add copyright information or disclaimer or confidentiality blurbs to their reports? I'm curious to your reasons and if the reasoning is based on the industry you're in or the type of report. Thanks in advance for any feedback. [blues]

Try adding a table - removing the borders so that it doesn't look like a table and set the Datasource to the datasource that contains your client info.

It sounds like a likert scale for a survey.... I might be wrong about that but what if you make the questions your row group and the 'scale' 0, 1, 2 as your column groups.

Have you tried something like this: https://msdn.microsoft.com/query/dev14.query?appId=Dev14IDEF1&l=EN-US&k=k(sql13.rtp.rptdesigner.reportproperties.variables.f1)&rd=true Read-write use Set a value once and serialize the value within a report session. The read-write option for variables...

I don't know if you ever got this accomplished but I have done the same thing, 6 reports total, not 9 though. I made a master report with the main header and footer of the report to be shared by all of report including the subreports. The header contains my companies dynamic logos and the...

I have done that, except for the padding it by 10% part - good idea for negotiations. I do have a document listing everything I've worked on. A projection of future projects will be difficult because this company is very flexible and changes directions on a dime. Many times what I'm told...

Both of the senior people (myself and my coworker) in my group do not want management positions. We are good at and enjoy what we do and are constantly being challenged with assignments that are thought to be impossible but we find ways to accomplish them. I do not want to step away from doing...

My current position has 'changed' titles a few times with no salary increase but I've always received a 'top-level' annual merit increase (lame IMO 3-5%). I have been asking for a technical career path because I did know when I started with the company that this was a completely new direction...

Hi Stewman, In SSRS you don't need the 'then' or 'else' text in a IIF statement. example: =iif(fields!type.value in ('firsttype','secondtype'), '*', iif(sum(fields!cost.value,"GroupingName")=0, '*', 'Elsevaluegoeshere')) The first test is in blue, the result if true is in blue bolded, the...

Hi Everyone I have a report that includes a table using dataset1 grouped by facility. The table is set to include column headers, 18 months worth of data and totals. Directly beneath the table is two side by side pie charts using dataset2 grouped by facility. Lastly once I get the first two...

My query is set to compare All Clients survey data (likert scale) to a specific Client's survey data. My current query unions the data - no problem. The problem begins when I'm comparing the scale value aka Response: The All clients query returns data for all or most of the values but the...

Hi Skittle, In the properties window, for BackgroundColor, try entering #ffaaff without the equal sign in front of it or use the RGB for that color. Hope this helps. Jacque