DB Reporting Tools

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.

Share tech news, updates, or what's on your mind.

Sign up to Post

Hi,

 I have a problem with SSRS windows File share subscription. I am trying to post a file from Server A to Server B using windows filesharesubscriptions.  The account (ABC) I am using to post the file has access to shared folder on Server B, is an administrator on both Server A and B. But I am still getting Impersonation error. Please advise what needs to be done.
0
I've taken over the SSRS reports in our organisation and have the responsibility of developing new reports. I can do this (although not as well as the previous incumbent coming as I do from more of an SQL background).
Anyway, I'm having a problem with login credentials for some reports I've developed; we have a bespoke solution provided by our application vendor which passes credentials through to the reporting server. For some legacy reports this works fine and the reports open. However, the new reports I have created prompt for an SSRS login, UNLESS I have already opened one of the reports that does work. It seems that running a report that does work stores the credentials meaning that subsequent report requests do not require SSRS login.
So, what I would like to do is figure out why a working report does not require login credentials and see if I can replicate the setup in my new reports. Looking at one of the reports in BIDS, I can see that there is no data source shown, either embedded or shared. Obviously the report will not run in BIDS. However, the same report runs perfectly happily in Report Builder 3.0. I can't see any connection strings hidden anywhere, no parameters or variables appear to be set up, so I'm just wondering how it is possible for that report to work with no data source?

For information, here is a screenshot of the report in Report Builder:

Report Builder Design
And the Report results:

Report Results
0
Is there a tutorial that would explain step by step how to set up a Telerik report in the following scenario?

Winforms application
The report includes 5 parameters and a table
The data is decided by the user based on an interface
The application adds the data to a DataTable.
The parameters are calculated by the code based on user choices.

So when the user clicks I want to be able to
populate the dataTable
populate the parameters
call and show the report

My questions include
Does the code go into the Viewer or the report
Can I use a single form with a report viewer for many reports

Thanks in advance:)
0
I am trying to open a pop up window in SSRS without any parameters (just need it to go to this report) and when I click on the link from the main report nothing happens. I have done countless numbers of these with passing parameters, just never without. Am I missing something painfully obvious?


="javascript:void window.open(" &"'"& Globals!ReportServerUrl &"/Pages/ReportViewer.aspx?"&"/Billing Reports/links/ICDQuick)"
0
Hello there,

I have developed a report with SSRS 2012 and when I view the report on the reporting server for some reason the first row of the tablix on page 2 gets hidden under the column header. What could it be??. Also I have enabled to show the column header as and when I scroll down the page but it is not working in here. But this feature is working in the SQL Server Data tool when I test there. I am testing on IE 11. Please help,.

1
cheers
Zolf
0
Hello there,

I have this reoport which I would like to show the sum of the product sales instead of each product sales. Please see the screenshot to get a clearer picture as to what I mean.

1
cheers
Zolf
0
Does anyone know of any FREE comprehensive Capacity Planning Tools?  I'm looking to measure mail stores, DBs, and file/NAS/SAN/VM storage.  The three questions I am looking to answer are the following, in an executive summary, and a comprehensive detailed report for administrators and engineers alike:  What's the current capacity available? What's the current capacity usage? When are we trending to run out of capacity?
0
hi i have report which was develop in 6i now when i what to run the report in 11g is showing qty column value as *********** but when i run the same report in 6i i got 22.34 which is correct this is the property
report
0
Hello,
I am trying to export crystal report to be sent by Email using MHTML format type in VS2013 using below command
                        CrReport.ExportToDisk(HTML32, "FilePath.html")
                        CrReport.ExportToDisk(HTML40, "FilePath.html")

I notice that we can export during crystal report preview using MHTML but I could not find this format type during runtime
we are working crystal report for Visual studio 2013
Any hint?
Thank you
0
Hello.  I am writing Access 2010 vba script to automatically send access reports to multiple email recipients.  however, I need to prevent or turn off the warnings "...Program trying to send...confirm..."  How can I do this?

DoCmd.SendObject acSendReport, "rpt_ChkAvg_3009", acFormatPDF, "Terry M", , , "Current Month Check Average Report", _
"See Attached Check Average Report", 0, False

