0
I'm trying to build a SSRS 2008 report so that it displays a table based on start and end date parameters. But when I set the default values for these date options, it displays the same entries in my table no matter what options I select, since they are the defaults. So I tried setting defaults = available values, but this does the same thing. So how do I create cascading parameters so that the table correctly filters based on date logic?
I have three parameters: "Parameter_Week", "Start_Date" and "End Date". They are all taken from the same data set, where Parameter Week is in string format "6/12/11 - 6/18/11" and the start date is "6/12/11" and the end date is "6/18/ eleven ". In the same dataset there are 4 different records that are always equal to the last 4 weeks.
And the table data table only accepts the following 2 parameters: Start and End date. So I want this table to filter records based on these dates. However, I get the below error if I set the default values for these two parameters to "None".
The Start Date parameter does not matter.
(Both the start and end date options are hidden, since only the Week option should be visible.)
So to summarize, I have tried all combinations to set default values for these two date parameters. If I set default values = No, then I will get the above error message. But if I set the default to anything else, then it always returns the same table entries as the default.
Sorting:
Activity
0
Here's what I did:
Create a dataset to define a list of weeks
Create a parameter (@DateString) that sets the available values from the new dataset, set the label and value fields to a DateString field (created from a string of concatenated dates (ie 6/12/11 - 6/18/11)).
Create a 2nd dataset that is almost the same as the first except adding filter options
WHERE DateString = @DateString
Create 2 parameters @Date1 and @Date2. Set visibility to Hidden. Get the values from the query and set the data set for your second data set and the value field for your date1. Go to the Advanced section and select Always Update. (Do this for @date2 change the value field for date2)
Create a data set for a table with date parameters:
SELECT * FROM Events WHERE Date BETWEEN @Date1 and @Date2
Create a table with values from this dataset
Run the report and change parameters on different dates, and the table is updated as the parameters change.
Probably everyone who plays CS GO for a long period of time knows or has heard that in addition to settings, you need to select launch parameters.
So what are launch options? These are commands that force you to perform an action when you start CS GO. For example, you can skip the splash screen with engine information using the “-novid” parameter.
How do you set the launch option(s)?
It's very simple, follow the instructions in the screenshots!
Below are some launch options from which you can choose which ones you like. (Launch parameters are set separated by a space, as in the screenshot)
-novid— removes the splash screen with the engine (allows you to speed up loading)
-w 640 -h 480- will launch the game with a screen resolution of 640x480 pixels (optional)
-full- will launch the game in full screen mode
-window- will launch the game in windowed mode
-noborder- will launch the game in windowed mode without a border
-dxlevel 81- for using DirectX 8.1
-dxlevel 90- for using DirectX 9
-heapsize 262144— allocates 512MB for the game random access memory
-heapsize 524288— allocates 1GB of RAM for the game
-heapsize 1048576— allocates 2GB of RAM for the game
-noaafonts- to disable screen font smoothing
-freq 100— to change Hertz for HL1 Engine monitors. CRT 60-100 85=Common LCD 60-75 72=Common
-refresh 100— to change Hertz for HL2 Engine monitors. CRT 60-100 85=Common LCD 60-75 72=Common
-soft- to run the game in graphic mode Software
-d3d- to run the game in Direct3D graphics mode
-gl- to run the game in Open GL graphics mode
-nojoy— to disable joystick support
-noipx— to disable the LAN protocol
-noip— to remove an IP address without the ability to connect to servers
-nosound- forcefully mutes the sound in the game
-nosync— forcibly disables vertical sync
-console— to gain access to the developer console
-dev— to enable mods for developers
-zone #- to allocate more memory to files such as autoexec.cfg, etc.
-safe- to start the game in safe mode and mute audio
-autoconfig— to restore standard video settings
-condebug- to save all console logs in text file console.log
-nocrashdialog— to cancel the display of some errors (memory could not be read)
-toconsole- to launch the game engine in the console if the map is not defined with +map
+a +r_mmx 1- to launch the game with a console command or cvar command in command line(instead of cfg)
+exec name.cfg— to connect a config with the name “name”
-lv- this option enables the “low” violence mode
FPS increasing options!
1. -novid
2. -console
3. -freq (number of hertz of your monitor)
4. -threads (number of processor cores)
5. -high (increases fps on weak computers)
6. +rate 128000
7. +cl_cmdrate 128
8. +cl_updaterate 128
9. +cl_interp 0
10. +cl_interp_ratio
11. +fps_max 0
You can support the site and at the same time get skins for free
That's all! All your questions can be asked in the comments, we will try to find an answer! Good luck!
(6 ratings, average: 3,67 out of 5)
Many of you have probably heard about launch options in cs go, but not everyone knows what they are for and which of them can really benefit your PC. What are launch options? These are commands that tell the game to perform some action when loading or to launch the game with certain settings. Good settings launchers will not only ensure a smooth skating rink, but will also make your life easier. For example, you can change the screen resolution when opening cs go or skip the introductory video (to save time).
Of course, 80% of the teams described above are for some cybernerds. I listed them just in case. A optimal parameters I recommend borrowing launchers for cs go from the Navi team.
Pro players certainly know what needs to be written down there. It's unlikely they're missing out on anything. Let's see what Natus Vincere players have there. Launch options for top Natus Vincere CS:GO players
Launch parameters for Arseny "ceh9" Trinozhenko:
W 1280 -h 720 -novid -freq 144 +rate 128000 +cl_interp 0.01 +cpu_frequency_monitoring 2 +engine_no_focus_sleep convar 1 cl_obs_interp_enable 0 +cl_hideserverip -console
Yes, my roster is old, but essentially all eSports players have similar teams + they change them periodically. So there’s no need to worry too much. Take the one you like best.
Yes, I forgot the most important thing - to tell you how to install them (or rather, where to register them). To set launch parameters in cs go, you need to right-click in steam, select the properties tab and switch to the tab called “set launch parameters”, as shown in the figure below:
Let's quickly run through some common questions you may have.
For comfort. In fact, you don't have to use them at all. I personally haven't used them. I had enough of those in the game.
This is done using the command -w 640 -h 480, where instead of these numbers you can put any resolution you need.
Commands that allow you to open cs go in windowed mode (this can be done in the settings inside the game or without entering the game, by adding the following to the properties):
You don't have to write anything at all. I've played like this all my life and it hasn't caused any problems. Yes, a weak PC, low FPS, etc. all this is unpleasant. But essentially there is only one way to influence them - updating the hardware. So don't worry too much. If you have a weak PC, I recommend that you first and then write in the console:
Novid -console -freq 60 +rate 128000 +cl_cmdrate 128 +cl_updaterate 128 -threads 4 -high +cl_interp 0 +cl_interp_ratio 1+fps_max (Your value)
To return standard rate values, enter the following:
rate 80000; cl_updaterate 64; cl_cmdrate 64; cl_interp 0.03125; cl_interp_ratio 2; cl_lagcompensation 1
How do I set the game launch options?
Game Launch Options can be used to change game settings without having to log into the game. Launch settings allow the user to change game properties, bypassing in-game settings. This can help if the game does not start due to incompatible graphics settings, as well as in solving a wide range of other problems.
This article describes how to change game launch options through the Steam library. You can also set launch options by creating a shortcut to the game and configuring the Steam launch options for that shortcut.
These launch options only work for games on the Goldsrc and Source engines. They are not suitable for most games from other developers.
Please see Valve's list of games to see which games support these options.
Most console commands can also work as launch parameters if you add a “+” symbol in front of the command, but some commands do not work in this form. Below is a list of the most common startup options.
Our games no longer support DirectX 7 as a launch option, and using it may cause the game to crash. If you previously used the -dxlevel 70 startup option, make sure it is no longer used.
In our example we will use launch Google Chrome with the incognito parameter, although the method will work with other programs that support launch options. Please note that for different programs launch options are different.
So, how do you attach an application with arbitrary parameters to the taskbar?
The first thing you need to do is create a shortcut for the desired program. To do this, open the Start menu and find the program that you want to pin to the taskbar.
Once you find it, right-click on it and select Send. Then select Desktop (create shortcut).
Having created a shortcut to the program you need on your desktop, you need to edit its launch parameters. To do this, right-click on the shortcut and select Properties.
In the Properties window that opens, you need to add in the Object field required parameters. Parameters must be added after the closing quotes. Because we want to run Chrome in incognito mode, we will add the –incognito parameter.
Note: Some programs use the prefix “-“ before the parameter, while others use the prefix “/”. Therefore, before writing a parameter, refer to the documentation for the program you need.
Once you've added your options, you can simply pin the icon to the taskbar - just like you would normally. Namely, by right-clicking on the icon and selecting from context menu pin item to the taskbar.
Now you can remove the icon you created from your desktop.
Now, if you try to launch your program from the taskbar, it will start with your parameters.
That's all! Good luck to you!