myDBR Forums » Tag: styles

myDBR Forums » Tag: styles - Recent Posts http://mydbr.com/forums/tags.php?tag=styles myDBR support and idea sharing en-US Fri, 24 May 2013 17:32:35 +0000 http://bbpress.org/?v=1.0.3 <![CDATA[Search]]> q http://mydbr.com/forums/search.php myDBR Team on "Pre-defined Styles" http://mydbr.com/forums/topic.php?id=1123#post-3404 Fri, 01 Mar 2013 07:59:41 +0000 myDBR Team 3404@http://mydbr.com/forums/ We've got few css classes for dbr.text that will not change so you can safely use them (left, right, box, comment). Other than that, you are better off by defining your own classes so you can be sure we do alter your report layout while updating the application. -- myDBR Team shhedrick on "Pre-defined Styles" http://mydbr.com/forums/topic.php?id=1123#post-3401 Thu, 28 Feb 2013 20:57:28 +0000 shhedrick 3401@http://mydbr.com/forums/ For instance, the dbr.text command has a "style" parameter. I know "left" and "right" work but what else? shhedrick on "Pre-defined Styles" http://mydbr.com/forums/topic.php?id=1123#post-3400 Thu, 28 Feb 2013 20:19:32 +0000 shhedrick 3400@http://mydbr.com/forums/ Is there anyplace to see a summary of all the styles that you have already defined in mydbr? I would rather use a style you've created than redundantly create my own. Thanks. thewah on "Number Formatting Via Dynamic Cellstyle" http://mydbr.com/forums/topic.php?id=1105#post-3336 Tue, 19 Feb 2013 21:14:32 +0000 thewah 3336@http://mydbr.com/forums/ I was originally using colstyle, but it would kick out a printf error when trying to apply formatting to the "N/A" returned by some of the snipped queries (for the two most recent months, it doesn't return a numeric value, but a string). I was able to get there by just rounding the values to the proper precision and concatenating the special characters, so it eventually worked out. myDBR Team on "Number Formatting Via Dynamic Cellstyle" http://mydbr.com/forums/topic.php?id=1105#post-3335 Tue, 19 Feb 2013 20:25:58 +0000 myDBR Team 3335@http://mydbr.com/forums/ The cellstyle column should only contain a CSS style. You can set the prefix and number of decimals with dbr.colstyle. -- myDBR Team thewah on "Number Formatting Via Dynamic Cellstyle" http://mydbr.com/forums/topic.php?id=1105#post-3334 Tue, 19 Feb 2013 19:59:27 +0000 thewah 3334@http://mydbr.com/forums/ Using this for formatting... select 'dbr.cellstyle','Pay Per Funded Deal','moneystyle'; select 'dbr.cellstyle','Payroll Adjustment','moneystyle'; select 'dbr.cellstyle','Personal Funding %','percentstyle'; And this to set the style... select date_format(p.start_date,'%Y/%m') as 'Month', [many field removed] ,if(month(now()) = month(p.start_date) or month(now())-1 = month(p.start_date),'notfoundstyle',if(special_number>=0,'color:green;$%.2f;','color:red;$%.2f;')) as '[moneystyle]' ,if(month(now()) = month(p.start_date) or month(now())-1 = month(p.start_date),'notfoundstyle','%.2f%') as '[percentstyle]' from ... myDBR Team on "Number Formatting Via Dynamic Cellstyle" http://mydbr.com/forums/topic.php?id=1105#post-3332 Tue, 19 Feb 2013 18:38:09 +0000 myDBR Team 3332@http://mydbr.com/forums/ What have you tried? -- myDBR Team thewah on "Number Formatting Via Dynamic Cellstyle" http://mydbr.com/forums/topic.php?id=1105#post-3331 Tue, 19 Feb 2013 17:57:52 +0000 thewah 3331@http://mydbr.com/forums/ I'm trying for properly format some numbers using the printf style arguments. I am trying to do so via dyanamic styles. I can select the style and it works for color/background/etc formatting, but I can't get it to properly add special characters ($,%). If I don't do dynamic styling, printf errors out (I have a case statement that returns "N/A" for a number of fields, but the normal styling errors out during printf on character fields) myDBR Team on "Is it possible to flip the axis on a table?" http://mydbr.com/forums/topic.php?id=348#post-1421 Thu, 22 Sep 2011 08:23:17 +0000 myDBR Team 1421@http://mydbr.com/forums/ First example is a cross table report supported by myDBR. Second example is a full table transposing which for now is not supported. If there is a demand a feature like this, we can add it to roadmap. -- myDBR Team se-eric on "Is it possible to flip the axis on a table?" http://mydbr.com/forums/topic.php?id=348#post-1418 Wed, 21 Sep 2011 20:30:26 +0000 se-eric 1418@http://mydbr.com/forums/ Here are a couple of examples using the excel function to special paste transposed. <a href="http://screencast.com/t/0wVpRT7Rw" rel="nofollow">http://screencast.com/t/0wVpRT7Rw</a> This would be very valuable for mydbr to have IMO because MySQL on its own does not have any easy way to transpose things without getting pretty complex. myDBR Team on "Is it possible to flip the axis on a table?" http://mydbr.com/forums/topic.php?id=348#post-1417 Wed, 21 Sep 2011 18:22:19 +0000 myDBR Team 1417@http://mydbr.com/forums/ How would you want to deal with multiple rows? -- myDBR Team se-eric on "Is it possible to flip the axis on a table?" http://mydbr.com/forums/topic.php?id=348#post-1416 Wed, 21 Sep 2011 18:10:46 +0000 se-eric 1416@http://mydbr.com/forums/ Let's say I have a table where the first column is dates, and the second column is a numerical rating submitted on that date. Is there a way to flip the axis so that the date is row 1 and the rating is row 2? fdelpozo on "Percent for column style" http://mydbr.com/forums/topic.php?id=276#post-1144 Tue, 24 May 2011 12:46:19 +0000 fdelpozo 1144@http://mydbr.com/forums/ Thanks, It works fine. myDBR Team on "Percent for column style" http://mydbr.com/forums/topic.php?id=276#post-1143 Tue, 24 May 2011 12:17:44 +0000 myDBR Team 1143@http://mydbr.com/forums/ myDBR uses standard printf for formatting. Use "%.2f %%". -- myDBR Team fdelpozo on "Percent for column style" http://mydbr.com/forums/topic.php?id=276#post-1142 Tue, 24 May 2011 12:05:44 +0000 fdelpozo 1142@http://mydbr.com/forums/ How can I set the percent symbol "%" for a column? MYDBR uses this symbol for parameters. I try "%.2f %" and don't works. I have another style for money (Euros) like this "%.2f €" and works fine. What about the percent symbol? Thanks brad@foreverybody on "dbr.colstyle styling NULL values" http://mydbr.com/forums/topic.php?id=259#post-1062 Wed, 27 Apr 2011 22:27:38 +0000 brad@foreverybody 1062@http://mydbr.com/forums/ yes; showing 0% where there is a value is desired, NULL values I wish to be left blank. Thank you. myDBR Team on "dbr.colstyle styling NULL values" http://mydbr.com/forums/topic.php?id=259#post-1061 Wed, 27 Apr 2011 21:24:17 +0000 myDBR Team 1061@http://mydbr.com/forums/ You do wish to show also the percentages where the value is zero? We'll take a look at it. -- myDBR Team brad@foreverybody on "dbr.colstyle styling NULL values" http://mydbr.com/forums/topic.php?id=259#post-1060 Wed, 27 Apr 2011 21:14:24 +0000 brad@foreverybody 1060@http://mydbr.com/forums/ Hi, I have a crosstab report that has a % column that i have styled using dbr.colstyle so that positive % is green with a % sign. However, this report contains a lot of NULL values in the % so the report shows 0.0% all over the place and its very distracting. I know this is only a cosmetic issue, but I'm wondering if there is/could be an option for styles to only apply to non null values. Edit: one more minor thing I am using dbr.hsum to sum my "tally" column but mydbr is including the following % column as well even tho i didnt ask for it. Obviously the % adds up to 100% so i really dont care and its taking up space.