Thank you.

ic
0
I'm trying to create a report that will show me what stage a non-conformance report is in.  There's various tabs within the program that get completed (Origination, Investigation, Disposition, and Verification) There is a check box that the user marks to complete that particular section.    I thought that the best way to be able to show me the current stage was to  group my report by what stage it is in.  So I've attempted to create a formula but I'm having issues getting the formula's syntax correct.

Is this the best/easiest way to do this?  I also suppose I need to check if isnull in my formula as well which I haven't done yet.

My formula reads:
if  totext({view_PT_NC.Originated_complete}) = 'True' and
if totext({view_PT_NC.Investigation_complete}) = 'True' and
if totext({view_PT_NC.Disposition_complete}) = 'True' and
if totext({view_PT_NC.Verification_complete}) = 'True' then
"closed"

else

if  totext({view_PT_NC.Originated_complete}) = 'True' and
if totext({view_PT_NC.Investigation_complete}) = 'True' and
if totext({view_PT_NC.Disposition_complete}) = 'True' then
"Verification"

else

if  totext({view_PT_NC.Originated_complete}) = 'True' and
if totext({view_PT_NC.Investigation_complete}) = 'True' then
"Disposition"

else

if  totext({view_PT_NC.Originated_complete}) = 'True' then
"Investigation"

else
 "Unknown"
--mail-staylor--Custom-Reports-uniPo.rpt
0
Hello there,

I have 2 instance of database on my machine,SQLServer 2012 and SQLServer 2008R2,Please see screenshot. I will be using the 2008R2 database for data and SQL2012 for SSIS,SSRS implementation. Now my packages are ready for deployment. But I am stuck from here. While deploying I need to refer the Server name  to which instance of SQL.

ee.gif
ee1.gif
0
I have a table that lists employee ID's, FIrstName, LastName, etc.
Other tables used in my report has the Employee ID.
The user isn't going to know the employee ID's, only their name.  

 I created a formula that displays the employee's full name.  I want the user to be able to select which employees he wants filtered in the report.  How can I achieve this?
0
Hi Experts,

am receiving a system generated txt file as report, I want a macro to convert into Excel sheet. You will find attached 2 files:
1- Excel sheet, how I would like to have after running the macro.
2- txt file.

Thanks for support.
Copy-of-BJAZ_COMCB_20150930_0080.xlsx
COMUPLOAD-2015-10-25-U00000000184000.Txt
0
Hello there,

I have 2 servers one is production which I have mssql2008 R2 installed on MSSERVER 2003 and I have another server MSSERVER 2012 which has MSSQL 2012. Now I want to create log shipping between the two DB. That is, the source will be sq2008r2 and target sql2012. Also I want to know will IS,RS,AS for SQL2012 work with SQL2008 DB.

cheers
Zolf
0
Hello guys,
here its the problem..

cannot open DHCP, DNS  or any other administration tools DC, IIS, ROUTING even the task manager.
what i noticed its that it seems to open, but it flash real quick and got close.

i am suspicious about a virus, i ran antivirus and spyware but still same issue.

any idea ?
0
Hello all

I am looking for a solution I can either buy or is open source for web based reporting from our database.  I do not want to licenses a SAAS.

The solution needs to work like crystal reports for the web in allowing the user to run canned reports, create new reports, export to pdf and excel along with creating and modifying templates,
0
Hello Experts,

I have built two queries using two different Universe. One Universe will give me data for the year 2015 and another data will give data for 2016.

Our fiscal calendar for 2015 ( October 2014 to September 2015). Hence I have the complete data for the year 2015 in one "Universe" .

For the year 2016 I will get the data from another Universe, which will get refreshed everyday.

I am doing an analysis where I need to compare the 2015 and 2016 data together.

Experts, please let me know if there is way to append 2015 and 2016 data using queries created by two different universe.

The data for 2015 remains constant, the data for 2016 should get append as soon its refreshed. Please advise if there is a way to append this data.

