I have a report in SQL Server Business Intelligence Studio that is a .rdl file(Report Definition/Report Designer). Currently, the report graphs a line chart given the a LOAN_AMOUNT(Y-AXIS) for a given Day of the Month (X-AXIS). Everyday of the month is not represented as data being retrieved from the database. As a result, certain parts of a line may be discontinuous. How do I make this line continuous even if no data-points exist?
SQL Server Business Intelligence Studio: Discontinuous Line Chart
725 views Asked by dionysus At
1
There are 1 answers
Related Questions in VISUAL-STUDIO-2008
- Unable to cross-compile a simple program using MSVC 9
- How to add/import and control 3d object to visual studio 2008
- How to use charting libraries in windows form application for compact windows?
- How to use MSBuild for Visual Studio 2008 in a docker container?
- Cannot edit and save DLL resources in Visual Studio
- Special language constants make the .RC file uneditable
- visual studio How do I run a windows 2008 ce Solution on VS 2017?
- [VB.NET][2008] 2 forms show and close
- What is the meaning of #if !defined(AFX_RESOURCE_DLL) || defined(AFX_TARG_BGR)
- Visual Studio 2008 DataGrid column width changing
- How to run batch script in IBM Rhapsody after build is successful to copy config files
- How to add reference under COM link in Visual Studio 2008?
- Visual Studio 2008 Form1 textbox1.text renames Form2 label1.Text
- How can I tell what version of VB/.NET this project is using?
- How Objects stored in memory? Inherting a Base Class vs. Creating a Base Class Member Object
Related Questions in RDL
- Automatically deploy .rdl files to PowerBI
- In RDL report how can I move tablix rows down?
- SSRS DataTransform property in VS 2013 produces no output
- Want to add another row in tablix if my data is changed from the same field in RDLC
- RDL files are opening up in XML format in Visual Studio 2022. I have the Microsoft RDLC Report Designer installed
- Why stop the common language runtime (CLR) while exporting Excel File in ssrs report
- SQL Report Builder 2014 ignores Arial Font and Report uses Helvetica instead
- Facing Security permission preview rdl report
- Font issue with matrix in rdl file - Power BI paginated report
- I am trying to generate QR code using RDLC and Asp.net Core but getting below error
- In SSRS RDL toggle button expand/collapse making report slower due to huge data
- Microsoft Power BI Report Builder to render base64 to pdf
- Visual Studio Report not Exporting Correctly to Excel
- Update root Report node in SSRS report XML to include rd node
- Are multiple datasets needed in an SSRS report?
Related Questions in REPORT-DESIGNER
- Problem with loading rdlc in report viewer
- Acumatica Report designer IF,AND, SUM formula
- Reporting services: why is there all this blank space at the start of my chart?
- RDLC/Reporting Services: Gauge inside table is cut off
- How can I access which fields are placed in a report design with Devexpress Xtrareport in C#?
- IIF Expression in RDLC report of ASP.NET project acting weird
- Pentaho cde & Report-designer source
- .NET 6 Report Designer System.Runtime.Serialization.Primivites Version 6.0.0.0 Error
- Incorrect values in array
- Show View in Telerik Report Designer
- Acumatica Report Designer Concat variable shows incomplete field
- How to add customer drop down menu in Devexpress Report Designer UI
- Word Representation of the Amount field in Acumatica In Report Designer
- SSRS Design will not let me edit
- Is it possible to sort an Acumatica report by a calculated field (formula)?
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
You should use a function like this:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61519
To generate all dates, even if they are not in the database and assign the loan amount to 0.
For instance, if in february (no leap year) and your database has values for feb 1, and feb 14 only then you should use the date function posted to get all dates and assign the value 0 to loan amount of all other dates. Only then should you use this as your datasource for your report (I assume you are using stored procedures and not a direct table).