Hot News

PlayStation Plus for PS4 multiplayer to fund service improvements 138 6days 1hr ago
Microsoft defends Xbox One game policy, says industry is in 'transition' 127 4days 18hrs ago
Sony: 'of course' PS4 can do cloud computing 124 3days 17hrs ago
Xbox One will 'certainly' play games after next system launches 119 2days 20hrs ago
PS4 video shows off user interface, multi-tasking, and game downloading 103 6days 3hrs ago
PS4 momentum grows after E3, survey shows 80 1day 23hrs ago
Oculus Rift secures $16 million in venture capital 77 18hrs 0mins ago
3D Realms suing Gearbox over Duke Nukem Forever royalties 71 5days 23hrs ago
PlayStation 4 looks tiny in this comparison 67 6days 22hrs ago
EA Sports' Ignite engine not on PC because average PCs not powerful enough 67 23hrs 30mins ago

Latest News

Morning Discussion

by Alice O'Connor, Feb 23, 2010 5:00am PST

Chris is jetting off to Mothership GameFly this morning to teach Brian the secret handshake, the Shackshake, leaving me in charge around here for a while.

To the Shackcave!

Read all the News

« Previous Story
Warner Bros. Buys Batman: Arkham Asylum Dev Rocksteady

Next Story »
Chris Taylor Narrates Two Supreme Commander 2 Unit Videos

See All Comments | 276 Threads | 6,339 Comments

#5335

Refresh Thread

By: epit x Show Full Post

Reply

Web reporting for business

Is there something out there that allows me to create web reports from my MSSQL server, but the reports are customized based on login to the site?

Something like SQL Reporting Services would be perfect if I could use a WHERE user='%USERNAME%' in the SQL and have the variable show that report with just the specific users' login name in it.

I'm afraid to ask if crystal reports does something like this cause I've heard its a bitch. or something like tying SQLRS into Sharepoint?

Feb 23, 2010 2:52pm PST

toggle
Web reporting for business Is there something out there that allows me to create web reports from my M... : epit
Thread Truncated. Click to see all 11 replies.
- toggle
  Do you want just the user's name or you want the data to be dynamic to just the user's data? : bombay
  - toggle
    well, I assume if you have at least the username, you can build sql around it to pull just the users' dat... : epit
    - toggle
      With Business Views in Crystal Reports you can link to two separate data sources (IE: AD and MSSQL) then ... : spiffymc
      
      I'd really shy away from this, you now own reporting accuracy. : bombay
    - Do you have row level security in the erp, or a method to tell and slice the data at the erp level? Many... : bombay
- toggle
  You people are crazy. Crystal Reports is awesome, you just need to learn how to use it properly =) : spiffymc
  - toggle
    And yes Crystal Reports can do that as long as you're not talking about two completely different reports,... : spiffymc
    - #5480
      
      Refresh Thread
      
      By: spiffymc x Show Full Post
      
      Reply
      
      Actually even if it was two separate reports, I would just create them as sub-report objects and have the main report either hide or show the relevant content sections depending on the user that logged into the system.
      
      Feb 23, 2010 3:12pm PST
      
      Actually even if it was two separate reports, I would just create them as sub-report objects and have the... : spiffymc
  - toggle
    I've just seen a lot of hate and very little love for CR. not sure where the hate comes from as I've only... : epit
    - I'm just biased because I used to teach a few basic and advanced Crystal Reports classes. It all comes do... : spiffymc