Thanks.
Ganesh
0
We have a customer that utilized SQL Report builder in Visual Studio 2005. They are retiring this setup and are looking for a modern solution that will provide the same/similar features/functions that the report builder in Visual Studio 2005 had. They also will need to access multiple version of SQL Server instances to build reports off of, so a new solution with backwards compatibility. The customer reviewed SQL Server Report Builder 2014 and said that it was too basic and a "downgrade" from the one in the earlier version of Visual Studio.
0
Does anyone know of a tool similar to Navicat or DBVisualizer that works with AS400?
0
I mostly have only done single parameter's into my reports and today find myself needing to pass two. Syntax wise, I know this is wrong, can someone help point out my mistake? I have tried several combos and it just isnt going.

= "javascript:void window.open(" &"'"&Globals!ReportServerUrl &"/Pages/ReportViewer.aspx?" 
&"/Visualutions/links/PatientPayments&rc:Parameters=False&rc:Toolbar=False&PATIENTPROFILEID="& Fields!PatientProfileId.Value &" &  DATE=" Fields!ApptStart.Value &  "
','DetailsWindow',' left=300, top=180,width =885, height=320, Scrollbars=0 location=no'" &")"

Open in new window

0
Hello Experts,

I have data with column  Fiscal Year; Fiscal Week; Fiscal Month; Transaction Date; Order Amount - C$

I used below mentioned syntax to calculate "Day of the Week"

_day_of_week ([Transaction Date],1) ( i got the results 1 for Monday; 2 for Tuesday ........ 7 for Sunday).

Then i used below mentioned syntax to get only Monday's in the new column.

If ([Day]='1') then ('Monday') else (' ') ( Here also i got the results)

Now, I want Amount for only Mondays:

For E.g.:
Order amount  Only Mon Only Mon amount
 $100                                  Monday                   $100
$20
$30                                     Monday                    $30
$40
$200

I tried using the below mentioned syntax to get above mentioned results, But not successful:( (Getting weird reults)

case
when ([Day]='1')
then ([Order Amount - C$])
else (null)
end

It would great if anyone can help on this request. Please do let me know if you need any further clarification.

Thanks,
Ganesh
0
Hi. I am building an access database. The database is to track projects, so I have one table for the project details, and a different database for the details of each sub-contractor (i.e. a table for "contractors", another table for "Landscapers", one for "Woodworkers", etc).  The project table has fields that link to these other tables so I can insert the name of the particular Landscaper, or particular general contractor who is working on that project.  This all seems to work ok.
Then I built a report to spit out the data for each project. So the project name, number, owner name, etc is on the report, as well as the name / info for each sub-contractor that is selected in the project itself.  Strange thing is happening on the report though.  Every field for these people must be filled in, or nothing at all shows up on the report. If I fill in every single option, then it all shows up.  But not every project has all these people - not every project will have a landscaper - but if any of these fields are not filled in - then just nothing gets pulled into the report.  I'm not sure if it's how I built the report - and somehow all the fields are linked in the report, or if it's something to do with the table structure.  I tend to think it has to do with how I built the report though. Any one ever come across this? Any ideas? Thanks!
0
Hello Experts,

I am a newbie to Cognos. I am using Cognos version 10.2.

I have a column named "Transaction_Date" in my data, using this i am trying to calculate "Day of the week"( i.e 1 is the first day of the week as indicated by the second parameter (1 to 7, 1 being Monday and 7 being Sunday).

I used the below mentioned syntax to get the results:

_day_of_week ([Time Metrics].[Transaction Date]],1)

But I am getting an error message as mentioned below:

Parsing error before or near position: 52 of: "_day_of_week ([Time Metrics].[Transaction Date]],1)"

I am clueless how to proceed further, since the syntax seems okay...

It would of great help if any one can help me to get the results.

Looking forward for the positive response!

Thanks,
Ganesh
0
Hello, I am having a problem with access 2010 report equation.  I'm trying to get the percent to show zero if LYDayDol = 0.  I keep getting the error ...wrong number of arguments...

=IIf([LYDayDol <>0,Sum([ActDayDol])-Sum([LYDayDol])/Sum([LYDayDol]),0)
0

DB Reporting Tools

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.

Top Experts In
DB Reporting Tools
<
Monthly
>