string - SSRS choosing dynamic Columns -

-

For my report, I have to choose which columns are dynamically accessing the database < pre> FCST_Sales_2014_Q4_with_SF FCST_Sales_2015_Q1_with_SF FCST_Sales_2015_Q2_with_SF FCST_Sales_2015_Q3_with_SF

I need: to be more precice:

column in the database, thus named for the current year and quarter Report to choose, so I am using now () which I need to composite with expression For example: 

  = year (now ())   
 and  
  = switch (month ( Now ()) = 1, 1, month (now ()) = 2, 1, month (now ()) = 3, 1, month (now ()) = 4, 2, month (now ()) = 5 , 2, month (now ()) = 6, 2, month (now ()) = 7, 3, month (now ()) = 8, 3, month (now ()) = 9, 3, month (now ()) = 10, 4, month (now ()) = 11, 4, month (now ()) = 12, 4)   
 results  2014  And  4  what exactly i want If I am using the following:  
  = ( "field! Fsissisass_s +" + Sisarar (Year (Now ()) + "_kyu" + CSR (switch (Month (Now () ) = 1, 1, month (now ()) = 2,1, month (now ()) = 3,1, month (now ()) = 4, 2, month (now ()) = 5,2, Month (now ()) = 6,2, month (now ()) = 7,3, month (now ()) = 8,3, month (now ()) = 9,3, month (now ()) = 10, 4, month (now ()) = 11,4, month (now ()) = 12,4)) + "_with_SF")   
 I need string exactly ( FCST_Sales_2014_Q4_with_SF ) But the problem is that I I can not use the  .value  operation if I add the  sum ()  and  .value  to the expression then I get the error message , Then there is no member of the  .value  string. Expression I used:  
  = add (("! Fields FCST_Sales_" + CSTR (year (Now ()) + '_Q "+ CSTR (switch (month (now ()) = 1,1, month (now ()) = 2,1, month (now ()) = 3,1, month ( Now ()) = 4,2, month (now ()) = 5,2, month (now ()) = 6,2, month (now ()) = 7,3, month (now ()) = 8 , 3, month (now () ) = 9,3, month (now ()) = 10, 4, month (now ()) = 11,4, month (now ()) = 12,4) + "_with_SF"). Value)   
 Is there a solution for this problem?   
 
 
 You can not create such an area - you are actually creating a string what you want to do The field name is created to look it up in the  field  collection, so instead:  
  field! FieldName.Value   
 looks like this:  
  field ("field name"). Value   
 So you can use your very large expression:  
  = yoga (field ("FCSSASS_s +" + CST (year (now ( ) (+) + "_Q" + CSR (Switch (month (now ()) = 1, 1, month (now ()) = 2, 1, month (now ()) = 3, 1, month (now ( ) = 4,2, month (now ()) = 5, 2, month (now ()) = 6, 2, month (now ()) = 7, 3, month (now ()) = 8, 3 , Month (now ()) = 9, 3, month (now ()) = 10, 4, month (now ()) = 11, 4, month (now ()) = 12, 4)) + "_with_SF" ). Value)   
 You can also simplify that expression. You must do this for:  
  (month (today) + 2) \ 3   
 then your expression below  
  = add (fields ("FCST_Sales_" + CSTR (year (today)) + '_Q "+ CSTR ((month (today) + 2) \ 3) +' _with_SF"). Value)  alternative method the dynamically field using SQL to create name   
 another potentially simple way by using a dynamic SQL string. coherent field names for example, if your SQL looked like this : From MyTable  
  Defense Select FCST_Sales_2014_Q4_with_SF   
 You can change that leads to a SQL statement is a string expression. Right-click the dataset, select the dataset property and click on the Expression Editor  fx  button next to the query. Now we can create SQL statements from a string, such as  
  = "SELECT FCST_Sales_" + Sisarar (Year (Today)) + "_Q" + CSR ((Month (today) + 2) \ 3) + "_with_SF AS FCST_Sales" and "From MyTable"   
 Now you are dynamically making the field name in SQL query and it is  FCST_Sales  In the dataset so that you can easily use the known field value in your report, which makes your calculations very easy:  
  = Field! FCST_Sales.Value   
 and  
  = SUM (field! FCST_Sales.Value)

Comments

Post a Comment

Popular posts from this blog

php - PDO bindParam() fatal error -

-
I am trying to learn PDO, now I have written this small code, but it gives me a serious error: Fatal error: Call a member function at a non-object dot () ... $ con = new mysqli ("127.0.0.1", "root", "", "csvdangercheck"); $ Query = $ con- & gt; ("Id,` var1`, `var2`) values ​​(" id,: var1,: var2) ";); $ query- & gt; bypass pattern (': id', $ id); $ query- & gt; BindParam (': var1', $ VAL1); $ Query- & gt; bindParam (': var2', $ val2); $ Query-> Executed (); I Trying to use print_r ($ con-> errorInfo ()) but Fatal error: Undefined method mysqli :: errorInfo ( ) ... can someone tell me what am I missing? Flaffeh said, you have PDO Missing Mysqy, try it: $ con = new PDO ('mysql: host = 127.0.0.1; dbname = csvdangercheck', 'root', '');
Read more

php - How can I cram 6+31 numeric characters into 22 alphanumeric characters? -

-
I have a 6 digit number and a 31-digit number (such as "234536" and "201103231043330478311223582826") that I The API needs to be crawled in the same 22-character alphanumeric field that uses PHP. I tried to convert each one to 32 (using custom code could not handle the base_convert () large number) and to connect with a single-character delimiter, but It only gives me 26 characters This is a restore API, so the letters should be URI-protected. I would like to do a database table cross with two references without reference to another reference value, if possible, any suggestions? Instead use a radix of 62. This will give you 22 characters for the top, 3.35 for the pre and 17.3 for the next. & gt; & Gt; & Gt; Math.log (10 ** 6) /math.log (62) 3.3474826039165504 & gt; & Gt; & Gt; Math.log (10 ** 31) /math.log (62) 17.295326786902177
Read more

logging - How can I log both the Request.InputStream and Response.OutputStream traffic in my ASP.NET MVC3 Application for specific Actions? -

-
For a specific set of tasks, I need to log in to the incoming request inputstream as well as outgoing response. is. I am using an ActionFilterAttribute for this and overriding the OnActionExecuted and OnResultExecuted methods. So I'm starting with this idea ... Public category ActionLoggerAttribute: ActionFilterArrbit {Public Override Zero On-Offed Execution (ActionActioned Contact Filter Filter) {base.OnActionAxecuted (FilterContext); HttpRequestBase request = filterContext.HttpContext.Request; // TODO: Log the request. InputStream} Public Override Zero OnResultExecuted (ResultExecutedContext FilterContext) {base.OnResultExecuted (filterContext); HTTPRPSPointBase Response = FilterContacts Hpptex response; // TODO: Log on Response.OutputStream}} Ideally I'll hook it up with enterprise library logging because I'm already using it for error logging. Am I reaching the input and output stream at the right time? Can I easily use the Enterprise Library to log i...
Read more