Go Premium for a chance to win a PS4. Enter to Win

x

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

I'm trying to create a report in Cognos 11 with the following format:
Desired Output
I have a crosstab query in the format below which I would like to convert to the format above or create a new report:
Crosstab
Query
Thanks
0
Concerto's Cloud Advisory Services
LVL 5
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

how to create two Oracle tables in Oracle Report Builder 6i, run cursors on the tables, and table name is based on parameter values (&var), use the table created in data model to run a report
0
Hey all,

I've recently become part of a team that uses BIRT in combination with Actuate/OpenText iHub.

One of my tasks involves programmatically retrieving a full list of reports running on the iHub server. I've already discovered that iHub has a web service API that could possibly be used but I cannot find what method to use that achieves this.

Any experienced BIRT/iHub users on here that could help me get somewhere?

Looking forward to those reponses! :)

VV.
0
This is a two part question. I'm using VS 2015 Enterprise with .NET 4.7 Projects are VB.NET
1. How do I setup my CR inside my VB.NET project so that the data .XML file resides in a environmental variable location?
    When I set my Datasource Location inside my application project (Using ADO.NET) it asks for a specific .XML location.
    I can put in "C:\SomeFolderName\data.xml" & it works, but I'd rather not clutter up Users Machine with a folder that may get deleted or altered. So my thinking is to put the file into [APPDATA] folder, but the project looks for the file upon entry.
2. How do I include, or automate the Crystal Reports redistributable inside my setup project?
    I can put the CR_64bit.msi & CR_32bit.msi on the disk & have the User install the correct one first, but I'd rather not leave the install up to possible omission or wrong one.
Thank you,
Russ
0
I've been researching how to subtotal "inventory-like" metrics; however, I have not come up with a good solution.

Here's an example:

craigs-question.JPG
So, the QTY 5 "belongs" to KEY2 = AA and is applied to KEY3 values A and B. AB's QTY of 2
is applied to KEY3 values C and D. As you can see in the subtotal line for KEY1 value A, the
QTY total is 7 (5 + 2), while the REV values simply sum up to $18.00. Again, my issue is this:
How do I arrive at a QTY value of 7 at the subtotal for A? My SQL already is structured such that
the repeating QTY values are applied at the lowest level (KEY3) in the result set.  I actually have
six levels of these KEYS in the hierarchy, and the roll-up needs to occur for all of them.
0
Hi I have a query returning all the information I need and want to put it into a SSRS report.

Item Number             Item Des.                Qty On Hand          SKU Number       QTY On Order
1234                                  Test Item                            10                     4567                  Sum Of PO QTY(28)
                                         PO Number             PO QTY
                                            9991                                    5
                                            9992                                   23
                                     
Every time I add the "PO" section it inserts as a column beside the item number and I cant move it...

Thanks in advance.
0
Qlikview Help!!!
I have a pivot table in Qlikview 11.
1) Original - is my original pivot table
2) Final - is the pivoted version of Original
3) Result - this is what the result needs to be

How to calculate the difference columns - DIFF1, DIFF2, DIFF3 in the same format as attached? Please help.

Capture2.PNG
0
We use a cloud based finance system, and as part of this we use Crystal reports.  I have recently established that whilst the application and database servers are our own dedicated servers, the Crystal RAS is shared with other cloud provider clients.

I have a few issues, 1 – I know what Crystal does but don’t know the details of how a RAS server works, especially when multiple clients are using one server which will of course be pointing to numerous databases and; 2 – because of point 1, I not sure if I should be concerned about our data being accessed by other clients, for example how is our data/reports segregated from other clients?).

Can anyone help with my understanding of the technical details behind the workings of a Crystal RAS server is this type of environment and what controls we should be putting in place, getting evidence of from the provider to ensure that our data is still secure from unauthorised access?

Many thanks.
0
I am trying to display a report, I have a stored procedure that requires 3 parameters.  I am also using EF6 to push and pull data but I don't seem to be getting any data back to my report data source.  In my edmx file I see the SP in the functions folder and can pull scheme info.

In the code behind I try this
    ReportDataSource rds = new ReportDataSource("dsBOL.PrintBOLDataTable", dt);
but nothing.

Here is a shot of the report data source.

ds.PNG
0
Hello There,

I am trying to create two column report for labeling purposes, I followed instructions on the following link : blogs.wrox.com/article/creating-mailing-labels-in-sql-server-reporting-services

but the data keeps appearing on one column and not on both columns, I changed all sizes and tried tables and lists same results, it just wont populate the second column : ( .

Any help is very much appreciated.

Thank you in advance.
0
Free Tool: IP Lookup
LVL 11
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Hi,
I want to compute balance cashbook reconciliation statement in crystal ,
I have STATEMENT  BALANCE which is initial balance depending to period have selected,
I have two columns for Deposits and withdrawals.
My problem is I want to get running balance  depending whether is withdrawal or deposit.thank you
0
how to run crystal reports in batch
0
I am currently working on a project that requires my wireless network to automatically log and report network activity. I currently have Sophos UTM firewall with AP55C access points. the UTM has a section to configure IPS. But I am looking for something more specific to wireless. I called Sophos support, and the confirmed that they do not have WIPS built in.

So my question is if anyone knows of a product that I can use alongside my existing setup. Instead of replacing my setup with WIPS compatible APs. I am hoping for something that is able to use my existing APs as sensors and have something like a VM server that gathers the information from the wireless network and reports back.
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
>