Tuesday, March 27, 2012
Advice on a good strategy
1.) I'm doing some reporting using the Crystal Reports software my company has installed; however, I see threads of people using all kinds of more powerful software (VB, C, etc) to work with Crystal (web development, etc). Crystal Reports is on a terminal server here, and my audience will use that software to view the reports. Am I then limited to the Crystal (or Basic) syntax found in the software, or can I somehow use something like Perl or C to do my programming? I'm not sure how all of this goes together.
2.) More specifically, I'm trying to build a parts list tree (parent/child). The database is organized such that it makes this correlation difficult. In one Table (Part Master), is a list of all unique parts. In another table is a list of all unique jobs (times we've made the parts) (Jobs) that would show the part being made (one part shown) (link to Part Master). In the third table (Materials), the Jobs are listed with all of the sub components used for the main part for that job. Here, I'd want to capture the sub-components, but then loop back through the original Part Master to capture THEIR subcomponets, and so on. There could be up to 5 levels of this.
Basically, I want a user to enter a top-level assembly number, then I want to show every part used for that assembly, all the way down. My problem is that I really need to loop through the original list of returned records (I think). If I find the first part, and the first level of sub-parts, I may have passed those records already, so I need to re-read the list. I attempted build an array of the entire list of parts and do the logic at the end, but there are 82,000 of them (limit is 1000 and I don't plan to do Case with 82 levels). I'm inclined to believe that Crystal Reports (v.10) does not support multi-dimensional arrays, making this even tricker.
Can someone help me on a strategy to attack this one?Well, first you probably need to realize, that even if they are using VB or C-whatever or anything else in conjunction with Crystal, that Crystal is still a data-analysis/reporting engine. All it does is spit out the data in whatever format you design the report to do so. You can connect directly to your database (I am guessing it is a relatively standard engine, although you don't mention it), and then use crystal to select certain sets of data, group that data, and summarize that data, no matter what the general GUI interface to your data is. So just use crystal, point it to your database through ODBC or OLEDB (or whichever method you want), and go. Now, how you allow your users to view those reports is another matter, you might put shortcuts on the desktop (if the full version of CR is accessible through the terminal server), or use or develop a CR viewer for them to open the reports in. For that, you would need another tool, such as VB or C-whatever.
It does sound as if you have several layers of one-to many relationships to account for in the description of your project. My presonal experience leads me to usually start for the smallest partion, and work up. If you want a jobs report, that will show the detail down to the smallest sub-part, you would probably know that you need to start from an AssembyID, display each individual part, and below each part, a list of sub-parts. So you would add each of those tables to your report and link them by their primary keys (I usually use a left join if there is any possibility of missing links, i.e., a sub-part entry that is not in the table, otherwise an inner join would be more efficient). Then group by jobid, partid, and sub-part id. Add all the fields you want for each job (be sure to keep the field boxes in the correct group).
Obviously, this is hugely simplified and requires a lot more, but that is a basic approach. More detail could be given, if you give me a list of tables and their relationships.
ScottJ
Thursday, March 22, 2012
AdventureWorks Samples Not working
Manager in RS 2005. When I click on any of the reports, the report just
spins away and never returns the report information. I eventually (10
minutes later) just stop the browser. I made sure I have permissions to all
the data sources as well. Has anyone else had this problem or know where I
can look to see where the report(s) are hanging?
System Information:
Windows XP Pro
IIS 5.x
SQL Server 2005 Std.
VS 2005 Pro
Reporting Services 2005Verify that the dataset(s) in a report are actually working.
"Michael" wrote:
> I've installed and deployed the AdventureWorks Sample reports to Report
> Manager in RS 2005. When I click on any of the reports, the report just
> spins away and never returns the report information. I eventually (10
> minutes later) just stop the browser. I made sure I have permissions to all
> the data sources as well. Has anyone else had this problem or know where I
> can look to see where the report(s) are hanging?
> System Information:
> Windows XP Pro
> IIS 5.x
> SQL Server 2005 Std.
> VS 2005 Pro
> Reporting Services 2005
>|||I'm pretty sure the dataset is working since when I preview in VS2005 I can
get the sample to work with no problem. Strangely also, when I use VS2005 to
deploy and open the Samples folder, I can click on a sample report and it
works as expected. Only when I go to http://localhost/reports/home.aspx ->
AdventureWorks Samples -> Sample report does it just spin away.
"Bing Bing Yu" wrote:
> Verify that the dataset(s) in a report are actually working.
>
> "Michael" wrote:
> > I've installed and deployed the AdventureWorks Sample reports to Report
> > Manager in RS 2005. When I click on any of the reports, the report just
> > spins away and never returns the report information. I eventually (10
> > minutes later) just stop the browser. I made sure I have permissions to all
> > the data sources as well. Has anyone else had this problem or know where I
> > can look to see where the report(s) are hanging?
> >
> > System Information:
> > Windows XP Pro
> > IIS 5.x
> > SQL Server 2005 Std.
> > VS 2005 Pro
> > Reporting Services 2005
> >
> >
AdventureWorks Sample Reports
Hi folks,
Newbie question. Anyone knows how to create dropdown selection boxes in a report just like in the Employee Sales Summary report? Cheers!
Moving thread to the Reporting Services Group|||If you install the sample reports, you can just open them in report designer and investigate the Report - Report Parameter settings in the VS menu. The Employee Sales Summary report uses a query to determine the valid values list of the parameter - which results in the drop down being shown.
Alternatively, this MSDN topic should get you started: http://msdn2.microsoft.com/en-us/library/ms155917.aspx
-- Robert
Adventureworks sample reports
Sorry - what is SSX?
Regarding Storefront - do you mean these folks: http://www.storefront.com/?
What is it you're trying to do? Do you mean can you deliver reports to be printed using a standard online printing solution? If so then yes it is possible. No we can't do it out of the box, but you can write a delivery extension to send report output to the online service provider if they expose an API for submitting requests programmatically. You can learn about delivery extensions here: http://msdn2.microsoft.com/library/ms154672.aspx
Hope that helps,
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
Hi Lukasz,
I have seen other posts refering to SQL Server Express using the acronym SSX.
I have been trying to run Adventureworks samples/reports and keep getting error messages that I don't have the application/version to load/run files with the extension .csproj or .rptproj. I have downloaded/installed SSX, Adventureworks samples, VBX, CSX, Visual Web Developer, SSNSX and the .Net Framework 2.0 SDK.
Storefront is a sample project included in the Adventureworks sample package. It is intended to illustrate a sample web page for the fictitous Adventureworks company.
I wish to be able to view sample reports included in the sample package.
I have been successful at connecting to the database. I can view database stucture/tables/links. I have not been able to view a report, form or any "front-end" views.
Being new to these programs and this level of programing, I don't know if I the programs listed above lack this functionality or if I haven't gone thru the correct procedures to run/view these samples.
Any help would be greatly appreciated.
Thanks in advance,
Randy
|||Wow - was I ever off the mark .
Ok - here's what you're looking for. I don't know about csproj - I don't think the web developer allows you to compile C# projects. You might need to invest in a full edition of Visual Studio 2005 C# to be able to compile these.
In order to handle rptproj you'll need to download the evaluation edition of reporting services (http://www.microsoft.com/sql/downloads/trial-software.mspx) and install the report designer component.
SQL Server Express (also SSX/SSE, adnausium) doesn't come with Reporting Services yet - we're working on a SKU that provides this functionality as we speak. So you'll need the evaluation edition of reporting services.
Hope that helps,
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
Saturday, February 25, 2012
Adobe Reader could not open ...
to clients.
We are using SQL server 2000 and SQL Reporting Services 2000.
Several of the clients are reporting that they are unable to open their
report.
They get "Adobe reader could not open ReportName because it is either not a
supported file type or the file is corrupted... etc"
No custom code involved, all reports are generated in the same manner and
deployed in the same manner.
In some organizations several clients receive the same report and only one
or two of the clients reports a problem.
All these clients are using the same version of Adobe reader.
Is this a reader problem or a Report Server issue?
I am having a problem narrowing it down to the reader or generator!We are having the same issue. It was working for a while and now, user by
user, we are running into the same problem. Does anyone have any suggestions?
"Doug Gifford" wrote:
> On a weekly basis I have over 100 subscription reports in pdf format emailed
> to clients.
> We are using SQL server 2000 and SQL Reporting Services 2000.
> Several of the clients are reporting that they are unable to open their
> report.
> They get "Adobe reader could not open ReportName because it is either not a
> supported file type or the file is corrupted... etc"
> No custom code involved, all reports are generated in the same manner and
> deployed in the same manner.
> In some organizations several clients receive the same report and only one
> or two of the clients reports a problem.
> All these clients are using the same version of Adobe reader.
> Is this a reader problem or a Report Server issue?
> I am having a problem narrowing it down to the reader or generator!
>
Adobe Acrobat 8 vs. RS 2005 PDF Rendering
Recently there has been a push in my company to get Adobe Acrobat 8 deployed, and apparently the same PDFs which have been working all this time will cause Acrobat 8 to choke. By choke, I mean that Acrobat will load into memory but have some sort of problem with the PDFs, and never show up. The users, not realizing what is going on, will then ask for the same report again, causing two stalled instances of Acrobat to be opened now, etc.
Removing the new acrobat and replacing it with Acrobat 7 solves the problem. Long term, this is not a good solution however... Has anyone else had a similar experience? I've googled around and have come up empty.
I've seen Acrobat 8 act that when it cannot communicate properly with the Adobe updater. On a client that is experiencing that behavior, can you launch Acrobat 8 and manually ensure it is up-to-date?
Thanks.
|||Thanks Donovan,I've passed this on to our tech support guys and will be doing a test later today myself on one of our spare workstations. I should be able to replicate the issue our users have seen - at which point I'll play with the Acrobat update options and determine whether they are the cause. I'll post a follow-up comment to this thread with the results.
Thursday, February 9, 2012
Admin rights to Report Manager disappeared...?
Out of the blue I have lost administration rights to RS Report Manager. I
can no longer access several reports (others do work). When I connect to the
Report Manager the GUI is displayed, but I can't access all of the usual tabs
(ie. under the properties tab I can only see the 'General' and 'Security'
options, nothing else.)
I've tried accessing Report Manager via a client with domain admin rights
and via the RS server with local admin rights still the same problem...
Can anybody get me started on troubleshooting?
Kind Regards,
Casey.Casey,
I had this same problem...everything worked fine and then out of the
blue I couldn't update reports, deploy new reports, log into Report
Manager. I discovered that in Computer Management console when I Right
clicked on Default Web Site and went into Properties, then Directory
Security, then clicked on Anonymous Access and Authentication control,
and clicked the Edit button, that I did have Anonymous Access set.
When I tried to remote into that web server and perform changes I was
getting logged in as the anonymous user account with the limited rights
I gave that account. After hours when I'm working on the web server
now, I turn the anonymous option off, Restart IIS and do my
work...finally with the proper rights.
I hope this helps...
Jeff